public DTO.EditFormData GetData(int userId, int id, int?workOrderID, out Library.DTO.Notification notification) { DTO.EditFormData editFormData = new DTO.EditFormData(); notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; try { using (WorkOrderCostMngEntities context = CreateContext()) { var workOrder = context.BOMMng_WorkOrder_View.Where(o => o.BOMID == id).FirstOrDefault(); editFormData.Data = new DTO.BOMDTO(); editFormData.Data.BOMDTOs = new List <DTO.BOMDTO>(); //init workorder info editFormData.Data.WorkOrderID = workOrder.WorkOrderID; editFormData.Data.WorkOrderUD = workOrder.WorkOrderUD; editFormData.Data.WorkOrderDescription = workOrder.WorkOrderDescription; editFormData.Data.WorkOrderQnt = workOrder.WorkOrderQnt; editFormData.Data.OPSequenceID = workOrder.OPSequenceID; editFormData.Data.OPSequenceNM = workOrder.OPSequenceNM; editFormData.Data.ClientUD = workOrder.ClientUD; editFormData.Data.ModelID = workOrder.ModelID; editFormData.Data.ModelUD = workOrder.ModelUD; editFormData.Data.ModelNM = workOrder.ModelNM; editFormData.Data.WorkOrderStatusID = workOrder.WorkOrderStatusID; editFormData.Data.WorkOrderTypeNM = workOrder.WorkOrderTypeNM; editFormData.Data.WorkOrderStatusNM = workOrder.WorkOrderStatusNM; if (workOrder.StartDate.HasValue) { editFormData.Data.StartDate = workOrder.StartDate.Value.ToString("dd/MM/yyyy"); } if (workOrder.FinishDate.HasValue) { editFormData.Data.FinishDate = workOrder.FinishDate.Value.ToString("dd/MM/yyyy"); } editFormData.Data.ProductArticleCode = workOrder.ProductArticleCode; editFormData.Data.ProductDescription = workOrder.ProductDescription; editFormData.Data.WorkOrderWastagePercent = workOrder.WastagePercent; editFormData.Data.ProductID = workOrder.ProductID; List <WorkOrderCostMng_WorkOrderCost_View> dbItem = context.WorkOrderCostMng_WorkOrderCost_View.Where(x => x.WorkOrderID == workOrderID).ToList(); editFormData.WorkOrderCosts = converter.DB2DTO_WorkOrderCost(dbItem); return(editFormData); } } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; Exception iEx = Library.Helper.GetInnerException(ex); notification.Message = iEx.Message; return(editFormData); } }
public List <DTO.ProductionItem> getProductionItemTypeCost(int userId, Hashtable filters) { List <DTO.ProductionItem> result = new List <DTO.ProductionItem>(); using (WorkOrderCostMngEntities context = this.CreateContext()) { Module.Framework.DAL.DataFactory fw_factory = new Framework.DAL.DataFactory(); int? companyID = fw_factory.GetCompanyID(userId); string searchQuery = filters["searchQuery"].ToString(); var dbItems = context.SupportMng_ProductionItem_View.Where(o => o.CompanyID == companyID && o.ProductionItemTypeID == 7 && (o.ProductionItemNM.Contains(searchQuery) || o.ProductionItemUD.Contains(searchQuery))).ToList(); return(AutoMapper.Mapper.Map <List <SupportMng_ProductionItem_View>, List <DTO.ProductionItem> >(dbItems)); } }
public bool UpdateData(int userId, int id, ref object dtoItem, out Library.DTO.Notification notification) { notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; List <WorkOrderCost> dataItem = ((Newtonsoft.Json.Linq.JArray)dtoItem).ToObject <List <WorkOrderCost> >(); try { //get companyID Module.Framework.DAL.DataFactory fw_factory = new Framework.DAL.DataFactory(); int?companyID = fw_factory.GetCompanyID(userId); using (WorkOrderCostMngEntities context = CreateContext()) { List <WorkOrderCost> dbWorkOrderCosts = context.WorkOrderCost.Where(x => x.WorkOrderID == id).ToList(); List <int> dbWorkOrderCostsDelete = dbWorkOrderCosts.Select(y => y.WorkOrderCostID).Where(x => !dataItem.Select(z => z.WorkOrderCostID).Contains(x)).ToList(); foreach (WorkOrderCost item in dataItem) { if (!dbWorkOrderCosts.Select(x => x.WorkOrderCostID).ToList().Contains(item.WorkOrderCostID)) { context.WorkOrderCost.Add(item); } else { WorkOrderCost dbWorkOrderCost = dbWorkOrderCosts.Where(x => x.WorkOrderCostID == item.WorkOrderCostID).FirstOrDefault(); dbWorkOrderCost.Qty = item.Qty; dbWorkOrderCost.CostPrice = item.CostPrice; } } foreach (int iddelete in dbWorkOrderCostsDelete) { WorkOrderCost itemdelete = context.WorkOrderCost.Where(x => x.WorkOrderCostID == iddelete).FirstOrDefault(); if (itemdelete != null) { context.WorkOrderCost.Remove(itemdelete); } } context.SaveChanges(); return(true); } } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; Exception iEx = Library.Helper.GetInnerException(ex); notification.Message = iEx.Message; return(false); } }