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 }));
}
}
