public ReportViewModel GetHollarConsumpViewModel(List <object> objLst, string startDate, string endDate, string stockId) { var reportViewModel = new ReportViewModel() { LeftMainTitle = "Johan Group", LeftSubTitle = "IT", Name = "Hollar Cost", //ReportDate = DateTime.Now, ReportLogo = "~/Content/logo.jpg", //ReportTitle = "Retailerwise Sales Report", ReportLanguage = "en-US", //UserNamPrinting = UserPrinting, Format = ReportViewModel.ReportFormat.PDF, ViewAsAttachment = false }; int stock = Convert.ToInt32(stockId); STK_tblStock stk = context.STK_tblStock.Where(ss => ss.ID == stock).FirstOrDefault(); string stkName = stk == null ? "উভয় মিল" : stk.stockName; //adding the dataset information to the report view model object reportViewModel.ReportDataSets.Add(new ReportViewModel.ReportDataSet() { DataSetData = objLst, DatasetName = "datset_HollarConsump" }); reportViewModel.ReportParams.Add(new ReportParameter("startDate", startDate)); reportViewModel.ReportParams.Add(new ReportParameter("endDate", endDate)); reportViewModel.ReportParams.Add(new ReportParameter("stock", stkName)); return(reportViewModel); }
public ReportViewModel GetRepoertViewModel(List <object> objLst, int stockId, int productId, string fromDate, string toDate) { var reportViewModel = new ReportViewModel() { LeftMainTitle = "Johan Group", LeftSubTitle = "IT", Name = "Stock Report", //ReportDate = DateTime.Now, ReportLogo = "~/Content/logo.jpg", //ReportTitle = "Retailerwise Sales Report", ReportLanguage = "en-US", //UserNamPrinting = UserPrinting, Format = ReportViewModel.ReportFormat.PDF, ViewAsAttachment = false }; STK_tblStock stock = context.STK_tblStock.Where(pp => pp.ID == stockId).FirstOrDefault(); tblProduct product = context.tblProducts.Where(pp => pp.ID == productId).FirstOrDefault(); string sname = stock.stockName ?? "N/A"; string pname = product.productName ?? "N/A"; //adding the dataset information to the report view model object reportViewModel.ReportDataSets.Add(new ReportViewModel.ReportDataSet() { DataSetData = objLst, DatasetName = "dataSet_GetStockInfo" }); reportViewModel.ReportParams.Add(new ReportParameter("stockName", sname)); reportViewModel.ReportParams.Add(new ReportParameter("productName", pname)); reportViewModel.ReportParams.Add(new ReportParameter("startDate", fromDate)); reportViewModel.ReportParams.Add(new ReportParameter("endDate", toDate)); return(reportViewModel); }
public bool EditStock(STK_tblStock stk) { var existStk = context.STK_tblStock.Where(ss => ss.ID >= stk.ID).FirstOrDefault(); existStk.stockName = stk.stockName; existStk.stockAddress = stk.stockAddress; return(context.SaveChanges() > 0); }
public List <STK_tblStock> GetStock(STK_tblStock stk) { List <STK_tblStock> stkList = null; if (stk == null) { stkList = context.STK_tblStock.ToList(); } else if (stk.ID > 0) { stkList = context.STK_tblStock.Where(x => x.ID == stk.ID).ToList(); } return(stkList); }
public ReportViewModel GetPaddyStockViewModel(List <object> objLst, int stockId, int productId, string fromDate, string toDate) { var reportViewModel = new ReportViewModel() { LeftMainTitle = "Johan Group", LeftSubTitle = "IT", Name = "Stock Report", //ReportDate = DateTime.Now, ReportLogo = "~/Content/logo.jpg", //ReportTitle = "Retailerwise Sales Report", ReportLanguage = "en-US", //UserNamPrinting = UserPrinting, Format = ReportViewModel.ReportFormat.PDF, ViewAsAttachment = false }; tblProduct product = context.tblProducts.Where(pp => pp.ID == productId).FirstOrDefault(); string pname = product.productName ?? "N/A"; STK_tblStock stk = context.STK_tblStock.Where(ss => ss.ID == stockId).FirstOrDefault(); string stockName = stk.stockName ?? "N/A"; DateTime fdate = Convert.ToDateTime(fromDate); DateTime tdate = Convert.ToDateTime(toDate); var result = context.func_paddyparta(stockId, productId, fdate, tdate).ToList(); var prodStocks = context.STK_Balance.Where(ss => ss.stockId == stockId && ss.productId == productId).ToList(); double totBag = 0, totQty = 0; foreach (var item in prodStocks) { totBag += item.sackQuantity ?? 0; totQty += (item.sackQuantity * item.sackWeight) ?? 0; } double avgparta = result.Count > 0 ? result[0].Value : 0; //adding the dataset information to the report view model object reportViewModel.ReportDataSets.Add(new ReportViewModel.ReportDataSet() { DataSetData = objLst, DatasetName = "dataSet_PaddyStockInfo" }); reportViewModel.ReportParams.Add(new ReportParameter("stockName", stockName)); reportViewModel.ReportParams.Add(new ReportParameter("productName", pname)); reportViewModel.ReportParams.Add(new ReportParameter("startDate", fromDate)); reportViewModel.ReportParams.Add(new ReportParameter("endDate", toDate)); reportViewModel.ReportParams.Add(new ReportParameter("avgParta", avgparta.ToString())); //"#.##" reportViewModel.ReportParams.Add(new ReportParameter("totBag", totBag.ToString())); //"#.##" reportViewModel.ReportParams.Add(new ReportParameter("totQty", totQty.ToString())); //"#.##" return(reportViewModel); }
public JsonResult EditStock([System.Web.Http.FromBody] STK_tblStock stk) { if (Session["role"] == null) { Session["userId"] = null; Session["role"] = null; return(Json(false, JsonRequestBehavior.AllowGet)); } else if (Session["role"].ToString() == "Super Admin") { return(Json(stkRepository.EditStock(stk), JsonRequestBehavior.AllowGet)); } else { Session["userId"] = null; Session["role"] = null; return(Json(false, JsonRequestBehavior.AllowGet)); } }
public JsonResult SaveStock(STK_tblStock stk) { if (Session["role"] == null) { Session["userId"] = null; Session["role"] = null; return(Json(false, JsonRequestBehavior.AllowGet)); } else if (Session["role"].ToString() == "Admin" || Session["role"].ToString() == "Super Admin") { return(Json(stkRepository.SaveStock(stk), JsonRequestBehavior.AllowGet)); } else { Session["userId"] = null; Session["role"] = null; return(Json(false, JsonRequestBehavior.AllowGet)); } }
public List <object> GetHollarConsumpRpt(string starDate, string endDate, string stockId) { DateTime fromD = Convert.ToDateTime(starDate); DateTime toD = Convert.ToDateTime(endDate); int stock = Convert.ToInt32(stockId); STK_tblStock hollar = context.STK_tblStock.Where(ss => ss.stockName == "হোলার").FirstOrDefault(); var hollarConsumpLst = from paddTrans in context.PaddyTransactions.Where(cc => cc.stockId == hollar.ID && cc.date >= fromD && cc.date <= toD && (stock == 0 || cc.fromStock == stock)) // here 5 is id of hollar join prod in context.tblProducts on paddTrans.prodId equals prod.ID //join stk in context.STK_tblStock on paddTrans.fromStock equals stk.ID select new { paddTrans.date, paddTrans.serial, paddTrans.bagWeight, paddTrans.rcvQty, paddTrans.millCost, prod.productName //stk.stockName }; return(hollarConsumpLst.ToList <object>()); }
public bool SaveStock(STK_tblStock stk) { stk.createDate = DateTime.Now; context.STK_tblStock.Add(stk); return(context.SaveChanges() > 0); }
// [Authorize(Roles = "Admin,Super Admin,User")] public JsonResult GetStock(STK_tblStock stk) { var stkList = stkRepository.GetStock(stk); return(Json(stkList, JsonRequestBehavior.AllowGet)); }