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