// GET: ClosingStock public ActionResult Index() { InitDropdown(); FillWarehouse(); FillItemCategory(); ClosingStock cs = new ClosingStock(); cs.itmCatId = 0; FillGroup(); FillSubGroup(); return(View("Index", cs)); }
// GET: StockMovementRegister public ActionResult Index() { InitDropdown(); FillWarehouse(); FillItemCategory(); FillPartNo(); //FillGroup(); //FillSubGroup(); ClosingStock cs = new ClosingStock(); cs.itmCatId = 0; cs.itmGrpId = 0; cs.itmSubGrpId = 0; cs.ItemId = 0; ViewBag.startdate = FYStartdate; return(View("Index", cs)); }
//public ActionResult ItemGroup(int Code) //{ // FillItemGroup(Code); // return PartialView("_ItemGroupDropdown"); //} //public ActionResult ItemSubGroup(int Code) //{ // FillItemSubGroup(Code); // return PartialView("_ItemSubGroupDropdown"); //} //public ActionResult ItemCategory() //{ // FillItemCategory(); // return PartialView("_ItemCategoryDropdown"); //} public ActionResult Print(DateTime?from, DateTime?to, string Spname = "", int Spid = 0, int ItmCatid = 0, string ItmCatname = "", string Itmname = "", string Itmid = "", string PartNo = "") { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "StoresLedger.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("Stkpoint"); ds.Tables["Head"].Columns.Add("ItemCat"); ds.Tables["Head"].Columns.Add("Item"); ds.Tables["Head"].Columns.Add("OrganizationName"); ds.Tables["Head"].Columns.Add("Image1"); ds.Tables["Head"].Columns.Add("PartNo"); //-------DT ds.Tables["Items"].Columns.Add("Entrydate"); ds.Tables["Items"].Columns.Add("Transno"); ds.Tables["Items"].Columns.Add("TransType"); ds.Tables["Items"].Columns.Add("QtyIn"); ds.Tables["Items"].Columns.Add("Qtyout"); ds.Tables["Items"].Columns.Add("PartNum"); OrganizationRepository repo = new OrganizationRepository(); var Head = repo.GetOrganization(OrganizationId); DataRow dr = ds.Tables["Head"].NewRow(); dr["From"] = from.Value.ToShortDateString(); dr["To"] = to.Value.ToShortDateString(); dr["Stkpoint"] = Spname; dr["ItemCat"] = ItmCatname; dr["Item"] = Itmid; dr["PartNo"] = PartNo; dr["OrganizationName"] = Head.OrganizationName; dr["Image1"] = Server.MapPath("~/App_images/") + Head.Image1; ds.Tables["Head"].Rows.Add(dr); StoresLedgerRepository repo1 = new StoresLedgerRepository(); //var Items = repo1.GetSOVarianceDataDTPrint(from, to, itmid, itmName, SupId, SupName); var Items = repo1.GetStoresLedgerDataDTPrint(from, to, Spid, ItmCatid, Itmid, OrganizationId, PartNo); foreach (var item in Items) { var SupplyOrderRegItem = new ClosingStock { stocktrnDate = item.stocktrnDate, StockUserId = item.StockUserId, StockType = item.StockType, INQTY = item.INQTY, OUTQTY = item.OUTQTY, PartNo = item.PartNo, }; DataRow dri = ds.Tables["Items"].NewRow(); dri["Entrydate"] = SupplyOrderRegItem.stocktrnDate.ToString("dd-MMM-yyyy"); dri["Transno"] = SupplyOrderRegItem.StockUserId; dri["TransType"] = SupplyOrderRegItem.StockType; dri["QtyIn"] = SupplyOrderRegItem.INQTY; dri["Qtyout"] = SupplyOrderRegItem.OUTQTY; dri["PartNum"] = SupplyOrderRegItem.PartNo; //dri["totalOutQty"] = SupplyOrderRegItem.UnitName; ds.Tables["Items"].Rows.Add(dri); } ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "StoresLedger.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("StoresLedger.pdf"))); } catch (Exception ex) { throw; } }
public ActionResult Print(string Spname = "", int Spid = 0, int ItmCatid = 0, string ItmCatname = "", int Itmid = 0, string Itmname = "", string PartNo = "", string PartName = "", string ItemGroupname = "", int ItemGroupId = 0, int ItemSubGroupId = 0, string ItemSubGroupname = "") { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "CurrentStockReport.rpt")); DataSet ds = new DataSet(); ds.Tables.Add("Head"); ds.Tables.Add("Items"); // //-------HEAD ds.Tables["Head"].Columns.Add("Stkpoint"); ds.Tables["Head"].Columns.Add("ItemCat"); ds.Tables["Head"].Columns.Add("Item"); ds.Tables["Head"].Columns.Add("OrganizationName"); ds.Tables["Head"].Columns.Add("Image1"); ds.Tables["Head"].Columns.Add("PartName"); ds.Tables["Head"].Columns.Add("ItemGroupname"); ds.Tables["Head"].Columns.Add("ItemSubGroupname"); //-------DT ds.Tables["Items"].Columns.Add("Item"); ds.Tables["Items"].Columns.Add("PartNo"); ds.Tables["Items"].Columns.Add("CurrentStk"); ds.Tables["Items"].Columns.Add("Unit"); OrganizationRepository repo = new OrganizationRepository(); var Head = repo.GetOrganization(OrganizationId); DataRow dr = ds.Tables["Head"].NewRow(); dr["Stkpoint"] = Spname; dr["ItemCat"] = ItmCatname; dr["Item"] = Itmname; dr["PartName"] = PartName; dr["ItemGroupname"] = ItemGroupname; dr["ItemSubGroupname"] = ItemSubGroupname; dr["OrganizationName"] = Head.OrganizationName; dr["Image1"] = Server.MapPath("~/App_images/") + Head.Image1; ds.Tables["Head"].Rows.Add(dr); ClosingStockRepository repo1 = new ClosingStockRepository(); //var Items = repo1.GetSOVarianceDataDTPrint(from, to, itmid, itmName, SupId, SupName); var Items = repo1.GetCurrentStockDataDTPrint(stockPointId: Spid, itemCategoryId: ItmCatid, itemId: Itmid, OrganizationId: OrganizationId, partno: PartNo, itmGroup: ItemGroupId, itmSubgroup: ItemSubGroupId); foreach (var item in Items) { var SupplyOrderRegItem = new ClosingStock { ItemName = item.ItemName, PartNo = item.PartNo, Quantity = item.Quantity, UnitName = item.UnitName, }; DataRow dri = ds.Tables["Items"].NewRow(); dri["Item"] = SupplyOrderRegItem.ItemName; dri["PartNo"] = SupplyOrderRegItem.PartNo; dri["CurrentStk"] = SupplyOrderRegItem.Quantity; dri["Unit"] = SupplyOrderRegItem.UnitName; ds.Tables["Items"].Rows.Add(dri); } ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "CurrentStockReport.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("CurrentStockReport.pdf"))); } catch (Exception ex) { throw; } }