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 AddEditOPM(int OPM_ID = 0) { BuyerReferenceManager objBuyerReferenceManager = new BuyerReferenceManager(new DataContext()); ParticipiantManager objParticipiantManager = new ParticipiantManager(new DataContext()); BuyerNameManager objBuyerNameManager = new BuyerNameManager(new DataContext()); OPMManager context = new OPMManager(new DataContext()); OPM_Model objModel = new OPM_Model(); if (OPM_ID != 0) { objModel.Table = context.GetOPMById(OPM_ID); if (objModel.Table.Participants != null) { objModel.Participant = objModel.Table.Participants.Split(','); } if (objModel.Table.BuyerReferenceName != null) { objModel.BuyerReferenceName = objModel.Table.BuyerReferenceName.Split(','); } } else { objModel.Table = new OPM(); objModel.Participant = null; objModel.BuyerReferenceName = null; } objModel.BuyerReferenceNameList = Extens.ToSelectList(objBuyerReferenceManager.GetDtBuyerReferenceName(), "BuyerReferenceName", "BuyerReferenceName"); objModel.BuyerStoryNameList = Extens.ToSelectList(objBuyerReferenceManager.GetDtBuyerStoryName(), "StoryName", "StoryName"); objModel.BuyerNameList = Extens.ToSelectList(objBuyerNameManager.GetDtBuyerName(), "Buyername", "Buyername"); objModel.ParticipantList = Extens.ToSelectList(objParticipiantManager.GetDtParticipiantName(), "Name", "Name"); return(PartialView("OPMCRUD", objModel)); }
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 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 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)); }
public ActionResult GanttChart() { BuyerListManager objBuyername = new BuyerListManager(new DataContext()); var lstBuyername = Extens.ToSelectList(objBuyername.GetDtBuyer(), "Buyername", "Buyername"); ViewBag.LstBuyername = lstBuyername; return(View()); }
// 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)); }
private void button_Fibonancci_Click(object sender, EventArgs e) { Form2 form = new Form2(); //Form not closable form.ControlBox = false; Extens.CloseAfterDelay(form, 2000); form.ShowDialog(); localhost.WebService1 Fib = new localhost.WebService1(); MessageBox.Show("the value in Fibonacci sequence = " + Fib.Fibonacci(10)); }
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 void BindSample3(EmployeeModel objModel, int page, int pageSize) { CityManager objCityManager = new CityManager(new DataContext()); EmployeeManager context = new EmployeeManager(new DataContext()); StringBuilder query = new StringBuilder(); List <string> colName = common.GetColumns(CommonFunction.module.Employee.ToString()); query = common.GetSqlTableQuery(CommonFunction.module.Employee.ToString()); if (objModel != null) { objModel.StaticPageSize = pageSize; } objModel.CityList = Extens.ToSelectList(objCityManager.GetDtCity(), "CityID", "CityName"); context.setModel(query, objModel, colName, "Name", page, pageSize); }
public ActionResult AddEditQAInspection(int OPM_ID, int QAIns_ID = 0) { TypeOfInspectionManager objTypeOfInspection = new TypeOfInspectionManager(new DataContext()); QAInspectionManager context = new QAInspectionManager(new DataContext()); QAInspection_Model objModel = new QAInspection_Model(); if (QAIns_ID != 0) { objModel.Table = context.GetQAInspectionById(QAIns_ID); } else { objModel.Table = new QAInspection(); objModel.Table.OPM_ID = OPM_ID; } objModel.InspectionTypeList = Extens.ToSelectList(objTypeOfInspection.GetTypeOfInspection(), "InspectionType", "InspectionType"); return(PartialView("QAInspectionCRUD", objModel)); }
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)); }
public void BindOPMGrid(OPM_Model objModel, int page, int pageSize) { BuyerReferenceManager objBuyerReferenceManager = new BuyerReferenceManager(new DataContext()); StringBuilder query = new StringBuilder(); var colName = common.GetColumns(CommonFunction.module.OPM.ToString()); query = common.GetSqlTableQuery(CommonFunction.module.OPM.ToString()); if (objModel != null) { objModel.StaticPageSize = pageSize; } objModel.BuyerReferenceNameList = Extens.ToSelectList(objBuyerReferenceManager.GetDtBuyerReferenceName(), "BuyerReferenceName", "BuyerReferenceName"); //objModel.BuyerStoryNameList = Extens.ToSelectList(objBuyerReferenceManager.GetDtBuyerReferenceName(), "StoryName", "StoryName"); OPMManager context = new OPMManager(new DataContext()); objModel.sortOrder = "desc"; objModel.fieldName = "OPM_ID"; context.setModel(query, objModel, colName, "OPM_ID", page, pageSize); }
// 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 })); } }
public ActionResult AddEditProcessByUser(int ID = 0) { ProcessListManager objProcessListManager = new ProcessListManager(new DataContext()); UserMasterListManager objUserMasterListManager = new UserMasterListManager(new DataContext()); //ProcessByUserManager context = new ProcessByUserManager(new DataContext()); VW_ProcessByUserManager context = new VW_ProcessByUserManager(new DataContext()); ProcessByUser_Model objModel = new ProcessByUser_Model(); if (ID != 0) { objModel.Table = context.GetProcessByUserById(ID); objModel.UserId = objModel.Table.UserID; objModel.ProcessId = !string.IsNullOrEmpty(objModel.Table.ProcessID)? objModel.Table.ProcessID.Split(',') : null; objModel.UserList = Extens.ToSelectList(objUserMasterListManager.GetDtUserListForProcess(objModel.Table.UserID), "UserID", "UserName"); } else { objModel.Table = new VW_ProcessByUser(); objModel.UserList = Extens.ToSelectList(objUserMasterListManager.GetDtUserListForProcess(), "UserID", "UserName"); } objModel.ProcessList = Extens.ToSelectList(objProcessListManager.GetDtProcess(), "ProcID", "Processname"); return(PartialView("ProcessByUserCRUD", objModel)); }