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", ""); }