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(); } }
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()); }
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 static string[] GetCities(string prefix) { List <string> data = new List <string>(); DataSet ds = CommanDataLoad.ExecuteDataSet("select City_name, City_Id from City_master where is_active=1 and City_Name like '%" + prefix + "%'", "2", "Manage Lead", ""); 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()); }
//private DropDownList ddldept; protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { CommanDataLoad.Load_CommanDropDown(ddlcompany, "", "select Company_id,company_name from company_Master", "0", "Company_id", "company_name", "Company_Master", ""); //CommanDataLoad.Load_CommanDropDown(ddlreportingauth, "", "select Empid,emp_name from employee_Master order by emp_name asc", "0", "empid", "emp_name", "Employee_Master", ""); CommanDataLoad.Load_CommanDropDown(ddldesignation, "", "select designation_id,designation from designation_Master order by designation asc", "0", "designation_id", "designation", "designation_Master", ""); CommanDataLoad.Load_CommanDropDown(ddldept, "", "select department_id,department_name from department_Master order by department_name asc", "0", "department_id", "department_name", "department_Master", ""); CommanDataLoad.Load_CommanDropDown(ddlreportingauth, "", "select emp_code,emp_name from employee_Master order by emp_name asc", "0", "emp_code", "emp_name", "Employee_Master", ""); //dgemployeelist.DataSource = BindGrid(); //dgemployeelist.DataBind(); txtctc.Text = "0"; txtvariable.Text = "0"; } }
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()); }
protected void btnsubmit_Click(object sender, EventArgs e) { if (Session["checkExits"] == null || Session["checkExits"].ToString() == "") { if (txtMessage.Text != "" && TextArea1.Text != "") { string[] param = new string[12]; param[0] = "messageTitle"; param[1] = txtMessage.Text; param[2] = "messageBody"; param[3] = TextArea1.Text; param[4] = "is_Active"; if (Active.Checked == true) { param[5] = "1"; } else { param[5] = "0"; } param[6] = "IP_address"; param[7] = ClsConnection.StrIP; param[8] = "UserId"; param[9] = ClsConnection.Userid; param[10] = "MessageId"; param[11] = lblid.Text; int rowaffected = CommanDataLoad.ExecuteNonQuery("usp_insert_message_Master", "1", "Message_Master", param); if (rowaffected > 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Saved Successfully')", true); ClearControls(); BindGrid(); } } } else { //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Please Enter Values In Data field ')", true); //ClearControls(); update_data(); } // ClearControls(); Session["checkExits"] = ""; }
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) { } }
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 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; } }
protected void Update_Data() { try { string[] param = new string[24]; param[0] = "Map_Id"; param[1] = lblMapId.Text; param[2] = "Bank_Id"; param[3] = ddlbName.SelectedValue; param[4] = "City_Id"; param[5] = ddlcName.SelectedValue; param[6] = "Product_Id"; param[7] = ddlpName.SelectedValue; param[8] = "Contact_Person"; param[9] = txtcPerson.Text; param[10] = "Designation"; param[11] = txtDesign.Text; param[12] = "Mobile_No"; param[13] = txtmNo.Text; param[14] = "Landline_No"; param[15] = txtlandNo.Text; param[16] = "Fax_No"; param[17] = txtfNo.Text; param[18] = "Email_Id"; param[19] = txteId.Text; param[20] = "Userid"; param[21] = ClsConnection.Userid; param[22] = "Ip_Addr"; param[23] = ClsConnection.StrIP; int rowaffected = CommanDataLoad.ExecuteNonQuery("USP_Update_Bank_Product_Mapping", "1", "Edit Bank Product Mapping", param); if (rowaffected > 0) { Response.Write("<script>alert('Record Updated Successfully.');</script>"); } Popup(false); Load_Grid(); ClearControls(); } catch (Exception ex) { //lblmsg.Text = "Some Error" + ex.Message.ToString(); } }
protected int DirectWebsiteLead(string CName, string MobileNo, string Email, string CityId, string Profession, string Product_Id, string MonthlyIncome) { int result = 0; try { string[] param = new string[14]; param[0] = "CName"; param[1] = CName; param[2] = "MobileNo"; param[3] = MobileNo; param[4] = "City_Id"; param[5] = CityId; param[6] = "Email"; param[7] = Email; param[8] = "Profession"; param[9] = Profession; param[10] = "MonthlyIncome"; param[11] = MonthlyIncome; param[12] = "Product_Id"; param[13] = Product_Id; int rowaffected = CommanDataLoad.ExecuteNonQuery("USP_Insert_LeadRawData_Website", "1", "Customer Web Request", param); if (rowaffected > 0) { //Response.Write("<script>alert('Record Insert Successfully.');</script>"); result = 1; Response.Write(result); } else { result = 0; Response.Write(result); } return(result); } catch (Exception ex) { result = 0; //lblmsg.Text = "Some Error" + ex.Message.ToString(); } return(result); }
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 { } }
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(); } } }
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); }
protected void btnsubmit_Click(object sender, EventArgs e) { string strDump = ""; int i = 0; int j = 0; strDump = "delete from group_rights where groupid=" + ddlgroup.SelectedValue + ";"; while (i < TreeView1.Nodes.Count) { if (TreeView1.Nodes[i].Checked == true) { strDump = strDump + "Insert into Group_Rights (Menu_ID,Groupid,UserId,ip,sysdate)"; strDump = strDump + "values(" + TreeView1.Nodes[i].Value + "," + ddlgroup.SelectedValue + "," + CommanDataLoad.UserId + ",'" + Request.UserHostAddress + "',getdate());"; } j = 0; while (j < TreeView1.Nodes[i].ChildNodes.Count) { if (TreeView1.Nodes[i].ChildNodes[j].Checked == true) { strDump = strDump + "Insert into Group_Rights (Menu_ID,Groupid,UserId,ip,sysdate)"; strDump = strDump + "values(" + TreeView1.Nodes[i].ChildNodes[j].Value + "," + ddlgroup.SelectedValue + "," + CommanDataLoad.UserId + ",'" + Request.UserHostAddress + "',getdate());"; } j = j + 1; } i = i + 1; } int rowaffected = CommanDataLoad.ExecuteNonQuery(strDump, "2", "Group Rights Item", ""); if (rowaffected > 0) { Response.Write("<script>alert('Record Inserted Successfully.');</script>"); } else { Response.Write("<script>alert('Technical error Please contact CS Development Team');</script>"); } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { string[] param = new string[22]; param[0] = "Bank_Id"; param[1] = ddlBank.SelectedValue; param[2] = "City_Id"; param[3] = ddlCity.SelectedValue; param[4] = "Product_Id"; param[5] = ddlProduct.SelectedValue; param[6] = "Contact_Person"; param[7] = txtContactPerson.Text; param[8] = "Designation"; param[9] = txtDesignation.Text; param[10] = "Mobile_No"; param[11] = txtMobileNo.Text; param[12] = "Landline_No"; param[13] = txtLandlineNo.Text; param[14] = "Fax_No"; param[15] = txtFaxNo.Text; param[16] = "Email_Id"; param[17] = txtEmailId.Text; param[18] = "UserId"; param[19] = ClsConnection.Userid; param[20] = "Ip_Addr"; param[21] = ClsConnection.StrIP; int rowaffected = CommanDataLoad.ExecuteNonQuery("USP_Insert_Bank_Product_Mapping", "1", "Bank Product Mapping", param); if (rowaffected > 0) { Response.Write("<script>alert('Record Saved Successfully.');</script>"); } Load_Grid(); ClearControls(); } catch (Exception ex) { //lblmsg.Text = "Some Error" + ex.Message.ToString(); } }
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); } }
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(); } }
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(); } }
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 btnsubmit_Click(object sender, EventArgs e) { if (txtname.Text != "" && txtemail.Text != "" && txtmobile.Text != "" && txtremark.Text != "") { string[] param = new string[8]; param[0] = "name"; param[1] = txtname.Text; param[2] = "email"; param[3] = txtemail.Text; param[4] = "mobile"; param[5] = txtmobile.Text; param[6] = "Remark"; param[7] = txtremark.Text; int rowaffected = CommanDataLoad.ExecuteNonQuery("usp_insert_lead_Master", "1", "Lead_Capture_Master", param); if (rowaffected > 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Saved Successfully')", true); ClearControls(); } } }
protected void Update_Data() { try { string[] param = new string[12]; param[0] = "Bank_Id"; param[1] = lblBankId.Text; param[2] = "Bank_Name"; param[3] = txtBankName.Text; param[4] = "Bank_Address"; param[5] = txtBankAddress.Text; param[6] = "Is_Active"; if (chkIsAct.Checked == true) { param[7] = "1"; } else { param[7] = "0"; } param[8] = "Userid"; param[9] = ClsConnection.Userid; param[10] = "Ip_Addr"; param[11] = ClsConnection.StrIP; int rowaffected = CommanDataLoad.ExecuteNonQuery("USP_Update_Bank_Master", "1", "Bank Master", param); if (rowaffected > 0) { Response.Write("<script>alert('Record Updated Successfully.');</script>"); } Popup(false); BindGrid(); ClearControls(); } catch (Exception ex) { //lblmsg.Text = "Some Error" + ex.Message.ToString(); } }
protected void Update_Data() { try { string[] param = new string[12]; param[0] = "Sub_Division_Id"; param[1] = lblSubDivisionId.Text; param[2] = "Division_Id"; param[3] = ddlDiv.SelectedValue; param[4] = "Sub_Division_Name"; param[5] = txtSubDiv.Text; param[6] = "Is_Active"; if (chkIsAct.Checked == true) { param[7] = "Y"; } else { param[7] = "N"; } param[8] = "Userid"; param[9] = ClsConnection.Userid; param[10] = "Ip_Addr"; param[11] = ClsConnection.StrIP; int rowaffected = CommanDataLoad.ExecuteNonQuery("USP_Update_Sub_Division", "1", "Sub Division Master", param); if (rowaffected > 0) { Response.Write("<script>alert('Record Updated Successfully.');</script>"); } Popup(false); Load_Grid(); ClearControls(); } catch (Exception ex) { //lblmsg.Text = "Some Error" + ex.Message.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 btnsubmit_Click(object sender, EventArgs e) { try { if (txtstatename.Text == "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Please enter State Name')", true); return; } DateTime localdate = DateTime.Now; string[] param = new string[8]; param[0] = "State_name"; param[1] = txtstatename.Text; param[2] = "Is_Active"; param[3] = "1"; param[4] = "Created_on"; param[5] = string.Format("{0:s}", localdate); param[6] = "cuserid"; param[7] = ClsConnection.Userid; int rowaffected = CommanDataLoad.ExecuteNonQuery("SpInsState_Master", "1", "State_Master", param); if (rowaffected > 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Saved Successfully')", true); BindGrid(); } ClearControls(); } catch (Exception ex) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Some Error' + ex.Message.ToString();)", true); } }
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); }