protected void binddata()
{
Hashtable htAddPlanParams = getLedgerParamsData();
Cls_business_lcoshareDef obj = new Cls_business_lcoshareDef();
DataTable dtPlanDet = obj.getPlanDetails(htAddPlanParams, username, catid);
if (dtPlanDet == null)
{
Response.Redirect("~/ErrorPage.aspx");
return;
}
if (dtPlanDet.Rows.Count == 0)
{
grdExpiry.Visible = false;
lblMessage.Text = "No data found";
}
else
{
grdExpiry.Visible = true;
lblMessage.Text = "";
ViewState["searched_trans"] = dtPlanDet;
grdExpiry.DataSource = dtPlanDet;
grdExpiry.DataBind();
}
}
protected void btndownPlandl_Click(object sender, EventArgs e)
{
clear_msg();
lblMessage.Text = "";
if (chkabcmap.Checked == false && chkaddmap.Checked == false && chkcity.Checked == false && chkdt.Checked == false && chkplan.Checked == false)
{
lblMessage.Text = "Please Select One Option!!";
return;
}
Hashtable htAddPlanParams = getLedgerParamsData();
Cls_business_lcoshareDef obj = new Cls_business_lcoshareDef();
DataTable dtPlanDet = obj.getPlanDetails(htAddPlanParams, username, catid);
if (dtPlanDet == null)
{
lblMessage.Text = "Something went wrong...";
}
if (dtPlanDet.Rows.Count == 0)
{
lblMessage.Text = "No Data Found";
}
else
{
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/") + "PlanDetails_" + datetime + ".xls");
try
{
int j = 0;
String strheader = "Sr. No." + Convert.ToChar(9)
+ "Plan Name" + Convert.ToChar(9)
+ "Plan Type" + Convert.ToChar(9)
+ "Plan Poid" + Convert.ToChar(9)
+ "Deal Poid" + Convert.ToChar(9)
+ "Product Poid" + Convert.ToChar(9)
+ "Customer Price" + Convert.ToChar(9)
+ "Lco Price" + Convert.ToChar(9)
+ "City" + Convert.ToChar(9)
+ "LCO Code" + Convert.ToChar(9)
+ "LCO Name" + Convert.ToChar(9);
while (j < dtPlanDet.Rows.Count)
{
sw.WriteLine(strheader);
for (int i = 0; i < dtPlanDet.Rows.Count; i++)
{
j = j + 1;
string strrow = j.ToString() + Convert.ToChar(9)
+ dtPlanDet.Rows[i]["var_plan_name"].ToString() + Convert.ToChar(9)
+ dtPlanDet.Rows[i]["var_plan_plantype"].ToString() + Convert.ToChar(9)
+ dtPlanDet.Rows[i]["var_plan_planpoid"].ToString() + Convert.ToChar(9)
+ dtPlanDet.Rows[i]["var_plan_dealpoid"].ToString() + Convert.ToChar(9)
+ dtPlanDet.Rows[i]["var_plan_productpoid"].ToString() + Convert.ToChar(9)
+ dtPlanDet.Rows[i]["num_plan_custprice"].ToString() + Convert.ToChar(9)
+ dtPlanDet.Rows[i]["num_plan_lcoprice"].ToString() + Convert.ToChar(9)
+ dtPlanDet.Rows[i]["var_city_name"].ToString() + Convert.ToChar(9)
+ dtPlanDet.Rows[i]["LCO_Code"].ToString() + Convert.ToChar(9)
+ dtPlanDet.Rows[i]["LCO_NAME"].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;
}
//dtPlanDet = null;
dtPlanDet.Dispose();
Response.Redirect("../MyExcelFile/" + "PlanDetails_" + datetime + ".xls");
}
}
