// // GET: /Test/ public string Add() { IUniversityRepository repo = new UniversityRepositoryImpl(); UNIVERSITY uni = new UNIVERSITY() { UNI_CITY = "Novi Sad", UNI_NAME = "Univerzitet u Novom Sadu" }; repo.Add(uni); return("Ok"); }
public void Delete(long id) { using (ctx = new ReadingRoomsEntities()) { UNIVERSITY entity = ctx.UNIVERSITies.Where(u => u.UNI_ID == id).FirstOrDefault(); if (CheckHelper.IsFilled(entity)) { ctx.UNIVERSITies.Remove(entity); ctx.SaveChanges(); } } }
public UNIVERSITY Update(UNIVERSITY entity) { UNIVERSITY updatedUni = null; using (ctx = new ReadingRoomsEntities()) { updatedUni = ctx.UNIVERSITies.Attach(entity); ctx.Entry(entity).State = EntityState.Modified; ctx.SaveChanges(); } return(updatedUni); }
public UNIVERSITY GetById(long id) { UNIVERSITY uni = null; using (ctx = new ReadingRoomsEntities()) { if (id > 0) { uni = ctx.UNIVERSITies .Where(u => u.UNI_ID == id) .FirstOrDefault(); } } return(uni); }
public HttpResponseMessage PostUniversity([FromBody] UNIVERSITY uni) { try { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { entities.UNIVERSITies.Add(uni); //entities.INSERT_UNIVERSITY(uni.UNIVERSITY_NAME); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, uni); message.Headers.Location = new Uri(Request.RequestUri + uni.UNIVERSITY_ID.ToString()); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public UNIVERSITY Add(UNIVERSITY entity) { UNIVERSITY insertedUni = null; if (CheckHelper.IsFilled(entity)) { using (ctx = new ReadingRoomsEntities()) { entity.UNI_ID = 1; UNIVERSITY maxUni = ctx.UNIVERSITies.OrderByDescending(u => u.UNI_ID).FirstOrDefault(); if (CheckHelper.IsFilled(maxUni)) { entity.UNI_ID = maxUni.UNI_ID + 1; } insertedUni = ctx.UNIVERSITies.Add(entity); ctx.SaveChanges(); } } return(insertedUni); }