public IHttpActionResult Put(Users value) { using (ezbookdatabaseContext db = new ezbookdatabaseContext()) { var entity = db.Users.FirstOrDefault(e => e.UsersId == value.UsersId); entity.Names = value.Names; entity.Passwords = value.Passwords; entity.Email = value.Email; entity.Department = value.Department; entity.Nationality = value.Nationality; entity.Profilepic = value.Profilepic; entity.Code = value.Code; db.SaveChanges(); } try { string message = "Added"; return(Ok(message)); } catch (Exception ex) { string message = "Add Fail" + ex.Message; return(Ok(message)); } }
public IHttpActionResult Get() { List <Booking> bookingList = new List <Booking>(); using (ezbookdatabaseContext db = new ezbookdatabaseContext()) { List <cancelbooking> BookingList = (from b in db.Users join c in db.Booking on b.UsersId equals c.UsersId where (c.Status == "Approve") orderby(c.BookingId) descending select new cancelbooking { BookingId = c.BookingId, UsersId = b.UsersId, RoomId = c.RoomId, Name = c.Name, Title = c.Title, Location = c.Location, Date = c.Date, Time = c.Time, Status = c.Status, Username = b.Names }).ToList(); return(Ok(BookingList)); } }
public IHttpActionResult Get() { List <schedule> schedulelists = new List <schedule>(); using (ezbookdatabaseContext db = new ezbookdatabaseContext()) { List <schedule> schedulelist = (from b in db.Users join c in db.Booking on b.UsersId equals c.UsersId join e in db.Room on c.RoomId equals e.RoomId where (c.Status == "Approve") select new schedule { Roompic = e.Image, BookingId = c.BookingId, UsersId = b.UsersId, RoomId = c.RoomId, Name = c.Name, Title = c.Title, Location = c.Location, Date = c.Date, Time = c.Time, Status = c.Status, Username = b.Names }).ToList(); return(Ok(schedulelist)); } }
public IHttpActionResult Get() { using (ezbookdatabaseContext db = new ezbookdatabaseContext()) { List <BookingAppilcation> BookingApplicationList = (from d in db.Booking join e in db.Users on d.UsersId equals e.UsersId where (d.Status == "New") select new BookingAppilcation { Username = e.Names, BookingId = d.BookingId, UserId = d.UsersId, RoomName = d.Name, Title = d.Title, Status = d.Status, Location = d.Location, Time = d.Time, Date = d.Date, }).ToList(); return(Ok(BookingApplicationList)); } }
public IHttpActionResult Get() { using (ezbookdatabaseContext db = new ezbookdatabaseContext()) { List <Data> CancellationList = (from c in db.Cancellation join d in db.Booking on c.BookingId equals d.BookingId join e in db.Users on d.UsersId equals e.UsersId where (c.Status == "New") select new Data { Username = e.Names, CancelId = c.CancellationId, BookingId = d.BookingId, RoomName = d.Name, Title = d.Title, Status = c.Status, Reason = c.Reason, Location = d.Location, Time = d.Time, Date = d.Date, }).ToList(); return(Ok(CancellationList)); } }
public IHttpActionResult Get() { List <Booking> bookingList = new List <Booking>(); using (ezbookdatabaseContext db = new ezbookdatabaseContext()) { bookingList = db.Booking.ToList(); return(Ok(bookingList)); } }
public IHttpActionResult Get() { List <Booking> bookingList = new List <Booking>(); using (ezbookdatabaseContext db = new ezbookdatabaseContext()) { bookingList = db.Booking.Where(a => a.Status == "Approve").OrderBy(a => a.BookingId).ToList(); return(Ok(bookingList)); } }
public IHttpActionResult Get() { List <Cancellation> cancelList = new List <Cancellation>(); using (ezbookdatabaseContext db = new ezbookdatabaseContext()) { cancelList = db.Cancellation.Where(a => a.Status == "New").OrderBy(a => a.CancellationId).ToList(); return(Ok(cancelList)); } }
public IHttpActionResult Get() { using (ezbookdatabaseContext db = new ezbookdatabaseContext()) { List <UserData> User = (from u in db.Users select new UserData { UsersId = u.UsersId, Names = u.Names, Passwords = u.Passwords, Email = u.Email, Department = u.Department, StartDate = u.StartDate, Nationality = u.Nationality, Position = u.Position, Code = u.Code, Profilepic = u.Profilepic, }).ToList(); return(Ok(User)); } }