public ActionResult Gantt() { ProductManager objProductManager = new ProductManager(new DataContext()); BuyerListManager objBuyername = new BuyerListManager(new DataContext()); BuyerOrderNumberListManager objBuyerOrderNumber = new BuyerOrderNumberListManager(new DataContext()); ProcessListManager objProcessListManager = new ProcessListManager(new DataContext()); List <BuyerOrderNumber> lstBuyerOrderNumber = objBuyerOrderNumber.GetAll(); List <ProductUpdateGrid> lstProductUpdateGrid = objProductManager.GetProductMasterList(); int i = 1; List <ProductGantt> lst = new List <ProductGantt>(); foreach (BuyerOrderNumber obj in lstBuyerOrderNumber) { ProductGantt obj1 = new ProductGantt(); obj1.id = i; obj1.name = obj.BuyerOrderNumberName; List <Series> s1 = lstProductUpdateGrid.Where(c => c.BuyerOrderNumberName == obj.BuyerOrderNumberName).Select(c => new Series { start = c.StartDate.Value, end = c.SPCDate.Value, name = c.Processname, color = null }).ToList(); obj1.series = s1; lst.Add(obj1); i++; } ProductGantt_Model model = new ProductGantt_Model(); model.ProcessList = Extens.ToSelectList(objProcessListManager.GetDtProcess(), "Processname", "Processname"); model.BuyerOrderNumberList = Extens.ToSelectList(objBuyerOrderNumber.GetDtBuyerOrderNumber(), "BuyerOrderNumberName", "BuyerOrderNumberName"); model.SeriesList = lst; model.Json = JsonConvert.SerializeObject(lst); return(View(model)); }
public ActionResult Bar() { ProductGroupChartManager objPGChartManager = new ProductGroupChartManager(new DataContext()); BuyerOrderNumberListManager objBuyerOrderNumberListManager = new BuyerOrderNumberListManager(new DataContext()); var lstData = objPGChartManager.GetAll().ToList(); List <string> categories = new List <string>(); List <decimal> lstProductQty = new List <decimal>(); List <decimal> lstFinishedQty = new List <decimal>(); List <decimal> lstBalanceQty = new List <decimal>(); GroupBarModel model = new GroupBarModel(); model.BuyerOrderNumberList = Extens.ToSelectList(objBuyerOrderNumberListManager.GetDtBuyerOrderNumber(), "BuyerOrderNumberName", "BuyerOrderNumberName"); foreach (VW_ProductGroupChart obj in lstData) { categories.Add(obj.Productname + "-" + obj.Processname); lstProductQty.Add(obj.ProductQtyfrom); lstFinishedQty.Add(obj.FinishedQty); lstBalanceQty.Add(obj.BalanceQty); } model.categories = JsonConvert.SerializeObject(categories); model.ProductQty = JsonConvert.SerializeObject(lstProductQty); model.FinishedQty = JsonConvert.SerializeObject(lstFinishedQty); model.BalanceQty = JsonConvert.SerializeObject(lstBalanceQty); return(View(model)); }
public ActionResult AddEditProductMaster(int ProductID = 0) { BuyerListManager objBuyerListManager = new BuyerListManager(new DataContext()); BuyerOrderNumberListManager objBuyerOrderNumberListManager = new BuyerOrderNumberListManager(new DataContext()); ProcessListManager objProcessListManager = new ProcessListManager(new DataContext()); SupplierListManager objSupplierListManager = new SupplierListManager(new DataContext()); ProductListManager objProductListManager = new ProductListManager(new DataContext()); UnitListManager objUnitListManager = new UnitListManager(new DataContext()); SetNoteListManager objSetNoteListManager = new SetNoteListManager(new DataContext()); ProductManager context = new ProductManager(new DataContext()); ProductUpdateGrid_Model objModel = new ProductUpdateGrid_Model(); if (ProductID != 0) { objModel.Table = context.GetProductMasterById(ProductID); } else { objModel.Table = new ProductUpdateGrid(); } objModel.BuyerList = Extens.ToSelectList(objBuyerListManager.GetDtBuyer(), "Buyername", "Buyername"); objModel.BuyerOrderNumberList = Extens.ToSelectList(objBuyerOrderNumberListManager.GetDtBuyerOrderNumber(), "BuyerOrderNumberName", "BuyerOrderNumberName"); objModel.ProcessList = Extens.ToSelectList(objProcessListManager.GetDtProcess(), "Processname", "Processname"); objModel.SupplierList = Extens.ToSelectList(objSupplierListManager.GetDtSupplier(), "Suppliername", "Suppliername"); objModel.ProductList = Extens.ToSelectList(objProductListManager.GetDtProduct(), "Productname", "Productname"); objModel.UnitList = Extens.ToSelectList(objUnitListManager.GetDtUnit(), "Unitname", "Unitname"); objModel.SetNoteList = Extens.ToSelectList(objSetNoteListManager.GetDtSetNote(), "Setnotename", "Setnotename"); return(PartialView("ProductMasterCRUD", objModel)); }
public ActionResult ResetGantt(string ProcessName, string BuyerOrderNumberName) { ProductManager objProductManager = new ProductManager(new DataContext()); BuyerOrderNumberListManager objBuyerOrderNumber = new BuyerOrderNumberListManager(new DataContext()); ProcessListManager objProcessListManager = new ProcessListManager(new DataContext()); List <BuyerOrderNumber> lstBuyerOrderNumber = new List <BuyerOrderNumber>(); List <ProductUpdateGrid> lstProductUpdateGrid = new List <ProductUpdateGrid>(); if (!string.IsNullOrEmpty(BuyerOrderNumberName) && !string.IsNullOrEmpty(ProcessName)) { lstBuyerOrderNumber = objBuyerOrderNumber.GetAll(c => c.BuyerOrderNumberName == BuyerOrderNumberName).ToList(); lstProductUpdateGrid = objProductManager.GetAll(c => c.BuyerOrderNumberName == BuyerOrderNumberName && c.Processname == ProcessName).ToList(); } else if (string.IsNullOrEmpty(BuyerOrderNumberName) && !string.IsNullOrEmpty(ProcessName)) { lstBuyerOrderNumber = objBuyerOrderNumber.GetAll().ToList(); lstProductUpdateGrid = objProductManager.GetAll(c => c.Processname == ProcessName).ToList(); } else if (!string.IsNullOrEmpty(BuyerOrderNumberName) && string.IsNullOrEmpty(ProcessName)) { lstBuyerOrderNumber = objBuyerOrderNumber.GetAll(c => c.BuyerOrderNumberName == BuyerOrderNumberName).ToList(); lstProductUpdateGrid = objProductManager.GetAll(c => c.BuyerOrderNumberName == BuyerOrderNumberName).ToList(); } else { lstBuyerOrderNumber = objBuyerOrderNumber.GetAll().ToList(); lstProductUpdateGrid = objProductManager.GetAll().ToList(); } ProductGantt_Model model = new ProductGantt_Model(); model.ProcessList = Extens.ToSelectList(objProcessListManager.GetDtProcess(), "Processname", "Processname"); model.BuyerOrderNumberList = Extens.ToSelectList(objBuyerOrderNumber.GetDtBuyerOrderNumber(), "BuyerOrderNumberName", "BuyerOrderNumberName"); if (lstProductUpdateGrid.Count() > 0) { int i = 1; List <ProductGantt> lst = new List <ProductGantt>(); foreach (BuyerOrderNumber obj in lstBuyerOrderNumber) { ProductGantt obj1 = new ProductGantt(); obj1.id = i; obj1.name = obj.BuyerOrderNumberName; List <Series> s1 = lstProductUpdateGrid.Where(c => c.BuyerOrderNumberName == obj.BuyerOrderNumberName).Select(c => new Series { start = c.StartDate.Value, end = c.SPCDate.Value, name = c.Processname, color = null }).ToList(); obj1.series = s1; lst.Add(obj1); i++; } model.SeriesList = lst; model.Json = JsonConvert.SerializeObject(lst); } else { model.SeriesList = new List <ProductGantt>(); model.Json = ""; } return(View("Gantt", model)); }
// GET: UserDashboard public ActionResult Dashboard() { FinalLineInspectionManager context1 = new FinalLineInspectionManager(new DataContext()); InLineInspectionManager context2 = new InLineInspectionManager(new DataContext()); MidLineInspectionManager context3 = new MidLineInspectionManager(new DataContext()); OrderPackingManager context4 = new OrderPackingManager(new DataContext()); OrdersDespatcheManager context5 = new OrdersDespatcheManager(new DataContext()); UserManager context6 = new UserManager(new DataContext()); DSProductUpdateGridManager context7 = new DSProductUpdateGridManager(new DataContext()); PKGKDManager context8 = new PKGKDManager(new DataContext()); PKGKDDespatchManager context9 = new PKGKDDespatchManager(new DataContext()); DashboardModel model = new DashboardModel(); model.LstFinalLineInspection = context1.GetList(); model.LstInLineInspection = context2.GetList(); model.LstMidLineInspection = context3.GetList(); model.LstOrderPacking = context4.GetList(); model.LstOrdersDespatche = context5.GetList(); model.LstDSProductUpdateGrid = context7.GetList(); model.LstBuyerOrderPackingList = context8.GetList(); model.LstBuyerOrderDespatchList = context9.GetList(); List <string> labels = new List <string>(); labels.Add("Online User"); labels.Add("Offline User"); List <int> series = new List <int>(); int onlineUsers = 0; int totUsers = context6.GetTotalUserCount(); var allUser = context6.GetAll().ToList(); if (HttpContext.Application["TotalOnlineUsers"] != null) { onlineUsers = Convert.ToInt32(HttpContext.Application["TotalOnlineUsers"]); } if (HttpContext.Application["OnlineUsers"] != null) { string user = (string)HttpContext.Application["OnlineUsers"]; List <string> lstUser = user.Split(',').ToList(); model.LstUser = allUser.Where(c => lstUser.Contains(c.UserId.ToString())).Select(c => new Tuple <string, string>(c.UserName, c.ImageName)).ToList(); } BuyerListManager objbuyerNameManager = new BuyerListManager(new DataContext()); BuyerOrderNumberListManager objBuyerOrderNumberNameManager = new BuyerOrderNumberListManager(new DataContext()); ProcessListManager objProcessListManager = new ProcessListManager(new DataContext()); model.BuyerList = Extens.ToSelectList(objbuyerNameManager.GetDtBuyer(), "Buyername", "Buyername"); model.BuyerOrderNumberList = Extens.ToSelectList(objBuyerOrderNumberNameManager.GetDtBuyerOrderNumber(), "BuyerOrderNumberName", "BuyerOrderNumberName"); model.ProcessList = Extens.ToSelectList(objProcessListManager.GetDtProcess(), "Processname", "Processname"); int offlineUsers = totUsers - onlineUsers; series.Add(onlineUsers); series.Add(offlineUsers); model.labels = JsonConvert.SerializeObject(labels); model.series = JsonConvert.SerializeObject(series); ViewBag.OnlineUser = model.LstUser; return(View(model)); }
public void BindProductGrid(ProductUpdateGrid_Model objModel, int page, int pageSize) { BuyerListManager objBuyerListManager = new BuyerListManager(new DataContext()); BuyerOrderNumberListManager objBuyerOrderNumberListManager = new BuyerOrderNumberListManager(new DataContext()); ProcessListManager objProcessListManager = new ProcessListManager(new DataContext()); SupplierListManager objSupplierListManager = new SupplierListManager(new DataContext()); ProductListManager objProductListManager = new ProductListManager(new DataContext()); UnitListManager objUnitListManager = new UnitListManager(new DataContext()); SetNoteListManager objSetNoteListManager = new SetNoteListManager(new DataContext()); ProductManager context = new ProductManager(new DataContext()); PlannerManager pln_context = new PlannerManager(new DataContext()); FinishingManager fis_context = new FinishingManager(new DataContext()); objModel.PlannerUpdateGridList = pln_context.GetPlannerUpdateGridList(); objModel.FinishingUpdateGridList = fis_context.GetFinishingUpdateGridList(); StringBuilder query = new StringBuilder(); var colName = common.GetColumns(CommonFunction.module.ProductMaster.ToString()); query = common.GetSqlTableQuery(CommonFunction.module.ProductMaster.ToString()); string uProcess = ""; if (Session["UserProcess"] != null) { uProcess = Session["UserProcess"].ToString(); } uProcess = "'" + uProcess.Replace(",", "','") + "'"; query.Append(" AND Processname IN (" + uProcess + ") AND "); if (objModel != null) { objModel.StaticPageSize = pageSize; } objModel.BuyerList = Extens.ToSelectList(objBuyerListManager.GetDtBuyer(), "ByrID", "Buyername"); objModel.BuyerOrderNumberList = Extens.ToSelectList(objBuyerOrderNumberListManager.GetDtBuyerOrderNumber(), "BuyerOrderNumberID", "BuyerOrderNumberName"); objModel.ProcessList = Extens.ToSelectList(objProcessListManager.GetDtProcess(), "ProcID", "Processname"); objModel.SupplierList = Extens.ToSelectList(objSupplierListManager.GetDtSupplier(), "SupID", "Suppliername"); objModel.ProductList = Extens.ToSelectList(objProductListManager.GetDtProduct(), "PrdID", "Productname"); objModel.UnitList = Extens.ToSelectList(objUnitListManager.GetDtUnit(), "UnitID", "Unitname"); objModel.SetNoteList = Extens.ToSelectList(objSetNoteListManager.GetDtSetNote(), "SetID", "Setnotename"); objModel.sortOrder = "desc"; objModel.fieldName = "ProductID"; context.setModel(query, objModel, colName, "ProductID", page, pageSize); }
public ActionResult AddEditPKGKDList(int OPM_ID, int PkgDesID = 0) { BuyerOrderNumberListManager objBuyerOrderNumber = new BuyerOrderNumberListManager(new DataContext()); PKGKDListManager context = new PKGKDListManager(new DataContext()); PKGKDList_Model objModel = new PKGKDList_Model(); if (PkgDesID != 0) { objModel.Table = context.GetPKGKDListById(PkgDesID); } else { objModel.Table = new PKGKDList(); objModel.Table.OPM_ID = OPM_ID; } objModel.BuyerOrderNumberList = Extens.ToSelectList(objBuyerOrderNumber.GetDtBuyerOrderNumber(), "BuyerOrderNumberName", "BuyerOrderNumberName"); return(PartialView("PKGKDListCRUD", objModel)); }
// GET: AdminChart public ActionResult Index() { ProcessListManager objProcessListManager = new ProcessListManager(new DataContext()); BuyerListManager objBuyerListManager = new BuyerListManager(new DataContext()); BuyerOrderNumberListManager objBuyerOrderNumberListManager = new BuyerOrderNumberListManager(new DataContext()); VW_ProductSummaryManager objVW_ProductSummaryManager = new VW_ProductSummaryManager(new DataContext()); List <VW_ProductSummary> lst = objVW_ProductSummaryManager.GetProductSummaryList(); SeriesData obj1 = new SeriesData(); obj1.name = "ProductQty"; obj1.data = lst.Select(c => c.ProductQty).ToList(); SeriesData obj2 = new SeriesData(); obj2.name = "FinishedQty"; obj2.data = lst.Select(c => c.FinishedQty).ToList(); SeriesData obj3 = new SeriesData(); obj3.name = "BalanceQty"; obj3.data = lst.Select(c => c.BalanceQty).ToList(); List <SeriesData> SeriesData = new List <SeriesData>(); SeriesData.Add(obj1); SeriesData.Add(obj2); SeriesData.Add(obj3); VW_ProductSummary_Model objModel = new VW_ProductSummary_Model(); objModel.BuyerList = Extens.ToSelectList(objBuyerListManager.GetDtBuyer(), "Buyername", "Buyername"); objModel.BuyerOrderNumberList = Extens.ToSelectList(objBuyerOrderNumberListManager.GetDtBuyerOrderNumber(), "BuyerOrderNumberName", "BuyerOrderNumberName"); objModel.ProcessList = Extens.ToSelectList(objProcessListManager.GetDtProcess(), "Processname", "Processname"); objModel.SeriesList = SeriesData; objModel.Json = JsonConvert.SerializeObject(SeriesData); objModel.categories = JsonConvert.SerializeObject(lst.Select(c => c.Buyername + " / " + c.BuyerOrderNumberName + " / " + c.Processname).ToList()); return(View(objModel)); }
public ActionResult AddEditVendor(int OPM_ID, int VP_ID = 0) { BuyerOrderNumberListManager objBuyerOrderNumber = new BuyerOrderNumberListManager(new DataContext()); ParticipiantManager objParticipiantManager = new ParticipiantManager(new DataContext()); SupplierListManager objSupplierListManager = new SupplierListManager(new DataContext()); VendorManager context = new VendorManager(new DataContext()); Vendor_Model objModel = new Vendor_Model(); if (VP_ID != 0) { objModel.Table = context.GetVendorById(VP_ID); } else { objModel.Table = new Vendor(); objModel.Table.OPM_ID = OPM_ID; } objModel.BuyerOrderNumberList = Extens.ToSelectList(objBuyerOrderNumber.GetDtBuyerOrderNumber(), "BuyerOrderNumberName", "BuyerOrderNumberName"); objModel.ParticipiantNameList = Extens.ToSelectList(objParticipiantManager.GetDtParticipiantName(), "Name", "Name"); objModel.SupplierNameList = Extens.ToSelectList(objSupplierListManager.GetDtSupplier(), "Suppliername", "Suppliername"); return(PartialView("VendorCRUD", objModel)); }
public ActionResult ResetBar(string BuyerOrderNumberName) { ProductGroupChartManager objPGChartManager = new ProductGroupChartManager(new DataContext()); BuyerOrderNumberListManager objBuyerOrderNumberListManager = new BuyerOrderNumberListManager(new DataContext()); var lstData = new List <VW_ProductGroupChart>(); if (!string.IsNullOrEmpty(BuyerOrderNumberName)) { lstData = objPGChartManager.GetAll(c => c.BuyerOrderNumberName == BuyerOrderNumberName).ToList(); } else { lstData = objPGChartManager.GetAll().ToList(); } List <string> categories = new List <string>(); List <decimal> lstProductQty = new List <decimal>(); List <decimal> lstFinishedQty = new List <decimal>(); List <decimal> lstBalanceQty = new List <decimal>(); GroupBarModel model = new GroupBarModel(); model.BuyerOrderNumberList = Extens.ToSelectList(objBuyerOrderNumberListManager.GetDtBuyerOrderNumber(), "BuyerOrderNumberName", "BuyerOrderNumberName"); if (lstData != null && lstData.Count() > 0) { foreach (VW_ProductGroupChart obj in lstData) { categories.Add(obj.Productname + "-" + obj.Processname); lstProductQty.Add(obj.ProductQtyfrom); lstFinishedQty.Add(obj.FinishedQty); lstBalanceQty.Add(obj.BalanceQty); } return(Json(new { Error = false, Categories = categories, ProductQty = lstProductQty, FinishedQty = lstFinishedQty, BalanceQty = lstBalanceQty })); } else { return(Json(new { Error = true })); } }