| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157 | 
							- 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 DevExpress.XtraCharts.Native;
 
- using DevExpress.XtraPrinting.Native;
 
- using iBemsDataService;
 
- using iBemsDataService.Model;
 
- namespace iBemsDataService.Controllers
 
- {
 
-     public class CmUserToLicenseController : ApiController
 
-     {
 
-         private iBemsEntities db = new iBemsEntities();
 
-         // PUT: api/CmUserToLicense/5
 
-         [ResponseType(typeof(void))]
 
-         public IHttpActionResult PutCmUserToLicense( int id , UserToLicense userToLicense )
 
-         {
 
-             if (!ModelState.IsValid)
 
-             {
 
-                 return BadRequest(ModelState);
 
-             }
 
-             if( id != userToLicense.SiteId )
 
-             {
 
-                 return BadRequest();
 
-             }
 
-             db.Entry( userToLicense ).State = EntityState.Modified;
 
-             try
 
-             {
 
-                 db.SaveChanges();
 
-             }
 
-             catch (DbUpdateConcurrencyException)
 
-             {
 
-                 if (!CmUserToLicenseExists(id))
 
-                 {
 
-                     return NotFound();
 
-                 }
 
-                 else
 
-                 {
 
-                     throw;
 
-                 }
 
-             }
 
-             return StatusCode(HttpStatusCode.NoContent);
 
-         }
 
-         // POST: api/CmUserToLicense
 
-         [ResponseType( typeof ( void ) )]
 
-         public IHttpActionResult PostCmUserToLicense( List<UserToLicense> userToLicenses )
 
-         {
 
-             if ( !ModelState.IsValid )
 
-             {
 
-                 return BadRequest( ModelState );
 
-             }
 
-             Uri uri = Request.RequestUri;
 
-             var uriQuery = HttpUtility.ParseQueryString( uri.Query );
 
-             string userId = uriQuery.Get( "UserId" );
 
-             int siteId;
 
-             if ( int.TryParse( uriQuery.Get( "SiteId" ) , out siteId ) == false ||
 
-                  userId == null )
 
-             {
 
-                 return NotFound();
 
-             }
 
-             var query = from d in db.CmUserToLicense
 
-                         where d.SiteId == siteId &&
 
-                               d.UserId == userId 
 
-                         select d;
 
-             try
 
-             {                
 
-                 foreach( var deleteItem in query )
 
-                 {
 
-                     db.CmUserToLicense.Remove( deleteItem );                
 
-                 }
 
-                 foreach( var f in userToLicenses )
 
-                 {
 
-                     var newData = new CmUserToLicense
 
-                     {
 
-                         SiteId = f.SiteId,
 
-                         UserId = f.UserId ,
 
-                         LicenseId = f.LicenseId
 
-                     };
 
-                     db.CmUserToLicense.Add( newData );
 
-                 }
 
-                 db.SaveChanges();
 
-             }
 
-             catch( DbUpdateException e )
 
-             {
 
-                 //if( CmUserToLicenseExists( CmUserToLicense.SiteId ) )
 
-                 //{
 
-                 //    return Conflict();
 
-                 //}
 
-                 //else
 
-                 {
 
-                     throw e;
 
-                 }
 
-             }
 
-             return StatusCode( HttpStatusCode.NoContent );
 
-         }
 
-         // DELETE: api/CmUserToLicense/5
 
-         [ResponseType(typeof(CmUserToLicense))]
 
-         public IHttpActionResult DeleteCmUserToLicense(int id)
 
-         {
 
-             var CmUserToLicense = db.CmUserToLicense.Find(id);
 
-             if (CmUserToLicense == null)
 
-             {
 
-                 return NotFound();
 
-             }
 
-             db.CmUserToLicense.Remove(CmUserToLicense);
 
-             db.SaveChanges();
 
-             return Ok(CmUserToLicense);
 
-         }
 
-         protected override void Dispose(bool disposing)
 
-         {
 
-             if (disposing)
 
-             {
 
-                 db.Dispose();
 
-             }
 
-             base.Dispose(disposing);
 
-         }
 
-         private bool CmUserToLicenseExists(int id)
 
-         {
 
-             return db.CmUserToLicense.Count(e => e.SiteId == id) > 0;
 
-         }
 
-     }
 
-     public class UserToLicense
 
-     {
 
-         public int SiteId { get; set; }
 
-         public string UserId { get; set; }
 
-         public int LicenseId { get; set; }
 
-     };
 
- }
 
 
  |