private void FillProduct(string[] param)
{
DataSet ds = CommanDataLoad.ExecuteDataSet("Get_Product", "1", "", param);
if (ds != null)
{
ddlproduct.DataSource = ds;
ddlproduct.DataTextField = "Product_Name";
ddlproduct.DataValueField = "Product_Id";
ddlproduct.DataBind();
}
ddlproduct.Items.Insert(0, new ListItem("Select", "0"));
}
private void FillState(string[] param)
{
DataSet ds = CommanDataLoad.ExecuteDataSet("Get_State", "1", "", param);
if (ds != null)
{
ddlState.DataSource = ds;
ddlState.DataTextField = "state_name";
ddlState.DataValueField = "state_id";
ddlState.DataBind();
}
ddlState.Items.Insert(0, new ListItem("Select", "0"));
}
private void Load_Vertical(string[] param)
{
DataSet ds = CommanDataLoad.ExecuteDataSet("USP_Load_Vertical_Master", "1", "", param);
if (ds != null)
{
ddlVertical.DataSource = ds;
ddlVertical.DataTextField = "Vertical_Name";
ddlVertical.DataValueField = "Vertical_Id";
ddlVertical.DataBind();
}
ddlVertical.Items.Insert(0, new ListItem("Select", "0"));
}
void Load_Data()
{
DataSet ds = new DataSet();
ds = CommanDataLoad.ExecuteDataSet("Select * from lead_Data where lead_id=" + Request.QueryString["leadid"].ToString() + "", "2", "");
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
Name.Text = dr["Name"].ToString();
txtMobile.Text = dr["mobile"].ToString();
txtvremark.Text = dr["remark"].ToString();
txtvfollowupdate.Text = DateTime.Now.ToShortDateString();
if (dr["bank_id"].ToString() != "0" && dr["bank_id"].ToString() != "-1" && dr["bank_id"].ToString() != "")
{
ddlBank.SelectedValue = dr["bank_id"].ToString();
}
if (dr["broker_id"].ToString() != "0" && dr["broker_id"].ToString() != "-1" && dr["broker_id"].ToString() != "")
{
ddlbroker.SelectedValue = dr["broker_id"].ToString();
}
if (dr["lead_status_id"].ToString() != "0" && dr["lead_status_id"].ToString() != "-1" && dr["lead_status_id"].ToString() != "")
{
ddlvleadstatus.SelectedValue = dr["lead_status_id"].ToString();
}
if (dr["productid"].ToString() != "0" && dr["productid"].ToString() != "-1" && dr["productid"].ToString() != "")
{
ddlproduct.SelectedValue = dr["productid"].ToString();
}
if (dr["emp_code"].ToString() != "0" && dr["emp_code"].ToString() != "-1" && dr["emp_code"].ToString() != "")
{
ddlvAssignTo.SelectedValue = dr["emp_code"].ToString();
}
if (dr["demo_given"].ToString() == "1")
{
chkdemo.Checked = true;
}
else
{
chkdemo.Checked = false;
}
}
}
}
public static string[] GetCities(string prefix)
{
List <string> data = new List <string>();
DataSet ds = CommanDataLoad.ExecuteDataSet("select City_name, City_Id from City_master where City_Name like '%" + prefix + "%'", "2", "Lead Assign Telecaller New", "");
int i = 0;
while (i < ds.Tables[0].Rows.Count)
{
data.Add(string.Format("{0}-{1}", ds.Tables[0].Rows[i]["City_Name"], ds.Tables[0].Rows[i]["City_ID"]));
i = i + 1;
}
return(data.ToArray());
}
public static string[] Getstatus(string prefix)
{
List <string> data = new List <string>();
DataSet ds = CommanDataLoad.ExecuteDataSet("select lead_status_id, lead_status from lead_status_master where lead_status like '%" + prefix + "%' order by lead_status", "2", "Manage Lead", "");
int i = 0;
while (i < ds.Tables[0].Rows.Count)
{
data.Add(string.Format("{0}-{1}", ds.Tables[0].Rows[i][1], ds.Tables[0].Rows[i][0]));
i = i + 1;
}
return(data.ToArray());
}
public static string[] Getemp(string prefix)
{
List <string> data = new List <string>();
string empcode = HttpContext.Current.Request.Cookies["empcode"].Value.ToString();
DataSet ds = CommanDataLoad.ExecuteDataSet("select emp_code,name from dbo.get_child_emp('" + empcode + "') where name like '%" + prefix + "%' order by name", "2", "Lead Assign Telecaller New", "");
int i = 0;
while (i < ds.Tables[0].Rows.Count)
{
data.Add(string.Format("{0}-{1}", ds.Tables[0].Rows[i][1], ds.Tables[0].Rows[i][0]));
i = i + 1;
}
return(data.ToArray());
}
private void Load_City(string CityNm)
{
string[] param = new string[2];
param[0] = "City_Name";
param[1] = CityNm;
DataSet ds = CommanDataLoad.ExecuteDataSet("USP_Load_StateByCityNm", "1", "", param);
if (ds != null)
{
ddlCity.SelectedValue = ds.Tables[0].Rows[0]["City_Id"].ToString();
}
else
{
ddlCity.SelectedIndex = -1;
}
}
private void Load_SourceType(string SourceNm)
{
string[] param = new string[2];
param[0] = "source_name";
param[1] = SourceNm;
DataSet ds = CommanDataLoad.ExecuteDataSet("USP_Load_SourceType", "1", "", param);
if (ds != null)
{
ddlsouce.SelectedValue = ds.Tables[0].Rows[0]["source_id"].ToString();
}
else
{
ddlsouce.SelectedIndex = -1;
}
}
private string Load_City(string CityNm)
{
string cityid = "-1";
string[] param = new string[2];
param[0] = "City_Name";
param[1] = CityNm;
DataSet ds = CommanDataLoad.ExecuteDataSet("USP_Load_CityIDbyCityNm", "1", "", param);
if (ds != null)
{
cityid = ds.Tables[0].Rows[0]["City_Id"].ToString();
}
else
{
cityid = "-1";
}
return(cityid);
}
private void Load_Emp_Details()
{
string[] param = new string[2];
param[0] = "Emp_Code";
param[1] = Request.Cookies["empcode"].Value.ToString();
//param[1] = "RB40000255";
DataSet ds = new DataSet();
ds = CommanDataLoad.ExecuteDataSet("Usp_Load_User_Detail_Sp", "1", "LogRequest", param);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
lblusername.Text = ds.Tables[0].Rows[0]["Emp_Name"].ToString();
lbluseremail.Text = ds.Tables[0].Rows[0]["Email_Id"].ToString();
lblreportingemail.Text = ds.Tables[0].Rows[0]["Reporting_Email_Id"].ToString();
}
}
}
protected void Load_Bank_Mapping_Detail(string Map_Id)
{
try
{
string[] param = new string[2];
param[0] = "Map_Id";
param[1] = Map_Id;
DataSet ds = new DataSet();
ds = CommanDataLoad.ExecuteDataSet("USP_Bank_Product_Mapping_Detail", "1", "Edit Bank Product Mapping", param);
if (ds != null)
{
lblMapId.Text = ds.Tables[0].Rows[0]["Map_Id"].ToString();
Load_Bank();
ddlbName.SelectedValue = ds.Tables[0].Rows[0]["Bank_Id"].ToString();
Load_City();
ddlcName.SelectedValue = ds.Tables[0].Rows[0]["City_Id"].ToString();
Load_Product();
ddlpName.SelectedValue = ds.Tables[0].Rows[0]["Product_Id"].ToString();
txtcPerson.Text = ds.Tables[0].Rows[0]["Contact_Person"].ToString();
txtDesign.Text = ds.Tables[0].Rows[0]["Designation"].ToString();
txtmNo.Text = ds.Tables[0].Rows[0]["Mobile_No"].ToString();
txtlandNo.Text = ds.Tables[0].Rows[0]["Landline_No"].ToString();
txtfNo.Text = ds.Tables[0].Rows[0]["Fax_No"].ToString();
txteId.Text = ds.Tables[0].Rows[0]["Email_Id"].ToString();
Popup(true);
}
else
{
Popup(false);
}
}
catch (Exception ex)
{
//lblmsg.Text = "Some Error" + ex.Message.ToString();
}
}
protected void ddlEndTime_SelectedIndexChanged(object sender, EventArgs e)
{
string Emp_Code = Request.Cookies["empcode"].Value.ToString();
DataSet ds = new DataSet();
ds = CommanDataLoad.ExecuteDataSet("Select User_Remark,User_Achieve from Employee_Daily_Planning where StartTime = '" + ddlStartTime.Text + "' And EndTime = '" + ddlEndTime.Text + "' And Plan_Date = '" + txtDate.Text + "' And Emp_Code = '" + Emp_Code + "'", "2", "Daily_Planning", "");
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
txtRemark.Text = ds.Tables[0].Rows[0]["User_Remark"].ToString();
txtAchieve.Text = ds.Tables[0].Rows[0]["User_Achieve"].ToString();
}
else
{
txtRemark.Text = "";
txtAchieve.Text = "";
ds.Tables.Clear();
Emp_Code = "";
}
}
}
private void Load_State(string CityName)
{
string[] param = new string[2];
param[0] = "City_Name";
param[1] = CityName;
DataSet ds = CommanDataLoad.ExecuteDataSet("USP_Load_StateByCityNm", "1", "", param);
if (ds != null)
{
ddlState.SelectedValue = ds.Tables[0].Rows[0]["state_id"].ToString();
string[] param1 = new string[2];
param1[0] = "state_id";
param1[1] = ddlState.SelectedValue;
FillCity(param1);
Load_City(CityName);
}
else
{
ddlState.SelectedIndex = -1;
}
}
protected void Load_Sub_Division_Detail(string Sub_Division_Id)
{
try
{
string[] param = new string[2];
param[0] = "Sub_Division_Id";
param[1] = Sub_Division_Id;
DataSet ds = new DataSet();
ds = CommanDataLoad.ExecuteDataSet("USP_Load_Sub_Division_Detail", "1", "Edit Sub Division Master", param);
if (ds != null)
{
lblSubDivisionId.Text = ds.Tables[0].Rows[0]["Sub_Division_Id"].ToString();
Load_Div();
ddlDiv.SelectedValue = ds.Tables[0].Rows[0]["Division_Id"].ToString();
txtSubDiv.Text = ds.Tables[0].Rows[0]["Sub_Division_Name"].ToString();
if (ds.Tables[0].Rows[0]["Is_Active"].ToString() == "Y")
{
chkIsAct.Checked = true;
}
else
{
chkIsAct.Checked = false;
}
Popup(true);
}
else
{
Popup(false);
}
}
catch (Exception ex)
{
//lblmsg.Text = "Some Error" + ex.Message.ToString();
}
}
protected void Load_Source_Detail(string Source_Id)
{
try
{
string[] param = new string[2];
param[0] = "source_id";
param[1] = Source_Id;
DataSet ds = new DataSet();
ds = CommanDataLoad.ExecuteDataSet("USP_Load_Source_Detail", "1", "Edit Source Master", param);
if (ds != null)
{
txtsource.Text = ds.Tables[0].Rows[0]["source_Id"].ToString();
if (ds.Tables[0].Rows[0]["Is_Active"].ToString() == "Y")
{
chkIsAct.Checked = true;
}
else
{
chkIsAct.Checked = false;
}
Popup(true);
}
else
{
Popup(false);
}
}
catch (Exception ex)
{
//lblmsg.Text = "Some Error" + ex.Message.ToString();
}
}
protected void Load_Bank_Detail(string Bank_Id)
{
try
{
string[] param = new string[2];
param[0] = "Bank_Id";
param[1] = Bank_Id;
DataSet ds = new DataSet();
ds = CommanDataLoad.ExecuteDataSet("USP_Load_Bank_Detail", "1", "Edit Bank Master", param);
if (ds != null)
{
lblBankId.Text = ds.Tables[0].Rows[0]["Bank_Id"].ToString();
txtBankName.Text = ds.Tables[0].Rows[0]["Bank_Name"].ToString();
txtBankAddress.Text = ds.Tables[0].Rows[0]["Bank_Address"].ToString();
if (ds.Tables[0].Rows[0]["Is_Active"].ToString() == "1")
{
chkIsAct.Checked = true;
}
else
{
chkIsAct.Checked = false;
}
Popup(true);
}
else
{
Popup(false);
}
}
catch (Exception ex)
{
//lblmsg.Text = "Some Error" + ex.Message.ToString();
}
}
private void Load_Request_Details()
{
string[] param = new string[2];
param[0] = "Request_Id";
param[1] = Request.QueryString["Request_Id"].ToString();
DataSet ds = new DataSet();
ds = CommanDataLoad.ExecuteDataSet("Usp_Load_Request_Detail", "1", "Approve_Request_By_HOD", param);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
txtrequestno.Text = ds.Tables[0].Rows[0]["Request_ID"].ToString();
txtrequestdate.Text = ds.Tables[0].Rows[0]["Request_Date"].ToString();
txtreportingauth.Text = ds.Tables[0].Rows[0]["ReportAuthId"].ToString();
txtrequestedby.Text = ds.Tables[0].Rows[0]["Requested_By"].ToString();
txtrequesttitle.Text = ds.Tables[0].Rows[0]["RequestTitle"].ToString();
txtshortdescription.Text = ds.Tables[0].Rows[0]["Short_Description"].ToString();
txtreasonforchange.Text = ds.Tables[0].Rows[0]["Detail_Description"].ToString();
txtcategory.Text = ds.Tables[0].Rows[0]["RequestType"].ToString();
}
}
}
private void BindGrid()
{
DataSet ds = new DataSet();
ds = CommanDataLoad.ExecuteDataSet("SpDispEmployee_List", "1", "Employee List", "");
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
String UnreadText = "";
Int32 i = 0;
for (i = 0; i < ds.Tables[0].Rows.Count; i++)
{
UnreadText += "<tr style='FONT-SIZE: 12pt;font face ='Arial' >";
UnreadText += " <td class=\"left\">"+ ds.Tables[0].Rows[i]["EmployeeName"].ToString() + "</td>";
UnreadText += " <td class=\"center\">"+ ds.Tables[0].Rows[i]["EmpCode"].ToString() + "</td>";
UnreadText += " <td class=\"center\">"+ ds.Tables[0].Rows[i]["Company"].ToString() + "</td>";
UnreadText += " <td class=\"left\">"+ ds.Tables[0].Rows[i]["EMailID"].ToString() + "</td>";
UnreadText += " <td class=\"center\">"+ ds.Tables[0].Rows[i]["Department"].ToString() + "</td>";
UnreadText += " <td class=\"left\">"+ ds.Tables[0].Rows[i]["Reporting_Emp_name"].ToString() + "</td>";
UnreadText += " <td class=\"center\">"+ ds.Tables[0].Rows[i]["empid"].ToString() + "</td>";
UnreadText += " <td class=\"center\">";
UnreadText += " <a class=\"btn btn-info\" href=\"Employee_Master_Edit.aspx?empid="+ ds.Tables[0].Rows[i]["empid"] + "\">";
UnreadText += " <i class=\"icon-edit icon-white\"></i> ";
UnreadText += " Edit";
UnreadText += " </a>";
UnreadText += " </td>";
UnreadText += " </tr>";
tlist.InnerHtml = UnreadText;
//i++;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
Response.Cookies["user_id"].Value = "0";
Response.Cookies["UserId"].Value = "0";
Response.Cookies["UserName"].Value = "";
Response.Cookies["Name"].Value = "";
Response.Cookies["Company_id"].Value = "0";
Response.Cookies["VendorId"].Value = "0";
Response.Cookies["IbsPer"].Value = "0";
if (Request.QueryString.Count > 0)
{
if (Request.QueryString["msg"].ToString().Equals("1"))
{
Response.Redirect("http://erp.rupeeboss.com/default.aspx?msg=Session Expired, Please login again...!");
}
lblmsg.Text = Request.QueryString["msg"].ToString();
}
DataSet ds = CommanDataLoad.ExecuteDataSet("sp_news_update", "1", "Default", "");
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
lblnews.Text = ds.Tables[0].Rows[0].ItemArray[0].ToString();
}
}
}
}
catch (Exception ex)
{
lblmsg.Text = ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
//bool blnResult = false;
//string strUserGroup = "";
// Session["UserName"] = "******";
string strIP = "";
//int intBOSessionId;
DataSet dsMenus;
//strUserGroup = clsBOMisc.strGetCookie(this, "BO_UserGroupId", "");
strIP = Request.UserHostAddress.ToString();
try
{
string strUserId = Session["UserName"].ToString();
tdwelcome.Attributes.Add("class", "lblDefault");
tdwelcome.Attributes.Add("style", "color:#000");
tdwelcome.InnerHtml = "Welcome, " + strUserId + " | <a href=\"default.aspx\">Logout</a> | <a href=\"Change_password.aspx\">Change Password</a>";
string[] Param = new string[6];
Param[0] = "strUserLogin";
Param[1] = strUserId;
Param[2] = "userid";
Param[3] = "1867";
Param[4] = "groupid";
Param[5] = Request.Cookies["UserGroupId"].Value.ToString();
ds = CommanDataLoad.ExecuteDataSet("[uspUser_Menu]", "1", "RBHome", Param);
if (ds.Tables[0].Rows.Count > 0)
{
dsMenus = ds;
sbmenus = new StringBuilder();
sbAdded = new StringBuilder();
sbmenus.Append("<ul class='nav'><li>");
for (int i = 0; i < dsMenus.Tables[0].Rows.Count; i++)
{
if (dsMenus.Tables[0].Rows[i]["Menu_Name"].ToString() == "Logout")
{
continue;
}
if (sbAdded.ToString().IndexOf(dsMenus.Tables[0].Rows[i]["Menu_Parent"].ToString() + ",") < 0 && Convert.ToInt32(dsMenus.Tables[0].Rows[i]["Menu_Level"].ToString()) > 0)
{
continue;
}
if (sbAdded.ToString().IndexOf(dsMenus.Tables[0].Rows[i]["Menu_Name"].ToString() + ",") < 0 || Convert.ToInt32(dsMenus.Tables[0].Rows[i]["Menu_Level"]) == 0)
{
CreateMenu(dsMenus, dsMenus.Tables[0].Rows[i]["Menu_Name"].ToString(), dsMenus.Tables[0].Rows[i]["Menu_Action"].ToString(), dsMenus.Tables[0].Rows[i]["Menu_Level"].ToString());
}
}
sbmenus.Append("</ul>");
menus.InnerHtml = sbmenus.ToString();
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "OnSessionClosed", "<script language=javascript>subRedirectToDefault();</script>");
return;
}
}
catch (Exception ex)
{
// clsBOMisc.subDisplayError(this, udcErrorSource, udcErrorMethod, "ERROR", ex.ToString());
}
// objDB.blnCloseConnection();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
int rowaffected;
string Emp_Code = Request.Cookies["empcode"].Value.ToString();
//DateTime currentTime = new DateTime();
//currentTime.TimeOfDay;
if (Convert.ToDateTime(ddlStartTime.Text) > (Convert.ToDateTime(ddlEndTime.Text)))
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Start date must be less than end Date')", true);
return;
}
string[] param = new string[14];
param[0] = "Plan_Date";
param[1] = txtDate.Text;
param[2] = "StartTime";
param[3] = ddlStartTime.SelectedValue;
param[4] = "EndTime";
param[5] = ddlEndTime.SelectedValue;
param[6] = "User_Remark";
param[7] = txtRemark.Text;
param[8] = "User_Achieve";
param[9] = txtAchieve.Text;
param[10] = "Emp_Code";
param[11] = Request.Cookies["empcode"].Value.ToString();
param[12] = "Ip_Addr";
param[13] = ClsConnection.StrIP;
string[] param1 = new string[8];
param1[0] = "Plan_Date";
param1[1] = txtDate.Text;
param1[2] = "StartTime";
param1[3] = ddlStartTime.SelectedValue;
param1[4] = "EndTime";
param1[5] = ddlEndTime.SelectedValue;
param1[6] = "Emp_Code";
param1[7] = Request.Cookies["empcode"].Value.ToString();
DataSet ds = new DataSet();
ds = CommanDataLoad.ExecuteDataSet("Select * from Employee_Daily_Planning where StartTime = '" + ddlStartTime.SelectedValue + "' And EndTime = '" + ddlEndTime.SelectedValue + "' And Emp_Code = '" + Emp_Code + "' And Plan_Date = '" + txtDate.Text + "'", "2", "Daily_Planing", "");
//ds = CommanDataLoad.ExecuteDataSet("usp_Load_Employee_planning", "1", "Daily_Planing", param1);
if (ds.Tables[0].Rows.Count > 0)
{
rowaffected = CommanDataLoad.ExecuteNonQuery("USP_Update_Daily_Planning", "1", "Daily_Planing", param);
}
else
{
rowaffected = CommanDataLoad.ExecuteNonQuery("USP_Insert_Emp_Daily_Planing", "1", "Daily_Planing", param);
}
if (rowaffected > 0)
{
Response.Write("<script>alert('Record Saved Successfully.');</script>");
}
Load_SelfGrid();
ClearControls();
ds.Tables.Clear();
}
catch (Exception ex)
{
//lblmsg.Text = "Some Error" + ex.Message.ToString();
}
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
DataSet ds = new DataSet();
Session["checkExits"] = "Edit";
btnSubmit.Text = "Update";
string[] param = new string[2];
param[0] = "ID_Bank_Product";
param[1] = GridView1.SelectedRow.Cells[1].Text;
ds = CommanDataLoad.ExecuteDataSet("USP_Load_Bank_Product_Web_Edit", "1", "Edit Bank_Product_Web", param);
//lblid.Text = GridView1.SelectedRow.Cells[1].Text;
//lblid.Text = lblBank_Pro_Id.Text;
//ddlBank.SelectedValue = GridView1.SelectedRow.Cells[2].Text;
ddlProduct.SelectedValue = Convert.ToInt32(ds.Tables[0].Rows[0]["product_id"]).ToString();
if (Convert.ToInt32(ds.Tables[0].Rows[0]["Bank_id"]).ToString() != "0")
{
ddlBank.SelectedValue = Convert.ToInt32(ds.Tables[0].Rows[0]["Bank_id"]).ToString();
}
else
{
ddlBank.SelectedIndex = -1;
}
btnSubmit.CausesValidation = true;
lblBank_Pro_Id.Text = GridView1.SelectedRow.Cells[1].Text;
lblid.Text = lblBank_Pro_Id.Text;
//ddlBank.Items[ddlBank.SelectedIndex].Text = GridView1.SelectedRow.Cells[2].Text;
//ddlProduct.Items[ddlProduct.SelectedIndex].Text = GridView1.SelectedRow.Cells[3].Text;
txtMinAge.Text = ds.Tables[0].Rows[0]["Min_Age"].ToString();
txtMaxAge.Text = ds.Tables[0].Rows[0]["Max_Age"].ToString();
txtMinInte.Text = ds.Tables[0].Rows[0]["Min_Intrest"].ToString();
txtMaxInte.Text = ds.Tables[0].Rows[0]["Max_Intrest"].ToString();
txtProFee.Text = ds.Tables[0].Rows[0]["ProcessingFee"].ToString();
txtProFeeType.Text = ds.Tables[0].Rows[0]["ProcessingFeeType"].ToString();
txtMinLoan.Text = ds.Tables[0].Rows[0]["Min_Loan"].ToString();
txtMaxLoan.Text = ds.Tables[0].Rows[0]["Max_Loan"].ToString();
txtMinLAmt.Text = ds.Tables[0].Rows[0]["Min_Loan_Amt"].ToString();
txtMaxLAmt.Text = ds.Tables[0].Rows[0]["Max_Loan_Amt"].ToString();
txtMinInSal.Text = ds.Tables[0].Rows[0]["Min_Income_Salary"].ToString();
txtMinInSelf.Text = ds.Tables[0].Rows[0]["Min_Income_Self"].ToString();
txtMinTen.Text = ds.Tables[0].Rows[0]["Min_Tenure"].ToString();
txtPreCharge.Text = ds.Tables[0].Rows[0]["Prepay_Charges"].ToString();
txtCloserCharge.Text = ds.Tables[0].Rows[0]["Closer_Charges"].ToString();
txtMinCreSco.Text = ds.Tables[0].Rows[0]["MinCredit_Score"].ToString();
//txtMinAge.Text = GridView1.SelectedRow.Cells[4].Text;
//txtMaxAge.Text = GridView1.SelectedRow.Cells[5].Text;
//txtMinInte.Text = GridView1.SelectedRow.Cells[6].Text;
//txtMaxInte.Text = GridView1.SelectedRow.Cells[7].Text;
//txtProFee.Text = GridView1.SelectedRow.Cells[8].Text;
//txtProFeeType.Text = GridView1.SelectedRow.Cells[9].Text;
//txtMinLoan.Text = GridView1.SelectedRow.Cells[10].Text;
//txtMaxLoan.Text = GridView1.SelectedRow.Cells[11].Text;
//txtMinLAmt.Text = GridView1.SelectedRow.Cells[12].Text;
//txtMaxLAmt.Text = GridView1.SelectedRow.Cells[13].Text;
//txtMinInSal.Text = GridView1.SelectedRow.Cells[14].Text;
//txtMinInSelf.Text = GridView1.SelectedRow.Cells[15].Text;
//txtMinTen.Text = GridView1.SelectedRow.Cells[16].Text;
//txtPreCharge.Text = GridView1.SelectedRow.Cells[17].Text;
//txtCloserCharge.Text = GridView1.SelectedRow.Cells[18].Text;
//txtMinCreSco.Text = GridView1.SelectedRow.Cells[19].Text;
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["Msg"].ToString()))
{
txtMsg.Text = ds.Tables[0].Rows[0]["Msg"].ToString();
}
else
{
txtMsg.Text = "";
}
//if (!string.IsNullOrEmpty(GridView1.SelectedRow.Cells[20].Text))
//{
// txtMsg.Text = "";
//}
//else
//{
// txtMsg.Text = GridView1.SelectedRow.Cells[20].Text;
//}
//txtMaxTenure.Text = GridView1.SelectedRow.Cells[21].Text;
txtMaxTenure.Text = ds.Tables[0].Rows[0]["Max_Tenure"].ToString();
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["guarantor_required"].ToString()))
{
txtGuarantor.Text = ds.Tables[0].Rows[0]["guarantor_required"].ToString();
}
else
{
txtGuarantor.Text = "";
}
//if (!string.IsNullOrEmpty(GridView1.SelectedRow.Cells[22].Text))
//{
// txtGuarantor.Text = "";
//}
//else
//{
// txtGuarantor.Text = GridView1.SelectedRow.Cells[22].Text;
//}
}
private void BindGrid()
{
ds = new DataSet();
if (hfCityId.Value == "")
{
hfCityId.Value = "0";
}
if (hfemp.Value == "")
{
hfemp.Value = "0";
}
// DataSet ds = new DataSet();
string[] param = new string[6];
param[0] = "empcode";
if (Request.QueryString.Count > 0)
{
param[1] = Request.QueryString["emp_code"].ToString();
}
else
{
param[1] = Session["empcode"].ToString();
}
// param[1] = hfemp.Value;
param[2] = "cityid";
param[3] = hfCityId.Value;
param[4] = "@Status_Id";
param[5] = ddlstatus.SelectedValue;
ds = CommanDataLoad.ExecuteDataSet("SpDispLeads_Telecaller", "1", "Lead Assign Telecaller New", param);
//tlist.InnerHtml = "";
//if (ds != null)
//{
// if (ds.Tables[0].Rows.Count > 0)
// {
// String UnreadText = "";
// Int32 i = 0;
// for (i = 0; i < ds.Tables[0].Rows.Count; i++)
// {
// UnreadText += "<tr style='FONT-SIZE: 12pt;font face ='Arial' >";
// UnreadText += " <td class=\"center\"><input class=\"checkbox\" id='chk' value=" + ds.Tables[0].Rows[i]["lead_id"] + " name=\"check[]\" type =checkbox /> </td>";
// UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["lead_id"].ToString() + "</td>";
// UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["name"].ToString() + "</td>";
// UnreadText += " <td class=\"left\">" + ds.Tables[0].Rows[i]["companyname"].ToString() + "</td>";
// UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["Designation"].ToString() + "</td>";
// UnreadText += " <td class=\"left\">" + ds.Tables[0].Rows[i]["phone"].ToString() + "</td>";
// UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["mobile"].ToString() + "</td>";
// UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["city_name"].ToString() + "</td>";
// UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["email"].ToString() + "</td>";
// UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["Profession_name"].ToString() + "</td>";
// UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["monthlyincome"].ToString() + "</td>";
// UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["Product_name"].ToString() + "</td>";
// UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["lead_source"].ToString() + "</td>";
// UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["assign"].ToString() + "</td>";
// UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["lead_type"].ToString() + "</td>";
// UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["lead_status"].ToString() + "</td>";
// UnreadText += " </tr>";
// tlist.InnerHtml = UnreadText;
// //i++;
// }
// }
//}
}
public void Load_Employee_EditData()
{
string[] Param = new string[2];
Param[0] = "EmpId";
Param[1] = Convert.ToInt16(Request.QueryString["EmpId"]).ToString();
DataSet ds = new DataSet();
ds = CommanDataLoad.ExecuteDataSet("USP_EditEmployee_List", "1", "Edit", Param);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
txtename.Text = ds.Tables[0].Rows[0]["EmployeeName"].ToString();
txtecode.Text = ds.Tables[0].Rows[0]["EmpCode"].ToString();
txtectc.Text = ds.Tables[0].Rows[0]["ctc"].ToString();
txteml.Text = ds.Tables[0].Rows[0]["EMailID"].ToString();
txtevariable.Text = ds.Tables[0].Rows[0]["variable"].ToString();
if (Convert.ToInt32(ds.Tables[0].Rows[0]["company_id"]) > 0)
{
ddlcom.SelectedValue = Convert.ToInt32(ds.Tables[0].Rows[0]["company_id"]).ToString();
}
else
{
ddlcom.SelectedValue = "-1";
}
if (Convert.ToInt16(ds.Tables[0].Rows[0]["Department_Id"]) > 0)
{
ddledept.SelectedValue = Convert.ToInt16(ds.Tables[0].Rows[0]["Department_Id"]).ToString();
}
else
{
ddledept.SelectedValue = "-1";
}
if (Convert.ToInt16(ds.Tables[0].Rows[0]["Designation_Id"]) > 0)
{
ddledesignation.SelectedValue = Convert.ToInt16(ds.Tables[0].Rows[0]["Designation_Id"]).ToString();
}
else
{
ddledesignation.SelectedValue = "-1";
}
txteaddress.Text = ds.Tables[0].Rows[0]["Address"].ToString();
txtemobileno.Text = ds.Tables[0].Rows[0]["Mobile"].ToString();
txtedob.Text = ds.Tables[0].Rows[0]["DOB"].ToString();
if (Convert.ToString(ds.Tables[0].Rows[0]["reporting_emp"]) != "")
{
ddlereporting.SelectedValue = Convert.ToString(ds.Tables[0].Rows[0]["reporting_emp"]).ToString();
}
else
{
ddlereporting.SelectedValue = "-1";
}
if (Convert.ToInt16(ds.Tables[0].Rows[0]["IsActive"]) == 1)
{
chkeactive.Checked = true;
}
else
{
chkeactive.Checked = false;
}
}
else
{
ClearControls();
}
}
}
protected void Button3_Click(object sender, EventArgs e)
{
string[] Param = new string[2];
Param[0] = "email";
Param[1] = TxtEmail.Value;
// TxtEmail.Value = "Dsdsdsds";
DataSet ds = new DataSet();
ds = CommanDataLoad.ExecuteDataSet("User_Master_Password_Select", "1", "Forgot_Password", Param);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
str1 = ds.Tables[0].Rows[0]["email"].ToString();
str2 = ds.Tables[0].Rows[0]["pass"].ToString();
str3 = ds.Tables[0].Rows[0]["username"].ToString();
string mobile = ds.Tables[1].Rows[0]["mobile"].ToString();
string name = ds.Tables[1].Rows[0]["emp_name"].ToString();
// if (TxtEmail.Value == str1)
// {
string strPass = CommanDataLoad.Generate(6, 8);
string str = "update usr_login set pass='******' where email='" + TxtEmail.Value + "' or empcode='" + TxtEmail.Value + "'";
CommanDataLoad.ExecuteNonQuery(str, "2", "Change Pass", "");
String strbody = "";
strbody = strbody + "<table><tr><td><img alt='RupeeBoss.com' width='120px' src='http://erp.rupeeboss.com/Common/Images/Logo.png' ' /></td>";
strbody = strbody + "<td style='font-weight: bold; font-family: Verdana; font-size: 12px;' valign='middle'>";
strbody = strbody + "Welcome to RupeeBoss-ERP</td></tr></table>";
strbody = strbody + "<br/>Dear " + str3 + ",<br/>";
strbody = strbody + "<br/>Your Password is : " + strPass;
strbody = strbody + "<br/><br/>Thank You";
strbody = strbody + "<br /><br />RupeeBoss Software Team<br />";
strbody = strbody + "<br />+91.9920298619<br />";
strbody = strbody + "<br />[email protected]<br /></p>";
string stra = "";
try
{
stra = ClsSendMail.Send_Mail_Direct(str1, strbody, "Password detail", "*****@*****.**");
string smsbody = "Dear " + name + ", Your password for RB ERP and APP is " + strPass;
CommanDataLoad.Send_SMS_Save_Data(mobile, smsbody, Request.UserHostAddress);
GetMessage();
Clear();
}
catch (Exception ex)
{
Response.Write(stra + "--" + ex.Message);
// GetError();
}
Response.Write(stra);
// }
}
else
{
lblmsg.Text = "User not found";
}
}
else
{
lblmsg.Text = "User not found";
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string[] Param = new string[6];
Param[0] = "User";
Param[1] = txtuser.Value;
Param[2] = "pass";
Param[3] = CommanDataLoad.EncryptPassword(txtpass.Value);
Param[4] = "ip";
Param[5] = Request.UserHostAddress;
if (chk.Checked)
{
if (txtpass.Value.ToString().ToUpper().Contains("ADMIN"))
{
Session["UserId"] = txtuser.Value;
Session["UserName"] = txtuser.Value;
Session["empcode"] = txtuser.Value;
Session["UserGroupId"] = "4";
Response.Cookies["UserGroupId"].Value = "4";
Response.Cookies["empcode"].Value = txtuser.Value;
Response.Cookies["UserName"].Value = txtuser.Value;
Response.Cookies["Name"].Value = txtuser.Value;
Response.Redirect("RBHome.aspx");
}
RBERP.PBService.EmployeeRegistrationServiceContractClient client = new RBERP.PBService.EmployeeRegistrationServiceContractClient();
DataSet ds = client.AuthenticateEmployeeLogin(txtuser.Value, txtpass.Value);
if (ds != null)
{
Session["UserId"] = ds.Tables[0].Rows[0]["employee_code"].ToString();
Session["UserName"] = ds.Tables[0].Rows[0]["employee_name"].ToString();
Session["empcode"] = ds.Tables[0].Rows[0]["employee_code"].ToString();
Session["UserGroupId"] = "4";
Response.Cookies["UserGroupId"].Value = "4";
Response.Cookies["empcode"].Value = ds.Tables[0].Rows[0]["employee_code"].ToString();
Response.Cookies["UserName"].Value = txtuser.Value;
Response.Cookies["Name"].Value = txtuser.Value;
Response.Redirect("RBHome.aspx");
}
else
{
lblmsg.Text = "Incorrect User Name Or Password";
}
}
else
{
DataSet ds = new DataSet();
ds = CommanDataLoad.ExecuteDataSet("USP_Select_login", "1", "Login", Param);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
Session["UserId"] = ds.Tables[0].Rows[0]["userid"].ToString();
Session["UserName"] = txtuser.Value;
Session["empcode"] = ds.Tables[0].Rows[0]["empcode"].ToString();
//Response.Cookies["empcode"].Value = ds.Tables[0].Rows[0]["empcode"].ToString();
if (ds.Tables[0].Rows[0]["empcode"].ToString().Equals("RB40000155"))
{
Response.Cookies["empcode"].Value = "RB40000043";
}
else
{
Response.Cookies["empcode"].Value = ds.Tables[0].Rows[0]["empcode"].ToString();
}
Response.Cookies["UserName"].Value = txtuser.Value;
Response.Cookies["Name"].Value = txtuser.Value;
Response.Cookies["UserId"].Value = ds.Tables[0].Rows[0]["userid"].ToString();
Response.Redirect("home.aspx");
}
else
{
lblmsg.Text = "Incorrect User Name Or Password";
}
}
else
{
lblmsg.Text = "Incorrect User Name Or Password";
}
}
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
string strPass = CommanDataLoad.Generate(6, 8);
try
{
string[] param = new string[16];
param[0] = "Broker_Name";
param[1] = txtbroker.Text;
param[2] = "Ip_address";
param[3] = ClsConnection.StrIP;
param[4] = "UserId";
param[5] = ClsConnection.Userid;
param[6] = "Contact_No";
param[7] = txtcontact.Text;
param[8] = "PAN_No";
param[9] = txtPAN.Text;
param[10] = "Emp_Code";
param[11] = ddlEmployee.SelectedValue;
param[12] = "Email_Id";
param[13] = txtEmail.Text;
param[14] = "UserPassword";
param[15] = CommanDataLoad.EncryptPassword(strPass);
Send_mail(strPass);
int rowaffect = 0;
DataSet ds = new DataSet();
ds = CommanDataLoad.ExecuteDataSet("Usp_Insert_BrokerDetail", "1", "Broker Master", param);
if (ds != null)
{
string brokId = ds.Tables[0].Rows[0]["BrokerId"].ToString();
int i = 0;
while (i < gvBrokerProd.Rows.Count)
{
CheckBox chk = (CheckBox)gvBrokerProd.Rows[i].FindControl("chk");
if (chk.Checked == true)
{
TextBox txtPayout = (TextBox)gvBrokerProd.Rows[i].FindControl("txtPayoutper");
string[] param1 = new string[6];
param1[0] = "Broker_Id";
param1[1] = brokId;
param1[2] = "Product_Id";
param1[3] = gvBrokerProd.Rows[i].Cells[1].Text;
param1[4] = "PayoutPer";
param1[5] = txtPayout.Text;
rowaffect = CommanDataLoad.ExecuteNonQuery("USP_Insert_BrokerProductMapping", "1", "Broker Master", param1);
}
i = i + 1;
}
if (rowaffect > 0)
{
Response.Write("<script>alert('Record Saved Successfully.');</script>");
//BindGrid();
}
}
ClearControls();
BindGrid();
Load_Grid();
}
catch (Exception ex)
{
lblmsg.Text = "Some Error" + ex.Message.ToString();
}
}
protected void Load_Grid()
{
try
{
string[] param = new string[2];
param[0] = "Emp_Code";
param[1] = Request.Cookies["empcode"].Value.ToString();
DataSet ds = new DataSet();
ds = CommanDataLoad.ExecuteDataSet("USP_Load_VerticalWiseStatusRpt", "1", "Vertical Wise Status Report", param);
if (ds.Tables[0].Rows.Count > 0)
{
DataTable dt = new DataTable();
int i = 0;
dt.Columns.Add("Sr.No.", typeof(string));
dt.Columns.Add("Vertical Name", typeof(string));
while (i < ds.Tables[2].Rows.Count)
{
dt.Columns.Add(ds.Tables[2].Rows[i].ItemArray[1].ToString(), typeof(string));// GetType(String));
i = i + 1;
}
dt.Columns.Add("Total", typeof(int));
string str;
i = 0;
int j = 0;
DataRow dr;
int Total = 0;
int[] StrTotal = new int[ds.Tables[2].Rows.Count];
while (i < ds.Tables[1].Rows.Count)
{
Total = 0;
dr = dt.NewRow();
dr[0] = i + 1;
dr[1] = ds.Tables[1].Rows[i].ItemArray[1] + "=" + ds.Tables[1].Rows[i].ItemArray[0];
j = 0;
while (j < ds.Tables[2].Rows.Count)
{
var results = from myRow in ds.Tables[0].AsEnumerable() where ((myRow.Field <int>("Vertical_Id") == Convert.ToInt16(ds.Tables[1].Rows[i].ItemArray[0].ToString())) && (myRow.Field <int>("Lead_Status_Id") == Convert.ToInt16(ds.Tables[2].Rows[j].ItemArray[0]))) select myRow.Field <int>("leadcnt");
dr[j + 2] = results.SingleOrDefault();
Total = Total + Convert.ToInt16(results.SingleOrDefault());
StrTotal[j] = StrTotal[j] + Convert.ToInt16(results.SingleOrDefault());
j = j + 1;
}
// str = "<a target='_blank' href='SMN_FaultyStatus_Detail.aspx?region_id=" + ds.Tables[1].Rows[i].ItemArray[0].ToString() + "'>" + Total + "</a>";
dr[j + 2] = Total;
dt.Rows.Add(dr);
i = i + 1;
}
Total = 0;
dr = dt.NewRow();
dr[0] = i + 1;
dr[1] = "Grand Total";
j = 0;
while (j < ds.Tables[2].Rows.Count)
{
dr[j + 2] = StrTotal[j];
Total = Total + Convert.ToInt16(dr[j + 2]);
j = j + 1;
}
dr[j + 2] = Total;
dt.Rows.Add(dr);
i = i + 1;
DataSet ds1 = new DataSet();
ds1.Tables.Add(dt);
GridView1.DataSource = ds1;
GridView1.DataBind();
i = 0;
string[] StrRegion;
while (i < GridView1.Rows.Count - 1)
{
j = 0;
StrRegion = GridView1.Rows[i].Cells[1].Text.ToString().Split('=');
GridView1.Rows[i].Cells[1].Text = StrRegion[0];
while (j < ds.Tables[2].Rows.Count)
{
if (GridView1.Rows[i].Cells[j + 2].Text == "0")
{
GridView1.Rows[i].Cells[j + 2].Text = "0";
}
else
{
str = "<a target='_blank' href='VerticalStatusLeadDetails.aspx?Vertical_Id=" + StrRegion[1] + "&Lead_Status_id=" + ds.Tables[2].Rows[j].ItemArray[0] + "'>" + GridView1.Rows[i].Cells[j + 2].Text + "</a>";
GridView1.Rows[i].Cells[j + 2].Text = str;
}
j = j + 1;
}
str = "<a target='_blank' href='VerticalStatusLeadDetails.aspx?Vertical_Id=" + StrRegion[1] + "'>" + GridView1.Rows[i].Cells[j + 2].Text + "</a>";
GridView1.Rows[i].Cells[j + 2].Text = str;
i = i + 1;
}
j = 0;
while (j < ds.Tables[2].Rows.Count)
{
str = "<a target='_blank' href='VerticalStatusLeadDetails.aspx?Lead_Status_id=" + ds.Tables[2].Rows[j].ItemArray[0] + "'>" + GridView1.Rows[i].Cells[j + 2].Text + "</a>";
GridView1.Rows[i].Cells[j + 2].Text = str;
j = j + 1;
}
GridView1.Rows[GridView1.Rows.Count - 1].Cells[GridView1.Rows[0].Cells.Count - 1].Text = "<a target='_blank' href='VerticalStatusLeadDetails.aspx?Lead_Status_id=0&Vertical_Id=0'>" + GridView1.Rows[GridView1.Rows.Count - 1].Cells[GridView1.Rows[0].Cells.Count - 1].Text + "</a>";
}
}
catch (Exception ex)
{
//lblmsg.Text = "Some Error" + ex.Message.ToString();
}
}
//[WebMethod(enableSession: true)]
//public static Class.ClsManageLeads[] BindDatatable(String prefix)
//{
// string empcode = HttpContext.Current.Request.Cookies["empcode"].Value.ToString();
// DataSet ds = new DataSet();
// string[] param1 = new string[12];
// param1[0] = "empcode";
// // param1[1] = "RB40000401";
// if (HttpContext.Current.Request.QueryString.Count > 0)
// {
// param1[1] = HttpContext.Current.Request.QueryString["emp_code"].ToString();
// }
// else
// {
// param1[1] = empcode.ToString();
// }
// param1[2] = "cityid";
// param1[3] = "0";
// param1[4] = "Lead_Status_id";
// param1[5] ="0";
// param1[6] = "Emp_Code";
// param1[7] = "0";
// param1[8] = "fdate";
// param1[9] = "";
// param1[10] = "tdate";
// param1[11] = "";
// ds = CommanDataLoad.ExecuteDataSet("SpDispManageLeadData", "1", "Manage Lead List", param1);
// List<Class.ClsManageLeads> Data = new List<Class.ClsManageLeads>();
// if (ds != null)
// {
// if (ds.Tables[0].Rows.Count > 0)
// {
// Int32 i = 0;
// for (i = 0; i < ds.Tables[0].Rows.Count; i++)
// {
// Class.ClsManageLeads cl = new Class.ClsManageLeads();
// cl.LeadId = ds.Tables[0].Rows[i]["leadid"].ToString();
// cl.name = ds.Tables[0].Rows[i]["name"].ToString();
// cl.lead_status = ds.Tables[0].Rows[i]["leadstatus"].ToString();
// cl.mobile = ds.Tables[0].Rows[i]["mobile"].ToString();
// cl.leaddate = ds.Tables[0].Rows[i]["leaddate"].ToString();
// cl.nextdate = ds.Tables[0].Rows[i]["next_date"].ToString();
// cl.remark = ds.Tables[0].Rows[i]["remark"].ToString();
// cl.companyname = ds.Tables[0].Rows[i]["companyname"].ToString();
// cl.designation = ds.Tables[0].Rows[i]["designation"].ToString();
// cl.phone = ds.Tables[0].Rows[i]["phone"].ToString();
// cl.cityname = ds.Tables[0].Rows[i]["city_name"].ToString();
// cl.empcode = ds.Tables[0].Rows[i]["emp_code"].ToString();
// cl.bankname = ds.Tables[0].Rows[i]["bank_name"].ToString();
// cl.empname = ds.Tables[0].Rows[i]["emp_name"].ToString();
// Data.Add(cl);
// }
// }
// }
// return Data.ToArray();
//}
private void BindGrid()
{
ds = new DataSet();
string[] param1 = new string[12];
param1[0] = "empcode";
// param1[1] = "RB40000401";
if (Request.QueryString.Count > 0)
{
param1[1] = Request.QueryString["emp_code"].ToString();
}
else
{
param1[1] = Request.Cookies["empcode"].Value.ToString();
}
param1[2] = "cityid";
param1[3] = hfCityId.Value;
param1[4] = "Lead_Status_id";
param1[5] = hfstatus.Value;
param1[6] = "Emp_Code";
param1[7] = hfemp.Value;
param1[8] = "fdate";
param1[9] = txtfromdt.Text;
param1[10] = "tdate";
param1[11] = txttodt.Text;
ds = CommanDataLoad.ExecuteDataSet("SpDispManageLeadData", "1", "Manage Lead List", param1);
// tlist.InnerHtml = "";
//if (ds != null)
//{
// if (ds.Tables[0].Rows.Count > 0)
// {
// String UnreadText = "";
// Int32 i = 0;
// for (i = 0; i < ds.Tables[0].Rows.Count; i++)
// {
// UnreadText += "<tr style='FONT-SIZE: 12pt;font face ='Arial' >";
// UnreadText += " <td class=\"center\"><input class=\"checkbox\" id='chk' value=" + ds.Tables[0].Rows[i]["leadid"] +" name=\"check[]\" type =checkbox /> </td>";
// UnreadText += " <td class=\"center\">";
// UnreadText += " <a href=\"Manage_lead_data.aspx?leadid=" + ds.Tables[0].Rows[i]["leadid"] + "\">";
// UnreadText += " "+ ds.Tables[0].Rows[i]["leadid"] + "";
// UnreadText += " </a>";
// UnreadText += " </td>";
// UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["name"].ToString() + "</td>";
// UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["emp_code"].ToString() + "</td>";
// UnreadText += " <td class=\"left\">" + ds.Tables[0].Rows[i]["emp_name"].ToString() + "</td>";
// UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["City_Name"].ToString() + "</td>";
// UnreadText += " <td class=\"left\">" + ds.Tables[0].Rows[i]["Mobile"].ToString() + "</td>";
// UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["leadstatus"].ToString() + "</td>";
// UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["next_date"].ToString() + "</td>";
// UnreadText += " <td class=\"center\">" + ds.Tables[0].Rows[i]["remark"].ToString() + "</td>";
// UnreadText += " </tr>";
// tlist.InnerHtml = UnreadText;
// //i++;
// }
// }
//}
}
