//删除居民的出入记录 public static void RemoveRecord(string id) { using (var entity = new CommunityEpidemicManagementSystemContext()) { try { entity.ResidentAccessManagements.Remove(Get(id)); entity.SaveChanges(); } catch (Exception ex) { string errorInfo = ex.Message; if (ex is DbEntityValidationException) { foreach (var validationResult in ((DbEntityValidationException)ex).EntityValidationErrors) { foreach (var error in validationResult.ValidationErrors) { errorInfo = $"{errorInfo}" + "\n" + $"{error.ErrorMessage}"; } } } throw new ApplicationException("删除时出错!\n" + $"{errorInfo}"); } } }
//更新 public static void Update(Worker worker) { using (var entity = new CommunityEpidemicManagementSystemContext()) { try { entity.Workers.Remove(Get(worker.WorkerId)); entity.Workers.Add(worker); entity.SaveChanges(); } catch (Exception ex) { string errorInfo = ex.Message; if (ex is DbEntityValidationException) { foreach (var validationResult in ((DbEntityValidationException)ex).EntityValidationErrors) { foreach (var error in validationResult.ValidationErrors) { errorInfo = $"{errorInfo}" + "\n" + $"{error.ErrorMessage}"; } } } throw new ApplicationException("更新时出错!\n" + $"{errorInfo}"); } } }
//添加紧急事件 public static void Add(Emergency emerg) { try { using (var entity = new CommunityEpidemicManagementSystemContext()) { entity.Emergencies.Add(emerg); entity.SaveChanges(); } } catch (Exception ex) { string errorInfo = ex.Message; if (ex is DbEntityValidationException) { foreach (var validationResult in ((DbEntityValidationException)ex).EntityValidationErrors) { foreach (var error in validationResult.ValidationErrors) { errorInfo = $"{errorInfo}" + "\n" + $"{error.ErrorMessage}"; } } } throw new ApplicationException("添加时出错!\n" + $"{errorInfo}"); } }
//删除 public static void Remove(string task_id) { using (var entity = new CommunityEpidemicManagementSystemContext()) { try { AdministratorTask task = Get(task_id); entity.AdministratorTasks.Remove(task); entity.SaveChanges(); } catch (Exception ex) { string errorInfo = ex.Message; if (ex is DbEntityValidationException) { foreach (var validationResult in ((DbEntityValidationException)ex).EntityValidationErrors) { foreach (var error in validationResult.ValidationErrors) { errorInfo = $"{errorInfo}" + "\n" + $"{error.ErrorMessage}"; } } } throw new ApplicationException("删除时出错!\n" + $"{errorInfo}"); } } }
//新增 public static void Add(AdministratorTask task) { using (var entity = new CommunityEpidemicManagementSystemContext()) { if (Get(task.AdministratorTaskId) != null) { throw new ApplicationException("已经存在!"); } try { entity.AdministratorTasks.Add(task); entity.SaveChanges(); } catch (Exception ex) { string errorInfo = ex.Message; if (ex is DbEntityValidationException) { foreach (var validationResult in ((DbEntityValidationException)ex).EntityValidationErrors) { foreach (var error in validationResult.ValidationErrors) { errorInfo = $"{errorInfo}" + "\n" + $"{error.ErrorMessage}"; } } } throw new ApplicationException("添加时出错!\n" + $"{errorInfo}"); } } }
//向任务添加工作人员 public static void AddServerToMission(uint mission_id, Worker server) { using (var entity = new CommunityEpidemicManagementSystemContext()) { try { entity.ResidentMissions.Find(mission_id).Server = server; entity.SaveChanges(); } catch (Exception ex) { string errorInfo = ex.Message; if (ex is DbEntityValidationException) { foreach (var validationResult in ((DbEntityValidationException)ex).EntityValidationErrors) { foreach (var error in validationResult.ValidationErrors) { errorInfo = $"{errorInfo}" + "\n" + $"{error.ErrorMessage}"; } } } throw new ApplicationException("更新时出错!\n" + $"{errorInfo}"); } } }
//删除一条出行经历 public static void Remove(string id) { using (var entity = new CommunityEpidemicManagementSystemContext()) { try { entity.TravelRecords.Remove(Get(id)); entity.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.Message); } } }
//添加一条出行经历 public static void Add(TravelRecord travelRecord) { //生成一条旅行经历加入数据库 using (var entity = new CommunityEpidemicManagementSystemContext()) { //在点击事件中创建新对象时,要记得生成一个ID // string ID = Guid.NewGuid().ToString(); // TravelRecord tr = new TravelRecord(ID,user,resident,departure,destination,dateLeave,dateCome, // transport,transportNumber,remarks); try { entity.TravelRecords.Add(travelRecord); entity.SaveChanges(); } catch (Exception e) { Console.WriteLine(e.Message); } } }
//健康记录每人每天一条,不多不少,因此构造方法即可,没有添加和删除方法 //选中一条健康记录进行编辑-->就是健康打卡 public static void Update(HealthInformation information) { using (var entity = new CommunityEpidemicManagementSystemContext()) { try { entity.HealthInformations.Remove(Get(information.HealthInformationId)); entity.HealthInformations.Add(information); if (information.HealthStatus == "健康" || information.HealthStatus == "已治愈") { information.Resident.HealthStatus = HealthStatus.Health; } else if (information.HealthStatus == "发热" || information.HealthStatus == "疑似") { information.Resident.HealthStatus = HealthStatus.quarantine; } else if (information.HealthStatus == "确诊") { information.Resident.HealthStatus = HealthStatus.sick; } entity.SaveChanges(); } catch (Exception ex) { string errorInfo = ex.Message; if (ex is DbEntityValidationException) { foreach (var validationResult in ((DbEntityValidationException)ex).EntityValidationErrors) { foreach (var error in validationResult.ValidationErrors) { errorInfo = $"{errorInfo}" + "\n" + $"{error.ErrorMessage}"; } } } throw new ApplicationException("更新时出错!\n" + $"{errorInfo}"); } } }