public void BindLCO() { cls_Business_rptLcowiseUserdetails objDetails = new cls_Business_rptLcowiseUserdetails(); DataTable dt = objDetails.getLcoSub(Session["username"].ToString().Trim(), category_id, operator_id); ddlLco.DataSource = dt; ddlLco.DataTextField = "username"; ddlLco.DataValueField = "username"; ddlLco.DataBind(); }
protected void BindData() { string username, catid, operator_id; if (Session["username"] != null || Session["operator_id"] != null) { username = Session["username"].ToString(); catid = Convert.ToString(Session["category"]); operator_id = Session["TOperID"].ToString(); //Convert.ToString(Session["operator_id"]); } else { Session.Abandon(); Response.Redirect("~/Login.aspx"); return; } string Showall = ""; string lcoid = ""; if (Request.QueryString["showall"] == "0") { Showall = Request.QueryString["showall"]; } else { Showall = Request.QueryString["showall"]; if (catid != "3") { lcoid = Convert.ToString(Session["Lcoid"]); } } cls_Business_rptLcowiseUserdetails objTran = new cls_Business_rptLcowiseUserdetails(); DataTable dt = objTran.getLcouserdetails(username, lcoid, Showall, catid, operator_id); if (dt.Rows.Count == 0) { grdLcodet.Visible = false; lblSearchMsg.Text = "No data found"; btngrnExel.Visible = false; } else { btngrnExel.Visible = true; grdLcodet.Visible = true; btngrnExel.Visible = true; ViewState["dt"] = dt; lblSearchMsg.Text = ""; grdLcodet.DataSource = dt; grdLcodet.DataBind(); } }
protected void FillGrid() { cls_Business_rptLcowiseUserdetails objDetails = new cls_Business_rptLcowiseUserdetails(); DataTable dt = objDetails.getLcoSubDetails(username, category_id, operator_id); grdUsers.DataSource = dt; grdUsers.DataBind(); if (grdUsers.Rows.Count > 0) { div1.Visible = true; } else { div1.Visible = false; lblResponse.Text = "Data Not Found"; } }
protected void lnkUserID_Click(object sender, EventArgs e) { div1.Visible = false; int rindex = ((GridViewRow)(((LinkButton)(sender)).Parent.BindingContainer)).RowIndex; HiddenField hdnUserID = (HiddenField)grdUsers.Rows[rindex].FindControl("hdnUserID"); HiddenField hdnUserName = (HiddenField)grdUsers.Rows[rindex].FindControl("hdnUserName"); Session["UserUpdate"] = hdnUserID.Value; div3.Visible = true; cls_Business_rptLcowiseUserdetails objDetails = new cls_Business_rptLcowiseUserdetails(); DataTable dt = objDetails.getLcoSubRight_Details(Session["UserUpdate"].ToString(), category_id, operator_id); if (dt.Rows.Count > 0) { grdUsers_2.DataSource = dt; grdUsers_2.DataBind(); } else { /* dt.Columns.Add(new DataColumn("VAR_ACCESS_USERNAME")); * dt.Columns.Add(new DataColumn("PlanAdd")); * dt.Columns.Add(new DataColumn("PlanRenew")); * dt.Columns.Add(new DataColumn("PlanChange")); * dt.Columns.Add(new DataColumn("PlanCancel")); * dt.Columns.Add(new DataColumn("Discount")); * dt.Columns.Add(new DataColumn("Retrack")); * dt.Columns.Add(new DataColumn("CustModify")); * dt.Columns.Add(new DataColumn("STBSwap")); * dt.Columns.Add(new DataColumn("VCSwap")); * dt.Columns.Add(new DataColumn("AutoRenew")); * dt.Columns.Add(new DataColumn("Deactivate")); * dt.Columns.Add(new DataColumn("Div_TERMINATE")); * dt.Columns.Add(new DataColumn("FocPack")); * dt.Columns.Add(new DataColumn("VAR_ACCESS_INSBY")); * dt.Columns.Add(new DataColumn("VAR_ACCESS_INSDT"));*/ dt.Rows.Add(3, Session["UserUpdate"].ToString(), "No", "No", "No", "No", "No", "No", "No", "No", "No", "No", "No", "No", "No", "", System.DateTime.Now); grdUsers_2.DataSource = dt; grdUsers_2.DataBind(); } }
protected void btnSearch_Click(object sender, EventArgs e) { if (Session["username"] != null || Session["operator_id"] != null) { username = Session["username"].ToString(); catid = Convert.ToString(Session["category"]); operator_id = ddlLco.SelectedValue.Split('#')[0].ToString(); //Convert.ToString(Session["operator_id"]); Session["TOperID"] = operator_id.ToString(); } else { Session.Abandon(); Response.Redirect("~/Login.aspx"); return; } string strCon = ConfigurationSettings.AppSettings["conString"].ToString().Trim(); OracleConnection con = new OracleConnection(strCon); string str = ""; cls_Business_rptLcowiseUserdetails objTran = new cls_Business_rptLcowiseUserdetails(); DataTable dt = objTran.getLcoSearch(username, ddlLco.SelectedValue.Split('#')[1].ToString(), "0", catid, operator_id); if (dt.Rows.Count == 0) { btnAll.Visible = false; grdLcodet.Visible = false; lblSearchMsg.Text = "No data found"; btngrnExel.Visible = false; } else { btnAll.Visible = true; btngrnExel.Visible = true; grdLcodet.Visible = true; btngrnExel.Visible = true; lblSearchMsg.Text = ""; grdLcodet.DataSource = dt; grdLcodet.DataBind(); } }
protected void BindData() { if (Session["username"] != null || Session["operator_id"] != null) { username = Session["username"].ToString(); catid = Convert.ToString(Session["category"]); operator_id = ddlLco.SelectedValue.Split('#')[0].ToString(); //Convert.ToString(Session["operator_id"]); } else { Session.Abandon(); Response.Redirect("~/Login.aspx"); return; } cls_Business_rptLcowiseUserdetails objTran = new cls_Business_rptLcowiseUserdetails(); DataTable dt = objTran.getLcodetails(username, catid, operator_id); if (dt.Rows.Count == 0) { btnAll.Visible = false; grdLcodet.Visible = false; lblSearchMsg.Text = "No data found"; btngrnExel.Visible = false; } else { btnAll.Visible = true; btngrnExel.Visible = true; grdLcodet.Visible = true; btngrnExel.Visible = true; lblSearchMsg.Text = ""; ViewState["searched_Lco"] = dt; grdLcodet.DataSource = dt; grdLcodet.DataBind(); } }
protected void btnAll_Click(object sender, EventArgs e) { string username, catid, operator_id; if (Session["username"] != null || Session["operator_id"] != null) { username = Session["username"].ToString(); catid = Convert.ToString(Session["category"]); operator_id = Convert.ToString(Session["operator_id"]); } else { Session.Abandon(); Response.Redirect("~/Login.aspx"); return; } string Showall = "0"; string lcoid = ""; cls_Business_rptLcowiseUserdetails objTran = new cls_Business_rptLcowiseUserdetails(); DataTable dt = objTran.getLcouserdetails(username, lcoid, Showall, catid, operator_id); if (dt.Rows.Count != 0) { DateTime dd = DateTime.Now; string datetime = dd.Day + "" + dd.Month + "" + dd.Year + "" + dd.Hour + "" + dd.Minute + "" + dd.Second; StreamWriter sw = new StreamWriter(Server.MapPath("../MyExcelFile/") + "UserDetails_" + datetime + ".xls"); try { int j = 0; String strheader = "Sr.No." + Convert.ToChar(9) + "User Id" + Convert.ToChar(9) + "User Name" + Convert.ToChar(9) + "First Name" + Convert.ToChar(9) + "Middle Name" + Convert.ToChar(9) + "Last Name" + Convert.ToChar(9) + "Address" + Convert.ToChar(9) + "Code" + Convert.ToChar(9) + "Brmpoid" + Convert.ToChar(9) + "state" + Convert.ToChar(9) + "City" + Convert.ToChar(9) + "User Type" + Convert.ToChar(9) + "Email" + Convert.ToChar(9) + "Mobile Number" + Convert.ToChar(9) + "Account number" + Convert.ToChar(9) + "Balance" + Convert.ToChar(9) + "Inserted By" + Convert.ToChar(9) + "Date" + Convert.ToChar(9); while (j < dt.Rows.Count) { sw.WriteLine(strheader); for (int i = 0; i < dt.Rows.Count; i++) { j = j + 1; string strrow = j.ToString() + Convert.ToChar(9) + "'" + dt.Rows[i]["username"].ToString() + Convert.ToChar(9) + dt.Rows[i]["userowner"].ToString() + Convert.ToChar(9) + dt.Rows[i]["fname"].ToString() + Convert.ToChar(9) + dt.Rows[i]["mname"].ToString() + Convert.ToChar(9) + dt.Rows[i]["lname"].ToString() + Convert.ToChar(9) + dt.Rows[i]["addr"].ToString() + Convert.ToChar(9) + dt.Rows[i]["code"].ToString() + Convert.ToChar(9) + dt.Rows[i]["brmpoid"].ToString() + Convert.ToChar(9) + dt.Rows[i]["ststeid"].ToString() + Convert.ToChar(9) + dt.Rows[i]["cityid"].ToString() + Convert.ToChar(9) + dt.Rows[i]["flag"].ToString() + Convert.ToChar(9) + dt.Rows[i]["email"].ToString() + Convert.ToChar(9) + dt.Rows[i]["mobno"].ToString() + Convert.ToChar(9) + dt.Rows[i]["accno"].ToString() + Convert.ToChar(9) + dt.Rows[i]["balance"].ToString() + Convert.ToChar(9) + dt.Rows[i]["insby"].ToString() + Convert.ToChar(9) + dt.Rows[i]["insdt"].ToString() + Convert.ToChar(9); sw.WriteLine(strrow); } } sw.Flush(); sw.Close(); } catch (Exception ex) { sw.Flush(); sw.Close(); Response.Write("Error : " + ex.Message.Trim()); return; } Response.Redirect("../MyExcelFile/" + "UserDetails_" + datetime + ".xls"); } if (dt == null) { Response.Redirect("~/ErrorPage.aspx"); return; } // Response.Redirect("../Reports/rptUserdetailsLcowiseDet.aspx?showall=0"); }
protected void btn_genExl_Click(object sender, EventArgs e) { string username, catid, operator_id; if (Session["username"] != null || Session["operator_id"] != null) { username = Session["username"].ToString(); catid = Convert.ToString(Session["category"]); operator_id = ddlLco.SelectedValue.Split('#')[0].ToString(); //Convert.ToString(Session["operator_id"]); } else { Session.Abandon(); Response.Redirect("~/Login.aspx"); return; } cls_Business_rptLcowiseUserdetails objTran = new cls_Business_rptLcowiseUserdetails(); DataTable dt = objTran.getLcodetails(username, catid, operator_id); if (dt.Rows.Count != 0) { DateTime dd = DateTime.Now; string datetime = dd.Day + "" + dd.Month + "" + dd.Year + "" + dd.Hour + "" + dd.Minute + "" + dd.Second; StreamWriter sw = new StreamWriter(Server.MapPath("../MyExcelFile/") + "LcoDetails_" + datetime + ".xls"); try { int j = 0; String strheader = "Sr.No." + Convert.ToChar(9) + "LCO Code" + Convert.ToChar(9) + "LCO Name" + Convert.ToChar(9) + "Company Name" + Convert.ToChar(9) + "Distributor" + Convert.ToChar(9) + "Sub Distributor" + Convert.ToChar(9) + "State" + Convert.ToChar(9) + "City" + Convert.ToChar(9) + "User Count" + Convert.ToChar(9); while (j < dt.Rows.Count) { sw.WriteLine(strheader); for (int i = 0; i < dt.Rows.Count; i++) { j = j + 1; string strrow = j.ToString() + Convert.ToChar(9) + "'" + dt.Rows[i]["lcocode"].ToString() + Convert.ToChar(9) + dt.Rows[i]["lconame"].ToString() + Convert.ToChar(9) + dt.Rows[i]["companyname"].ToString() + Convert.ToChar(9) + dt.Rows[i]["distributor"].ToString() + Convert.ToChar(9) + dt.Rows[i]["subdistributor"].ToString() + Convert.ToChar(9) + dt.Rows[i]["statename"].ToString() + Convert.ToChar(9) + dt.Rows[i]["cityname"].ToString() + Convert.ToChar(9); strrow += dt.Rows[i]["usercnt"].ToString() + Convert.ToChar(9); sw.WriteLine(strrow); } } sw.Flush(); sw.Close(); } catch (Exception ex) { sw.Flush(); sw.Close(); Response.Write("Error : " + ex.Message.Trim()); return; } Response.Redirect("../MyExcelFile/" + "LcoDetails_" + datetime + ".xls"); } if (dt == null) { Response.Redirect("~/ErrorPage.aspx"); return; } }