//删除居民的出入记录
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}");
}
}
}
