| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162 | 
							- using System;
 
- using System.Collections;
 
- using System.Collections.Generic;
 
- using System.Data.Entity;
 
- using System.Data.Entity.Infrastructure;
 
- using System.Linq;
 
- using System.Net;
 
- using System.Web;
 
- using System.Web.Http;
 
- using System.Web.Http.Description;
 
- using DevExpress.Office.Utils;
 
- using iBemsDataService.Model;
 
- using iBemsDataService.Util;
 
- using System.Transactions;
 
- using System.Diagnostics;
 
- namespace iBemsDataService.Controllers
 
- {
 
-     public class FmsWorkHistoryController : ApiController
 
-     {
 
-         private iBemsEntities db = new iBemsEntities();
 
-         [ResponseType(typeof(void))]
 
-         [ActionName("Remove")]
 
-         public IHttpActionResult PostFmsWorkHistoryRemove(FmsWorkHistory workRequest)
 
-         {
 
-             if (!ModelState.IsValid)
 
-             {
 
-                 return BadRequest(ModelState);
 
-             }
 
-             try
 
-             {
 
-                 using (var transaction = new TransactionScope())
 
-                 {
 
-                     var tempSiteId = workRequest.SiteId;
 
-                     var tempWorkRequestId = workRequest.WorkRequestId;
 
-                     var foundQuery = db.FmsWorkResultCheckItemMaterial.Where(x =>
 
-                        x.SiteId == tempSiteId &&
 
-                        x.WorkRequestId == tempWorkRequestId);
 
-                     foreach (var deleteItem in foundQuery)
 
-                     {
 
-                         db.FmsWorkResultCheckItemMaterial.Remove(deleteItem);
 
-                     }
 
-                     var foundQuery1 = db.FmsWorkResultCheckItem.Where(x =>
 
-                        x.SiteId == tempSiteId &&
 
-                        x.WorkRequestId == tempWorkRequestId);
 
-                     foreach (var deleteItem in foundQuery1)
 
-                     {
 
-                         db.FmsWorkResultCheckItem.Remove(deleteItem);
 
-                     }
 
-                     var foundQuery2 = db.FmsWorkResultFile.Where(x =>
 
-                        x.SiteId == tempSiteId &&
 
-                        x.WorkRequestId == tempWorkRequestId);
 
-                     foreach (var deleteItem in foundQuery2)
 
-                     {
 
-                         db.FmsWorkResultFile.Remove(deleteItem);
 
-                     }
 
-                     var foundQuery3 = db.FmsWorkResultLaw.Where(x =>
 
-                        x.SiteId == tempSiteId &&
 
-                        x.WorkRequestId == tempWorkRequestId);
 
-                     foreach (var deleteItem in foundQuery3)
 
-                     {
 
-                         db.FmsWorkResultLaw.Remove(deleteItem);
 
-                     }
 
-                     var foundQuery4 = db.FmsWorkResultToFacility.Where(x =>
 
-                        x.SiteId == tempSiteId &&
 
-                        x.WorkRequestId == tempWorkRequestId);
 
-                     foreach (var deleteItem in foundQuery4)
 
-                     {
 
-                         db.FmsWorkResultToFacility.Remove(deleteItem);
 
-                     }
 
-                     var foundQuery10 = db.FmsMaterialRelease.Where(x =>   //추가
 
-                       x.SiteId == tempSiteId &&
 
-                       x.WorkRequestId == tempWorkRequestId);
 
-                     foreach (var deleteItem in foundQuery10)
 
-                     {
 
-                         db.FmsMaterialRelease.Remove(deleteItem);
 
-                     }
 
-                     var foundQuery5 = db.FmsWorkResult.Where(x =>
 
-                        x.SiteId == tempSiteId &&
 
-                        x.WorkRequestId == tempWorkRequestId);
 
-                     foreach (var deleteItem in foundQuery5)
 
-                     {
 
-                         db.FmsWorkResult.Remove(deleteItem);
 
-                     }
 
-                     var foundQuery6 = db.FmsWorkOrderToFacility.Where(x =>
 
-                       x.SiteId == tempSiteId &&
 
-                       x.WorkRequestId == tempWorkRequestId);
 
-                     foreach (var deleteItem in foundQuery6)
 
-                     {
 
-                         db.FmsWorkOrderToFacility.Remove(deleteItem);
 
-                     }
 
-                     var foundQuery7 = db.FmsWorkOrder.Where(x =>
 
-                       x.SiteId == tempSiteId &&
 
-                       x.WorkRequestId == tempWorkRequestId);
 
-                     foreach (var deleteItem in foundQuery7)
 
-                     {
 
-                         db.FmsWorkOrder.Remove(deleteItem);
 
-                     }
 
-                     var foundQuery8 = db.FmsWorkRequestToFacility.Where(x =>
 
-                       x.SiteId == tempSiteId &&
 
-                       x.WorkRequestId == tempWorkRequestId);
 
-                     foreach (var deleteItem in foundQuery8)
 
-                     {
 
-                         db.FmsWorkRequestToFacility.Remove(deleteItem);
 
-                     }
 
-                     var foundQuery9 = db.FmsWorkRequest.Where(x =>
 
-                       x.SiteId == tempSiteId &&
 
-                       x.WorkRequestId == tempWorkRequestId);
 
-                     foreach (var deleteItem in foundQuery9)
 
-                     {
 
-                         db.FmsWorkRequest.Remove(deleteItem);
 
-                     }
 
-                     db.SaveChanges();
 
-                     transaction.Complete();
 
-                 }
 
-             }
 
-             catch (Exception)
 
-             {
 
-                 throw;
 
-             }
 
-             return StatusCode(HttpStatusCode.NoContent);
 
-         }
 
-         protected override void Dispose(bool disposing)
 
-         {
 
-             if (disposing)
 
-             {
 
-                 db.Dispose();
 
-             }
 
-             base.Dispose(disposing);
 
-         }
 
-         public class FmsWorkHistory
 
-         {
 
-             public int SiteId { get; set; }
 
-             public int WorkRequestId { get; set; }
 
-             public int WorkTypeId { get; set; }
 
-             public int BusinessFieldId { get; set; }
 
-             public int WorkScheduleId { get; set; }
 
-             public int WorkProgressId { get; set; }
 
-             public string Title { get; set; }
 
-             public string Content { get; set; }
 
-             public string RequestUserId { get; set; }
 
-             public System.DateTime RequestDate { get; set; }
 
-             public System.DateTime StartWorkDate { get; set; }
 
-             public string RejectUserId { get; set; }
 
-             public System.DateTime RejectDate { get; set; }
 
-             public string RejectReason { get; set; }
 
-             public int InspectionAgencyId { get; set; }
 
-         }
 
-     }
 
- }
 
 
  |