// GET: StockReport public ActionResult Index() { //StockReportRepository repo = new StockReportRepository(); //return View(repo.GetStockReport()); FillItemCategory(); FillItemGroup(); FillItemSubGroup(); //FillWarehouse(); StockReportSummary stk = new StockReportSummary(); stk.ItemId = 0; stk.itmGrpId = 0; stk.itmSubGrpId = 0; return(View(stk)); }
public ActionResult Print(string itmid = "", string PartNo = "") { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "StockSummary.rpt")); DataSet ds = new DataSet(); ds.Tables.Add("Head"); ds.Tables.Add("Items"); // //-------HEAD ds.Tables["Head"].Columns.Add("OrganizationName"); ds.Tables["Head"].Columns.Add("Image1"); ds.Tables["Head"].Columns.Add("Item"); ds.Tables["Head"].Columns.Add("PartNo"); //-------DT ds.Tables["Items"].Columns.Add("Item"); ds.Tables["Items"].Columns.Add("IN"); ds.Tables["Items"].Columns.Add("OUT"); ds.Tables["Items"].Columns.Add("Balance"); ds.Tables["Items"].Columns.Add("PartNum"); OrganizationRepository repo = new OrganizationRepository(); var Head = repo.GetOrganization(OrganizationId); DataRow dr = ds.Tables["Head"].NewRow(); dr["OrganizationName"] = Head.OrganizationName; dr["Image1"] = Server.MapPath("~/App_images/") + Head.Image1; dr["Item"] = itmid; dr["PartNo"] = PartNo; ds.Tables["Head"].Rows.Add(dr); StockReportRepository repo1 = new StockReportRepository(); //var Items = repo1.GetSOVarianceDataDTPrint(from, to, itmid, itmName, SupId, SupName); var Items = repo1.GetStockReportDTPrint(itmid, PartNo); foreach (var item in Items) { var SupplyOrderRegItem = new StockReportSummary { ItemName = item.ItemName, InQuantity = item.InQuantity, OutQuantity = item.OutQuantity, Balance = item.Balance, PartNo = item.PartNo, }; DataRow dri = ds.Tables["Items"].NewRow(); dri["Item"] = SupplyOrderRegItem.ItemName; dri["IN"] = SupplyOrderRegItem.InQuantity; dri["OUT"] = SupplyOrderRegItem.OutQuantity; dri["Balance"] = SupplyOrderRegItem.Balance; dri["PartNum"] = SupplyOrderRegItem.PartNo; ds.Tables["Items"].Rows.Add(dri); } ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "StockSummary.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("StockSummary.pdf"))); } catch (Exception ex) { throw; } }