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;
}
}
