public IEnumerable <RoomCustomerViewModel> GetAll() { List <RoomCustomerViewModel> Room = new List <RoomCustomerViewModel>(); foreach (var item in db.CustomerRooms) { RoomCustomerViewModel obj = new RoomCustomerViewModel(); obj.id = item.id; obj.EndData = item.EndData; Room.Add(obj); } return(Room); }
public JsonResult CustomerRoom(RoomCustomerViewModel RoomCustomer) { int A = RC.Add(RoomCustomer); TempData["Roomcustomerid"] = A; if (A != 0) { return(Json("success", JsonRequestBehavior.AllowGet)); } else { return(Json("success", JsonRequestBehavior.AllowGet)); } }
public IEnumerable <RoomCustomerViewModel> GtById(int id) { List <RoomCustomerViewModel> RoomCustomer = new List <RoomCustomerViewModel>(); foreach (var item in db.CustomerRooms.Where(x => x.CustomerIdfk == id)) { RoomCustomerViewModel obj = new RoomCustomerViewModel(); obj.id = item.id; obj.CustomerIdfk = item.CustomerIdfk; obj.Name = item.Customer.CustomerName; obj.startDate = item.startDate.ToString(); obj.EndData = item.EndData.ToString(); obj.RoomName = item.Room.RoomNo; RoomCustomer.Add(obj); } return(RoomCustomer); }
// GET: Rooms/Details/5 public async Task <IActionResult> Details(int?id, int?customerid) { if (id == null) { return(NotFound()); } var room = await _context.Room .Include(r => r.RoomStatus) .Include(r => r.RoomType) .FirstOrDefaultAsync(m => m.RoomId == id); if (room == null) { return(NotFound()); } Customer customer = null; if (customerid != null) { customer = await _context.Customer .FirstOrDefaultAsync(m => m.CustomerId == customerid); } if (room == null) { return(NotFound()); } var roomCustomerVM = new RoomCustomerViewModel { Room = room, Customer = customer }; return(View(roomCustomerVM)); }
public int Add(RoomCustomerViewModel RoomCustomer) { var roomid = db.CustomerRooms.Where(x => x.RoomIdfk == RoomCustomer.RoomIdfk).FirstOrDefault(); if (roomid != null) { return(0); } else { CustomerRoom obj = new CustomerRoom(); obj.id = RoomCustomer.id; obj.CustomerIdfk = RoomCustomer.CustomerIdfk; obj.startDate = RoomCustomer.startDate; obj.EndData = RoomCustomer.EndData; obj.RoomIdfk = RoomCustomer.RoomIdfk; db.CustomerRooms.Add(obj); obj.IsPase = true; db.SaveChanges(); return(RoomCustomer.id); } }