| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219 | 
							- 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.Web;
 
- using System.Web.Http;
 
- using System.Web.Http.Description;
 
- using iBemsDataService;
 
- using iBemsDataService.Model;
 
- using iBemsDataService.Util;
 
- namespace iBemsDataService.Controllers
 
- {
 
-     public class FmsEquipmentRentInfoController : ApiController
 
-     {
 
-         private iBemsEntities db = new iBemsEntities();
 
-         [ResponseType(typeof(void))]
 
-         [ActionName("InsertEquipments")]
 
-         public IHttpActionResult PostFmsEquipmentRentInfoEquipments(List<RentEquipment> equipments)
 
-         {
 
-             if (!ModelState.IsValid)
 
-             {
 
-                 return BadRequest(ModelState);
 
-             }
 
-             Uri uri = Request.RequestUri;
 
-             var uriQuery = HttpUtility.ParseQueryString(uri.Query);
 
-             int siteId, equipmentRentId;
 
-             if (int.TryParse(uriQuery.Get("SiteId"), out siteId) == false ||
 
-                 int.TryParse(uriQuery.Get("EquipmentRentId"), out equipmentRentId) == false)
 
-             {
 
-                 return BadRequest("Not Found Parameters.");
 
-             }
 
-             try
 
-             {
 
-                 foreach (var equip in equipments)
 
-                 {
 
-                     var originHistory = db.FmsEquipmentHistory
 
-                         .Where(fe => 
 
-                             fe.SiteId == siteId &&
 
-                             fe.EquipmentId == equip.EquipmentId)
 
-                         .OrderByDescending(fe => fe.EquipmentHistoryId)
 
-                         .Take(1).FirstOrDefault();
 
-                     if (originHistory == null) { return BadRequest("Not Found Stored Info."); }
 
-                     FmsEquipmentHistory targetHistory = new FmsEquipmentHistory()
 
-                     {
 
-                         AddDate = DateTime.Now,
 
-                         CurrentStockCount = originHistory.CurrentStockCount - equip.CurrentRentCount,
 
-                         EquipmentId = originHistory.EquipmentId,
 
-                         EquipmentRentId = equipmentRentId,
 
-                         EquipmentStateTypeId = equip.EquipmentStateTypeId,
 
-                         LossCount = 0,
 
-                         RentCount = equip.CurrentRentCount, // 신규추가인 경우 
 
-                         CurrentRentCount = equip.CurrentRentCount,
 
-                         ReturnCount = 0,
 
-                         SiteId = siteId,
 
-                         StoredCount = 0,
 
-                         TotalStockCount = originHistory.TotalStockCount,
 
-                         UpdateDate = DateTime.Now,
 
-                         IsReturned = false
 
-                     };
 
-                     db.FmsEquipmentHistory.Add(targetHistory);
 
-                 }
 
-                 db.SaveChanges();
 
-             }
 
-             catch (DbUpdateException e) { throw e; }
 
-             return StatusCode(HttpStatusCode.NoContent);
 
-         }
 
-         [ResponseType(typeof(void))]
 
-         [ActionName("UpdateEquipments")]
 
-         public IHttpActionResult PostFmsEquipmentRentInfoEquipments(List<UpdateRentEquipment> equipments)
 
-         {
 
-             if (!ModelState.IsValid)
 
-             {
 
-                 return BadRequest(ModelState);
 
-             }
 
-             Uri uri = Request.RequestUri;
 
-             var uriQuery = HttpUtility.ParseQueryString(uri.Query);
 
-             int siteId, equipmentRentId;
 
-             if (int.TryParse(uriQuery.Get("SiteId"), out siteId) == false ||
 
-                 int.TryParse(uriQuery.Get("EquipmentRentId"), out equipmentRentId) == false)
 
-             {
 
-                 return BadRequest("Not Found Parameters.");
 
-             }
 
-             // 불출내역에 포함된 공기구 리스트 
 
-             var originHistoryList = db.FmsEquipmentHistory.Where(fe => 
 
-                 fe.SiteId == siteId &&
 
-                 fe.EquipmentRentId == equipmentRentId)
 
-                 .OrderByDescending(fe => fe.EquipmentHistoryId)
 
-                 .ToList();
 
-             try
 
-             {
 
-                 foreach (var equip in equipments)
 
-                 {
 
-                     var originHistory = originHistoryList.Where(h => 
 
-                         h.SiteId == siteId &&
 
-                         h.EquipmentId == equip.EquipmentId)
 
-                         .FirstOrDefault();
 
-                     if (originHistory == null)
 
-                     {
 
-                         // 이전 정보가 없는 경우 신규 저장 
 
-                         var lastestHistory = db.FmsEquipmentHistory
 
-                             .Where(fe => fe.EquipmentId == equip.EquipmentId)
 
-                             .OrderByDescending(fe => fe.EquipmentHistoryId)
 
-                             .Take(1).FirstOrDefault();
 
-                         FmsEquipmentHistory targetHistory = new FmsEquipmentHistory()
 
-                         {
 
-                             AddDate = DateTime.Now,
 
-                             CurrentStockCount = lastestHistory.CurrentStockCount - equip.RentCount,
 
-                             EquipmentId = lastestHistory.EquipmentId,
 
-                             EquipmentRentId = equipmentRentId,
 
-                             EquipmentStateTypeId = equip.EquipmentStateTypeId,
 
-                             LossCount = 0,
 
-                             RentCount = equip.RentCount,
 
-                             CurrentRentCount = equip.RentCount,
 
-                             ReturnCount = 0,
 
-                             SiteId = siteId,
 
-                             StoredCount = 0,
 
-                             TotalStockCount = lastestHistory.TotalStockCount,
 
-                             UpdateDate = DateTime.Now,
 
-                             IsReturned = false,
 
-                         };
 
-                         db.FmsEquipmentHistory.Add(targetHistory);
 
-                     }
 
-                     else
 
-                     {
 
-                         if (originHistory.CurrentRentCount != equip.CurrentRentCount)
 
-                         {
 
-                             // 현재 넘어온 값과 원래 데이터를 비교 하여 재고량을 다시 계산 
 
-                             if (originHistory.CurrentRentCount > equip.CurrentRentCount)
 
-                             {
 
-                                 originHistory.CurrentStockCount += (originHistory.CurrentRentCount - equip.CurrentRentCount);
 
-                             }
 
-                             else if (originHistory.CurrentRentCount < equip.CurrentRentCount)
 
-                             {
 
-                                 originHistory.CurrentStockCount -= (equip.CurrentRentCount - originHistory.CurrentRentCount);
 
-                             }
 
-                             originHistory.CurrentRentCount = equip.CurrentRentCount;
 
-                             originHistory.UpdateDate = DateTime.Now;
 
-                         }
 
-                     }
 
-                 }
 
-                 // 이전 정보 수가 현재 정보 수 보다 많은 경우, 공기구를 삭제하였을 경우 
 
-                 if (originHistoryList.Count > equipments.Count)
 
-                 {
 
-                     List<int> originEquipIdList = originHistoryList.Select(e => e.EquipmentId).ToList();
 
-                     List<int> targetEquipIdList = equipments.Select(e => e.EquipmentId).ToList();
 
-                     List<int> deleteTargetEquipIdList = originEquipIdList.Except(targetEquipIdList).ToList();
 
-                     foreach (var equipId in deleteTargetEquipIdList)
 
-                     {
 
-                         var deleteTarget = originHistoryList.Where(h => 
 
-                             h.SiteId == siteId &&
 
-                             h.EquipmentId == equipId)
 
-                             .FirstOrDefault();
 
-                         db.FmsEquipmentHistory.Remove(deleteTarget);
 
-                     }
 
-                 }
 
-                 db.SaveChanges();
 
-             }
 
-             catch (DbUpdateException e) { throw e; }
 
-             return StatusCode(HttpStatusCode.NoContent);
 
-         }
 
-         protected override void Dispose(bool disposing)
 
-         {
 
-             if (disposing)
 
-             {
 
-                 db.Dispose();
 
-             }
 
-             base.Dispose(disposing);
 
-         }
 
-     }
 
-     public class RentEquipment
 
-     {
 
-         public int SiteId { get; set; }
 
-         public int EquipmentId { get; set; }
 
-         public int RentCount { get; set; }
 
-         public int CurrentRentCount { get; set; }
 
-         public int ReturnCount { get; set; }
 
-         public int LossCount { get; set; }
 
-         public int StoredCount { get; set; }
 
-         public int EquipmentRentId { get; set; }
 
-         public short EquipmentStateTypeId { get; set; }
 
-     }
 
-     public class UpdateRentEquipment : RentEquipment
 
-     {
 
-     }
 
- }
 
 
  |