protected void btnsubmit_Click(object sender, EventArgs e) { try { string strmsg = "0"; strmsg = CommanDataLoad.Check_Duplicate_Record("select 1 from lead_data where mobile='" + txtMobile.Text + "' ", "2", "lead capture", ""); if (strmsg != "0") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record is already exists..!')", true); return; } string[] param = new string[50]; param[0] = "name"; param[1] = Name.Text; param[2] = "ip"; param[3] = ClsConnection.StrIP; param[4] = "UserId"; if (lblUserId.Text != "") { param[5] = lblUserId.Text; } else { param[5] = ClsConnection.Userid; } param[6] = "mobile"; param[7] = txtMobile.Text; param[8] = "email"; param[9] = txtEmailId.Text; param[10] = "monthlyincome"; param[11] = txtIncome.Text; param[12] = "dob"; param[13] = txtDob.Text.Trim();//!= "" ? CommonValidation.GetYYYY_MM_DD(txtDob.Text) : ""; param[14] = "pan"; param[15] = txtPan.Text; param[16] = "address"; param[17] = txtAddress.Text; param[18] = "cityid"; param[19] = ddlCity.SelectedValue; param[20] = "stateid"; param[21] = ddlState.SelectedValue; param[22] = "profession"; param[23] = ddlProfession.SelectedValue; param[24] = "productid"; param[25] = ddlproduct.SelectedValue; param[26] = "companyname"; param[27] = txtcompanyname.Text; param[28] = "Designation"; param[29] = txtdesignation.Text; param[30] = "lead_type"; param[31] = ddlleadtype.SelectedValue; param[32] = "source_id"; param[33] = ddlsouce.SelectedValue; param[34] = "status_id"; param[35] = ddlstatus.SelectedValue; param[36] = "ndate"; param[37] = txtndate.Text; param[38] = "empcode"; if (lblUserId.Text != "") { param[39] = lblUserId.Text; } else { if (ddlassign.SelectedIndex > 0) { param[39] = Request.Cookies["empcode"].Value.ToString(); } else { param[39] = Request.Cookies["empcode"].Value.ToString(); } } param[40] = "Vertical_Id"; param[41] = ddlVertical.SelectedValue; param[42] = "loan_amt"; if (txtLoanAmt.Text != "") { param[43] = txtLoanAmt.Text; } else { param[43] = "0.00"; } param[44] = "Bank_Id"; param[45] = ddlBank.SelectedValue; param[46] = "broker_id"; param[47] = ddlbroker.SelectedValue; param[48] = "demogiven"; if (chkdemo.Checked) { param[49] = "1"; } else { param[49] = "0"; } int rowaffected = CommanDataLoad.ExecuteNonQuery("Insert_Lead", "1", "", param); if (rowaffected > 0) { Response.Write("<script>alert('Record Saved Successfully.');</script>"); // BindGrid(); ClearControls(); } else { Response.Write("<script>alert('Something wrong..!, Might be you entered mobile number is already exists in database please verify and update again.');</script>"); } //GridView1.DataBind(); } catch (Exception ex) { lblmsg.Text = "Some Error" + ex.Message.ToString(); //Console.WriteLine("Some ERROR" + ex.Message.ToString()); } }