public static async Task updateEMData(ManageRequestInfo info)
{
using (var db = new Session2Entities())
{
var query = (from em in db.EmergencyMaintenances
where em.ID == info.EMID
select em).First();
query.EMStartDate = info.StartDate;
query.EMEndDate = info.EndDate;
query.EMTechnicianNote = info.TechnicianNote;
foreach (var item in info.AddedParts)
{
bool beforeExpire = await warningParts(item.PartName, info.AssetID);
//pass by default
DialogResult result = DialogResult.OK;
if (beforeExpire)
{
result = MessageBox.Show($"Are you sure you want to replace { item.PartName} before the end of its effective life?", "Warning!", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
}
if (result == DialogResult.OK)
{
var addpart = (await getPartfromName(item.PartName)).ID;
var cpid = (from c in db.ChangedParts
orderby c.ID descending
select c.ID).First() + 1;
ChangedPart cp = new ChangedPart();
cp.EmergencyMaintenanceID = info.EMID;
cp.PartID = addpart;
cp.Amount = item.Amount;
cp.ID = cpid;
db.ChangedParts.Add(cp);
}
}
await db.SaveChangesAsync();
}
}
public static async Task addEmergencyMaintenance(AssetEMPageInfo info)
{
//insert maintenance request
using (var db = new Session2Entities())
{
var ID = (from em in db.EmergencyMaintenances
orderby em.ID descending
select em.ID).First() + 1;
var priorityID = (from p in db.Priorities
where p.Name == info.SelectedPriorities
select p.ID).First();
EmergencyMaintenance EM = new EmergencyMaintenance();
EM.ID = ID;
EM.PriorityID = priorityID;
EM.AssetID = info.AssetID;
EM.DescriptionEmergency = info.Description;
EM.OtherConsiderations = info.Considerations;
EM.EMTechnicianNote = null;
EM.EMReportDate = DateTime.Now;
EM.EMStartDate = DateTime.Now;
db.EmergencyMaintenances.Add(EM);
await db.SaveChangesAsync();
}
}
