| 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; }    };}
 |