protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ReportViewer1.Reset();
// int id = Convert.ToInt32(Request.QueryString["id"]);
string id = Request.QueryString["id"];
int RetailBillId = Decode(id);
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RetailManagementConnectionString"].ConnectionString);
SqlDataAdapter adp2 = new SqlDataAdapter("select * from RetailBills where RetailMasterId=" + RetailBillId, con);
RetailManagementDataSet5 ds2 = new RetailManagementDataSet5();
con.Open();
adp2.Fill(ds2);
ReportDataSource rds1 = new ReportDataSource("DataSet2", GetDs1(RetailBillId));
ReportDataSource rds = new ReportDataSource("DataSet1", GetDs(RetailBillId));
ReportDataSource rds2 = new ReportDataSource("DataSet3", GetDs2());
ReportDataSource rds3 = new ReportDataSource("DataSet4", GetDs3());
ReportViewer1.LocalReport.DataSources.Add(rds1);
ReportViewer1.LocalReport.DataSources.Add(rds);
ReportViewer1.LocalReport.DataSources.Add(rds2);
ReportViewer1.LocalReport.DataSources.Add(rds3);
ReportViewer1.LocalReport.ReportPath = "ReportEngine/RetailBillLetterHeadWithMRP.rdlc";
double grandtotal = Convert.ToDouble(ds2.Tables[1].Rows[0]["GrandTotal"]);
string Words = NumberToWords(grandtotal);
ReportParameter parameter = new ReportParameter("AmountInWords", (Words + " Only"));
ReportViewer1.LocalReport.SetParameters(parameter);
//ReportViewer1.LocalReport.EnableExternalImages = true;
//string ImagePath = Session["Barcode"].ToString();
//ReportParameter parameter = new ReportParameter("ImagePath", ImagePath);
//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 = "RetailBillLetterHeadWithMRP.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>", "RetailBillLetterHeadWithMRP.aspx?file=" + filename));
}
}
private DataTable GetDs1(int RBId)
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RetailManagementConnectionString"].ConnectionString);
SqlDataAdapter adp2 = new SqlDataAdapter("select * from RetailBills where RetailMasterId=" + RBId, con);
RetailManagementDataSet5 ds2 = new RetailManagementDataSet5();
con.Open();
adp2.Fill(ds2);
//find retail bill no using primary key
string RetailBillNo = ds2.Tables[1].Rows[0]["RetailBillNo"].ToString();
Session["RetailBillNo"] = RetailBillNo;
return(ds2.Tables[1]);
}
