how to validate phone number that is already exist in table

vijayaasri palaniappan

5y1.2k.NET

Hi,

How to show error message when enter already exist phone number during registeration(MVC).

Thank You.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
context is EntityFramework's context object if you are using ado.net then accordingly retrieve all the phone number from database.
vijayaasri palaniappan5y ago
Hi,

Yeah! I changed that.Then for Context ??
Kapil Gaur5y ago
Very good Sachin you have explained with quality code. This shows how dedicatedly you help people. I would just add here one thing this is the code where we have considered the data annotation validations and we have considered the list of numbers available in your project. Similarly you can also create remote repository validation also where again you will send that number to another API and it will give you the result. So there are n possible ways but Sachin has explained the best possible way. you can tweak a little bit always as per requirements.
Sachin Singh5y ago
UserMaster is the table in the database and class in the model.
vijayaasri palaniappan5y ago
Hi Sachin,

It shows error in UserMaster and Context.

Thank you.
Sachin Singh5y ago
step 1. Create a class PhoneNumberCheck overriding validationAttribute as shown below
public class PhoneNumberCheck:ValidationAttribute
    {
       protected override ValidationResult IsValid(object value, ValidationContext validationContext)
       {
           int[] phones= context.UserMaster.Select(x=>x.Phone).ToArray();
           UserMaster user= (UserMaster)validationContext.ObjectInstance;
           bool istrue = phones.Any(x => x == user.Phone);
           if (istrue)
           {
               return new ValidationResult("Phone is in use");
           }
           return ValidationResult.Success;
       }
    }
step 2. user this attribute on UserMaster class
public class UserMaster
      {
       [Required(ErrorMessage="can not be empty")]

        public string Name { get; set; }
        [Required]
        [Range(18,45,ErrorMessage="Age must be between 18 and 45")]
        public int Age { get; set; }
        [DataType(DataType.EmailAddress)]
        public string Email { get; set; }
        [DataType(DataType.PhoneNumber)]
         [PhoneNumberCheck]
        public int Phone { get; set; }
     }
Now, you will get the error message if the phone number exist.
please refer to my article on this
https://www.sharpencode.com/article/MVC/data-annotations