// // CUSTOM FUNCTION // public DTO.EditFormData GetData(int iRequesterID, int id, out Library.DTO.Notification notification) { using (var context = CreateContext()) { context.FactoryMng2_InsertDataForFactoryCaspacity_Function(); } notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; DTO.EditFormData data = new DTO.EditFormData(); data.Data = new DTO.Factory(); data.Data.FactoryImages = new List <DTO.FactoryImage>(); data.Data.FactoryBusinessCard = new List <DTO.FactoryBusinessCard>(); data.Data.FactoryCertificates = new List <DTO.FactoryCertificate>(); data.Data.FactoryTurnovers = new List <DTO.FactoryTurnover>(); data.Data.FactoryExpectedCapacities = new List <DTO.FactoryExpectedCapacity>(); data.Data.factoryCapacityByWeeks = new List <DTO.FactoryCapacityByWeek>(); data.Employees = new List <Support.DTO.Employee>(); data.EmployeeDepartmentDTOs = new List <DTO.EmployeeDepartmentDTO>(); data.FactoryRawMaterialSupplierList = new List <DTO.FactoryRawMaterialSupplier>(); data.SupplierList = new List <DTO.Supplier>(); data.Locations = new List <Support.DTO.FactoryLocation>(); data.Data.AppointmentDTOs = new List <DTO.AppointmentDTO>(); data.Data.weekInforRangeDTOs = new List <DTO.WeekInforRangeDTO>(); data.Data.factoryDocuments = new List <DTO.FactoryDocumentDTO>(); data.ProductGroupDTOs = new List <DTO.ProductGroupDTO>(); data.Data.FactoryProductGroupDTOs = new List <DTO.FactoryProductGroupDTO>(); data.UsersDTO = new List <DTO.UsersDTO>(); //try to get data try { if (id > 0) { //check permission on factory if (!fwFactory.CanPerformAction(iRequesterID, "FactoryMng2", Library.DTO.ModuleAction.CanCreate)) { if (fwFactory.CheckFactoryPermission(iRequesterID, id) == 0) { throw new Exception("You do not have access permission on this factory"); } } using (FactoryMng2Entities context = CreateContext()) { var factory = context.FactoryMng2_Factory_View.FirstOrDefault(o => o.FactoryID == id); if (factory == null) { throw new Exception("Can not found the factory to edit"); } data.Data = converter.DB2DTO_Factory(factory); data.Data.factoryCapacityByWeeks = converter.DB2DTO_GetSeasonByWeeks(context.FactoryMng2_function_FactoryCapacityByWeek(id).ToList()); } } else { // Set default status option = yes. data.Data.IsActive = true; } data.Employees = supportFactory.GetEmployee().ToList(); data.FactoryRawMaterialSupplierList = GetFactoryRawMaterialSupplierList(); data.SupplierList = GetSupplierList(); data.EmployeeDepartmentDTOs = GetEmployeeDepartmentDTOs(); data.Locations = supportFactory.GetFactoryLocation(); data.ProductGroupDTOs = GetProductGroupList(); using (var context = CreateContext()) { data.Data.weekInforRangeDTOs = converter.DB2DTO_WeeKInforRange(context.FactoryMng2_WeekInforRange_View.ToList()); data.UsersDTO = converter.DB2DTO_User2(context.SupportMng_User2_View.ToList()); } } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; } return(data); }
// // CUSTOM FUNCTION // public DTO.EditFormData GetData(int userId, 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.FactoryRawMaterial(); data.Data.FactoryRawMaterialCertificates = new List <DTO.FactoryRawMaterialCertificate>(); data.Data.FactoryRawMaterialTests = new List <DTO.FactoryRawMaterialTest>(); data.Data.FactoryRawMaterialTurnovers = new List <DTO.FactoryRawMaterialTurnover>(); data.Data.FactoryRawMaterialPricingPersons = new List <DTO.FactoryRawMaterialPricingPerson>(); data.Data.FactoryRawMaterialQualityPersons = new List <DTO.FactoryRawMaterialQualityPerson>(); data.Data.FactoryRawMaterialImages = new List <DTO.FactoryRawMaterialImage>(); data.Data.FactoryRawPaymentTerms = new List <DTO.FactoryRawPaymentTerm>(); data.Data.SubSupplierContracts = new List <DTO.SubSupplierContract>(); data.Data.SupplierContactQuickInfos = new List <DTO.SupplierContactQuickInfo>(); data.Data.supplierDirectors = new List <DTO.SupplierDirector>(); data.Data.supplierManagers = new List <DTO.SupplierManager>(); data.Data.supplierSampleTechnicals = new List <DTO.SupplierSampleTechnical>(); data.ProductGroupDTOs = new List <DTO.ProductGroupDTO>(); data.Data.FactoryRawMaterialProductGroupDTOs = new List <DTO.FactoryRawMaterialProductGroupDTO>(); data.materialsPrices = new List <DTO.MaterialsPrice>(); data.Data.materialsPrices = new List <DTO.MaterialsPrice>(); data.statusMaterialPrices = new List <DTO.StatusMaterialPrice>(); data.Data.statusMaterials = new List <DTO.StatusMaterialPrice>(); data.KeyRawMaterials = new List <DTO.KeyRawMaterial>(); data.Locations = new List <Support.DTO.FactoryLocation>(); data.Employees = new List <Support.DTO.Employee>(); data.SupplierPaymentTerms = new List <DTO.SupplierPaymentTerm>(); data.SubSupplierDocumentTypeDTOs = new List <DTO.SubSupplierDocumentTypeDTO>(); data.AppointmentDTO = new List <DTO.AppointmentDTO>(); data.Data.FactoryRawMaterialBusinessCardDTO = new List <DTO.FactoryRawMaterialBusinessCardDTO>(); data.UsersDTO = new List <DTO.UsersDTO>(); data.Data.FactoryRawMaterialGalleryDTO = new List <DTO.FactoryRawMaterialGalleryDTO>(); //try to get data try { using (FactoryRawMaterialMngEntities context = CreateContext()) { if (id > 0) { int? companyID = fwFactory.GetCompanyID(userId); List <int> internalCompanyIDs = new List <int> { 1, 2, 3, 4, 11, 13, 75 }; var factoryRaw = context.FactoryRawMaterialMng_FactoryRawMaterial_View.FirstOrDefault(o => o.FactoryRawMaterialID == id); if (internalCompanyIDs.Contains(companyID.Value)) { if (!internalCompanyIDs.Contains(factoryRaw.CompanyID.Value)) { factoryRaw = null; } } else { if (factoryRaw.CompanyID.Value != companyID.Value) { factoryRaw = null; } } if (factoryRaw == null) { throw new Exception("Can not found the data to edit"); } data.Data = converter.DB2DTO_FactoryRawMaterial(factoryRaw); } data.SupplierPaymentTerms = converter.DB2DTO_SupplierPaymentTermList(context.FactoryRawMaterialMng_SupportSupplierPaymentTerm_View.ToList()); data.SubSupplierDocumentTypeDTOs = converter.DB2DTO_SubSupplierDocumentTypeDTO(context.SupportMng_SubSupplierDocumentType_View.ToList()); data.AppointmentDTO = converter.DB2DTO_SubSupplierAppointmentDTO(context.PurchasingCalendarMng_PurchasingCalendarAppointment_View.ToList()); data.UsersDTO = converter.DB2DTO_UsersDTO(context.SupportMng_User2_View.ToList()); } data.Locations = supportFactory.GetFactoryLocation(); data.KeyRawMaterials = GetKeyMaterialList(); data.Employees = supportFactory.GetEmployee(); data.ProductGroupDTOs = GetProductGroupList(); data.statusMaterialPrices = GetStatusMaterialPrices(); } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; } return(data); }