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