public object GetDataWithFilter(int userID, System.Collections.Hashtable filters, int pageSize, int pageIndex, string orderBy, string orderDirection, out int totalRows, out Library.DTO.Notification notification) { totalRows = 0; notification = new Library.DTO.Notification(); notification.Type = Library.DTO.NotificationType.Success; int?companyID = fwFactory.GetCompanyID(userID); DTO.SearchFormDTO data = new DTO.SearchFormDTO(); try { int?alertLevel = (filters.ContainsKey("AlertLevel") && filters["AlertLevel"] != null && !string.IsNullOrEmpty(filters["AlertLevel"].ToString())) ? (int?)Convert.ToInt32(filters["AlertLevel"].ToString()) : null; int?factoryWarehouseID = (filters.ContainsKey("FactoryWarehouseID") && filters["FactoryWarehouseID"] != null && !string.IsNullOrEmpty(filters["FactoryWarehouseID"].ToString())) ? (int?)Convert.ToInt32(filters["FactoryWarehouseID"].ToString()) : null; int?materialGroupID = (filters.ContainsKey("MaterialGroupID") && filters["MaterialGroupID"] != null && !string.IsNullOrEmpty(filters["MaterialGroupID"].ToString())) ? (int?)Convert.ToInt32(filters["MaterialGroupID"].ToString()) : null; using (var context = CreateContext()) { var dbItem = context.StockStatusQntRpt_function_GetDataStockStatusQnt(alertLevel, factoryWarehouseID, materialGroupID, orderBy, orderDirection).Where(o => o.CompanyID == companyID).ToList(); data.stockStatusQntDTOs = converter.DB2DTO_StockStatus(dbItem.ToList()); } } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = Library.Helper.GetInnerException(ex).Message; } return(data); }
public object GetDataWithFilter(int userID, System.Collections.Hashtable filters, int pageSize, int pageIndex, string orderBy, string orderDirection, out int totalRows, out Library.DTO.Notification notification) { totalRows = 0; notification = new Library.DTO.Notification(); notification.Type = Library.DTO.NotificationType.Success; DTO.SearchFormDTO data = new DTO.SearchFormDTO(); try { string season = (filters.ContainsKey("Season") && filters["Season"] != null && !string.IsNullOrEmpty(filters["Season"].ToString())) ? filters["Season"].ToString() : null; int? factoryID = (filters.ContainsKey("FactoryID") && filters["FactoryID"] != null && !string.IsNullOrEmpty(filters["FactoryID"].ToString())) ? (int?)Convert.ToInt32(filters["FactoryID"].ToString()) : null; string clientUD = (filters.ContainsKey("ClientUD") && filters["ClientUD"] != null && !string.IsNullOrEmpty(filters["ClientUD"].ToString())) ? filters["ClientUD"].ToString() : null; string proformaInvoiceNo = (filters.ContainsKey("ProformaInvoice") && filters["ProformaInvoice"] != null && !string.IsNullOrEmpty(filters["ProformaInvoice"].ToString())) ? filters["ProformaInvoice"].ToString() : null; using (var context = CreateContext()) { var dbItem = context.ProductionSummaryRpt_function_GetDataProductionSummary(factoryID, season, clientUD, proformaInvoiceNo); data.ProductionSummaries = converter.DB2DTO_ProductionSummary(dbItem.ToList()); var dbItemDetail = context.ProductionSummaryRpt_function_GetDataProductionSummaryDetail(factoryID, season, clientUD, proformaInvoiceNo); data.ProductionSummaryDetails = converter.DB2DTO_ProductionSummaryDetail(dbItemDetail.ToList()); var dbWorkCenter = context.ProductionSummaryRpt_WorkCenter_View.Take(4); data.WorkCenters = converter.DB2DTO_WorkCenter(dbWorkCenter.ToList()); } } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = Library.Helper.GetInnerException(ex).Message; } return(data); }
public DTO.SearchFormDTO GetDataWithFilter(int userID, Hashtable filters, int pageSize, int pageIndex, string orderBy, string orderDirection, out int totalRows, out Notification notification) { notification = new Notification(); notification.Type = NotificationType.Success; totalRows = 0; DTO.SearchFormDTO data = new DTO.SearchFormDTO(); int? productionTeamID = null; string clientUD = null; string proformaInvoiceNo = null; string modelUD = null; string modelNM = null; string workOrderUD = null; int? workOrderStatusID = null; string productionItemTypeIDs = null; try { Framework.DAL.DataFactory fwFactory = new Framework.DAL.DataFactory(); int?companyID = fwFactory.GetCompanyID(userID); if (filters.ContainsKey("productionTeamID") && filters["productionTeamID"] != null) { productionTeamID = Convert.ToInt32(filters["productionTeamID"]); } if (filters.ContainsKey("clientUD") && filters["clientUD"] != null) { clientUD = filters["clientUD"].ToString(); } if (filters.ContainsKey("proformaInvoiceNo") && filters["proformaInvoiceNo"] != null) { proformaInvoiceNo = filters["proformaInvoiceNo"].ToString(); } if (filters.ContainsKey("modelUD") && filters["modelUD"] != null) { modelUD = filters["modelUD"].ToString(); } if (filters.ContainsKey("modelNM") && filters["modelNM"] != null) { modelNM = filters["modelNM"].ToString(); } if (filters.ContainsKey("workOrderUD") && filters["workOrderUD"] != null) { workOrderUD = filters["workOrderUD"].ToString(); } if (filters.ContainsKey("workOrderStatusID") && filters["workOrderStatusID"] != null) { workOrderStatusID = Convert.ToInt32(filters["workOrderStatusID"]); } if (filters.ContainsKey("productionItemTypeIDs") && filters["productionItemTypeIDs"] != null) { productionItemTypeIDs = filters["productionItemTypeIDs"].ToString(); } using (var context = CreateContext()) { totalRows = context.OutsourceRpt_function_GetWorkOrder(productionTeamID, clientUD, proformaInvoiceNo, modelUD, modelNM, workOrderUD, workOrderStatusID, productionItemTypeIDs, companyID).Count(); data.OutsourceWorkOrder = AutoMapper.Mapper.Map <List <OutsourceRpt_WorkOrder_View>, List <DTO.OutsourceWorkOrderDTO> >(context.OutsourceRpt_function_GetWorkOrder(productionTeamID, clientUD, proformaInvoiceNo, modelUD, modelNM, workOrderUD, workOrderStatusID, productionItemTypeIDs, companyID).ToList()); } } catch (Exception ex) { notification.Type = NotificationType.Error; notification.Message = Library.Helper.GetInnerException(ex).Message; } return(data); }