public RESERVATION Add(RESERVATION entity)
{
RESERVATION insertedReservation = null;
if (CheckHelper.IsFilled(entity))
{
using (ctx = new ReadingRoomsEntities())
{
entity.RES_ID = 1;
RESERVATION maxReservation = ctx.RESERVATIONs.OrderByDescending(s => s.RES_ID).FirstOrDefault();
if (CheckHelper.IsFilled(maxReservation))
{
entity.RES_ID = maxReservation.RES_ID + 1;
}
if (CheckHelper.IsFilled(entity.SEATs))
{
foreach (SEAT seat in entity.SEATs)
{
ctx.Entry(seat).State = EntityState.Unchanged;
}
}
insertedReservation = ctx.RESERVATIONs.Add(entity);
ctx.SaveChanges();
}
}
return(insertedReservation);
}
public void Delete(long id)
{
using (ctx = new ReadingRoomsEntities())
{
USER entity = ctx.USERs.Where(f => f.USR_ID == id).FirstOrDefault();
if (CheckHelper.IsFilled(entity))
{
ctx.USERs.Remove(entity);
ctx.SaveChanges();
}
}
}
public void Delete(long id)
{
using (ctx = new ReadingRoomsEntities())
{
READING_ROOM entity = ctx.READING_ROOM.Where(f => f.RROOM_ID == id).FirstOrDefault();
if (CheckHelper.IsFilled(entity))
{
ctx.READING_ROOM.Remove(entity);
ctx.SaveChanges();
}
}
}
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 void Delete(long id)
{
using (ctx = new ReadingRoomsEntities())
{
RESERVATION entity = ctx.RESERVATIONs.Where(s => s.RES_ID == id).FirstOrDefault();
if (CheckHelper.IsFilled(entity))
{
ctx.RESERVATIONs.Remove(entity);
ctx.SaveChanges();
}
}
}
public USER Update(USER entity)
{
USER updatedUser = null;
using (ctx = new ReadingRoomsEntities())
{
updatedUser = ctx.USERs.Attach(entity);
ctx.Entry(entity).State = EntityState.Modified;
ctx.SaveChanges();
}
return(updatedUser);
}
public READING_ROOM Update(READING_ROOM entity)
{
READING_ROOM updatedReadingRoom = null;
using (ctx = new ReadingRoomsEntities())
{
updatedReadingRoom = ctx.READING_ROOM.Attach(entity);
ctx.Entry(entity).State = EntityState.Modified;
ctx.SaveChanges();
}
return(updatedReadingRoom);
}
public SEAT Update(SEAT entity)
{
SEAT updatedSeat = null;
using (ctx = new ReadingRoomsEntities())
{
updatedSeat = ctx.SEATs.Attach(entity);
ctx.Entry(entity).State = EntityState.Modified;
ctx.SaveChanges();
}
return(updatedSeat);
}
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 FACULTY Update(FACULTY entity)
{
FACULTY updatedFaculty = null;
using (ctx = new ReadingRoomsEntities())
{
updatedFaculty = ctx.FACULTies.Attach(entity);
ctx.Entry(entity).State = EntityState.Modified;
ctx.SaveChanges();
}
return(updatedFaculty);
}
public RESERVATION Update(RESERVATION entity)
{
RESERVATION updatedReservation = null;
using (ctx = new ReadingRoomsEntities())
{
updatedReservation = ctx.RESERVATIONs.Attach(entity);
ctx.Entry(entity).State = EntityState.Modified;
ctx.SaveChanges();
}
return(updatedReservation);
}
public USER Add(USER entity)
{
USER insertedUser = null;
if (CheckHelper.IsFilled(entity))
{
using (ctx = new ReadingRoomsEntities())
{
entity.USR_ID = 1;
USER maxUser = ctx.USERs.OrderByDescending(f => f.USR_ID).FirstOrDefault();
if (CheckHelper.IsFilled(maxUser))
{
entity.USR_ID = maxUser.USR_ID + 1;
}
insertedUser = ctx.USERs.Add(entity);
ctx.SaveChanges();
}
}
return(insertedUser);
}
public READING_ROOM Add(READING_ROOM entity)
{
READING_ROOM insertedReadingRoom = null;
if (CheckHelper.IsFilled(entity))
{
using (ctx = new ReadingRoomsEntities())
{
entity.RROOM_ID = 1;
READING_ROOM maxReadingRoom = ctx.READING_ROOM.OrderByDescending(f => f.RROOM_ID).FirstOrDefault();
if (CheckHelper.IsFilled(maxReadingRoom))
{
entity.RROOM_ID = maxReadingRoom.RROOM_ID + 1;
}
insertedReadingRoom = ctx.READING_ROOM.Add(entity);
ctx.SaveChanges();
}
}
return(insertedReadingRoom);
}
public SEAT Add(SEAT entity)
{
SEAT insertedSeat = null;
if (CheckHelper.IsFilled(entity))
{
using (ctx = new ReadingRoomsEntities())
{
entity.SEAT_ID = 1;
SEAT maxSeat = ctx.SEATs.OrderByDescending(s => s.SEAT_ID).FirstOrDefault();
if (CheckHelper.IsFilled(maxSeat))
{
entity.SEAT_ID = maxSeat.SEAT_ID + 1;
}
insertedSeat = ctx.SEATs.Add(entity);
ctx.SaveChanges();
}
}
return(insertedSeat);
}
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);
}
public FACULTY Add(FACULTY entity)
{
FACULTY insertedFaculty = null;
if (CheckHelper.IsFilled(entity))
{
using (ctx = new ReadingRoomsEntities())
{
entity.FAC_ID = 1;
FACULTY maxFaculty = ctx.FACULTies.OrderByDescending(f => f.FAC_ID).FirstOrDefault();
if (CheckHelper.IsFilled(maxFaculty))
{
entity.FAC_ID = maxFaculty.FAC_ID + 1;
}
insertedFaculty = ctx.FACULTies.Add(entity);
ctx.SaveChanges();
}
}
return(insertedFaculty);
}