530a9e3eb1bc5b1db77bcda5cf50bd5988283825.svn-base 4.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157
  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. namespace iBemsDataService.Controllers
  18. {
  19. public class CmUserToLicenseController : ApiController
  20. {
  21. private iBemsEntities db = new iBemsEntities();
  22. // PUT: api/CmUserToLicense/5
  23. [ResponseType(typeof(void))]
  24. public IHttpActionResult PutCmUserToLicense( int id , UserToLicense userToLicense )
  25. {
  26. if (!ModelState.IsValid)
  27. {
  28. return BadRequest(ModelState);
  29. }
  30. if( id != userToLicense.SiteId )
  31. {
  32. return BadRequest();
  33. }
  34. db.Entry( userToLicense ).State = EntityState.Modified;
  35. try
  36. {
  37. db.SaveChanges();
  38. }
  39. catch (DbUpdateConcurrencyException)
  40. {
  41. if (!CmUserToLicenseExists(id))
  42. {
  43. return NotFound();
  44. }
  45. else
  46. {
  47. throw;
  48. }
  49. }
  50. return StatusCode(HttpStatusCode.NoContent);
  51. }
  52. // POST: api/CmUserToLicense
  53. [ResponseType( typeof ( void ) )]
  54. public IHttpActionResult PostCmUserToLicense( List<UserToLicense> userToLicenses )
  55. {
  56. if ( !ModelState.IsValid )
  57. {
  58. return BadRequest( ModelState );
  59. }
  60. Uri uri = Request.RequestUri;
  61. var uriQuery = HttpUtility.ParseQueryString( uri.Query );
  62. string userId = uriQuery.Get( "UserId" );
  63. int siteId;
  64. if ( int.TryParse( uriQuery.Get( "SiteId" ) , out siteId ) == false ||
  65. userId == null )
  66. {
  67. return NotFound();
  68. }
  69. var query = from d in db.CmUserToLicense
  70. where d.SiteId == siteId &&
  71. d.UserId == userId
  72. select d;
  73. try
  74. {
  75. foreach( var deleteItem in query )
  76. {
  77. db.CmUserToLicense.Remove( deleteItem );
  78. }
  79. foreach( var f in userToLicenses )
  80. {
  81. var newData = new CmUserToLicense
  82. {
  83. SiteId = f.SiteId,
  84. UserId = f.UserId ,
  85. LicenseId = f.LicenseId
  86. };
  87. db.CmUserToLicense.Add( newData );
  88. }
  89. db.SaveChanges();
  90. }
  91. catch( DbUpdateException e )
  92. {
  93. //if( CmUserToLicenseExists( CmUserToLicense.SiteId ) )
  94. //{
  95. // return Conflict();
  96. //}
  97. //else
  98. {
  99. throw e;
  100. }
  101. }
  102. return StatusCode( HttpStatusCode.NoContent );
  103. }
  104. // DELETE: api/CmUserToLicense/5
  105. [ResponseType(typeof(CmUserToLicense))]
  106. public IHttpActionResult DeleteCmUserToLicense(int id)
  107. {
  108. var CmUserToLicense = db.CmUserToLicense.Find(id);
  109. if (CmUserToLicense == null)
  110. {
  111. return NotFound();
  112. }
  113. db.CmUserToLicense.Remove(CmUserToLicense);
  114. db.SaveChanges();
  115. return Ok(CmUserToLicense);
  116. }
  117. protected override void Dispose(bool disposing)
  118. {
  119. if (disposing)
  120. {
  121. db.Dispose();
  122. }
  123. base.Dispose(disposing);
  124. }
  125. private bool CmUserToLicenseExists(int id)
  126. {
  127. return db.CmUserToLicense.Count(e => e.SiteId == id) > 0;
  128. }
  129. }
  130. public class UserToLicense
  131. {
  132. public int SiteId { get; set; }
  133. public string UserId { get; set; }
  134. public int LicenseId { get; set; }
  135. };
  136. }