| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186 | 
							- using System;
 
- using System.Collections.Generic;
 
- using System.Data;
 
- using System.Data.Entity;
 
- using System.Data.Entity.Infrastructure;
 
- using System.Diagnostics;
 
- using System.Linq;
 
- using System.Net;
 
- using System.Net.Http;
 
- using System.Transactions;
 
- using System.Web;
 
- using System.Web.Http;
 
- using System.Web.Http.Description;
 
- using iBemsDataService;
 
- using iBemsDataService.Model;
 
- using iBemsDataService.Util;
 
- namespace iBemsDataService.Controllers
 
- {
 
-     public class FmsEquipmentController : ApiController
 
-     {
 
-         private iBemsEntities db = new iBemsEntities();
 
-         [ResponseType(typeof(void))]
 
-         [ActionName("InsertFmsEquipment")]
 
-         public int InsertFmsEquipment(FmsEquipmentEx equipment)//2019-11-11 변경
 
-         {
 
-             Uri uri = Request.RequestUri;
 
-             var uriQuery = HttpUtility.ParseQueryString(uri.Query);
 
-             bool isAdditionalEquipment = false;
 
-             bool isNew = false;
 
-             bool.TryParse(uriQuery.Get("IsAdditionalEquipment"), out isAdditionalEquipment);
 
-             bool.TryParse(uriQuery.Get("IsNew"), out isNew);
 
-             // 2019.07.12
 
-             FmsEquipment equip = db.FmsEquipment.Where(e =>
 
-                 e.SiteId == equipment.SiteId &&
 
-                 e.EquipmentId == equipment.EquipmentId
 
-                 ).FirstOrDefault();
 
-             try
 
-             {
 
-                 using (var transaction = new TransactionScope())
 
-                 {
 
-                     if (!isAdditionalEquipment) // 추가 입고는 Equipment 등록할 필요없음!. 신규 등록 경우
 
-                     {
 
-                         if (equip == null) { equip = new FmsEquipment(); }
 
-                         equip.SiteId = equipment.SiteId;
 
-                         equip.Name = equipment.Name;
 
-                         equip.EquipmentTypeId = equipment.EquipmentTypeId;
 
-                         equip.WarehouseId = equipment.WarehouseId;
 
-                         equip.Unit = equipment.Unit;
 
-                         equip.Standard = equipment.Standard;
 
-                         equip.AddDate = DateTime.Now;
 
-                         equip.UpdateDate = DateTime.Now;
 
-                         equip.RegisterUserId = equipment.RegisterUserId;
 
-                         equip.SupplierName = equipment.SupplierName;
 
-                         equip.SupplierPhoneNo = equipment.SupplierPhoneNo;
 
-                         equip.ImageFileId = equipment.ImageFileId;
 
-                         db.FmsEquipment.Add(equip);
 
-                         db.SaveChanges();
 
-                     }
 
-                     if (equipment.StoredCount != 0)
 
-                     {
 
-                         FmsEquipmentHistory addHistory = new FmsEquipmentHistory()
 
-                         {
 
-                             AddDate = DateTime.Now,
 
-                             // 현재 수량 = 마지막정보의 현재수량 + 반납수량
 
-                             CurrentStockCount = equipment.CurrentStockCount != null ? equipment.CurrentStockCount + equipment.StoredCount : equipment.StoredCount,
 
-                             EquipmentId = equip.EquipmentId,
 
-                             LossCount = 0,
 
-                             RentCount = 0,
 
-                             CurrentRentCount = 0,
 
-                             ReturnCount = 0,
 
-                             SiteId = equipment.SiteId,
 
-                             StoredCount = equipment.StoredCount,
 
-                             TotalStockCount = equipment.TotalStockCount != null ? equipment.TotalStockCount + equipment.StoredCount : equipment.StoredCount,
 
-                             UpdateDate = DateTime.Now,
 
-                             EquipmentStateTypeId = 1
 
-                         };
 
-                         db.FmsEquipmentHistory.Add(addHistory);
 
-                     }
 
-                     db.SaveChanges();
 
-                     transaction.Complete();
 
-                 }
 
-             }
 
-             catch (DbUpdateException e) { throw e; }
 
-             return equip.EquipmentId;
 
-         }
 
-         [ResponseType(typeof(void))]
 
-         [ActionName("UpdateFmsEquipment")]
 
-         public int UpdateFmsEquipment(FmsEquipmentEx equipment)//2019-11-11 변경
 
-         {
 
-             Uri uri = Request.RequestUri;
 
-             var uriQuery = HttpUtility.ParseQueryString(uri.Query);
 
-             bool isAdditionalEquipment = false;
 
-             bool isNew = false;
 
-             bool.TryParse(uriQuery.Get("IsAdditionalEquipment"), out isAdditionalEquipment);
 
-             bool.TryParse(uriQuery.Get("IsNew"), out isNew);
 
-             FmsEquipment equip = db.FmsEquipment
 
-                         .Where(e => e.EquipmentId == equipment.EquipmentId && e.SiteId == equipment.SiteId)
 
-                         .FirstOrDefault();
 
-             try
 
-             {
 
-                 using (var transaction = new TransactionScope())
 
-                 {
 
-                     if (equip != null)
 
-                     {
 
-                         equip.Name = equipment.Name;
 
-                         equip.EquipmentTypeId = equipment.EquipmentTypeId;
 
-                         equip.WarehouseId = equipment.WarehouseId;
 
-                         equip.UpdateDate = DateTime.Now;
 
-                         equip.Unit = equipment.Unit;
 
-                         equip.Standard = equipment.Standard;
 
-                         equip.SupplierName = equipment.SupplierName;
 
-                         equip.SupplierPhoneNo = equipment.SupplierPhoneNo;
 
-                         equip.ImageFileId = equipment.ImageFileId;
 
-                         db.SaveChanges();
 
-                         transaction.Complete();
 
-                     }
 
-                 }
 
-             }
 
-             catch (DbUpdateException e) { throw e; }
 
-             return equip.EquipmentId;
 
-         }
 
-         [ResponseType(typeof(void))]
 
-         [ActionName("FmsEquipmentDelete")]
 
-         public IHttpActionResult FmsEquipmentDelete(FmsEquipmentEx equipment)
 
-         {
 
-             if (equipment.EquipmentId == 0) { return BadRequest(ModelState); }
 
-             var deleteHistoryQuery = db.FmsEquipmentHistory.Where(fe =>
 
-                 fe.SiteId == equipment.SiteId &&
 
-                 fe.EquipmentId == equipment.EquipmentId
 
-                 );
 
-             var deleteEquipmentQuery = db.FmsEquipment.Where(fe =>
 
-                 fe.SiteId == equipment.SiteId &&
 
-                 fe.EquipmentId == equipment.EquipmentId
 
-                 );
 
-             try
 
-             {
 
-                 using (var transaction = new TransactionScope())
 
-                 {
 
-                     // history 삭제
 
-                     FmsEquipmentHistory history = new FmsEquipmentHistory()
 
-                     {
 
-                         EquipmentId = equipment.EquipmentId
 
-                     };
 
-                     new QueryManager<Model.FmsEquipmentHistory>(db).Delete(db.FmsEquipmentHistory, deleteHistoryQuery);
 
-                     db.SaveChanges();
 
-                     // Equipment 삭제
 
-                     new QueryManager<Model.FmsEquipment>(db).Delete(db.FmsEquipment, deleteEquipmentQuery);
 
-                     db.SaveChanges();
 
-                     transaction.Complete();
 
-                 }
 
-             }
 
-             catch (DbUpdateException e) { throw e; }
 
-             return StatusCode(HttpStatusCode.NoContent);
 
-         }
 
-         protected override void Dispose(bool disposing)
 
-         {
 
-             if (disposing)
 
-             {
 
-                 db.Dispose();
 
-             }
 
-             base.Dispose(disposing);
 
-         }
 
-     }
 
- }
 
 
  |