6d45093f8bc17e1eae489cf0446281b7de8cbc77.svn-base 2.5 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283
  1. using System;
  2. using System.Collections;
  3. using System.Collections.Generic;
  4. using System.Data.Entity;
  5. using System.Data.Entity.Infrastructure;
  6. using System.Linq;
  7. using System.Net;
  8. using System.Web;
  9. using System.Web.Http;
  10. using System.Web.Http.Description;
  11. using DevExpress.Office.Utils;
  12. using iBemsDataService.Model;
  13. using iBemsDataService.Util;
  14. using System.Transactions;
  15. // hcLee 2015 03 06 작성
  16. namespace iBemsDataService.Controllers
  17. {
  18. public class FmsMaterialCodeClassController : ApiController
  19. {
  20. private iBemsEntities db = new iBemsEntities();
  21. [ResponseType( typeof( void ) )]
  22. public IHttpActionResult DeleteFmsMaterialCodeClass()
  23. {
  24. if ( !ModelState.IsValid )
  25. {
  26. return BadRequest( ModelState );
  27. }
  28. Uri uri = Request.RequestUri;
  29. var uriQuery = HttpUtility.ParseQueryString( uri.Query );
  30. int siteId, depth, materialClassId;
  31. if( int.TryParse( uriQuery.Get( "SiteId" ) , out siteId ) == false ||
  32. int.TryParse(uriQuery.Get("MaterialClassId"), out materialClassId) == false ||
  33. int.TryParse( uriQuery.Get( "Depth" ) , out depth ) == false )
  34. {
  35. return BadRequest("Not Found Parameters.");
  36. }
  37. using( var transaction = new TransactionScope() )
  38. {
  39. var qm = new QueryManager<FmsMaterialCodeClass>(db);
  40. var dbSet = db.FmsMaterialCodeClass;
  41. // 자식이 있으면 먼저 지운다 hcLee 2015 03 06
  42. var query = from d in dbSet
  43. where d.SiteId == siteId && d.ParentMaterialClassId == materialClassId
  44. select d;
  45. var list = query.ToList();
  46. foreach( var item in list )
  47. {
  48. qm.Delete( dbSet , item , true );
  49. }
  50. //그다음 자신을 지운다
  51. qm.Delete(dbSet, new FmsMaterialCodeClass
  52. {
  53. SiteId = siteId ,
  54. MaterialClassId = materialClassId
  55. } , true );
  56. db.SaveChanges();
  57. transaction.Complete();
  58. }
  59. return StatusCode( HttpStatusCode.NoContent );
  60. }
  61. protected override void Dispose(bool disposing)
  62. {
  63. if (disposing)
  64. {
  65. db.Dispose();
  66. }
  67. base.Dispose(disposing);
  68. }
  69. }
  70. }