///// <summary> ///// 根据组织机构ID获取本机及直属下级的监控点 ///// </summary> ///// <param name="organizationId"></param> ///// <returns></returns> //public static List<MonitorySite> GetAllMonitorySite(Guid organizationId) //{ // List<MonitorySite> list = new List<MonitorySite>(); // using (var db = new AllInOneContext.AllInOneContext()) // { // Organization org = db.Organization // .Include(t => t.Center) // .FirstOrDefault(p => p.OrganizationId.Equals(organizationId)); // if (org == null || org.Center == null || org.Center.EndPoints == null || org.Center.EndPoints.Count == 0) // return list; // var orgs = db.Organization // .Include(t => t.Center) // .Where(p => p.OrganizationTypeId != null && p.OrganizationFullName.Contains(org.OrganizationFullName)); // if (orgs.ToList().Count() == 0) // return list; // foreach (Organization Query in orgs.ToList()) // { // string url = string.Format("http://{0}:{1}/Resources/MonitorySite/organizationId={2}", org.Center.EndPoints[0].IPAddress, org.Center.EndPoints[0].Port, Query.OrganizationId); // var handler = new HttpClientHandler() { AutomaticDecompression = DecompressionMethods.GZip }; // using (var http = new HttpClient(handler)) // { // try // { // http.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); // var rst = http.GetAsync(url).Result.Content.ReadAsStringAsync().Result; // var obj = JsonConvert.DeserializeObject<List<MonitorySite>>(rst); // if (obj.ToList().Count == 0) // continue; // //过滤查勤监控点 // var data = obj.ToList().Where(p => p.IsDutycheckSite == true); // if (data.ToList().Count == 0) // continue; // list.AddRange(data.ToList()); // } // catch (Exception ex) // { // Console.WriteLine(ex.Message); // } // } // } // } // return list; //} /// <summary> /// 根据组织机构ID获取本机及直属下级的监控点的总数 /// </summary> /// <param name="organizationId"></param> /// <returns></returns> public static int GetAllMonitorySite(Guid organizationId) { int allCount = 0; using (var db = new AllInOneContext.AllInOneContext()) { Organization org = db.Organization .FirstOrDefault(p => p.OrganizationId.Equals(organizationId)); if (org == null) { return(allCount); } var orgs = db.Organization .Where(p => p.OrganizationTypeId == null && p.OrganizationFullName.Contains(org.OrganizationFullName)); if (orgs.ToList().Count() == 0) { return(allCount); } List <Organization> list = orgs.ToList(); foreach (Organization Query in orgs.ToList()) { allCount = allCount + Query.DutycheckPoints; } } return(allCount); }
public IActionResult GetSystemOptionsByOrganizationID(Guid parentSystemOptionId) { try { using (var db = new AllInOneContext.AllInOneContext()) { var data = db.SystemOption .Include(t => t.ApplicationSystemOptions).Include(t => t.ParentSystemOption) .Where(p => p.ParentSystemOption != null && p.ParentSystemOptionId.Equals(parentSystemOptionId)) .OrderBy(t => t.SystemOptionCode); if (data.Count() == 0) { return(NoContent()); } return(new ObjectResult(data.ToList())); } } catch (DbUpdateException dbEx) { _logger.LogError("GetSystemOptionsByOrganizationID:Message:{0}\r\n,StackTrace:{1}", dbEx.Message, dbEx.StackTrace); return(BadRequest(new ApplicationException { ErrorCode = "DBUpdate", ErrorMessage = "数据保存异常:" + dbEx.Message })); } catch (System.Exception ex) { _logger.LogError("GetSystemOptionsByOrganizationID:Message:{0}\r\n,StackTrace:{1}", ex.Message, ex.StackTrace); return(BadRequest(new ApplicationException { ErrorCode = "Unknown", ErrorMessage = ex.Message })); } }
public IActionResult Delete(Guid id) { try { using (var db = new AllInOneContext.AllInOneContext()) { using (var transaction = db.Database.BeginTransaction()) { DutyCheckPackageTimePlan plan = db.DutyCheckPackageTimePlan .Include(t => t.Schedule).ThenInclude(t => t.ScheduleCycle).ThenInclude(t => t.DayPeriods).ThenInclude(t => t.TimePeriods) .Include(t => t.Schedule).ThenInclude(t => t.ScheduleCycle).ThenInclude(t => t.CycleType) .Include(t => t.Organization) .FirstOrDefault(p => p.DutyCheckPackageTimePlanId.Equals(id)); if (plan == null) { return(NoContent()); } db.DutyCheckPackageTimePlan.Remove(plan); db.SaveChanges(); transaction.Commit(); return(new NoContentResult()); } } } catch (System.Exception ex) { return(BadRequest(new ApplicationException { ErrorCode = "Unknown", ErrorMessage = ex.Message })); } }
public IActionResult Update([FromBody] Encoder encoder) { try { if (encoder == null) { return(BadRequest()); } using (var db = new AllInOneContext.AllInOneContext()) { db.Encoder.Update(encoder); db.SaveChanges(); //同时更新摄像机IP db.Set <Camera>().Include(t => t.IPDevice).Where(t => t.EncoderId.Equals(encoder.EncoderId)). ForEachAsync(f => f.IPDevice.EndPointsJson = encoder.DeviceInfo.EndPointsJson).Wait(); db.SaveChanges(); return(NoContent()); } } catch (DbUpdateException dbEx) { _logger.LogError("修改编码器异常:Message:{0}\r\n,StackTrace:{1}", dbEx.Message, dbEx.StackTrace); return(BadRequest(new ApplicationException { ErrorCode = "DBUpdate", ErrorMessage = "数据保存异常:" + dbEx.Message })); } catch (System.Exception ex) { _logger.LogError("修改编码器异常:Message:{0}\r\n,StackTrace:{1}", ex.Message, ex.StackTrace); return(BadRequest(new ApplicationException { ErrorCode = "Unknown", ErrorMessage = ex.Message })); } }
public IActionResult Delete(Guid id) { try { using (var db = new AllInOneContext.AllInOneContext()) { StaffGroup data = db.StaffGroup.FirstOrDefault(p => p.StaffGroupId == id); if (data == null) { return(NoContent()); } db.StaffGroup.Remove(data); db.SaveChanges(); return(new NoContentResult()); } } catch (DbUpdateException dbEx) { _logger.LogError("Delete:Message:{0}\r\n,StackTrace:{1}", dbEx.Message, dbEx.StackTrace); return(BadRequest(new ApplicationException { ErrorCode = "DBUpdate", ErrorMessage = "数据保存异常:" + dbEx.Message })); } catch (System.Exception ex) { _logger.LogError("Delete:Message:{0}\r\n,StackTrace:{1}", ex.Message, ex.StackTrace); return(BadRequest(new ApplicationException { ErrorCode = "Unknown", ErrorMessage = ex.Message })); } }
public IActionResult Add([FromBody] DutySchedule model) { try { if (model == null) { return(BadRequest()); } using (var db = new AllInOneContext.AllInOneContext()) { db.DutySchedule.Add(model); db.SaveChanges(); return(Created("", "OK")); } } catch (DbUpdateException dbEx) { return(BadRequest(new ApplicationException { ErrorCode = "DBUpdate", ErrorMessage = "数据保存异常:" + dbEx.Message })); } catch (System.Exception ex) { return(BadRequest(new ApplicationException { ErrorCode = "Unknown", ErrorMessage = ex.Message })); } }
public IEnumerable <EncoderType> GetAllEncoderType() { using (var db = new AllInOneContext.AllInOneContext()) { return(db.Set <EncoderType>().ToList()); } }
public IActionResult Update([FromBody] DeviceGroup deviceGroup) { if (deviceGroup == null) { return(BadRequest("DeviceGroup object can not be null!")); } if (ExistsName(deviceGroup.DeviceGroupName, deviceGroup.OrganizationId, deviceGroup.DeviceGroupId)) { return(BadRequest("DeviceGroup name has been used!")); } using (var db = new AllInOneContext.AllInOneContext()) { try { db.Update(deviceGroup); db.SaveChanges(); return(NoContent()); } catch (DbUpdateException dbEx) { _logger.LogError("更新设备分组异常:Message:{0}\r\n,StackTrace:{1}", dbEx.Message, dbEx.StackTrace); return(BadRequest(new ApplicationException { ErrorCode = "DBUpdate", ErrorMessage = "数据保存异常:" + dbEx.Message })); } catch (Exception ex) { _logger.LogError("更新设备分组异常:Message:{0}\r\n,StackTrace:{1}", ex.Message, ex.StackTrace); return(BadRequest(new ApplicationException { ErrorCode = "Unknown", ErrorMessage = ex.Message })); } } }
public IActionResult Get(Guid id) { if (id == null || id == new Guid()) { return(NoContent()); } using (var db = new AllInOneContext.AllInOneContext()) { Fault Fault = db.Set <Fault>() .Include(t => t.CheckDutySite) .Include(t => t.CheckMan) .Include(t => t.DutyCheckOperation).ThenInclude(t => t.Attachments) .Include(t => t.DutyOrganization) .Include(t => t.FaultType) .FirstOrDefault(p => p.FaultId.Equals(id)); if (Fault == null) { return(NoContent()); } return(new ObjectResult(Fault)); } }
public IEnumerable <Staff> GetAll() { try { using (var db = new AllInOneContext.AllInOneContext()) { var data = db.Staff .Include(t => t.Application) .Include(t => t.DegreeOfEducation) .Include(t => t.DutyCheckType) .Include(t => t.Fingerprints) .Include(t => t.MaritalStatus) .Include(t => t.Nation) .Include(t => t.Organization) .Include(t => t.Photo) .Include(t => t.PhysiclalStatus) .Include(t => t.PoliticalLandscape) .Include(t => t.PositionType) .Include(t => t.RankType) .Include(t => t.ReignStatus) .Include(t => t.Sex) .Include(t => t.WorkingProperty); return(data.ToList()); } } catch (Exception ex) { return(null); } }
public IActionResult FuzzySearchByStaffName(string staffName) { if (staffName == "" || staffName.Length == 0) { return(BadRequest()); } using (var db = new AllInOneContext.AllInOneContext()) { var data = db.Staff .Include(t => t.Application) .Include(t => t.DegreeOfEducation) .Include(t => t.DutyCheckType) .Include(t => t.Fingerprints) .Include(t => t.MaritalStatus) .Include(t => t.Nation) .Include(t => t.Organization) .Include(t => t.Photo) .Include(t => t.PhysiclalStatus) .Include(t => t.PoliticalLandscape) .Include(t => t.PositionType) .Include(t => t.RankType) .Include(t => t.ReignStatus) .Include(t => t.Sex) .Include(t => t.WorkingProperty) .Where(p => p.StaffName.Contains(staffName)); if (data == null || data.Count() == 0) { return(NoContent()); } return(new ObjectResult(data.ToList())); } }
public IActionResult Get(Guid id) { try { using (var db = new AllInOneContext.AllInOneContext()) { InstitutionsDutyCheckSchedule data = db.InstitutionsDutyCheckSchedule //.Include(t => t.Entourages) .Include(t => t.InspectedOrganization) //.Include(t=>t.InspectionTarget) .Include(t => t.Lead) .FirstOrDefault(p => p.InstitutionsDutyCheckScheduleId.Equals(id)); if (data == null) { return(NoContent()); } return(new ObjectResult(data)); } } catch (Exception ex) { return(BadRequest(new ApplicationException { ErrorCode = "Unknown", ErrorMessage = ex.Message })); } }
public IActionResult Add([FromBody] ApplicationCenter model) { try { if (model == null) { return(BadRequest()); } using (var db = new AllInOneContext.AllInOneContext()) { db.ApplicationCenter.Add(model); db.SaveChanges(); return(Created("", "OK")); } } catch (DbUpdateException dbEx) { _logger.LogError("新增系统中心异常:Message:{0}\r\n,StackTrace:{1}", dbEx.Message, dbEx.StackTrace); return(BadRequest(new ApplicationException { ErrorCode = "DBUpdate", ErrorMessage = "数据保存异常:" + dbEx.Message })); } catch (System.Exception ex) { _logger.LogError("新增系统中心异常:Message:{0}\r\n,StackTrace:{1}", ex.Message, ex.StackTrace); return(BadRequest(new ApplicationException { ErrorCode = "Unknown", ErrorMessage = ex.Message })); } }
/// <summary> /// 同步哨位记录至勤务排班记录 /// </summary> /// <param name="punchLog"></param> public static void Synchronization(PunchLog punchLog) { try { using (var db = new AllInOneContext.AllInOneContext()) { //取当前记录 DutyCheckLog log = db.DutyCheckLog .Include(t => t.DutyCheckSiteSchedule).ThenInclude(t => t.CheckMan).ThenInclude(t => t.Organization) .Include(t => t.DutyCheckSiteSchedule).ThenInclude(t => t.CheckMan).ThenInclude(t => t.PositionType) .Include(t => t.DayPeriod).ThenInclude(t => t.TimePeriods) .FirstOrDefault(p => p.DutyCheckSiteSchedule != null && p.DutyCheckSiteScheduleId.Equals(punchLog.OnDutyStaff.StaffId) && new DateTime(p.PlanDate.Value.Year, p.PlanDate.Value.Month, p.PlanDate.Value.Day, p.TimePeriod.StartTime.Hour, p.TimePeriod.StartTime.Minute, p.TimePeriod.StartTime.Second) <= punchLog.LogTime && new DateTime(p.PlanDate.Value.Year, p.PlanDate.Value.Month, p.PlanDate.Value.Day, p.TimePeriod.EndTime.Hour, p.TimePeriod.EndTime.Minute, p.TimePeriod.EndTime.Second) >= punchLog.LogTime); // if (log == null) { return; } //同步记录 log.MainAppriseId = log.MainAppriseId; log.RecordTime = punchLog.LogTime; log.StatusId = new Guid("24AC9875-C463-47B6-8147-5845874C3CAF"); db.DutyCheckLog.Update(log); db.SaveChanges(); } } catch (Exception ex) { Console.WriteLine("Synchronization is Exception:" + ex.Message); } }
public IActionResult Get(Guid id) { try { using (var db = new AllInOneContext.AllInOneContext()) { ShiftHandoverLog data = db.ShiftHandoverLog .Include(t => t.OffGoing) .Include(t => t.OnComing) .Include(t => t.Organization) .Include(t => t.Status) .FirstOrDefault(p => p.ShiftHandoverLogId.Equals(id)); if (data == null) { return(NoContent()); } return(new ObjectResult(data)); } } catch (Exception ex) { return(BadRequest(new ApplicationException { ErrorCode = "Unknown", ErrorMessage = ex.Message })); } }
public IActionResult Get(string id) { try { using (var db = new AllInOneContext.AllInOneContext()) { EventLog data = db.EventLog .Include(t => t.Application).Include(t => t.EventLevel) .Include(t => t.EventLogType).Include(t => t.EventSource) .Include(t => t.Organization) .FirstOrDefault(p => p.EventLogId.Equals(id)); if (data == null) { return(NoContent()); } return(new ObjectResult(data)); } } catch (Exception ex) { _logger.LogError("Get:Message:{0}\r\n,StackTrace:{1}", ex.Message, ex.StackTrace); return(BadRequest(new ApplicationException { ErrorCode = "Unknown", ErrorMessage = ex.Message })); } }
public IActionResult Get(Guid id) { try { using (var db = new AllInOneContext.AllInOneContext()) { DutySchedule data = db.DutySchedule .Include(t => t.Lister) .Include(t => t.Organization) .Include(t => t.Schedule).ThenInclude(t => t.ScheduleCycle).ThenInclude(t => t.DayPeriods).ThenInclude(t => t.TimePeriods) .Include(t => t.Schedule).ThenInclude(t => t.ScheduleType) .Include(t => t.DutyScheduleDetails).ThenInclude(t => t.CadreSchedule) .Include(t => t.DutyScheduleDetails).ThenInclude(t => t.OfficerSchedule) .Include(t => t.DutyScheduleDetails).ThenInclude(t => t.NetWatcherSchedule).ThenInclude(t => t.Leader) .Include(t => t.DutyScheduleDetails).ThenInclude(t => t.NetWatcherSchedule).ThenInclude(t => t.Deputy) .Include(t => t.DutyScheduleDetails).ThenInclude(t => t.NetWatcherSchedule).ThenInclude(t => t.CheckTimePeriod) .FirstOrDefault(p => p.DutyScheduleId.Equals(id)); if (data == null) { return(NoContent()); } return(new ObjectResult(data)); } } catch (Exception ex) { return(BadRequest(new ApplicationException { ErrorCode = "Unknown", ErrorMessage = ex.Message })); } }
public IActionResult Get(Guid id) { try { using (var db = new AllInOneContext.AllInOneContext()) { DutyCheckMatter data = db.DutyCheckMatter .Include(t => t.MatterICO) .Include(t => t.Organization) .Include(t => t.VoiceFile) .FirstOrDefault(p => p.DutyCheckMatterId.Equals(id)); if (data == null) { return(NoContent()); } return(new ObjectResult(data)); } } catch (Exception ex) { return(BadRequest(new ApplicationException { ErrorCode = "Unknown", ErrorMessage = ex.Message })); } }
public IEnumerable <Encoder> GetAll() { using (var db = new AllInOneContext.AllInOneContext()) { return(CreateDbQuery(db).ToList()); } }
/// <summary> /// 推送反馈信息至上级 /// </summary> /// <param name="Feedback"></param> public bool PushFeedback(Fault model) { if (model == null) { return(false); } using (var db = new AllInOneContext.AllInOneContext()) { //查找监控点所在的组织机构 Organization org = db.Organization .Include(t => t.Center) .FirstOrDefault(p => p.OrganizationId.Equals(model.CheckDutySite.Organization.ParentOrganizationId)); if (org == null || org.Center == null || org.Center.EndPoints == null || org.Center.EndPoints.Count == 0) { return(false); } string url = string.Format("http://{0}:{1}/Paps/Feedback/Broadcast", org.Center.EndPoints[0].IPAddress, org.Center.EndPoints[0].Port); var ret = HttpClientHelper.Post(model, url); return(ret.Success); } }
public IActionResult Add([FromBody] Encoder encoder) { try { if (encoder == null) { return(BadRequest()); } using (var db = new AllInOneContext.AllInOneContext()) { db.Encoder.Add(encoder); db.SaveChanges(); // return CreatedAtRoute("GetById",new { id = encoder.EncoderId }, encoder); return(CreatedAtAction("", encoder)); } } catch (DbUpdateException dbEx) { _logger.LogError("添加编码器异常:Message:{0}\r\n,StackTrace:{1}", dbEx.Message, dbEx.StackTrace); return(BadRequest(new ApplicationException { ErrorCode = "DBUpdate", ErrorMessage = "数据保存异常:" + dbEx.Message })); } catch (Exception ex) { _logger.LogError("添加编码器异常:Message:{0}\r\n,StackTrace:{1}", ex.Message, ex.StackTrace); return(BadRequest(new ApplicationException { ErrorCode = "Unknown", ErrorMessage = ex.Message })); } }
public IActionResult Get(Guid id) { try { using (var db = new AllInOneContext.AllInOneContext()) { Feedback data = db.Feedback .Include(t => t.Circular) .Include(t => t.FeedbackOptions) .Include(t => t.FeedbackStaff) .Include(t => t.Fault) .FirstOrDefault(p => p.FeedbackId.Equals(id)); if (data == null) { return(NoContent()); } return(new ObjectResult(data)); } } catch (Exception ex) { return(BadRequest(new ApplicationException { ErrorCode = "Unknown", ErrorMessage = ex.Message })); } }
public IActionResult Update([FromBody] StaffGroup model) { try { if (model == null) { return(BadRequest()); } using (var db = new AllInOneContext.AllInOneContext()) { db.StaffGroup.Update(model); db.SaveChanges(); return(new NoContentResult()); } } catch (DbUpdateException dbEx) { _logger.LogError("Update:Message:{0}\r\n,StackTrace:{1}", dbEx.Message, dbEx.StackTrace); return(BadRequest(new ApplicationException { ErrorCode = "DBUpdate", ErrorMessage = "数据保存异常:" + dbEx.Message })); } catch (System.Exception ex) { _logger.LogError("Update:Message:{0}\r\n,StackTrace:{1}", ex.Message, ex.StackTrace); return(BadRequest(new ApplicationException { ErrorCode = "Unknown", ErrorMessage = ex.Message })); } }
private static void RemoveManyToMany(AllInOneContext.AllInOneContext db, Role Role) { //手动处理RolePermissions 多对多的关系,待找到合适的方法后再调整 if (Role.RolePermissions != null) { List <RolePermission> delList = new List <RolePermission>(); foreach (RolePermission rp in Role.RolePermissions) { RolePermission del = db.RolePermission .FirstOrDefault(p => p.PermissionId.Equals(rp.PermissionId) && p.RoleId.Equals(rp.RoleId)); if (del != null) { delList.Add(del); } } db.RolePermission.RemoveRange(delList); db.SaveChanges(); } //手动处理UserRole 多对多的关系,待找到合适的方法后再调整 if (Role.UserManyToRole != null) { List <UserRole> delList = new List <UserRole>(); foreach (UserRole rp in Role.UserManyToRole) { UserRole del = db.UserRole .FirstOrDefault(p => p.UserId.Equals(rp.UserId) && p.RoleId.Equals(rp.RoleId)); if (del != null) { delList.Add(del); } } db.UserRole.RemoveRange(delList); db.SaveChanges(); } }
public IActionResult Get(Guid id) { try { using (var db = new AllInOneContext.AllInOneContext()) { SystemOption data = db.SystemOption .Include(t => t.ApplicationSystemOptions) .FirstOrDefault(p => p.SystemOptionId.Equals(id)); if (data == null) { return(NoContent()); } return(new ObjectResult(data)); } } catch (Exception ex) { _logger.LogError("Get:Message:{0}\r\n,StackTrace:{1}", ex.Message, ex.StackTrace); return(BadRequest(new ApplicationException { ErrorCode = "Unknown", ErrorMessage = ex.Message })); } }
public IActionResult GetRoleByApplicationID(Guid applicationId) { try { using (var db = new AllInOneContext.AllInOneContext()) { var data = db.Role .Include(t => t.RolePermissions).Include(t => t.UserManyToRole) .Include(t => t.Organization).Include(t => t.Application) .Include(t => t.ControlResourcesType) .Where(p => p.Application.ApplicationId.Equals(applicationId)); if (data == null) { return(NoContent()); } return(new ObjectResult(data.ToList())); } } catch (DbUpdateException dbEx) { _logger.LogError("GetRoleByApplicationID:Message:{0}\r\n,StackTrace:{1}", dbEx.Message, dbEx.StackTrace); return(BadRequest(new ApplicationException { ErrorCode = "DBUpdate", ErrorMessage = "数据保存异常:" + dbEx.Message })); } catch (System.Exception ex) { _logger.LogError("GetRoleByApplicationID:Message:{0}\r\n,StackTrace:{1}", ex.Message, ex.StackTrace); return(BadRequest(new ApplicationException { ErrorCode = "Unknown", ErrorMessage = ex.Message })); } }
public IActionResult Update([FromBody] DailyOnDuty model) { try { if (model == null) { return(BadRequest()); } using (var db = new AllInOneContext.AllInOneContext()) { db.DailyOnDuty.Update(model); db.SaveChanges(); return(new NoContentResult()); } } catch (DbUpdateException dbEx) { return(BadRequest(new ApplicationException { ErrorCode = "DBUpdate", ErrorMessage = "数据保存异常:" + dbEx.Message })); } catch (System.Exception ex) { return(BadRequest(new ApplicationException { ErrorCode = "Unknown", ErrorMessage = ex.Message })); } }
public IActionResult Add([FromBody] Circular model) { try { if (model == null) { return(BadRequest()); } using (var db = new AllInOneContext.AllInOneContext()) { db.Circular.Add(model); db.SaveChanges(); // 下发通报至下级 PushCircular(model); // return(Created("", "OK")); } } catch (DbUpdateException dbEx) { return(BadRequest(new ApplicationException { ErrorCode = "DBUpdate", ErrorMessage = "数据保存异常:" + dbEx.Message })); } catch (System.Exception ex) { return(BadRequest(ex.Message)); } }
public IActionResult Get(Guid id) { try { using (var db = new AllInOneContext.AllInOneContext()) { DutyCheckPackageTimePlan data = db.DutyCheckPackageTimePlan .Include(t => t.Schedule).ThenInclude(t => t.ScheduleCycle).ThenInclude(t => t.DayPeriods).ThenInclude(t => t.TimePeriods) .Include(t => t.Schedule).ThenInclude(t => t.ScheduleCycle).ThenInclude(t => t.CycleType) .Include(t => t.Schedule).ThenInclude(t => t.ScheduleType) .Include(t => t.Organization) .FirstOrDefault(p => p.DutyCheckPackageTimePlanId.Equals(id)); if (data == null) { return(NoContent()); } return(new ObjectResult(data)); } } catch (Exception ex) { return(BadRequest(new ApplicationException { ErrorCode = "Unknown", ErrorMessage = ex.Message })); } }
public IActionResult Delete(Guid id) { try { using (var db = new AllInOneContext.AllInOneContext()) { using (var tran = db.Database.BeginTransaction()) { DutyCheckGroup group = db.DutyCheckGroup .Include(t => t.CheckDutySiteSchedules)/*.ThenInclude(t => t.CheckDutySite)*/ .Include(t => t.CheckDutySiteSchedules).ThenInclude(t => t.CheckMan) .FirstOrDefault(p => p.DutyCheckGroupId.Equals(id)); if (group == null) { return(NoContent()); } // RemoveLinkage(db, group); // db.DutyCheckGroup.Remove(group); db.SaveChanges(); tran.Commit(); return(new NoContentResult()); } } } catch (System.Exception ex) { return(BadRequest(new ApplicationException { ErrorCode = "Unknown", ErrorMessage = ex.Message })); } }