protected void gvDealer_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        try
        {
            int DealerId = Convert.ToInt32(gvDealer.DataKeys[e.RowIndex].Values[0]);


            Dealer_Registration objCV = (from c in dbJalagam.Dealer_Registrations
                                         where c.Id == DealerId
                                         select c).FirstOrDefault();


            dbJalagam.Dealer_Registrations.DeleteOnSubmit(objCV);
            dbJalagam.SubmitChanges();
        }
        catch (Exception ex)
        {
            throw ex;
            //  dbEMUP.Transaction.Rollback();
        }
        finally
        {
            this.BindGridDealer();
        }
    }
    private void GetData()
    {
        var objC = from objV in dbJalagam.Dealer_Registrations
                   where objV.Id == Convert.ToInt32(Request.QueryString["Id"])
                   select objV;
        Dealer_Registration objK = objC.SingleOrDefault();


        lblAge.Text             = Convert.ToString(objK.Age);
        lblCity.Text            = Convert.ToString(objK.City);
        lblConsitution.Text     = Convert.ToString(objK.Constitution);
        lblCurrentBusiness.Text = Convert.ToString(objK.Currnet_Business);
        lblContactNo.Text       = Convert.ToString(objK.ContactNo);
        lblDealerName.Text      = Convert.ToString(objK.Dealer_Name);
        lblEMailId.Text         = Convert.ToString(objK.EmailId);
        lblFirmName.Text        = Convert.ToString(objK.FirmName);
        lblQualification.Text   = Convert.ToString(objK.Qualification);
    }
    private void Save()
    {
        Dealer_Registration objK = new Dealer_Registration();

        //  objU.UserEmailId = Context.User.Identity.Name.ToString();

        objK.Dealer_Name = Convert.ToString(txtDealerName.Text);
        //objK.Age = Convert.ToString(txtAge.Text);
        // objK.Qualification = Convert.ToString(txtQualification.Text);
        // objK.EmailId = Convert.ToString(txtEMailId.Text);
        objK.ContactNo = Convert.ToString(txtContactNo.Text);
        // objK.City = Convert.ToString(txtCity.Text);
        // objK.Currnet_Business = Convert.ToString(txtCurrentBusiness.Text);
        // objK.FirmName = Convert.ToString(txtFirmName.Text);
        // objK.Constitution = Convert.ToString(txtConstitution.Text);
        objK.CreatedDate = DateTime.Now;
        // objU.CreatedBy = Context.User.Identity.Name.ToString();

        dbJalagam.Dealer_Registrations.InsertOnSubmit(objK);
        dbJalagam.SubmitChanges();
        clsPublic.ClearControls(Page.Controls);
        lblMsg.Text = "<div><i class='fa fa-check fa-2x'></i>" + "Details Submitted Successfully" + "</div>";
    }