protected void Load_Broker_Detail(string Broker_Id)
{
try
{
string[] param = new string[2];
param[0] = "Broker_Id";
param[1] = Broker_Id;
DataSet ds = new DataSet();
ds = CommanDataLoad.ExecuteDataSet("USP_Load_Broker_Detail", "1", "Edit Broker Master", param);
if (ds != null)
{
lblBrokerId.Text = ds.Tables[0].Rows[0]["Broker_Id"].ToString();
txtBrokerName.Text = ds.Tables[0].Rows[0]["Broker_Name"].ToString();
txtContactNo.Text = ds.Tables[0].Rows[0]["Contact_No"].ToString();
txtPANNo.Text = ds.Tables[0].Rows[0]["PAN_No"].ToString();
txtEmailid.Text = ds.Tables[0].Rows[0]["Email_Id"].ToString();
Load_Child();
ddlEmp.SelectedValue = ds.Tables[0].Rows[0]["Emp_Code"].ToString();
CommanDataLoad.Load_Gridview(gvbpchild, "USP_Load_BrokerProductDetail", "1", "Broker_Master", param);
Popup(true);
}
else
{
Popup(false);
}
}
catch (Exception ex)
{
//lblmsg.Text = "Some Error" + ex.Message.ToString();
}
}
public void Fill_Grid_Product()
{
try
{
string[] param1 = new string[6];
param1[0] = "fdate";
param1[1] = Convert.ToString(Request.QueryString["fdate"]);
param1[2] = "tdate";
param1[3] = Convert.ToString(Request.QueryString["tdate"]);
param1[4] = "Reporting_emp";
param1[5] = Convert.ToString(Request.QueryString["emp_code"]);
param1[6] = "Product_Id";
param1[7] = Convert.ToString(Request.QueryString["Product_Id"]);
//param1[5] = "RB40000043";
CommanDataLoad.Load_Gridview(grdDetails, "Usp_Sales_report_Product_Detail", "1", "admin_dashboard_sales_report", param1);
}
catch
{
throw;
}
finally
{
}
}
public void Bind_Valid_PopUpGrid()
{
string[] param1 = new string[2];
param1[0] = "Lead_ID";
param1[1] = Request.QueryString["leadid"].ToString();
CommanDataLoad.Load_Gridview(dgValidlead, "spdispManageLeadData_history", "1", "Manage_Leads", param1);
}
protected void Load_Grid()
{
if (txtfromdt.Text == "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Please Select From Date')", true);
return;
}
if (txttodt.Text == "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Please Select To Date')", true);
return;
}
string[] param = new string[6];
param[0] = "FromDt";
param[1] = txtfromdt.Text;
param[2] = "ToDt";
param[3] = txttodt.Text;
param[4] = "Emp_Code";
param[5] = Request.Cookies["empcode"].Value.ToString();
//param[5] = "RB40000043";
CommanDataLoad.Load_Gridview(GridView1, "USP_Load_Lead_Count_Report_new", "1", "Assign Lead Report", param);
CommanDataLoad.Load_Gridview(GridView2, "USP_Lead_Count_Report_StatusWise", "1", "Assign Lead Report", param);
if (GridView1.Rows.Count > 0 && GridView2.Rows.Count > 0)
{
//Panel1.Visible = true;
//Panel2.Visible = true;
}
}
public void Load_Grid()
{
try
{
string[] param = new string[2];
param[0] = "Requested_By";
param[1] = Request.Cookies["empcode"].Value.ToString();
//param[1] = "RB40000043";
CommanDataLoad.Load_Gridview(GridView1, "Usp_Load_Sw_Pending_Authority_Request_Report", "1", "Pending_Authority_Approval_Request_List_aspx", param);
}
catch (Exception ex)
{
lblmsg.Visible = true;
lblmsg.Text = "Some Error" + ex.Message.ToString();
}
if (GridView1.Rows.Count > 0)
{
lblmsg.Visible = false;
}
else
{
lblmsg.Visible = true;
lblmsg.Text = "No Pending Approval Request...!";
}
}
public void Bind_Valid_PopUpGrid()
{
string[] param1 = new string[2];
param1[0] = "Lead_ID";
param1[1] = lblvlid.Text;
CommanDataLoad.Load_Gridview(dgValidlead, "spdispManageLeadData_history", "1", "Manage_Leads_self", param1);
}
private void BindGrid()
{
string[] param1 = new string[2];
param1[0] = "Emp_Code";
param1[1] = Request.Cookies["empcode"].Value.ToString();
CommanDataLoad.Load_Gridview(GridView1, "Usp_Load_BrokerDetail", "1", "Broker_Master", param1);
}
public void Lod_Grid_Data()
{
string[] Param = new string[2];
Param[0] = "emp_code";
Param[1] = Request.Cookies["empcode"].Value.ToString();
//Param[1] ="131";
CommanDataLoad.Load_Gridview(GridView1, "Usp_Load_TargetedData", "1", "Target_Report", Param);
}
private void BindGrid()
{
string[] param = new string[2];
param[0] = "emp_code";
// param[1] = "RB40000098";
param[1] = Request.Cookies["empcode"].Value.ToString();
CommanDataLoad.Load_Gridview(dgteam, "SpDispLeadTeamMembers", "1", "Manage_Leads_Team", param);
}
protected void Load_Grid()
{
try
{
CommanDataLoad.Load_Gridview(GridView1, "USP_Load_Bank_Product_Mapping", "1", "Bank Product Mapping", "");
}
catch (Exception ex)
{
//lblmsg.Text = "Some Error" + ex.Message.ToString();
}
}
protected void Load_Grid()
{
try
{
CommanDataLoad.Load_Gridview(GridView1, "USP_Load_SourceNAme", "1", "Source Master", "");
}
catch (Exception ex)
{
//lblmsg.Text = "Some Error" + ex.Message.ToString();
}
}
public void BindGrid()
{
string[] param = new string[6];
param[0] = "empcode";
param[1] = Request.Cookies["empcode"].Value.ToString();
param[2] = "cityid";
param[3] = ddlCity.SelectedValue;
param[4] = "@Status_Id";
param[5] = ddlstatus.SelectedValue;
//param[1] = "RB40000401";
CommanDataLoad.Load_Gridview(dglead, "SpDispLeads_Telecaller", "1", "Lead_Assign_Telecaller", param);
}
public void Bind_Employee_Sales()
{
string[] param1 = new string[6];
param1[0] = "fdate";
param1[1] = txtfromdt.Text;
param1[2] = "tdate";
param1[3] = txttodt.Text;
param1[4] = "Reporting_emp";
param1[5] = Request.Cookies["empcode"].Value.ToString();
// param1[5] = Session["empcode"].ToString();
//param1[5] = "RB40000043";
CommanDataLoad.Load_Gridview(grdSales, "usp_sales_report_employee", "1", "admin_dashboard_sales_report", param1);
}
protected void Load_Grid()
{
try
{
string[] param = new string[2];
param[0] = "Menu_Parent";
param[1] = ddlmenu.SelectedValue;
CommanDataLoad.Load_Gridview(GridView1, "USP_Load_MenuList", "1", "Menu Edit", param);
}
catch (Exception ex)
{
//lblmsg.Text = "Some Error" + ex.Message.ToString();
}
}
public void Load_Grid()
{
try
{
string[] param = new string[4];
param[0] = "Empcode";
param[1] = Request.Cookies["empcode"].Value.ToString();
param[2] = "Plan_Date";
param[3] = txtDate.Text;
CommanDataLoad.Load_Gridview(GridView1, "USP_Load_EMP_Team_Daily_Planing", "1", "Daily_Planing", param);
}
catch (Exception ex)
{
//lblmsg.Text = "Some Error" + ex.Message.ToString();
}
}
public void Load_Grid()
{
try
{
//string[] param = new string[4];
//param[0] = "Empcode";
//param[1] = Request.Cookies["empcode"].Value.ToString();
//param[2] = "Plan_Date";
//param[3] = txtDate.Text;
CommanDataLoad.Load_Gridview(GridView1, "Usp_Load_Sw_Request_Report", "0", "Software_Request_Report", "");
}
catch (Exception ex)
{
lblmsg.Text = "Some Error" + ex.Message.ToString();
}
}
protected void Load_Lead_History(string Lead_Id)
{
try
{
string[] param = new string[2];
param[0] = "Lead_Id";
param[1] = Lead_Id;
CommanDataLoad.Load_Gridview(grdHistory, "USP_Load_Lead_Detail_History", "1", "View Assign Lead Detail", param);
Popup(true);
}
catch (Exception ex)
{
//lblmsg.Text = "Some Error" + ex.Message.ToString();
}
}
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 Load_Grid()
{
try
{
string[] param = new string[6];
param[0] = "Vertical_Id";
param[1] = Request.QueryString["Vertical_Id"];
param[2] = "Lead_Status_id";
param[3] = Request.QueryString["Lead_Status_id"];
param[4] = "Emp_Code";
param[5] = Request.Cookies["empcode"].Value.ToString();
CommanDataLoad.Load_Gridview(GridView1, "USP_Load_LeadDetail", "1", "Vertical Lead Details", param);
}
catch (Exception ex)
{
}
}
protected void Load_Grid()
{
try
{
string[] param = new string[6];
param[0] = "Empcode";
param[1] = Request.Cookies["empcode"].Value.ToString();
param[2] = "Month";
param[3] = ddlMonth.SelectedValue;
param[4] = "Year";
param[5] = ddlYear.SelectedValue;
CommanDataLoad.Load_Gridview(GridView1, "USP_Load_Team", "1", "Team_Target_Form", param);
}
catch (Exception ex)
{
//lblmsg.Text = "Some Error" + ex.Message.ToString();
}
}
public void Fill_Grid()
{
try
{
string[] param1 = new string[2];
param1[0] = "Id";
param1[1] = Convert.ToString(Request.QueryString["Id"]);
CommanDataLoad.Load_Gridview(grdDetails, "Usp_LoadPayout_Details", "1", "playout_detail", param1);
}
catch
{
throw;
}
finally
{
}
}
protected void Load_Grid()
{
try
{
string[] param1 = new string[10];
param1[0] = "FromDt";
param1[1] = Convert.ToString(Request.QueryString["fdate"]);
param1[2] = "ToDt";
param1[3] = Convert.ToString(Request.QueryString["tdate"]);
param1[4] = "Emp_Code";
param1[5] = Convert.ToString(Request.QueryString["Emp_Code"]);
param1[6] = "Type";
param1[7] = Convert.ToString(Request.QueryString["type"]);
param1[8] = "lead_staus_id";
if (Convert.ToString(Request.QueryString["lead_status_id"].ToString()) != "undefined")
{
param1[9] = Convert.ToString(Request.QueryString["lead_status_id"]);
}
else
{
param1[9] = "0";
}
if (Convert.ToString(Request.QueryString["type"]).Contains("ST"))
{
CommanDataLoad.Load_Gridview(grdDetails, "USP_Load_Lead_Detail_statusWise", "1", "View Assign Lead Detail", param1);
}
else
{
CommanDataLoad.Load_Gridview(grdDetails, "USP_Load_Assign_Lead_Detail", "1", "View Assign Lead Detail", param1);
}
}
catch
{
throw;
}
finally
{
}
}
public void Load_Lead_Details(string Empcode, string PlanDate, string StartTime, string EndTime)
{
try
{
string[] param = new string[8];
param[0] = "Empcode";
param[1] = Empcode;
param[2] = "Plan_Date";
param[3] = PlanDate;
param[4] = "StartTime";
param[5] = StartTime;
param[6] = "EndTime";
param[7] = EndTime;
CommanDataLoad.Load_Gridview(GridView2, "USP_Load_Emp_Lead_Detail", "1", "Daily_Planing", param);
}
catch (Exception ex)
{
//lblmsg.Text = "Some Error" + ex.Message.ToString();
}
}
public void Load_Grid()
{
try
{
CommanDataLoad.Load_Gridview(GridView1, "Usp_Load_Sw_Request_List_Sp", "0", "Sw_Request_List_Details", "");
}
catch (Exception ex)
{
lblmsg.Visible = true;
lblmsg.Text = "Some Error" + ex.Message.ToString();
}
if (GridView1.Rows.Count > 0)
{
lblmsg.Visible = false;
}
else
{
lblmsg.Visible = true;
lblmsg.Text = "Not found Request List...!";
}
}
private void BindGrid()
{
string[] param1 = new string[8];
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] = ddlCity.SelectedValue;
param1[4] = "Lead_Status_id";
param1[5] = ddlStatus.SelectedValue;
param1[6] = "Emp_Code";
param1[7] = ddlEmployee.SelectedValue;
CommanDataLoad.Load_Gridview(dgManageLeads, "SpDispManageLeadData", "1", "Manage_Leads_self", param1);
}
private void BindGrid()
{
CommanDataLoad.Load_Gridview(GridView1, "select * from Department_Master", "0", "Department", "");
}
private void BindGrid()
{
CommanDataLoad.Load_Gridview(dgproductlist, "select * from Product_master", "0", "Product", "");
}
private void BindGrid()
{
CommanDataLoad.Load_Gridview(dgbreaklist, "select Break_Type ,Time ,case when is_active = 1 then 'Y' else 'N' end as Is_Active, convert(varchar, Created_On, 103) as Created_On from break_master", "0", "Break Master", "");
}
private void BindGrid()
{
CommanDataLoad.Load_Gridview(dgleadstatuslist, "Usp_Load_city", "1", "City Master", "");
}
protected void Load_Grid()
{
CommanDataLoad.Load_Gridview(gvBrokerProd, "USP_Load_BrokerProdList", "1", "Broker_Master", "");
}