public void Save(int RequestId, ObservableCollection <User> MaintUsersAssigned) { //Remove the existing entries _dbContext.MaintReqUsersAssigned .RemoveRange(_dbContext.MaintReqUsersAssigned.Where(i => i.MaintRequestInitiationId == RequestId)); _dbContext.SaveChanges(); List <MaintRequestUsersAssigned> NewUsersAssigned = new(); if (MaintUsersAssigned.Count > 0) { foreach (var item in MaintUsersAssigned) { NewUsersAssigned.Add(new MaintRequestUsersAssigned { MaintRequestInitiationId = RequestId, UserId = item.Id }); } _dbContext.MaintReqUsersAssigned .AddRange(NewUsersAssigned); _dbContext.SaveChanges(); } }
public void SaveAddPPE(PPE ppe) { _ppeDBContext.PPE.Add ( new PPE { PPEName = ppe.PPEName, Description = ppe.Description, MaintRequestType = ppe.MaintRequestType, IconFileLocation = ppe.IconFileLocation } ); _ppeDBContext.SaveChanges(); }
public void AddEditArea(AreaModel area) { _areaDBContext.Areas.Add ( new AreaModel { AreaName = area.AreaName, CommentsNotes = area.CommentsNotes, FactoryId = area.FactoryId } ); _areaDBContext.SaveChanges(); }
public void AddNewAuthorization(AuthorizationRequest auth) { _sacoContext.AuthorizationRequests.Add ( new AuthorizationRequest { UserId = auth.UserId, MaintRequestInitiationId = auth.MaintRequestInitiationId, AuthorizationType = auth.AuthorizationType, Satus = auth.Satus } ); _sacoContext.SaveChanges(); }
public void AddEditGeneralRequestInfo(int maintReqId, GeneralRequest generalRequest, string newEdit) { if (newEdit == "New") { _sacoMaintenanceContext.GeneralRequests.Add ( new GeneralRequest { MaintRequestId = maintReqId, AuthorityToWorkUserId = generalRequest.AuthorityToWorkUserId, AuthorityToWorkDateTime = generalRequest.AuthorityToWorkDateTime, DetailOfWorkCompleted = generalRequest.DetailOfWorkCompleted, DetailOfWorkCompeltedUserId = generalRequest.DetailOfWorkCompeltedUserId, DetailOfWorkCompeltedDateTime = generalRequest.DetailOfWorkCompeltedDateTime, WorkCompletedYesNo = generalRequest.WorkCompletedYesNo, WorkCompletedDetails = generalRequest.WorkCompletedDetails, SignOffDetails = generalRequest.SignOffDetails, WorkCompletedSignOffYesNo = generalRequest.WorkCompletedSignOffYesNo, WorkCompletedSignOffUserId = generalRequest.WorkCompletedSignOffUserId, WorkCompletedSignOffDateTime = generalRequest.WorkCompletedSignOffDateTime } ); } else if (newEdit == "Edit") { _sacoMaintenanceContext.Update(generalRequest); } _sacoMaintenanceContext.SaveChanges(); }
//public SACOMaintenanceContext SacoMaintenanceContext { get; } public void AddEditPlantRequestInfo(int maintReqId, PlantRequest plantRequest) { _areaDBContext.PlantRequests.Add ( new PlantRequest { IsolationNitricAcid = plantRequest.IsolationNitricAcid, IsolatedPhosphoricAcid = plantRequest.IsolatedPhosphoricAcid, IsolatedSodiumHydroxide = plantRequest.IsolatedSodiumHydroxide, IsolatedSulphuricAcid = plantRequest.IsolatedSulphuricAcid, IsolatedOther = plantRequest.IsolatedOther, DrainingLinesNitricAcid = plantRequest.DrainingLinesNitricAcid, DrainingLinesSodiumHydroxide = plantRequest.DrainingLinesSodiumHydroxide, DrainingLinesSulphuricAcid = plantRequest.DrainingLinesSulphuricAcid, DrainingLinesOther = plantRequest.DrainingLinesOther, IsolationsCompressedAir = plantRequest.IsolationsCompressedAir, IsolationsElectrical = plantRequest.IsolationsElectrical, IsolationsGas = plantRequest.IsolationsGas, IsolationsMechanical = plantRequest.IsolationsMechanical, IsolationsSteam = plantRequest.IsolationsSteam, IsolationsWater = plantRequest.IsolationsWater, IsolationsOther = plantRequest.IsolationsOther, OtherPrecautions = plantRequest.OtherPrecautions, AuthorisationToWorkUserId = plantRequest.AuthorisationToWorkUserId, AuthorisationDatTime = plantRequest.AuthorisationDatTime, ReceiptPersonDoingWorkUserId = plantRequest.ReceiptPersonDoingWorkUserId, ReceiptCompanyId = plantRequest.ReceiptCompanyId, ClearancePosition = plantRequest.ClearancePosition, ClearanceDateTime = plantRequest.ClearanceDateTime, MaintRequestId = plantRequest.MaintRequestId } ); _areaDBContext.SaveChanges(); }
//public SACOMaintenanceContext SacoMaintenanceContext { get; } public void AddEditRisk(Risk risk) { _sacoMaintenanceContext.Risks.Add ( new Risk { RiskName = risk.RiskName, Description = risk.Description } ); _sacoMaintenanceContext.SaveChanges(); }
public void SaveEditArea(Company company) { _companyDBContext.Companies.Add ( new Company { CompanyName = company.CompanyName } ); _companyDBContext.SaveChanges(); }
//public SACOMaintenanceContext _sacoMaintenanceContext { get; } public void AddEditMachineType(MachineType machineType) { _machineTypeDBContext.Add ( new MachineType { TypeName = machineType.TypeName, Description = machineType.Description } ); _machineTypeDBContext.SaveChanges(); }
//public SACOMaintenanceContext SacoMaintenanceContext { get; } public void AddEditFactory(Factory factory) { _factoryDBContext.Factories.Add ( new Factory { FactoryName = factory.FactoryName } ); _factoryDBContext.SaveChanges(); }
//public SACOMaintenanceContext SacoMaintenanceContext { get; } public void AddEditEquipment(Equipment equipment) { _equipmentDBContext.Equipment.Add ( new Equipment { Name = equipment.Name, Description = equipment.Description, Comments = equipment.Comments, MachineTypeId = equipment.MachineTypeId, SerialIdentifierNumber = equipment.SerialIdentifierNumber } ); _equipmentDBContext.SaveChanges(); }
public void CanInsertFactoryIntoDatabase() { using (var context = new SACOMaintenanceContext()) { context.Database.EnsureDeleted(); context.Database.EnsureCreated(); var factory = new Factory(); factory.FactoryName = "Factory testing"; var factory1 = new Factory(); factory1.FactoryName = "This is another factory"; context.Factories.Add(factory); context.Factories.Add(factory1); context.SaveChanges(); Assert.AreNotEqual(0, factory.Id); } }
public void UpdateSupplier(Supplier supplier) { _sacoMaintenanceContext.Update <Supplier>(supplier); _sacoMaintenanceContext.SaveChanges(); }