public ActionResult Print(DateTime?from, DateTime?to, int itmid = 0, string itmName = "", int SupId = 0, string SupName = "") { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "PurchaseBillRegister.rpt")); DataSet ds = new DataSet(); ds.Tables.Add("Head"); ds.Tables.Add("Items"); // //-------HEAD ds.Tables["Head"].Columns.Add("From"); ds.Tables["Head"].Columns.Add("To"); ds.Tables["Head"].Columns.Add("SupplierHead"); ds.Tables["Head"].Columns.Add("ItemHead"); ds.Tables["Head"].Columns.Add("OrganizationName"); ds.Tables["Head"].Columns.Add("Image1"); //-------DT ds.Tables["Items"].Columns.Add("BillNo&Date"); ds.Tables["Items"].Columns.Add("Date"); ds.Tables["Items"].Columns.Add("Supplier"); ds.Tables["Items"].Columns.Add("Material"); ds.Tables["Items"].Columns.Add("Quantity"); ds.Tables["Items"].Columns.Add("rate"); ds.Tables["Items"].Columns.Add("TotalAmount"); SupplyOrderRegisterRepository repo = new SupplyOrderRegisterRepository(); var Head = repo.GetSupplyOrderRegisterHD(from, to, OrganizationId); DataRow dr = ds.Tables["Head"].NewRow(); dr["From"] = from.Value.ToShortDateString(); dr["To"] = to.Value.ToShortDateString(); dr["SupplierHead"] = SupName; dr["ItemHead"] = itmName; dr["OrganizationName"] = Head.OrganizationName; dr["Image1"] = Server.MapPath("~/App_images/") + Head.Image1; ds.Tables["Head"].Rows.Add(dr); PurchaseBillRegisterRepository repo1 = new PurchaseBillRegisterRepository(); var Items = repo1.GetPurchaseBillRegisterDataDTPrint(from, to, SupId, itmid, OrganizationId); foreach (var item in Items) { var SupplyOrderRegItem = new PurchaseBillRegister { PurchaseBillNoDate = item.PurchaseBillNoDate, PurchaseBillDate = item.PurchaseBillDate, SupplierName = item.SupplierName, ItemName = item.ItemName, Quantity = item.Quantity, Rate = item.Rate, Amount = item.Amount, }; DataRow dri = ds.Tables["Items"].NewRow(); dri["BillNo&Date"] = SupplyOrderRegItem.PurchaseBillNoDate; dri["Date"] = SupplyOrderRegItem.PurchaseBillDate.ToString("dd-MMM-yyyy"); dri["Supplier"] = SupplyOrderRegItem.SupplierName; dri["Material"] = SupplyOrderRegItem.ItemName; dri["Quantity"] = SupplyOrderRegItem.Quantity; dri["rate"] = SupplyOrderRegItem.Rate; dri["TotalAmount"] = SupplyOrderRegItem.Amount; ds.Tables["Items"].Rows.Add(dri); } ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "PurchaseBillRegister.xml"), XmlWriteMode.WriteSchema); rd.SetDataSource(ds); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); try { Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf", String.Format("PurchaseBillRegister.pdf"))); } catch (Exception ex) { throw; } }
public ActionResult Print(int SupId = 0, string SupName = "") { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "PurchaseMonthlyItemwise.rpt")); DataSet ds = new DataSet(); ds.Tables.Add("Head"); ds.Tables.Add("Items"); // //-------HEAD ds.Tables["Head"].Columns.Add("SupplierHead"); ds.Tables["Head"].Columns.Add("OrganizationName"); ds.Tables["Head"].Columns.Add("Image1"); //-------DT ds.Tables["Items"].Columns.Add("ItemDes"); ds.Tables["Items"].Columns.Add("Jan"); ds.Tables["Items"].Columns.Add("Feb"); ds.Tables["Items"].Columns.Add("Mar"); ds.Tables["Items"].Columns.Add("Apr"); ds.Tables["Items"].Columns.Add("May"); ds.Tables["Items"].Columns.Add("Jun"); ds.Tables["Items"].Columns.Add("Jul"); ds.Tables["Items"].Columns.Add("Aug"); ds.Tables["Items"].Columns.Add("Sep"); ds.Tables["Items"].Columns.Add("Oct"); ds.Tables["Items"].Columns.Add("Nov"); ds.Tables["Items"].Columns.Add("Dec"); ds.Tables["Items"].Columns.Add("Total"); OrganizationRepository repo = new OrganizationRepository(); var Head = repo.GetOrganization(OrganizationId); DataRow dr = ds.Tables["Head"].NewRow(); dr["SupplierHead"] = SupName; dr["OrganizationName"] = Head.OrganizationName; dr["Image1"] = Server.MapPath("~/App_images/") + Head.Image1; ds.Tables["Head"].Rows.Add(dr); PurchaseBillRegisterRepository repo1 = new PurchaseBillRegisterRepository(); var Items = repo1.GetPurchaseMonthlyItemWiseDataDTPrint(SupId: SupId, OrganizationId: OrganizationId, FYStartdate: FYStartdate, FYEnddate: FYEnddate); foreach (var item in Items) { var SupplyOrderRegItem = new PurchaseBillRegister { ItemName = item.ItemName, Jan = item.Jan, Feb = item.Feb, Mar = item.Mar, Apr = item.Apr, May = item.May, Jun = item.Jun, Jul = item.Jul, Aug = item.Aug, Sep = item.Sep, Oct = item.Oct, Nov = item.Nov, Dece = item.Dece, Total = item.Total }; DataRow dri = ds.Tables["Items"].NewRow(); dri["ItemDes"] = SupplyOrderRegItem.ItemName; dri["Jan"] = SupplyOrderRegItem.Jan; dri["Feb"] = SupplyOrderRegItem.Feb; dri["Mar"] = SupplyOrderRegItem.Mar; dri["Apr"] = SupplyOrderRegItem.Apr; dri["May"] = SupplyOrderRegItem.May; dri["Jun"] = SupplyOrderRegItem.Jun; dri["Jul"] = SupplyOrderRegItem.Jul; dri["Aug"] = SupplyOrderRegItem.Aug; dri["Sep"] = SupplyOrderRegItem.Sep; dri["Oct"] = SupplyOrderRegItem.Oct; dri["Aug"] = SupplyOrderRegItem.Aug; dri["Sep"] = SupplyOrderRegItem.Sep; dri["Oct"] = SupplyOrderRegItem.Oct; dri["Nov"] = SupplyOrderRegItem.Nov; dri["Dec"] = SupplyOrderRegItem.Dece; dri["Total"] = SupplyOrderRegItem.Total; ds.Tables["Items"].Rows.Add(dri); } ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "PurchaseMonthlyItemwise.xml"), XmlWriteMode.WriteSchema); rd.SetDataSource(ds); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); try { Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf", String.Format("PurchaseMonthlyItemwise.pdf"))); } catch (Exception ex) { throw; } }