I want add validation with phone and email

Question

If the user wants to register with the same email and phone, I want to get a warning that this email and phone have been registered before. I tried a lot of Ajax code about this, but I was not successful. Can you help?

@model WebApplication1.Models.Class1
@{
    Layout = null;
}






    








    



        @Html.Label("İller", htmlAttributes: new { @class = "bold-text" })
        @Html.DropDownList("DrpSehir", Model.Sehirler, "---Seçiniz---", new { @class = "form-control", @required = "required" })
        
            Lütfen İl Seçiniz!
        
        
            Güzel Görünüyor!
        
    
    

        @Html.Label("İlçeler", htmlAttributes: new { @class = "bold-text" })
        @Html.DropDownList("Drpilce", Model.ilceler, "---Seçiniz---", new { @class = "form-control", @required = "required" })


        
            Güzel Görünüyor!


@{
    ViewBag.Title = "ISKO DÜNYASINA HOŞGELDİNİZ!";
    Layout = "~/Views/Shared/_Layout.cshtml";
}










    




    
        
            @*Text*@
            
                
                    İsim
                    
                    
                        Lütfen İsminizi Giriniz!
                    
                    
                        Güzel Görünüyor!
                    
                


                


                
                    Soyisim
                    
                    
                        Lütfen Soyisminizi Giriniz!
                    
                    
                        Güzel Görünüyor!
                    
                
                @*DROPDOWNLİST-WİTH-SQL*@
            


            @{Html.RenderAction("Deneme");}







            

            @*RADİO BUTTON*@
            
                
                    Cinsiyet :
                    

                    

                    
                        Erkek
                        
                    
                    
                        Kadın
                        
                    
                
                

                

                
                    Aslerlik Durumu :
                    

                    

                    
                        Yapıldı
                        
                    
                    
                        Tecilli
                        
                    
                    
                        Muaf
                        
                    
                
                

                

                
                    Evlilik Durumu :
                    

                    

                    
                        Evli
                        
                    
                    
                        Bekar
                        
                    
                
            
            

            

            @*Text*@
            
                
                    Telefon
                    
                    
                        Lütfen Telefon Numaranızı 11 Hane Olacak Şekilde Giriniz!
                    
                    
                        Güzel Görünüyor!
                    
                
                

                
                    Telefon 2
                    
                    
                        Lütfen Telefon Numaranızı 11 Hane Olacak Şekilde Giriniz!
                    
                    
                        Güzel Görünüyor!
                    
                
            
            

            
                
                    Email
                    
                    
                        Lütfen Email Giriniz!
                    
                    
                        Güzel Görünüyor!
                    
                
                
                    Email Tekrar
                    
                    
                        Lütfen Email Giriniz!
                    
                    
                        Güzel Görünüyor!
                    
                
            
            


            @*TARİH*@
            

                
                    @Html.Label("Tarih", "Lisans Başlangıç Tarihi", htmlAttributes: new { @class = "control-label col-mb-3 bold-text" })
                    
                    
                        Lütfen Lisans Başlangıç Tarihini Giriniz!
                    
                    
                        Güzel Görünüyor!
                    
                


                
                    @Html.Label("Tarih", "Lisans Bitiş Tarihi", htmlAttributes: new { @class = "control-label col-mb-3 bold-text" })
                    
                    
                        Lütfen Lisans Bitiş Tarihi Giriniz!
                    
                    
                        Güzel Görünüyor!
                    
                
            

            


            @*DROPDOWNLİST*@
            
                
                    Yabancı Dil
                    

                        
                        
                            Lütfen Yabancı Dil Seçiniz !
                        
                        
                            Güzel Görünüyor!
                        
                    
                

                
                    Seviye
                    

                        
                        
                            Lütfen Yabancı Dil Seçiniz !
                        
                        
                            Güzel Görünüyor!
                        
                    
                
            
            


            
                
                 KVKK Metnini  Kabul Ediyorum.
                
                    Lütfen KVKK Onayı Veriniz !
                
                
                    Güzel Görünüyor!
                
            


            

            

            @*BUTTON*@
            
                
            
        
    







@*KVKK AKTİF OLDUĞUNDA ALINAN ALERT*@

@*POST EDİLDİĞİNDE BAŞARILI VE BAŞARISIZ ŞEKLİNDE DÖNÜŞ YAPAN KOD*@

@*WAS VALİDATED KODU*@

using Newtonsoft.Json.Linq;
using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using WebApplication1.Models;
using System.Globalization;
using Microsoft.Ajax.Utilities;
using System.Web.WebPages;
using System.Xml.Linq;
using System.Web.UI.WebControls;
using System.ComponentModel.DataAnnotations;
using System.Runtime.CompilerServices;
using System.Security.Cryptography.X509Certificates;
using System.Runtime.Remoting.Contexts;
using System.Data.SqlClient;
using System.Web.Helpers;
using System.Data.Entity.Validation;

namespace WebApplication1.Controllers
{
    public class FormExample1Controller : Controller
    {

        ISKOMENUEntities3 context = new ISKOMENUEntities3();
        public ISKOMENUEntities3 ISKOMENUEntities { get; private set; }
        public object Email { get; private set; }



        // GET: FormExample1
        ISKOMENUEntities3 db = new ISKOMENUEntities3();

        Class1 cs = new Class1();

        public ActionResult Deneme()
        {


            cs.Sehirler = new SelectList(db.Tbliller, "id", "ad");
            cs.ilceler = new SelectList(db.tblilceler, "ilceid", "ilcead");


            return View(cs);
        }

        public JsonResult ilcegetir(int p)
        {
            var ilceler = (from x in db.tblilceler
                           join y in db.Tbliller on x.Tbliller.id equals y.id
                           where x.Tbliller.id == p
                           select new
                           {
                               Text = x.ilcead,
                               Value = x.ilceid.ToString()
                           }).ToList();
            return Json(ilceler, JsonRequestBehavior.AllowGet);
        }





        public ActionResult Create()
        {
            return View();
        }
        [HttpPost]
        public ActionResult Create(FormCollection form)
        {



            ISKOMENUEntities3 db = new ISKOMENUEntities3();
            Users1 model = new Users1();
            try
            {


                model.UserName = form["UserName"].Trim();

                model.UserSurName = form["UserSurName"].Trim();

                int id = Convert.ToInt32(form["DrpSehir"].Trim());
                model.City = (from s in db.Tbliller where s.id == id select s.ad).FirstOrDefault();

                model.City2 = form["Drpilce"].Trim();

                model.Gender = Int16.Parse(form["Gender"]);

                model.Military = Int16.Parse(form["Military"]);

                model.Marital = Int16.Parse(form["Marital"]);

                model.Phone = form["Phone"].Trim();

                model.Phone2 = form["Phone2"].Trim();
                model.Email = form["Email"].Trim();


                if (form["lisansBaslangicTarih"] != "")
                    model.LisansBaslangicTarih = DateTime.Parse(form["lisansBaslangicTarih"]);
                if (form["lisansBitisTarih"] != "")
                    model.LisansBitisTatih = DateTime.Parse(form["lisansBitisTarih"]);

                model.YabanciDil = form["YabanciDil"];

                model.YabanciDil2 = form["YabanciDil2"];

                model.KayitTarihi = DateTime.Today;



                db.Users1.Add(model);

                db.SaveChanges();

                return View();
            }

            catch (DbEntityValidationException e)
            {
                foreach (var eve in e.EntityValidationErrors)
                {
                    Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
                        eve.Entry.Entity.GetType().Name, eve.Entry.State);
                    foreach (var ve in eve.ValidationErrors)
                    {
                        Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
                            ve.PropertyName, ve.ErrorMessage);
                    }
                }
                throw;
            }



        }

            public ActionResult About()
            {
                ViewBag.Message = "KVKK METNİ ;";

                return View();
            }



        }
    }

Accepted Answer

Hi @Harun Ergün,

You can refer to the code below.You can add a message box.

 function demo() {
    var phone = $("#Phone").val();
    var email = $("#Email").val();
    $.ajax({
        type: "POST",
        url: "/FormExample1/EmailExists",
        data: '{ phone: "' + phone + '",email: "' + email + '"}',

        contentType: "application/json; charset=utf-8",
        dataType: "json",
        success: function (response) {
            alert(response);
            var message = $("#message");
            if (response) {
                message.css("color", "green");
                message.html("success");
                $.ajax({
                    url: "/FormExample1/Create",
                    method: "POST",
                    data: $("form").serialize(),
                    success: function (response) {
                        swal.fire("Tebrikler!", "Kaydın başarı ile alındı!", "success");
                        $("form")[0].reset();
                    },
                    error: function () {
                        swal.fire("Hata oluştu!", "Sanırım bazı şeyler yanlış gitti!", "error");

                    }
                });

                return false; // Formun otomatik gönderimini engelle

            }
            else {

                message.css("color", "red");
                message.html("Email OR Phone already exists");
            }
        }
    });
}

You need to fetch data from database. Uncommented below are my tests. Because don't know which table the data is in, you can refer to the notes and modify it according to your own table.

public JsonResult EmailExists(string phone,string email)
        {
            // ISKOMENUEntities3 db = new ISKOMENUEntities3();
            // bool isValid = !db.Users.ToList().Exists(p => p.Email.Equals(email, StringComparison.CurrentCultureIgnoreCase));
            //&& !db.Users.ToList().Exists(p => p.Phone.Equals(phone, StringComparison.CurrentCultureIgnoreCase)
            bool isValid = !String.Equals(phone, "12345678978", StringComparison.OrdinalIgnoreCase)  
                && !String.Equals(email, "123@123.com", StringComparison.OrdinalIgnoreCase);
            
            return Json(isValid);
           
        }

Best regards,
Lan Huang

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer

you could use the unobtrusive validation and remote validators.

https://learn.microsoft.com/en-us/aspnet/core/mvc/models/validation?view=aspnetcore-7.0

if you want to code your own, you need to remember that the ajax calls are async, so after the calls are complete you will need to resubmit the form. $.ajax() returns a promise the validation can use to check the results.

I want add validation with phone and email

1 additional answer