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();
}
