protected void Page_Load(object sender, EventArgs e)
{
try
{
NetworkCredential NetCredentials = new NetworkCredential();
NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"];
NetCredentials.Password = ConfigurationManager.AppSettings["Password"];
Web_Order_Mail objser = new Web_Order_Mail();
objser.UseDefaultCredentials = true;
objser.Credentials = NetCredentials;
string str = ConfigurationManager.AppSettings["FilePath"] + objser.CustomerLedgerPrint(Convert.ToString(Request["CustomerNo"]), Convert.ToDateTime(Request["startdate"]), Convert.ToDateTime(Request["enddate"]), Convert.ToBoolean(0));
Response.Clear();
Response.ContentType = "application/pdf";
Response.WriteFile(str);
Response.Flush();
}
catch (Exception ex)
{
var message = new JavaScriptSerializer().Serialize(ex.Message.ToString());
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
}
protected void btnExcel_Download_Click(object sender, EventArgs e)
{
try
{
NetworkCredential NetCredentials = new NetworkCredential();
NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"];
NetCredentials.Password = ConfigurationManager.AppSettings["Password"];
if (txtStartDate.Text != null && txtEndDate.Text != null && txtEndDate.Text != "" && txtEndDate.Text != "")
{
DateTime startdate = Convert.ToDateTime(txtStartDate.Text);
DateTime enddate = Convert.ToDateTime(txtEndDate.Text);
DateTime todayDate = DateTime.Now;
if (enddate < startdate)
{
var message = new JavaScriptSerializer().Serialize("End Date should not be less than Start Date.");
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
else
{
Web_Order_Mail objser = new Web_Order_Mail();
objser.UseDefaultCredentials = true;
objser.Credentials = NetCredentials;
string str = ConfigurationManager.AppSettings["FilePath"] + objser.CustomerLedgerPrint(Convert.ToString(Request["CustomerNo"]), Convert.ToDateTime(startdate), Convert.ToDateTime(enddate), Convert.ToBoolean(1));
hf_Excel.Value = str;
ClientScript.RegisterStartupScript(GetType(), "Javascript", "javascript: AddPathExcel(); ", true);
Response.Clear();
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AppendHeader("content-disposition", "attachment; filename=\"" + str + "\"");
Response.WriteFile(str);
Response.Flush();
Response.End();
Response.Close();
}
}
else
{
lblMessage.Text = "Please enter Start date and End Date both.";
lblMessage.Visible = true;
}
}
catch (Exception ex)
{
var message = new JavaScriptSerializer().Serialize(ex.Message.ToString());
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
}
