protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ReportViewer1.Reset();
string id = Request.QueryString["id"];
int Id = Decode(id);
//SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["A2ZRetailConnectionString"].ConnectionString);
// SqlConnection con = new SqlConnection("Data Source=localhost;Initial Catalog=" + DatabaseName + ";Integrated Security=True");
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RetailManagementConnectionString"].ConnectionString);
SqlDataAdapter adp = new SqlDataAdapter("select * from DeliveryChallans where Id=" + Id, con);
DeliveryChallansDataSet ds = new DeliveryChallansDataSet();
adp.Fill(ds);
double grandtotal = Convert.ToDouble(ds.Tables[1].Rows[0]["GrandTotal"]);
string Words = NumberToWords(grandtotal);
con.Open();
ReportDataSource rds1 = new ReportDataSource("DataSet2", GetDataSet2(Id));
ReportDataSource rds = new ReportDataSource("DataSet1", GetDataSet1());
ReportDataSource rds2 = new ReportDataSource("DataSet3", GetDs2());
ReportViewer1.LocalReport.DataSources.Add(rds1);
ReportViewer1.LocalReport.DataSources.Add(rds);
ReportViewer1.LocalReport.DataSources.Add(rds2);
ReportViewer1.LocalReport.ReportPath = "ReportEngine/DeliveryChallanPrePrintedMRP.rdlc";
ReportParameter parameter = new ReportParameter("AmountInWords", (Words + " Only"));
ReportViewer1.LocalReport.SetParameters(parameter);
ReportViewer1.LocalReport.Refresh();
Warning[] warnings;
string[] streamIds;
string mimetype = string.Empty;
string encoding = string.Empty;
string extension = string.Empty;
string title = "Retail Bill";
byte[] bytes = ReportViewer1.LocalReport.Render("PDF", null, out mimetype, out encoding, out extension, out streamIds, out warnings);
Response.Buffer = true;
Response.Clear();
Response.ContentType = "application/pdf";
Response.BinaryWrite(bytes);
Response.End();
string filename = "DeliveryChallanPrePrintedMRP.pdf";
string path = Server.MapPath("C");
FileStream file = new FileStream(path + "/" + filename, FileMode.OpenOrCreate, FileAccess.ReadWrite);
file.Write(bytes, 0, bytes.Length);
file.Dispose();
Response.Write(string.Format("<script>window.open('{0}','_blank');</script>", "DeliveryChallanPrePrintedMRP.aspx?file=" + filename));
}
}
private DataTable GetDataSet2(int Id)
{
//SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["A2ZRetailConnectionString"].ConnectionString);
// SqlConnection con = new SqlConnection("Data Source=localhost;Initial Catalog=" + DatabaseName + ";Integrated Security=True");
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RetailManagementConnectionString"].ConnectionString);
SqlDataAdapter adp = new SqlDataAdapter("select * from DeliveryChallans where Id=" + Id, con);
DeliveryChallansDataSet ds = new DeliveryChallansDataSet();
con.Open();
adp.Fill(ds);
string ChallanNo = ds.Tables[1].Rows[0]["ChallanNo"].ToString();
Session["ChallanNo"] = ChallanNo;
return(ds.Tables[1]);
}
private DataTable GetDataSet2(int Id)
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RetailManagementConnectionString"].ConnectionString);
// SqlConnection con = new SqlConnection("Data Source=localhost;Initial Catalog=" + DatabaseName + ";Integrated Security=True");
SqlDataAdapter adp = new SqlDataAdapter("select * from DeliveryChallans where Id=" + Id, con);
DeliveryChallansDataSet ds = new DeliveryChallansDataSet();
con.Open();
adp.Fill(ds);
string ChallanNo = ds.Tables[1].Rows[0]["ChallanNo"].ToString();
Session["ChallanNo"] = ChallanNo;
GetDataSet1();
ds.Tables[1].Rows[0]["TotalAmount"] = Convert.ToDouble(Session["TotalAmount"]).ToString("#,###.00##");
ds.Tables[1].Rows[0]["TotalDiscount"] = Convert.ToDouble(Session["TotalDiscount"]).ToString("#,###.00##");
ds.Tables[1].Rows[0]["PackAndForwd"] = (Convert.ToDouble(ds.Tables[1].Rows[0]["GrandTotal"]) - Convert.ToDouble(Session["TotalAmount"])).ToString("#,###.00##");
ds.Tables[1].Rows[0]["GrandTotal"] = Convert.ToDouble(ds.Tables[1].Rows[0]["GrandTotal"]).ToString("#,###.00##");
return(ds.Tables[1]);
}