Check for duplicates record before inserting in database in ASP.Net MVC

sivanaid...

SOLVED CLOSED ACTIVE ANSWERED
User: sivanaidu
Posted: on Nov 21, 2018 11:33 PM
Forum: ASP.Net MVC
Answer: 1
Views: 24338
Sample Code: Download

please help me how to validate the empcode with database values in empcode column in mvc

i want to compare the input value (empcode) compare with all values of EmpCode column in database and show an validattion message in mvc

i want to ignore the duplicate value of particular column of table and again a new value should be inserted in table in mvc

this is below code

controller

        // List<Employee> ourProducts = new List<Employee>();
        [HttpPost]
        public JsonResult InsertEmployee(Employee Employee1, string empcode)
        {
            try
            {
                
                using (SivaKumarEntities entities = new SivaKumarEntities())
                {
                    bool status = false;
                    const string sConnString = "Data Source=125.62.198.183;Initial Catalog=SivaKumar;UserID=SivaKumar;Password=Siva@123";
                    SqlConnection con = new SqlConnection(sConnString);
                    SqlCommand cmd = new SqlCommand("select EmpCode from Employee", con);
                    cmd.Parameters.AddWithValue("@EmpCode", empcode);
                    cmd.Connection = con;
                    con.Open();
                    status = Convert.ToBoolean(cmd.ExecuteScalar());
                    con.Close();
                    SqlDataReader reader = cmd.ExecuteReader();
                    while (reader.Read())
                    {
                        ourProducts.Add(new Employee
                        {

                            EmpCode = reader["EmpCode"].ToString()

                        });
                    }
                    con.Close();
                }
            }
            catch (Exception)
            {
                TempData["Message"] = "<script>alert('Please enter emp no Unique');</script>";
            }
            return Json(Employee1);
         }

view

         $("body").on("click", "#btnAdd", function () {
             var languages = [];  
                $('.listvalue').each(function () {
                    if ($(this).is(":checked")) {
                        languages.push($(this).val());
                    }
                });
           
            var txtName = $("#EmpName");
            var txtCode = $("#EmpCode");
            var txtsalary = $("#salary");
           
            var radioValue = $("input[name='gender']:checked").val();
            var txtDepartment = $("#Department").find("option:selected");
           
            var txtProject = $("#Project");
          
            $.ajax({
                type: "POST",
                url: "/Home/InsertEmployee",
                data: '{EmpName: "' + txtName.val() + '", EmpCode: "' + txtCode.val() + '",salary: "' + txtsalary.val() + '",Gender: "' + radioValue + '",Department: "' + txtDepartment.text() + '",Skills: "' + languages + '",Project: "' + txtProject.val() + '" }',
                contentType: "application/json; charset=utf-8",
                dataType: "json",
                success: function (r) {
                 
                    var row = $("#WebGrid TBODY tr:last-child").clone(true);
                    if (row.find(".label").is(":empty")) {
                        $("#WebGrid TBODY tr:last-child").remove();
                    }
                    //location.reload();                  
                }
            });
        });

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 8

Reply
ANSWER
User: dharmendr
Replied: on Nov 26, 2018 07:03 AM
Report

Hi sivanaidu,

Check the below example.

Database

I have made use of the following table Customers with the schema as follows.

I have already inserted few records in the table.

You can download the database table SQL by clicking the download link below.

Download SQL file

Controller

public class HomeController : Controller
{
    // GET: /Home/
    public ActionResult Index()
    {
        CustomerEntities entities = new CustomerEntities();
        return View(entities.Customers.ToList());
    }

    [HttpPost]
    public JsonResult InsertEmployee(Customer customer)
    {
        try
        {
            using (CustomerEntities entities = new CustomerEntities())
            {
                List<Customer> customers = entities.Customers.Where(x => x.CustomerId == customer.CustomerId).ToList();
                if (customers.Count > 0)
                {
                    TempData["Message"] = "<script>alert('Please enter Unique emp no');</script>";
                }
                else
                {
                    entities.Customers.AddObject(customer);
                    entities.SaveChanges();
                }
            }
        }
        catch (Exception)
        {

        }
        return Json(customer);
    }
}

View

<%@ Page Language="C#" Inherits="System.Web.Mvc.ViewPage<IEnumerable<_170172_Insert_DataBase_Check_Duplicate.Customer>>" %>

<%@ Import Namespace="_170172_Insert_DataBase_Check_Duplicate" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Index</title>
    <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
    <script type="text/javascript">
        $(document).ready(function () {
            $('#btnAdd').click(function () {
                var name = $("#txtName").val();
                var id = $("#txtId").val();
                var country = $("#ddlCountry").find("option:selected").val();
                var customer = {};
                customer.CustomerId = id;
                customer.Name = name;
                customer.Country = country;

                $.ajax({
                    type: "POST",
                    url: "/Home/InsertEmployee",
                    data: customer,
                    contentType: "application/json; charset=utf-8",
                    dataType: "json",
                    success: function (r) {
                        location.reload();
                    }
                });
            });
        });
    </script>
</head>
<body>
    <table>
        <tr>
            <th>
                CustomerId
            </th>
            <th>
                Name
            </th>
            <th>
                Country
            </th>
        </tr>
        <% foreach (Customer customer in Model)
           { %>
        <tr>
            <td>
                <%: customer.CustomerId%>
            </td>
            <td>
                <%: customer.Name%>
            </td>
            <td>
                <%: customer.Country%>
            </td>
        </tr>
        <% } %>
    </table>
    <br />
    <table>
        <tr>
            <td>
                CustomerId
            </td>
            <td>
                <input type="text" id="txtId" />
            </td>
        </tr>
        <tr>
            <td>
                Name
            </td>
            <td>
                <input type="text" id="txtName" />
            </td>
        </tr>
        <tr>
            <td>
                Country
            </td>
            <td>
                <select name="Country" id="ddlCountry">
                    <option value="">--Select Country--</option>
                    <option value="France">France</option>
                    <option value="India">India</option>
                    <option value="Russia">Russia</option>
                    <option value="United States">United States</option>
                </select>
            </td>
        </tr>
        <tr>
            <td colspan="2" align="center">
                <input type="button" id="btnAdd" value="Add" />
            </td>
        </tr>
    </table>
</body>
</html>

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Check for duplicates record before inserting in database in ASP.Net MVC

Company

Explore

Follow us

Contact Us