// // CUSTOM FUNCTIONS // public DTO.SearchFilterData GetSearchFilter(int userId, out Library.DTO.Notification notification) { notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; DTO.SearchFilterData data = new DTO.SearchFilterData(); data.QuotationStatuses = new List <Support.DTO.QuotationStatus>(); data.Seasons = new List <Support.DTO.Season>(); data.Factories = new List <Support.DTO.Factory>(); try { data.QuotationStatuses = supportFactory.GetQuotationStatus(); data.Seasons = supportFactory.GetSeason(); data.Factories = supportFactory.GetFactory(userId); } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; } return(data); }
public override DTO.SearchFormData GetDataWithFilter(Hashtable filters, int pageSize, int pageIndex, string orderBy, string orderDirection, out int totalRows, out Library.DTO.Notification notification) { DTO.SearchFormData searchFormData = new DTO.SearchFormData(); notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; totalRows = 0; try { int? factoryID = null; string season = null; int? weekNo = null; string updatedDate = null; string updatorName = null; int userId = Convert.ToInt32(filters["userId"]); if (filters.ContainsKey("factoryID") && filters["factoryID"] != null) { factoryID = Convert.ToInt32(filters["factoryID"]); } if (filters.ContainsKey("season") && !string.IsNullOrEmpty(filters["season"].ToString())) { season = filters["season"].ToString().Replace("'", "''"); } if (filters.ContainsKey("weekNo") && filters["weekNo"] != null) { weekNo = Convert.ToInt32(filters["weekNo"]); } if (filters.ContainsKey("updatedDate") && !string.IsNullOrEmpty(filters["updatedDate"].ToString())) { updatedDate = filters["updatedDate"].ToString().Replace("'", "''"); } if (filters.ContainsKey("updatorName") && !string.IsNullOrEmpty(filters["updatorName"].ToString())) { updatorName = filters["updatorName"].ToString().Replace("'", "''"); } using (FactoryProductionStatusEntities context = CreateContext()) { totalRows = context.FactoryProductionStatusMng_function_SearchFactoryProductionStatus(orderBy, orderDirection, userId, factoryID, season, weekNo, updatedDate, updatorName).Count(); var result = context.FactoryProductionStatusMng_function_SearchFactoryProductionStatus(orderBy, orderDirection, userId, factoryID, season, weekNo, updatedDate, updatorName); searchFormData.Data = converter.DB2DTO_FactoryProductionStatusSearch(result.Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList()); } searchFormData.Factories = supportFactory.GetFactory(userId); searchFormData.Seasons = supportFactory.GetSeason(); searchFormData.WeekSeasons = supportFactory.GetWeekInSeason(Library.Helper.GetCurrentSeason()); return(searchFormData); } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; notification.DetailMessage.Add(ex.Message); if (ex.GetBaseException() != null) { notification.DetailMessage.Add(ex.GetBaseException().Message); } return(searchFormData); } }
public DTO.SupportData GetSupportData(string formName, out Library.DTO.Notification notification) { DTO.SupportData data = new DTO.SupportData(); notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; data.Factories = new List <Support.DTO.Factory>(); data.MeetingLocations = new List <DTO.MeetingLocation>(); data.Users = new List <Support.DTO.User2>(); data.Sales = new List <DTO.Sale>(); data.employeeDepartmentDTOs = new List <Support.DTO.EmployeeDepartmentDTO>(); data.TimeRange = new List <string>(); data.SCMAppointmentAttachedFileTypes = new List <Support.DTO.AppointmentAttachedFileType>(); try { switch (formName) { case "calendar": foreach (Support.DTO.MeetingLocation location in supportFactory.GetMeetingLocation()) { if (location.MeetingLocationID == 1 || location.MeetingLocationID == 4) //request Mr Luc AVT VIETNAM SHOWROOM AND AT FACTORY { data.MeetingLocations.Add(new DTO.MeetingLocation() { MeetingLocationID = location.MeetingLocationID, MeetingLocationNM = location.MeetingLocationNM, IsSelected = false }); } } data.Factories = supportFactory.GetFactory(); break; case "editEvent": data.Users = supportFactory.GetUsers2(); data.employeeDepartmentDTOs = supportFactory.GetDepartmentDTOs(); data.TimeRange = supportFactory.GetTimeRange(); data.SCMAppointmentAttachedFileTypes = supportFactory.GetAppointmentAttachedFileType(); using (SCMAgendaMngEntities context = CreateContext()) { data.Sales = converter.DB2DTO_SaleList(context.SupportMng_Sale_View.Where(o => o.CompanyID.Value != 3).ToList()); // company different than AVT } break; default: break; } } catch (Exception ex) { notification = new Library.DTO.Notification() { Message = ex.Message, Type = Library.DTO.NotificationType.Error }; } return(data); }
public DTO.FactoryAssignment.FormData GetFactoryAssignmentData(int id, out Library.DTO.Notification notification) { notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; DTO.FactoryAssignment.FormData data = new DTO.FactoryAssignment.FormData(); data.SupportList = new DTO.SupportData(); data.SupportList.Factories = new List <Support.DTO.Factory>(); data.Data = new DTO.FactoryAssignment.ProductDTO(); data.Data.SubFactoryDTOs = new List <DTO.FactoryAssignment.SubFactoryDTO>(); try { if (id > 0) { using (Sample3MngEntities context = CreateContext()) { data.Data = converter.DB2DTO_FactoryAssignment_Product(context.Sample3Mng_FactoryAssignment_Product_View.Include("Sample3Mng_FactoryAssignment_SubFactory_View").FirstOrDefault(o => o.SampleProductID == id)); } } data.SupportList.Factories = supportFactory.GetFactory(); } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; } return(data); }
public DTO.SearchFilterData GetSearchFilter(int userId, out Library.DTO.Notification notification) { notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; DTO.SearchFilterData data = new DTO.SearchFilterData(); data.Employees = new List <Support.DTO.Employee>(); data.FactoryRawMaterialSupplierList = new List <DTO.FactoryRawMaterialSupplier>(); //data.SupplierList = new List<DTO.Supplier>(); data.Locations = new List <Support.DTO.FactoryLocation>(); data.Factories = new List <Support.DTO.Factory>(); try { data.Employees = supportFactory.GetEmployee().ToList(); data.Locations = supportFactory.GetFactoryLocation(); data.Factories = supportFactory.GetFactory(userId); data.FactoryRawMaterialSupplierList = GetFactoryRawMaterialSupplierList(); //data.SupplierList = GetSupplierList(); } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; } return(data); }
public object GetInitData(int userID, out Library.DTO.Notification notification) { notification = new Library.DTO.Notification(); notification.Type = Library.DTO.NotificationType.Success; DTO.InitFormData data = new DTO.InitFormData(); try { Support.DAL.DataFactory supportFactory = new Support.DAL.DataFactory(); data.SupportSeason = supportFactory.GetSeason(); data.SupportFactory = supportFactory.GetFactory(userID); using (var context = CreateContext()) { context.FactoryPlanningMng_function_AddFactoryPlanningData(); } } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = Library.Helper.GetInnerException(ex).Message; } return(data); }
public override object GetInitData(int userId, out Notification notification) { notification = new Notification(); notification.Type = NotificationType.Success; InitFormDTO data = new InitFormDTO(); try { Support.DAL.DataFactory supportFactory = new Support.DAL.DataFactory(); data.Factories = supportFactory.GetFactory().ToList(); using (CompanyBranchMngEntities context = CreateContext()) { data.Locations = dataConverter.DB2DTO_Location(context.CompanyBranchMng_Location_View.ToList()); } } catch (Exception ex) { notification.Type = NotificationType.Error; notification.Message = Library.Helper.GetInnerException(ex).Message; } return(data); }
public object GetInitData(int userID, out Notification notification) { DTO.EditForm data = new EditForm() { Season = new List <Support.DTO.Season>(), Factory = new List <Support.DTO.Factory>() }; notification = new Notification() { Type = NotificationType.Success }; try { Support.DAL.DataFactory supportFactory = new Support.DAL.DataFactory(); data.Season = supportFactory.GetSeason().ToList(); data.Factory = supportFactory.GetFactory(userID).ToList(); } catch (Exception ex) { notification.Type = NotificationType.Error; notification.Message = Library.Helper.GetInnerException(ex).Message; } return(data); }
public override DTO.EditFormData GetData(int id, out Library.DTO.Notification notification) { notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; DTO.EditFormData data = new DTO.EditFormData(); data.Data = new DTO.FrameMaterialProfile(); data.Data.FrameMaterialProfileFactories = new List <DTO.FrameMaterialProfileFactory>(); data.Factories = new List <Module.Support.DTO.Factory>(); data.FrameMaterials = new List <Module.Support.DTO.FrameMaterial>(); //try to get data try { if (id > 0) { using (FrameMaterialProfileMngEntities context = CreateContext()) { var profile = context.FrameMaterialProfileMng_FrameMaterialProfile_View.FirstOrDefault(o => o.FrameMaterialProfileID == id); if (profile == null) { throw new Exception("Can not found the profile to edit"); } data.Data = converter.DB2DTO_FrameMaterialProfile(profile); } } data.Factories = supportFactory.GetFactory().ToList(); data.FrameMaterials = supportFactory.GetFrameMaterial().ToList(); } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; } return(data); }
public DTO.EditFormData GetData(int userId, int id, out Library.DTO.Notification notification) { DTO.EditFormData editFormData = new DTO.EditFormData(); notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; Module.Support.DAL.DataFactory support_factory = new Support.DAL.DataFactory(); Module.Framework.DAL.DataFactory fwFactory = new Module.Framework.DAL.DataFactory(); try { using (FactoryStockReceiptEntities context = CreateContext()) { //auto create production item context.FactoryStockReceiptMng_function_CreateProductionItem(); if (id > 0) { FactoryStockReceiptMng_FactoryStockReceipt_View dbItem; dbItem = context.FactoryStockReceiptMng_FactoryStockReceipt_View.FirstOrDefault(o => o.FactoryStockReceiptID == id); //check permission on factory if (fwFactory.CheckFactoryPermission(userId, dbItem.FactoryID.Value) == 0) { throw new Exception("You do not have access permission on this factory"); } editFormData.Data = converter.DB2DTO_FactoryStockReceipt(dbItem); } else { editFormData.Data = new DTO.FactoryStockReceipt(); editFormData.Data.FactoryStockReceiptDetails = new List <DTO.FactoryStockReceiptDetail>(); } editFormData.Factories = support_factory.GetFactory(userId); return(editFormData); } } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; notification.DetailMessage.Add(ex.Message); if (ex.GetBaseException() != null) { notification.DetailMessage.Add(ex.GetBaseException().Message); } return(editFormData); } }
public DTO.PriceComparison.FormData GetItemToCompareData(int id, int?offerSeasonDetailID, out Library.DTO.Notification notification) { notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; DTO.PriceComparison.FormData data = new DTO.PriceComparison.FormData(); data.Data = new DTO.PriceComparison.ProductOptionDetailDTO(); data.Factories = new List <Support.DTO.Factory>(); data.QuotationStatuses = new List <Support.DTO.QuotationStatus>(); try { using (ProductOverviewRptEntities context = CreateContext()) { if (offerSeasonDetailID.HasValue && offerSeasonDetailID.Value != 0) { ProductOverviewRpt_OfferSeasonDetail_View dbItem = context.ProductOverviewRpt_OfferSeasonDetail_View.FirstOrDefault(o => o.OfferSeasonDetailID == offerSeasonDetailID); if (dbItem == null) { throw new Exception("Item not found!"); } data.Data = AutoMapper.Mapper.Map <ProductOverviewRpt_OfferSeasonDetail_View, DTO.PriceComparison.ProductOptionDetailDTO>(dbItem); } else { ProductOverviewRpt_PriceComparison_ProductOptionDetail_View dbItem = context.ProductOverviewRpt_PriceComparison_ProductOptionDetail_View.FirstOrDefault(o => o.FactoryOrderDetailID == id); if (dbItem == null) { throw new Exception("Item not found!"); } data.Data = converter.DB2DTO_PriceComparison_ProductOptionDetail(dbItem); } } data.Factories = supportFactory.GetFactory().ToList(); data.QuotationStatuses = supportFactory.GetQuotationStatus().ToList(); return(data); } catch (Exception ex) { ex = Library.Helper.GetInnerException(ex); notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; } return(null); }
public DTO.InitDataDTO GetInitData(int userId, out Notification notification) { notification = new Notification() { Type = NotificationType.Success }; var data = new DTO.InitDataDTO(); data.Factories = new List <Support.DTO.Factory>(); try { data.Factories = supportFactory.GetFactory().ToList(); } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; } return(data); }
public object GetInitForm(int userID, out Library.DTO.Notification notification) { notification = new Library.DTO.Notification(); notification.Type = Library.DTO.NotificationType.Success; DTO.InitFormDTO data = new DTO.InitFormDTO(); try { Support.DAL.DataFactory supportFactory = new Support.DAL.DataFactory(); data.Seasons = supportFactory.GetSeason().ToList(); data.Factories = supportFactory.GetFactory().Where(s => s.FactoryID == 374043 || s.FactoryID == 374072).ToList(); } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = Library.Helper.GetInnerException(ex).Message; } return(data); }
// // CUSTOM FUNCTION // public DTO.SearchFilterData GetInitData(out Library.DTO.Notification notification) { notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; DTO.SearchFilterData data = new DTO.SearchFilterData(); data.Seasons = new List <Support.DTO.Season>(); data.Factories = new List <Support.DTO.Factory>(); //try to get data try { data.Seasons = supportFactory.GetSeason().ToList(); data.Factories = supportFactory.GetFactory().ToList(); } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; } return(data); }
public override DTO.EditFormData GetData(int id, out Library.DTO.Notification notification) { notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; DTO.EditFormData data = new DTO.EditFormData(); data.Data = new DTO.UserProfile(); data.Data.Permissions = new List <DTO.Permission>(); data.Data.FactoryAccesses = new List <DTO.FactoryAccess>(); data.Data.EmployeeFactories = new List <DTO.EmployeeFactory>(); data.InternalCompanies = new List <Support.DTO.InternalCompany>(); data.InternalDepartments = new List <Support.DTO.InternalDepartment>(); data.Locations = new List <Support.DTO.Location>(); data.UserGroups = new List <Support.DTO.UserGroup>(); data.Managers = new List <Support.DTO.Employee>(); data.JobLevels = new List <Support.DTO.JobLevel>(); data.Factories = new List <Support.DTO.Factory>(); //try to get data try { using (User2MngEntities context = CreateContext()) { data.Data = converter.DB2DTO_UserProfile(context.User2Mng_UserProfile_View.FirstOrDefault(o => o.UserId == id)); data.Data.Permissions = converter.DB2DTO_UserGroupPermissionList(context.User2Mng_UserGroupPermission_View.Where(o => o.UserGroupID == data.Data.UserGroupID).ToList()); List <DTO.Permission> permissions = converter.DB2DTO_UserPermissionList(context.User2Mng_UserPermission_View.Where(o => o.UserID == id).ToList()); DTO.Permission dtoTmpPermission; foreach (DTO.Permission dtoPermission in permissions) { dtoTmpPermission = data.Data.Permissions.FirstOrDefault(o => o.ModuleID == dtoPermission.ModuleID); if (dtoTmpPermission != null) { dtoTmpPermission.UserPermissionID = dtoPermission.UserPermissionID; if (!dtoTmpPermission.CanCreate) { dtoTmpPermission.CanCreateEditable = true; } if (dtoPermission.CanCreate) { dtoTmpPermission.CanCreate = true; } if (!dtoTmpPermission.CanRead) { dtoTmpPermission.CanReadEditable = true; } if (dtoPermission.CanRead) { dtoTmpPermission.CanRead = true; } if (!dtoTmpPermission.CanUpdate) { dtoTmpPermission.CanUpdateEditable = true; } if (dtoPermission.CanUpdate) { dtoTmpPermission.CanUpdate = true; } if (!dtoTmpPermission.CanDelete) { dtoTmpPermission.CanDeleteEditable = true; } if (dtoPermission.CanDelete) { dtoTmpPermission.CanDelete = true; } if (!dtoTmpPermission.CanPrint) { dtoTmpPermission.CanPrintEditable = true; } if (dtoPermission.CanPrint) { dtoTmpPermission.CanPrint = true; } if (!dtoTmpPermission.CanApprove) { dtoTmpPermission.CanApproveEditable = true; } if (dtoPermission.CanApprove) { dtoTmpPermission.CanApprove = true; } if (!dtoTmpPermission.CanReset) { dtoTmpPermission.CanResetEditable = true; } if (dtoPermission.CanReset) { dtoTmpPermission.CanReset = true; } } else { int moduleID = dtoPermission.ModuleID;//using to debug } } data.Data.FactoryAccesses = converter.DB2DTO_FactoryAccessList(context.User2Mng_FactoryAccess_View.Where(o => o.UserID == id).ToList()); data.Data.EmployeeFactories = converter.DB2DTO_EmployeeFactoryList(context.User2Mng_EmployeeFactory_View.Where(o => o.EmployeeID == data.Data.EmployeeID).ToList()); } // decorate int index = 0; foreach (DTO.Permission dtoPermission in data.Data.Permissions.Where(o => o.ParentID == 0).OrderBy(o => o.DisplayOrder)) { dtoPermission.DisplayOrder = index; index++; foreach (DTO.Permission dtoSubPermission in data.Data.Permissions.Where(o => o.ParentID == dtoPermission.ModuleID).OrderBy(o => o.DisplayOrder)) { dtoSubPermission.DisplayText = "-----" + dtoSubPermission.DisplayText; dtoSubPermission.DisplayOrder = index; index++; } } data.InternalCompanies = supportFactory.GetInternalCompany().ToList(); data.InternalDepartments = supportFactory.GetInternalDepartment().ToList(); data.Locations = supportFactory.GetLocation().ToList(); data.UserGroups = supportFactory.GetUserGroup().ToList(); data.Managers = supportFactory.GetEmployee().ToList(); data.JobLevels = supportFactory.GetJobLevel().ToList(); data.Factories = supportFactory.GetFactory().ToList(); } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; } return(data); }
public DTO.SearchFormData GetDataWithFilter(int userId, Hashtable filters, int pageSize, int pageIndex, string orderBy, string orderDirection, out int totalRows, out Library.DTO.Notification notification) { DTO.SearchFormData searchFormData = new DTO.SearchFormData(); notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; totalRows = 0; string factoryUD = string.Empty; string clientUD = string.Empty; string proformaInvoiceNo = string.Empty; string lds = string.Empty; string articleCode = string.Empty; string description = string.Empty; int? factoryID = null; if (filters.ContainsKey("factoryUD")) { factoryUD = filters["factoryUD"].ToString(); } if (filters.ContainsKey("clientUD")) { clientUD = filters["clientUD"].ToString(); } if (filters.ContainsKey("proformaInvoiceNo")) { proformaInvoiceNo = filters["proformaInvoiceNo"].ToString(); } if (filters.ContainsKey("lds")) { lds = filters["lds"].ToString(); } if (filters.ContainsKey("articleCode")) { articleCode = filters["articleCode"].ToString(); } if (filters.ContainsKey("description")) { description = filters["description"].ToString(); } if (filters.ContainsKey("factoryID") && filters["factoryID"] != null) { factoryID = Convert.ToInt32(filters["factoryID"]); } //if (filters.ContainsKey("factoryIDs") && filters["factoryIDs"] != null) //{ // //pare object to list string of factoryid // List<string> fID = ((Newtonsoft.Json.Linq.JArray)filters["factoryIDs"]).ToObject<List<string>>(); // foreach (var item in fID) // { // factoryIDs += item + ","; // } //} Module.Support.DAL.DataFactory sFactory = new Support.DAL.DataFactory(); searchFormData.Factories = sFactory.GetFactory(userId); try { using (FactoryStockListReportEntities context = CreateContext()) { List <int?> listFactoryID = context.UserFactoryAccess.Where(o => o.UserID == userId && o.CanAccess.HasValue && o.CanAccess.Value).Select(s => s.FactoryID).ToList(); //get total searchFormData.TotalStockQnt = context.FactoryStockListReportMng_FactoryStockList_View.Where(x => listFactoryID.Contains(x.FactoryID)).Sum(o => (o.TotalStockQnt.HasValue ? o.TotalStockQnt.Value : 0)); searchFormData.TotalStockQntIn40HC = context.FactoryStockListReportMng_FactoryStockList_View.Where(x => listFactoryID.Contains(x.FactoryID)).Sum(o => (o.TotalStockQntIn40HC.HasValue ? o.TotalStockQntIn40HC.Value : 0)); searchFormData.TotalProducedQnt = context.FactoryStockListReportMng_FactoryStockList_View.Where(x => listFactoryID.Contains(x.FactoryID)).Sum(o => (o.TotalProducedQnt.HasValue ? o.TotalProducedQnt.Value : 0)); searchFormData.TotalNotPackedQnt = context.FactoryStockListReportMng_FactoryStockList_View.Where(x => listFactoryID.Contains(x.FactoryID)).Sum(o => (o.TotalNotPackedQnt.HasValue ? o.TotalNotPackedQnt.Value : 0)); searchFormData.TotalPackedQnt = context.FactoryStockListReportMng_FactoryStockList_View.Where(x => listFactoryID.Contains(x.FactoryID)).Sum(o => (o.TotalPackedQnt.HasValue ? o.TotalPackedQnt.Value : 0)); //search var result = context.FactoryStockListReportMng_function_GetFactoryStockList(orderBy, orderDirection, factoryUD, clientUD, proformaInvoiceNo, lds, articleCode, description, factoryID, userId); searchFormData.Data = converter.DB2DTO_FactoryStockList(result.Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList()); //get sub total var sumData = context.FactoryStockListReportMng_function_GetFactoryStockList(orderBy, orderDirection, factoryUD, clientUD, proformaInvoiceNo, lds, articleCode, description, factoryID, userId).ToList(); totalRows = sumData.Count(); searchFormData.SubTotalStockQnt = sumData.Sum(o => (o.TotalStockQnt.HasValue ? o.TotalStockQnt.Value : 0)); searchFormData.SubTotalStockQntIn40HC = sumData.Sum(o => (o.TotalStockQntIn40HC.HasValue ? o.TotalStockQntIn40HC.Value : 0)); searchFormData.SubTotalProducedQnt = sumData.Sum(o => (o.TotalProducedQnt.HasValue ? o.TotalProducedQnt.Value : 0)); searchFormData.SubTotalNotPackedQnt = sumData.Sum(o => (o.TotalNotPackedQnt.HasValue ? o.TotalNotPackedQnt.Value : 0)); searchFormData.SubTotalPackedQnt = sumData.Sum(o => (o.TotalPackedQnt.HasValue ? o.TotalPackedQnt.Value : 0)); } return(searchFormData); } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; notification.DetailMessage.Add(ex.Message); if (ex.GetBaseException() != null) { notification.DetailMessage.Add(ex.GetBaseException().Message); } return(searchFormData); } }
public DTO.SearchForm GetDataWithFilter(int userId, Hashtable filters, int pageSize, int pageIndex, string orderBy, string orderDirection, out int totalRows, out Library.DTO.Notification notification) { DTO.SearchForm searchForm = new DTO.SearchForm(); searchForm.Factories = new List <Support.DTO.Factory>(); notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; totalRows = 0; try { string qcReportUD = null; int? factoryID = null; string clientUD = null; string articleCode = null; string proformaInvoiceNo = null; string updatedDate = null; if (filters.ContainsKey("QCReportUD") && !string.IsNullOrEmpty(filters["QCReportUD"].ToString())) { qcReportUD = filters["QCReportUD"].ToString().Replace("'", "''"); } if (filters.ContainsKey("FactoryID") && filters["FactoryID"] != null && !string.IsNullOrEmpty(filters["FactoryID"].ToString())) { factoryID = Convert.ToInt32(filters["FactoryID"]); } if (filters.ContainsKey("ArticleCode") && !string.IsNullOrEmpty(filters["ArticleCode"].ToString())) { articleCode = filters["ArticleCode"].ToString().Replace("'", "''"); } if (filters.ContainsKey("ProformaInvoiceNo") && !string.IsNullOrEmpty(filters["ProformaInvoiceNo"].ToString())) { proformaInvoiceNo = filters["ProformaInvoiceNo"].ToString().Replace("'", "''"); } if (filters.ContainsKey("UpdatedDate") && !string.IsNullOrEmpty(filters["UpdatedDate"].ToString())) { updatedDate = filters["UpdatedDate"].ToString().Replace("'", "''"); } if (filters.ContainsKey("ClientUD") && !string.IsNullOrEmpty(filters["ClientUD"].ToString())) { clientUD = filters["ClientUD"].ToString().Replace("'", "''"); } //if (filters.ContainsKey("TestDate") && !string.IsNullOrEmpty(filters["TestDate"].ToString())) //{ // testDate = filters["TestDate"].ToString().Replace("'", "''"); //} DateTime?valTestDate = updatedDate.ConvertStringToDateTime(); using (QCReportEntities context = CreateContext()) { totalRows = context.QCReportMng_function_SearchQCReportMng(qcReportUD, factoryID, clientUD, articleCode, proformaInvoiceNo, valTestDate, orderBy, orderDirection).Count(); var result = context.QCReportMng_function_SearchQCReportMng(qcReportUD, factoryID, clientUD, articleCode, proformaInvoiceNo, valTestDate, orderBy, orderDirection); searchForm.Data = converter.DB2DTO_SearchQCReport(result.Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList()); } searchForm.Factories = supportFactory.GetFactory().ToList(); return(searchForm); } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; notification.DetailMessage.Add(ex.Message); if (ex.GetBaseException() != null) { notification.DetailMessage.Add(ex.GetBaseException().Message); } return(searchForm); } }
public SearchFormData GetDataWithFilter(int userID, Hashtable filters, int pageSize, int pageIndex, string orderBy, string orderDirection, out int totalRows, out Notification notification) { // Define. SearchFormData searchFormData = new SearchFormData { SearchData = new List <SampleProductLocationSearchResultData>(), Seasons = new List <Support.DTO.Season>(), Locations = new List <SupportFactoryLocationData>(), Factories = new List <Support.DTO.Factory>(), Clients = new List <Support.DTO.Client>(), Statuses = new List <Support.DTO.SampleProductStatus>() }; notification = new Notification { Type = NotificationType.Success }; totalRows = 0; // Main. try { string season = null; string sampleProductItemUD = null; string articleDescription = null; string factoryUD = null; string locationUD = null; string clientUD = null; int? quantity = null; int? statusID = null; if (filters.ContainsKey("Season") && filters["Season"] != null && !string.IsNullOrEmpty(filters["Season"].ToString().Replace("'", "''"))) { season = filters["Season"].ToString().Trim(); } if (filters.ContainsKey("Code") && filters["Code"] != null && !string.IsNullOrEmpty(filters["Code"].ToString().Replace("'", "''"))) { sampleProductItemUD = filters["Code"].ToString().Trim(); } if (filters.ContainsKey("ArticleDescription") && filters["ArticleDescription"] != null && !string.IsNullOrEmpty(filters["ArticleDescription"].ToString().Replace("'", "''"))) { articleDescription = filters["ArticleDescription"].ToString().Trim(); } if (filters.ContainsKey("Factory") && filters["Factory"] != null && !string.IsNullOrEmpty(filters["Factory"].ToString().Replace("'", "''"))) { factoryUD = filters["Factory"].ToString().Trim(); } if (filters.ContainsKey("Location") && filters["Location"] != null && !string.IsNullOrEmpty(filters["Location"].ToString().Replace("'", "''"))) { locationUD = filters["Location"].ToString().Trim(); } if (filters.ContainsKey("Client") && filters["Client"] != null && !string.IsNullOrEmpty(filters["Client"].ToString().Replace("'", "''"))) { clientUD = filters["Client"].ToString().Trim(); } if (filters.ContainsKey("Quantity") && filters["Quantity"] != null && !string.IsNullOrEmpty(filters["Quantity"].ToString().Replace("'", "''"))) { quantity = Convert.ToInt32(filters["Quantity"].ToString().Trim()); } if (filters.ContainsKey("Status") && filters["Status"] != null && !string.IsNullOrEmpty(filters["Status"].ToString().Replace("'", "''"))) { statusID = Convert.ToInt32(filters["Status"].ToString().Trim()); } using (var context = CreateContext()) { totalRows = context.SampleProductLocationMng_function_SampleProductLocationSearchResult(season, sampleProductItemUD, articleDescription, factoryUD, locationUD, clientUD, quantity, statusID, userID, orderBy, orderDirection).Count(); var results = context.SampleProductLocationMng_function_SampleProductLocationSearchResult(season, sampleProductItemUD, articleDescription, factoryUD, locationUD, clientUD, quantity, statusID, userID, orderBy, orderDirection); searchFormData.SearchData = converter.DB2DTO_SampleLocationSearch(results.Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList()); var factoryResult = context.SampleProductLocationMng_function_SupportFactoryLocation(userID.ToString()); searchFormData.Locations = converter.DB2DTO_SampleFactory(factoryResult.ToList()); } searchFormData.Seasons = supportFactory.GetSeason().ToList(); searchFormData.Clients = supportFactory.GetClient().ToList(); searchFormData.Factories = supportFactory.GetFactory(userID).ToList(); searchFormData.Statuses = supportFactory.GetSampleProductStatus().ToList(); } catch (Exception ex) { notification.Type = NotificationType.Error; notification.Message = ex.Message; searchFormData = null; } // Result. return(searchFormData); }
public DTO.PurchasingCreditNoteSearchData GetPurchasingCreditNoteSearchResult2(int userId, Hashtable filters, int pageSize, int pageIndex, string orderBy, string orderDirection, out int totalRows, out Library.DTO.Notification notification) { notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; totalRows = 0; DTO.PurchasingCreditNoteSearchData data = new DTO.PurchasingCreditNoteSearchData(); data.Data = new List <DTO.PurchasingCreditNote>(); data.DataFactory = new List <Support.DTO.Factory>(); Module.Support.DAL.DataFactory support_factory = new Support.DAL.DataFactory(); string invoiceNo = string.Empty; string blNo = string.Empty; string supplierNM = string.Empty; string creditNoteNo = string.Empty; int? factoryID = null; if (filters.ContainsKey("invoiceNo")) { invoiceNo = filters["invoiceNo"].ToString(); } if (filters.ContainsKey("blNo")) { blNo = filters["blNo"].ToString(); } if (filters.ContainsKey("supplierNM")) { supplierNM = filters["supplierNM"].ToString(); } if (filters.ContainsKey("creditNoteNo")) { creditNoteNo = filters["creditNoteNo"].ToString(); } if (filters.ContainsKey("factoryID") && filters["factoryID"] != null) { factoryID = Convert.ToInt32(filters["factoryID"].ToString()); } try { using (PurchasingCreditNoteEntities context = CreateContext()) { totalRows = context.PurchasingCreditNoteMng_function_SearchPurchasingCreditNote(userId, orderBy, orderDirection, invoiceNo, blNo, supplierNM, creditNoteNo, factoryID).Count(); var result = context.PurchasingCreditNoteMng_function_SearchPurchasingCreditNote(userId, orderBy, orderDirection, invoiceNo, blNo, supplierNM, creditNoteNo, factoryID); data.Data = converter.DB2DTO_PurchasingCreditNoteSearch(result.Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList()); data.DataFactory = support_factory.GetFactory(userId); } } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; notification.DetailMessage.Add(ex.Message); if (ex.GetBaseException() != null) { notification.DetailMessage.Add(ex.GetBaseException().Message); } } return(data); }