protected void btnExport_Click(object sender, EventArgs e)
{
//DateTime FromDate;
//DateTime ToDate;
//int DistributorID = Convert.ToInt32(Session["DistributorID"]);
//int ClientTypeID = Convert.ToInt32(Session["ClientTypeID"]);
//int LoginID = Convert.ToInt32(Session["LoginId"]);
//ddlDistributor.SelectedValue = Convert.ToString(DistributorID);
//ddlDistributor.Attributes.Add("disabled", "disabled");
//FromDate = Convert.ToDateTime(txtFromDate.Text.Trim());
//ToDate = Convert.ToDateTime(txtToDate.Text.Trim());
//DataSet ds = ssc.GetPurchaseReport(Convert.ToInt32(ddlDistributor.SelectedValue), 0, LoginID, FromDate, ToDate, 0);
DataTable dt = (DataTable)ViewState["PurchaseDetail"];
if (dt.Rows.Count > 0)
{
DataView view = new DataView(dt);
DataTable dtExcel = view.ToTable("Selected", false, "PurchaseNumber", "InvoiceNumber", "SIMSerialNumber", "MobileNumber", "PIN", "PUK", "SIMType", "VendorName", "PurchaseDate");//, "INTERNATIONAL_BUNDLE_CODE", "INTERNATIONAL_BUNDLE_AMOUNT"
if (dtExcel.Rows.Count > 0)
{
string filename = " InventoryPurchaseReport.xls";
System.IO.StringWriter tw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
//GridView grdView = new GridView();
//grdView.DataSource = dtExcel;
//grdView.DataBind();
ScriptManager.RegisterStartupScript(this, GetType(), "", "HideProgress();", true);
// grdView.RenderControl(hw);
RepeaterPurchaseDetail.RenderControl(hw);
Response.ContentType = "application/vnd.ms-excel";
Response.AppendHeader("Content-Disposition", "attachment; filename=" + filename + "");
this.EnableViewState = false;
Response.Write(tw.ToString());
Response.End();
ScriptManager.RegisterStartupScript(this, GetType(), "", "HideProgress();", true);
}
}
}
protected void RepeaterUserList_ItemCommand(object source, RepeaterCommandEventArgs e)
{
try
{
if (e.CommandName == "View")
{
this.mpAddtinalDetailView.Show();
int id = Convert.ToInt32(e.CommandArgument);
string idnty = Encryption.Encrypt(id.ToString());
string condition = Encryption.Encrypt("View");
// Response.Redirect("~/User.aspx?Identity=" + idnty + "&Condition=" + condition, false);
DateTime FromDate;
DateTime ToDate;
int DistributorID = Convert.ToInt32(Session["DistributorID"]);
int ClientTypeID = Convert.ToInt32(Session["ClientTypeID"]);
int LoginID = Convert.ToInt32(Session["LoginId"]);
ddlDistributor.SelectedValue = Convert.ToString(DistributorID);
ddlDistributor.Attributes.Add("disabled", "disabled");
FromDate = Convert.ToDateTime("1900-01-01");
ToDate = DateTime.Now;
DataSet ds = ssc.GetPurchaseReport(Convert.ToInt32(ddlDistributor.SelectedValue), ClientTypeID, LoginID, FromDate, ToDate, id);
if (ds != null)
{
ViewState["PurchaseDetail"] = ds.Tables[1];
RepeaterPurchaseDetail.DataSource = ds.Tables[1];
RepeaterPurchaseDetail.DataBind();
}
}
if (e.CommandName == "Print")
{
int id = Convert.ToInt32(e.CommandArgument);
string idnty = Encryption.Encrypt(id.ToString());
string condition = Encryption.Encrypt("View");
// Response.Redirect("~/User.aspx?Identity=" + idnty + "&Condition=" + condition, false);
DateTime FromDate;
DateTime ToDate;
int DistributorID = Convert.ToInt32(Session["DistributorID"]);
int ClientTypeID = Convert.ToInt32(Session["ClientTypeID"]);
int LoginID = Convert.ToInt32(Session["LoginId"]);
ddlDistributor.SelectedValue = Convert.ToString(DistributorID);
ddlDistributor.Attributes.Add("disabled", "disabled");
FromDate = Convert.ToDateTime("1900-01-01");
ToDate = DateTime.Now;
DataSet ds = ssc.GetPurchaseReport(Convert.ToInt32(ddlDistributor.SelectedValue), ClientTypeID, LoginID, FromDate, ToDate, id);
if (ds != null)
{
ViewState["PurchaseDetail"] = ds.Tables[1];
DataTable dt = ds.Tables[1];
if (dt.Rows.Count > 0)
{
DataView view = new DataView(dt);
DataTable dtExcel = view.ToTable("Selected", false, "PurchaseNumber", "InvoiceNumber", "SIMSerialNumber", "MobileNumber", "PIN", "PUK", "SIMType", "VendorName", "PurchaseDate");//, "INTERNATIONAL_BUNDLE_CODE", "INTERNATIONAL_BUNDLE_AMOUNT"
if (dtExcel.Rows.Count > 0)
{
string filename = " InventoryPurchaseReport.xls";
System.IO.StringWriter tw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
GridView grdView = new GridView();
grdView.DataSource = dtExcel;
grdView.DataBind();
ScriptManager.RegisterStartupScript(this, GetType(), "", "HideProgress();", true);
grdView.RenderControl(hw);
Response.ContentType = "application/vnd.ms-excel";
Response.AppendHeader("Content-Disposition", "attachment; filename=" + filename + "");
this.EnableViewState = false;
Response.Write(tw.ToString());
Response.End();
ScriptManager.RegisterStartupScript(this, GetType(), "", "HideProgress();", true);
}
}
}
}
}
catch (Exception ex)
{
}
}
