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());
}
}
