5b0e520b820b040c6b8cb51119b56eb553e30813.svn-base 2.8 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Data;
  4. using System.Data.Entity;
  5. using System.Data.Entity.Infrastructure;
  6. using System.Diagnostics;
  7. using System.Linq;
  8. using System.Net;
  9. using System.Net.Http;
  10. using System.Web;
  11. using System.Web.Http;
  12. using System.Web.Http.Description;
  13. using DevExpress.XtraCharts.Native;
  14. using DevExpress.XtraPrinting.Native;
  15. using iBemsDataService;
  16. using iBemsDataService.Model;
  17. using iBemsDataService.Util;
  18. namespace iBemsDataService.Controllers
  19. {
  20. public class FmsWorkResultToFacilityController : ApiController
  21. {
  22. private iBemsEntities db = new iBemsEntities();
  23. // POST: api/FmsWorkResultToFacility
  24. [ResponseType( typeof( void ) )]
  25. public IHttpActionResult PostFmsWorkResultToFacility( List<WorkResultToFacility> workResultToFacilities )
  26. {
  27. if ( !ModelState.IsValid )
  28. {
  29. return BadRequest( ModelState );
  30. }
  31. Uri uri = Request.RequestUri;
  32. var uriQuery = HttpUtility.ParseQueryString( uri.Query );
  33. int siteId, workRequestId;
  34. if( int.TryParse( uriQuery.Get( "SiteId" ) , out siteId ) == false ||
  35. int.TryParse( uriQuery.Get( "WorkRequestId" ) , out workRequestId ) == false )
  36. {
  37. return BadRequest( "Not Found Parameters." );
  38. }
  39. var query = from d in db.FmsWorkResultToFacility
  40. where d.SiteId == siteId &&
  41. d.WorkRequestId == workRequestId
  42. select d;
  43. var qm = new QueryManager<FmsWorkResultToFacility>( db );
  44. try
  45. {
  46. qm.DeleteAndInsert(db.FmsWorkResultToFacility, workResultToFacilities, query);
  47. var updateRequestQuery = (
  48. from u in db.FmsWorkRequest
  49. where u.SiteId == siteId &&
  50. u.WorkRequestId == workRequestId
  51. select u).FirstOrDefault();
  52. // 작업상태가 대기인 경우 작업중으로 변경
  53. if (updateRequestQuery.WorkProgressId == (short)WorkProgress.WORK_STANDBY)
  54. {
  55. updateRequestQuery.WorkProgressId = (short)WorkProgress.WORKING;
  56. db.SaveChanges();
  57. }
  58. }
  59. catch( DbUpdateException e ) { throw e; }
  60. return StatusCode( HttpStatusCode.NoContent );
  61. }
  62. protected override void Dispose(bool disposing)
  63. {
  64. if (disposing)
  65. {
  66. db.Dispose();
  67. }
  68. base.Dispose(disposing);
  69. }
  70. }
  71. public class WorkResultToFacility
  72. {
  73. public int SiteId { get; set; }
  74. public int WorkRequestId { get; set; }
  75. public int FacilityCode { get; set; }
  76. };
  77. }