protected void grdactdact_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
grdactdact.PageIndex = e.NewPageIndex;
Hashtable htAddPlanParams = getParamsData();
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;
}
Cls_Business_rptserviceActDact objTran = new Cls_Business_rptserviceActDact();
Hashtable htResponse = objTran.Getsvcstatus(htAddPlanParams, username, catid, operator_id);
DataTable dt = null; //check for exception
if (htResponse["htResponse"] != null)
{
dt = (DataTable)htResponse["htResponse"];
}
if (dt == null)
{
Response.Redirect("~/ErrorPage.aspx");
return;
}
if (dt.Rows.Count == 0)
{
btngrnExel.Visible = false;
grdactdact.Visible = false;
lblSearchMsg.Text = "No data found";
}
else
{
btngrnExel.Visible = true;
grdactdact.Visible = true;
lblSearchMsg.Text = "";
//ViewState["searched_trans"] = dt;
grdactdact.DataSource = dt;
grdactdact.DataBind();
}
}
protected void btncnfmBlck_Click(object sender, EventArgs e)
{
try
{
Cls_Business_rptserviceActDact obj = new Cls_Business_rptserviceActDact();
string pro_output = obj.bulkUploadActTempRemove(Session["Bulk_ID"].ToString(), Session["username"].ToString().Trim());
if (pro_output.Split('#')[0] == "9999")
{
lblSearchMsg.Text = "Selected Data Removed Successfully";
Binddata();
}
}
catch (Exception ex)
{
Response.Write("Error : " + ex.Message.Trim());
return;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string from = txtFrom.Text;
string to = txtTo.Text;
DateTime fromDt;
DateTime toDt;
if (!String.IsNullOrEmpty(from) && !String.IsNullOrEmpty(to))
{
fromDt = new DateTime();
toDt = new DateTime();
fromDt = DateTime.ParseExact(from, "dd-MMM-yyyy", null);
toDt = DateTime.ParseExact(to, "dd-MMM-yyyy", null);
if (toDt.CompareTo(fromDt) < 0)
{
lblSearchMsg.Text = "To date must be later than From date";
grdactdact.Visible = false;
lblSearchMsg.ForeColor = System.Drawing.Color.Red;
return;
}
else if (Convert.ToDateTime(txtFrom.Text.ToString()) > DateTime.Now.Date)
{
lblSearchMsg.Text = "You can not select date greater than current date!";
return;
}
else if (Convert.ToDateTime(txtTo.Text.ToString()) > DateTime.Now.Date)
{
lblSearchMsg.Text = "You can not select date greater than current date!";
return;
}
else
{
lblSearchMsg.Text = "";
grdactdact.Visible = true;
}
}
Hashtable htAddPlanParams = getParamsData();
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;
}
Cls_Business_rptserviceActDact objTran = new Cls_Business_rptserviceActDact();
Hashtable htResponse = objTran.Getsvcstatus(htAddPlanParams, username, catid, operator_id);
DataTable dt = null; //check for exception
if (htResponse["htResponse"] != null)
{
dt = (DataTable)htResponse["htResponse"];
}
if (dt == null)
{
Response.Redirect("~/ErrorPage.aspx");
return;
}
lblSearchParams.Text = Server.HtmlDecode("<b style='color:#094791;'></b><b>Transaction From : </b>" + from + "<b>Transaction To : </b>" + to);
if (dt.Rows.Count == 0)
{
btngrnExel.Visible = false;
grdactdact.Visible = false;
lblSearchMsg.Text = "No data found";
}
else
{
btngrnExel.Visible = true;
grdactdact.Visible = true;
lblSearchMsg.Text = "";
ViewState["searched_trans"] = dt;
grdactdact.DataSource = dt;
grdactdact.DataBind();
ScriptManager.RegisterStartupScript(Page, this.GetType(), "Key", "<script>MakeStaticHeader('" + grdactdact.ClientID + "', 400, 1200 , 46 ,false); </script>", false);
DivRoot.Style.Add("display", "block");
}
}
protected void btngrnExel_Click(object sender, EventArgs e)
{
Hashtable htAddPlanParams = getParamsData();
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;
}
Cls_Business_rptserviceActDact objTran = new Cls_Business_rptserviceActDact();
Hashtable htResponse = objTran.Getsvcstatus(htAddPlanParams, username, catid, operator_id);
DataTable dt = null; //check for exception
if (htResponse["htResponse"] != null)
{
dt = (DataTable)htResponse["htResponse"];
}
if (dt == null)
{
Response.Redirect("~/ErrorPage.aspx");
return;
}
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/") + "ServiceActDact_" + datetime + ".xls");
try
{
int j = 0;
String strheader = "Sr.No." + Convert.ToChar(9)
+ "STB Number" + Convert.ToChar(9)
+ "Customer Code" + Convert.ToChar(9)
//+ "Account Poid" + Convert.ToChar(9)
//+ "Service Poid" + Convert.ToChar(9)
+ "VC Id" + Convert.ToChar(9)
+ "Status" + Convert.ToChar(9)
+ "Transaction By" + Convert.ToChar(9)
+ "Transaction Date" + Convert.ToChar(9)
+ "Order Id" + 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);
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) + "'";
strrow += dt.Rows[i]["STBNO"].ToString() + Convert.ToChar(9)
+ dt.Rows[i]["CUSTNO"].ToString() + Convert.ToChar(9)
//+ dt.Rows[i]["ACCPOID"].ToString() + Convert.ToChar(9)
//+ dt.Rows[i]["SVCPOID"].ToString() + Convert.ToChar(9)
+ "'"
+ dt.Rows[i]["VCID"].ToString() + Convert.ToChar(9)
+ dt.Rows[i]["STATUS"].ToString() + Convert.ToChar(9)
+ dt.Rows[i]["TRANSBY"].ToString() + Convert.ToChar(9)
+ "'"
+ dt.Rows[i]["TRANSDT"].ToString() + Convert.ToChar(9)
+ dt.Rows[i]["ORDERID"].ToString() + Convert.ToChar(9);
strrow += dt.Rows[i]["lcode"].ToString() + Convert.ToChar(9)
+ dt.Rows[i]["lnaame"].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);
sw.WriteLine(strrow);
}
}
sw.Flush();
sw.Close();
}
catch (Exception ex)
{
sw.Flush();
sw.Close();
Response.Write("Error : " + ex.Message.Trim());
return;
}
Response.Redirect("../MyExcelFile/" + "ServiceActDact_" + datetime + ".xls");
}
}
public void Binddata()
{
string from = txtFrom.Text;
string to = txtTo.Text;
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;
}
Hashtable htAddPlanParams = getParamsData();
Hashtable htResponse = new Hashtable();
if (rblFlag.SelectedValue == "1")
{
Cls_Business_rptserviceActDact objTran = new Cls_Business_rptserviceActDact();
htResponse = objTran.GetBulkSCHstatus(htAddPlanParams, username, operator_id);
}
else if (rblFlag.SelectedValue == "2")
{
Cls_Business_rptserviceActDact objTran = new Cls_Business_rptserviceActDact();
htResponse = objTran.GetBulkSCHDISstatus(htAddPlanParams, username, operator_id);
}
DataTable dt = null; //check for exception
if (htResponse["htResponse"] != null)
{
dt = (DataTable)htResponse["htResponse"];
}
if (dt == null)
{
Response.Redirect("~/ErrorPage.aspx");
return;
}
lblSearchParams.Text = Server.HtmlDecode("<b style='color:#094791;'></b><b>Transaction From : </b>" + from + "<b>Transaction To : </b>" + to);
if (dt.Rows.Count == 0)
{
btngrnExel.Visible = false;
grdactdact.Visible = false;
lblSearchMsg.Text = "No data found";
}
else
{
btngrnExel.Visible = true;
grdactdact.Visible = true;
lblSearchMsg.Text = "";
ViewState["searched_trans"] = dt;
grdactdact.DataSource = dt;
if (rblFlag.SelectedValue == "1")
{
grdactdact.Columns[10].Visible = false;
grdactdact.Columns[11].Visible = false;
grdactdact.Columns[12].Visible = true;
}
else
{
grdactdact.Columns[12].Visible = false;
}
grdactdact.DataBind();
ScriptManager.RegisterStartupScript(Page, this.GetType(), "Key", "<script>MakeStaticHeader('" + grdactdact.ClientID + "', 400, 1200 , 46 ,false); </script>", false);
DivRoot.Style.Add("display", "block");
}
}
protected void btngrnExel_Click(object sender, EventArgs e)
{
Hashtable htAddPlanParams = getParamsData();
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;
}
Cls_Business_rptserviceActDact objTran = new Cls_Business_rptserviceActDact();
Hashtable htResponse = objTran.GetBulkSCHstatus(htAddPlanParams, username, operator_id);
DataTable dt = null; //check for exception
if (htResponse["htResponse"] != null)
{
dt = (DataTable)htResponse["htResponse"];
}
if (dt == null)
{
Response.Redirect("~/ErrorPage.aspx");
return;
}
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/") + "BulkScheduler_ActDact_" + datetime + ".xls");
try
{
int j = 0;
String strheader = "Sr.No." + Convert.ToChar(9)
+ "Account No" + Convert.ToChar(9)
+ "VC Id" + Convert.ToChar(9)
+ "LCO Code" + Convert.ToChar(9)
+ "Status" + Convert.ToChar(9)
+ "Reason" + Convert.ToChar(9)
+ "Process Flag" + Convert.ToChar(9)
+ "Scheduler Date" + Convert.ToChar(9)
+ "Inserted By" + Convert.ToChar(9)
+ "Inserted 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) + "'";
strrow += dt.Rows[i]["accno"].ToString() + Convert.ToChar(9)
+ "'"
+ dt.Rows[i]["VCID"].ToString() + Convert.ToChar(9)
+ dt.Rows[i]["lcocode"].ToString() + Convert.ToChar(9)
+ dt.Rows[i]["ACTION"].ToString() + Convert.ToChar(9)
+ dt.Rows[i]["reason"].ToString() + Convert.ToChar(9)
+ dt.Rows[i]["PROCESSFLAG"].ToString() + Convert.ToChar(9)
+ dt.Rows[i]["SCHDATE"].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/" + "BulkScheduler_ActDact_" + datetime + ".xls");
}
}
