Validation of the repeated record

Question

Validation of the repeated record

Navigation

#1 by (1 votes)

1

I have a class named Matricula . It receives the register of Aluno and Serie .

I need to do a validation, where if the student is already enrolled in a registered series, the page displays a message stating that the student is already enrolled and does not want to be enrolled again.

Below is the registration code:

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Web;

namespace bj_cursosonline.Models
{
    public class Matricula
    {
        [Key]
        public int ID { get; set; }

        [Required(ErrorMessage = "Campo obrigatório!")]
        [Display(Name = "Aluno")]
        public int ALUNOSID { get; set; }

        [Required(ErrorMessage = "Campo obrigatório!")]
        [Display(Name = "Série")]
        public int SERIESID { get; set; }

        public virtual Series SERIES { get; set; }

        public virtual Alunos ALUNO { get; set; }
    }
}

Student Class:

public enum SEXOALUNO
{
    MASCULINO, FEMININO
}

public class Alunos
{
    [Key]

    public int ID { get; set; }

    [Display(Name = "Nome")]
    [Required(ErrorMessage = "Campo obrigatório!")]
    public string NOME { get; set; }

    [Display(Name = "Sexo")]
    [Required(ErrorMessage = "Campo obrigatório!")]
    public SEXOALUNO? SEXO { get; set; }

    [Required(ErrorMessage = "Campo obrigatório!")]
    [Display(Name = "Data de Nascimento")]
    [DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:yyyy-MM-dd}")]
    [DataType(DataType.Date, ErrorMessage = "Data em formato inválido!")]
    public DateTime DATANASCIMENTO { get; set; }

    public virtual ICollection<Matricula>
        Matricula
    { get; set; }
}

Serial Class:

public enum TURMA
{
    A, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q, R, S, T, U, V, W, X, Y, Z
}

public enum TURNO
{
    MANHÃ, TARDE, NOITE
}

public class Series
{
    [Key]
    public int ID { get; set; }

    [Required(ErrorMessage = "Campo Obrigatório!")]
    [StringLength(50)]
    [Display(Name = "Descrição:")]
    public string DESCRICAO { get; set; }

    [Display(Name = "Turma:")]
    public TURMA? TURMA { get; set; }

    [Display(Name = "Turno: ")]
    public TURNO? TURNO { get; set; }

    [Required(ErrorMessage = "Campo Obrigatório!")]
    [Display(Name = "Número da Sala:")]
    public int NUMSALA { get; set; }

    public virtual ICollection<Avaliacoes>
        Avaliacoes
    { get; set; }

    public virtual ICollection<Matricula>
        Matricula
    { get; set; }
}

c# asp.net-mvc

asked by anonymous 13.06.2017 / 14:28

1 answer

Problems with Alert Dialog Help with application release written in Visual C #

score 1 · Accepted Answer

In this case the ideal is before you save, you do a check if you already have a registry of that in your Bank, in case it has an error message.

A good way to do this validation is by using IValidatableObject , with which you can implement your own validations in your class.

namespace bj_cursosonline.Models
{
    public class Matricula : IValidatableObject
    {
        [Key]
        public int ID { get; set; }

        [Required(ErrorMessage = "Campo obrigatório!")]
        [Display(Name = "Aluno")]
        public int ALUNOSID { get; set; }

        [Required(ErrorMessage = "Campo obrigatório!")]
        [Display(Name = "Série")]
        public int SERIESID { get; set; }

        public virtual Series SERIES { get; set; }

        public virtual Alunos ALUNO { get; set; }

        public IEnumerable<ValidationResult> Validate(ValidationContext validationContext)
        {
            // aqui você faz uma consulta no Banco de dados e busca se já existe um cadastro desse aluno na serie
            var result = db.Matriculas.Count(m => m.ALUNOSID == ALUNOSID && m.SERIESID == SERIESID); 
            if (result > 0)
            {
                yield return new ValidationResult("Já existe uma Matricula para esse aluno nessa Serie", new string[] { "SERIESID" });
            }

        }
    }
}

More examples of how to use IValidatableObject link