protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ReportViewer1.Reset();
string id = Request.QueryString["id"];
int CreditNoteId = Decode(id);
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RetailManagementConnectionString"].ConnectionString);
//SqlConnection con = new SqlConnection("Data Source=MARY-PC;Initial Catalog=A To Z Life Style(India) Pvt Ltd Retail 01-04-2016 To 31-03-2017;Integrated Security=True");
SqlDataAdapter adp2 = new SqlDataAdapter("select * from SalesBillCreditNotes where Id=" + CreditNoteId, con);
SalesReturns ds2 = new SalesReturns();
con.Open();
adp2.Fill(ds2);
ReportDataSource rds1 = new ReportDataSource("DataSet2", GetDs1(CreditNoteId));
ReportDataSource rds = new ReportDataSource("DataSet1", GetDs(CreditNoteId));
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/SalesCreditNoteLetterHeadWithSP.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.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 = "SalesCreditNoteLetterHeadWithSP.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>", "SalesCreditNoteLetterHeadWithSP.aspx?file=" + filename));
}
}
private DataTable GetDs1(int DId)
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RetailManagementConnectionString"].ConnectionString);
//SqlConnection con = new SqlConnection("Data Source=MARY-PC;Initial Catalog=A To Z Life Style(India) Pvt Ltd Retail 01-04-2016 To 31-03-2017;Integrated Security=True");
SqlDataAdapter adp2 = new SqlDataAdapter("select * from SalesReturns where Id=" + DId, con);
SalesReturns ds2 = new SalesReturns();
con.Open();
adp2.Fill(ds2);
//find Challan no using primary key
string CreditNoteNo = ds2.Tables[1].Rows[0]["SalesReturnNo"].ToString();
Session["SalesReturnNo"] = CreditNoteNo;
return(ds2.Tables[0]);
}
