protected void ClearControls()
{
Name.Text = "";
txtAddress.Text = "";
txtEmailId.Text = "";
txtIncome.Text = "";
txtMobile.Text = "";
txtPan.Text = "";
ddlCity.SelectedValue = "0";
ddlproduct.SelectedValue = "0";
ddlProfession.SelectedValue = "0";
ddlState.SelectedValue = "0";
txtDob.Text = "";
txtcompanyname.Text = "";
txtdesignation.Text = "";
ddlstatus.SelectedItem.Text = "Select";
ddlleadtype.SelectedItem.Text = "Select";
txtndate.Text = "";
ddlVertical.SelectedIndex = -1;
ddlBank.SelectedIndex = -1;
txtLoanAmt.Text = "";
lblUserId.Text = "";
Name.Focus();
CommanDataLoad.Load_CommanDropDown(ddlstatus, "", "select * from lead_Status_Master order by lead_status asc", "0", "lead_Status_id", "Lead_Status", "Lead_status_Master", "");
}
protected void Page_Load(object sender, EventArgs e)
{
// Response.Cookies["empcode"].Value = "RB40000401";
if (!IsPostBack)
{
CommanDataLoad.Load_CommanDropDown(ddlstatus, "", "select * from lead_Status_Master order by lead_status asc", "0", "lead_Status_id", "Lead_Status", "Lead_status_Master", "");
FillControl();
Load_Bank();
txtDob.Text = DateTime.Today.AddYears(-20).ToShortDateString();
txtndate.Text = DateTime.Today.ToShortDateString();
if (Request.QueryString["source"] != "" && Request.QueryString["source"] != null)
{
string str = Request.QueryString["source"];
string[] strArr = null;
char[] splitchar = { ':' };
strArr = str.Split(splitchar);
lblUserId.Text = strArr[0];
sourcetype = strArr[1];
Load_SourceType(sourcetype);
ddlsouce.SelectedValue = "15";
ddlstatus.SelectedValue = "41";
if (strArr.Length > 2)
{
if (strArr[2] != "")
{
cityNm = strArr[2];
Load_State(cityNm);
}
}
Name.Text = Request.QueryString["cname"].ToString();
txtMobile.Text = Request.QueryString["cmobile"].ToString();
}
}
}
void Load_Parent()
{
string[] Param = new string[2];
Param[0] = "Module";
Param[1] = cbmodule.SelectedValue;
CommanDataLoad.Load_CommanDropDown(ddlParentName, "", "usp_select_parent_menu", "1", "Menu_Name", "Menu_Name", "Menu Master", Param);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
CommanDataLoad.Load_CommanDropDown(ddlstatus, "", "select * from lead_Status_Master order by lead_status asc", "0", "lead_Status_id", "Lead_Status", "Lead_status_Master", "");
BindGrid();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
CommanDataLoad.Load_CommanDropDown(ddlstate, "", "select * from state_Master order by state_name asc", "0", "state_id", "state_name", "City_Master", "");
BindGrid();
}
}
private void Load_Reporting_Auth()
{
string[] param = new string[2];
param[0] = "Emp_Code";
param[1] = Request.Cookies["empcode"].Value.ToString();
//param[1] = "RB40000255";
CommanDataLoad.Load_CommanDropDown(ddlreportingauth, "", "Usp_Load_Reporting_Authority", "1", "Reporting_emp", "Emp_Name", "LogRequest", param);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
CommanDataLoad.Load_CommanDropDown(ddlproduct, "", "select product_id,product_name from product_master order by Product_Name", "0", "product_id", "product_name", "product_master", "");
CommanDataLoad.Load_CommanDropDown(ddlbank, "", "select bank_id,bank_name from Bank_master order by bank_name", "0", "bank_id", "bank_name", "Bank_master", "");
BindGrid();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
CommanDataLoad.Load_CommanDropDown(ddlEmployee, "", "select * from dbo.get_child_emp('" + Request.Cookies["empcode"].Value.ToString() + "') order by name asc", "0", "emp_code", "name", "Broker Master", "");
Load_Grid();
BindGrid();
}
}
protected void Page_Load(object sender, EventArgs e)
{
//Session["empcode"] = "RB40000043";
//Response.Cookies["empcode"].Value = "RB40000043";
if (!IsPostBack)
{
CommanDataLoad.Load_CommanDropDown(ddlstatus, "", "select * from lead_Status_Master order by lead_status asc", "0", "lead_Status_id", "Lead_Status", "Lead_status_Master", "");
BindGrid();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
// Session["empcode"] = "RB40000401";
CommanDataLoad.Load_CommanDropDown(ddltelecaller, "", "select * from employee_master where reporting_emp='" + Request.Cookies["empcode"].Value.ToString() + "' order by emp_name asc", "0", "emp_code", "emp_name", "Employee_Master", "");
CommanDataLoad.Load_CommanDropDown(ddlCity, "", "Get_CityState", "1", "City_Id", "City_Name", "City_Master", "");
CommanDataLoad.Load_CommanDropDown(ddlstatus, "", "select * from lead_Status_Master order by lead_status asc", "0", "lead_Status_id", "Lead_Status", "Lead_status_Master", "");
BindGrid();
}
}
protected void dgValidlead_SelectedIndexChanged(object sender, EventArgs e)
{
CommanDataLoad.Load_CommanDropDown(ddlvleadstatus, "", "select * from Lead_status_master order by Lead_Status asc", "0", "Lead_status_id", "Lead_Status", "Manage_Leads_self", "");
CommanDataLoad.Load_CommanDropDown(ddlvAssignTo, "", "select * from dbo.get_child_emp('" + Request.Cookies["empcode"].Value.ToString() + "') order by name", "0", "emp_code", "name", "Manage Lead Self", "");
txtvfollowupdate.Text = DateTime.Now.Date.ToShortDateString();
txtvamt.Text = dgValidlead.SelectedRow.Cells[2].Text;
ddlvleadstatus.SelectedValue = dgValidlead.SelectedRow.Cells[6].Text;
ddlvAssignTo.SelectedValue = dgValidlead.SelectedRow.Cells[7].Text;
txtvremark.Text = dgValidlead.SelectedRow.Cells[4].Text;
vleadidhidden.Text = dgValidlead.SelectedRow.Cells[5].Text;
}
protected void Page_Load(object sender, EventArgs e)
{
//if (CommanDataLoad.CheckUserRights("19", Request.Cookies["userid"].Value.ToString()) == 0)
//{
// Response.Write("Please Login Again");
// ClientScript.RegisterClientScriptBlock(this.GetType(), "NO ACCESS", "<script language=javascript>javascript:subRedirectToDefault1();</script>");
// return;
//}
if (!IsPostBack)
{
CommanDataLoad.Load_CommanDropDown(ddluser, "", "Select UserId,UserName from usr_login order by UserName", "2", "UserId", "UserName", "Group Rights", "");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
CommanDataLoad.Load_CommanDropDown(ddledept, "", "select department_id,department_name from department_Master order by department_name asc", "0", "department_id", "department_name", "department_Master", "");
CommanDataLoad.Load_CommanDropDown(ddledesignation, "", "select designation_id,designation from designation_Master order by designation asc", "0", "designation_id", "designation", "designation_Master", "");
CommanDataLoad.Load_CommanDropDown(ddlcom, "", "select Company_id,company_name from company_Master", "0", "Company_id", "company_name", "Company_Master", "");
CommanDataLoad.Load_CommanDropDown(ddlereporting, "", "select Empid,emp_name from employee_Master order by emp_name asc", "0", "empid", "emp_name", "Employee_Master", "");
BindGrid();
//dgemployeelist.DataSource = BindGrid();
//dgemployeelist.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
CommanDataLoad.Load_CommanDropDown(ddledept, "", "select department_id,department_name from department_Master order by department_name asc", "0", "department_id", "department_name", "department_Master", "");
CommanDataLoad.Load_CommanDropDown(ddledesignation, "", "select designation_id,designation from designation_Master order by designation asc", "0", "designation_id", "designation", "designation_Master", "");
CommanDataLoad.Load_CommanDropDown(ddlcom, "", "select Company_id,company_name from company_Master", "0", "Company_id", "company_name", "Company_Master", "");
CommanDataLoad.Load_CommanDropDown(ddlereporting, "", "select emp_code,emp_name from employee_Master order by emp_name asc", "0", "emp_code", "emp_name", "Employee_Master", "");
Load_Employee_EditData();
string[] Param = new string[2];
Param[0] = "emp";
Param[1] = Convert.ToInt16(Request.QueryString["EmpId"]).ToString();
CommanDataLoad.Load_Gridview(GridView1, "sp_get_login_history", "1", "Edit employee", Param);
}
}
protected void ClearControls()
{
Name.Text = "";
txtMobile.Text = "";
ddlproduct.SelectedValue = "0";
ddlstatus.SelectedItem.Text = "New";
ddlsouce.SelectedItem.Text = "PolicyBoss";
ddlstatus.SelectedValue = "43";
ddlsouce.SelectedValue = "15";
ddlVertical.SelectedIndex = -1;
lblUserId.Text = "";
Name.Focus();
CommanDataLoad.Load_CommanDropDown(ddlstatus, "", "select * from lead_Status_Master order by lead_status asc", "0", "lead_Status_id", "Lead_Status", "Lead_status_Master", "");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
lblvlid.Text = Request.QueryString["leadid"].ToString();
Load_Bank();
Load_Assign_To();
Load_lead_Status();
Bind_Valid_PopUpGrid();
BindTime();
txtvfollowupdate.Text = DateTime.Now.Date.ToShortDateString();
string[] Param = new string[2];
Param[0] = "empcode";
Param[1] = Request.Cookies["empcode"].Value.ToString();
CommanDataLoad.Load_CommanDropDown(ddlproduct, "", "Get_Product", "1", "product_id", "product_name", "Manage Lead Data", "");
CommanDataLoad.Load_CommanDropDown(ddlbroker, "", "sp_load_broker", "1", "broker_id", "broker_name", "Lead Capture", Param);
Load_Data();
}
}
protected void Page_Load(object sender, EventArgs e)
{
// Response.Cookies["empcode"].Value = "RB40000401";
if (!Page.IsPostBack)
{
CommanDataLoad.Load_CommanDropDown(ddlStatus, "Select All", "select * from lead_Status_Master order by lead_status asc", "0", "lead_Status_id", "Lead_Status", "Lead_status_Master", "");
Load_lead_Status();
Load_Assign_To();
Load_City();
Load_Bank();
BindGrid();
BindTime();
//Util.JQueryUtils.RegisterTextBoxForDatePicker(Page, txtfollowup);
////RBERP.JQueryUtils.RegisterTextBoxForDatePicker(Page, txtfollowup);
////RBERP.JQueryUtils.RegisterTextBoxForDatePicker(Page, txtvfollowupdate);
}
}
private void FillControl()
{
string[] param = new string[1];
FillCity(param);
FillState(param);
FillProduct(param);
FillProfession(param);
ddlleadtype.Items.Insert(1, "Hot");
ddlleadtype.Items.Insert(2, "Warm");
load_source();
Load_Vertical(param);
string[] Param = new string[2];
Param[0] = "empcode";
Param[1] = Request.Cookies["empcode"].Value.ToString();
CommanDataLoad.Load_CommanDropDown(ddlassign, "", "sp_get_downteam", "1", "emp_code", "emp_name", "Lead Capture", Param);
CommanDataLoad.Load_CommanDropDown(ddlbroker, "", "sp_load_broker", "1", "broker_id", "broker_name", "Lead Capture", Param);
if (ddlassign.Items.Count > 0)
{
ddlassign.SelectedValue = Request.Cookies["empcode"].Value.ToString();
}
}
void Load_Module()
{
CommanDataLoad.Load_CommanDropDown(ddlmodule, "", "select distinct module_name from menu_master order by module_name ", "0", "module_name", "module_name", "Menu Edit", "");
}
private void Load_Req_Category()
{
CommanDataLoad.Load_CommanDropDown(ddlrequesttype, "", "Usp_Load_Soft_Request_Category", "0", "Category_ID", "Category_Name", "LogRequest", "");
}
void Load_Child()
{
CommanDataLoad.Load_CommanDropDown(ddlEmp, "", "Select * from Employee_Master", "0", "Emp_Code", "Emp_Name", "Broker Master", "");
}
protected void ddlmodule_SelectedIndexChanged(object sender, EventArgs e)
{
CommanDataLoad.Load_CommanDropDown(ddlmenu, "", "select MenuMasterID, Menu_Name from menu_master where menu_action='' and module_name='" + ddlmodule.SelectedValue + "' order by Menu_Name", "0", "Menu_Name", "Menu_Name", "Menu Edit", "");
}
protected void Load_Product()
{
CommanDataLoad.Load_CommanDropDown(ddlBank, "", "Get_Product", "1", "Product_Id", "Product_Name", "Product_Master", "");
}
void Load_lead_Status()
{
CommanDataLoad.Load_CommanDropDown(ddlvleadstatus, "Select All", "select * from Lead_status_master order by Lead_Status asc", "0", "Lead_status_id", "Lead_Status", "Manage_Leads_self", "");
}
void Load_Assign_To()
{
CommanDataLoad.Load_CommanDropDown(ddlEmployee, "Select All", "select * from dbo.get_child_emp('" + Request.Cookies["empcode"].Value.ToString() + "') order by name asc", "0", "emp_code", "name", "Manage Lead Self", "");
CommanDataLoad.Load_CommanDropDown(ddlvAssignTo, "", "select * from dbo.get_child_emp('" + Request.Cookies["empcode"].Value.ToString() + "') order by name", "0", "emp_code", "name", "Manage Lead Self", "");
}
void Load_City()
{
CommanDataLoad.Load_CommanDropDown(ddlCity, "Select All", "Get_CityState", "1", "City_Id", "City_Name", "Manage_Leads_self", "");
}
protected void Load_Bank()
{
CommanDataLoad.Load_CommanDropDown(ddlBank, "", "USP_Load_Bank", "1", "Bank_Id", "Bank_Name", "Bank_Master", "");
}
private void Load_Company()
{
CommanDataLoad.Load_CommanDropDown(ddlcompany, "", " select * from Company_Master", "0", "Company_Id", "Company_Name", "", "");
}
protected void Load_City()
{
CommanDataLoad.Load_CommanDropDown(ddlCity, "", "Get_CityState", "1", "City_Id", "City_Name", "City_Master", "");
}
private void Load_Group()
{
CommanDataLoad.Load_CommanDropDown(ddlGroupid, "", " select * from group_Master", "0", "Groupid", "GroupName", "", "");
}
