public List <RoomItemDetailDTO> GetRoomItemDetails() { List <RoomItemDetailDTO> list = new List <RoomItemDetailDTO>(); var roomItemDetails = dbcontext.Rooms_Item_Detail.ToList(); if (roomItemDetails != null) { foreach (var item in roomItemDetails) { RoomItemDetailDTO roomItemDetailDTO = new RoomItemDetailDTO(); roomItemDetailDTO.Rooms_Item_Detail_ID = item.Rooms_Item_Detail_ID; roomItemDetailDTO.ItemDate = item.ItemDate; roomItemDetailDTO.ItemID = item.ItemID; roomItemDetailDTO.ItemQuantity = item.ItemQuantity; roomItemDetailDTO.Room_NumberID = item.Room_NumberID; roomItemDetailDTO.StoreID = item.StoreID; //Get Item NAME to display var getItemName = dbcontext.Item_Stock.Where(i => i.Item_ID == item.ItemID).FirstOrDefault(); roomItemDetailDTO.Item_Name = getItemName.Item_Name; //Get Store Name to display var getStoreName = dbcontext.Stores.Where(s => s.Store_ID == item.StoreID).FirstOrDefault(); roomItemDetailDTO.Store_Name = getStoreName.Store_Name; list.Add(roomItemDetailDTO); } //NOT Working //Get ITemNameLIST to display //roomItemDetailDTO.ItemList = dbcontext.Item_Stock.Select(i => i.Item_Name).Distinct().ToList(); } return(list); }
public void Create(RoomItemDetailDTO roomItemDetailDTO) { Rooms_Item_Detail rooms_Item_Detail = new Rooms_Item_Detail(); //rooms_Item_Detail.Rooms_Item_Detail_ID = roomItemDetailDTO.Rooms_Item_Detail_ID; rooms_Item_Detail.ItemDate = roomItemDetailDTO.ItemDate; rooms_Item_Detail.ItemID = roomItemDetailDTO.ItemID; rooms_Item_Detail.ItemQuantity = roomItemDetailDTO.ItemQuantity; rooms_Item_Detail.Room_NumberID = roomItemDetailDTO.Room_NumberID; rooms_Item_Detail.StoreID = roomItemDetailDTO.StoreID; dbcontext.Entry(rooms_Item_Detail).State = EntityState.Added; dbcontext.SaveChanges(); }
public RoomItemDetailDTO GetbyID(int id) { RoomItemDetailDTO roomItemDetailDTO = new RoomItemDetailDTO(); var roomItemDetail = dbcontext.Rooms_Item_Detail.Where(r => r.Rooms_Item_Detail_ID == id).FirstOrDefault(); if (roomItemDetail != null) { roomItemDetailDTO.Rooms_Item_Detail_ID = roomItemDetail.Rooms_Item_Detail_ID; roomItemDetailDTO.ItemDate = roomItemDetail.ItemDate; roomItemDetailDTO.ItemID = roomItemDetail.ItemID; roomItemDetailDTO.ItemQuantity = roomItemDetail.ItemQuantity; roomItemDetailDTO.Room_NumberID = roomItemDetail.Room_NumberID; roomItemDetailDTO.StoreID = roomItemDetail.StoreID; } return(roomItemDetailDTO); }
public ActionResult Create(RoomItemDetailDTO roomItemDetailDTO) { _db.Create(roomItemDetailDTO); return(RedirectToAction("Index")); }
public void Edit(RoomItemDetailDTO roomItemDetailDTO) { throw new NotImplementedException(); }
public void Create(RoomItemDetailDTO roomItemDetailDTO) { _db.Create(roomItemDetailDTO); }