public TableManagementModel getTableByID(int id) { try { var query = posDatabase.TableManagements.Where(x => x.Id == id).FirstOrDefault(); TableManagementModel model = new TableManagementModel(); if (query != null) { model.id = query.Id; model.NoOfChair = (int)query.NoOfChair; model.RoomId = (int)query.RoomId; model.TableNo = (int)query.TableNo; } return(model); } catch (Exception e) { throw e; } }
public List <TableManagementModel> GetItemDetail() { try { List <TableManagementModel> tableManagementModels = new List <TableManagementModel>(); var qurey = posDatabase.TableManagements.ToList(); foreach (var item in qurey) { TableManagementModel tableManagement = new TableManagementModel(); tableManagement.id = item.Id; tableManagement.NoOfChair = (int)item.NoOfChair; tableManagement.TableNo = (int)item.TableNo; tableManagement.RoomId = (int)item.RoomId; tableManagementModels.Add(tableManagement); } return(tableManagementModels); } catch (Exception e) { throw e; } }
public List <TableManagementModel> getTableByRoomID(int id) { try { List <TableManagementModel> tableData = new List <TableManagementModel>(); var data = posDatabase.TableManagements.Where(x => x.RoomId == id).ToList(); if (data.Count() > 0) { foreach (var item in data) { TableManagementModel listing = new TableManagementModel(); listing.id = item.Id; listing.NoOfChair = (int)item.NoOfChair; listing.RoomId = (int)item.RoomId; listing.TableNo = (int)item.TableNo; tableData.Add(listing); } var query = posDatabase.Orders.Where(x => x.IsPaid == false).ToList(); if (query.Count > 0) { foreach (var item in query) { var da = tableData.Where(x => x.id == item.TableNo).FirstOrDefault(); if (da != null) { da.orderid = item.Id; } } } } return(tableData); } catch (Exception e) { throw e; } }
public bool InsertTable(TableManagementModel tableManagementModel) { try { if (tableManagementModel.id > 0) { TableManagement table = posDatabase.TableManagements.Where(x => x.Id == tableManagementModel.id).FirstOrDefault(); if (table == null) { return(false); } else { table.NoOfChair = tableManagementModel.NoOfChair; table.TableNo = tableManagementModel.TableNo; table.RoomId = tableManagementModel.RoomId; posDatabase.SaveChanges(); return(true); } } else { TableManagement table = new TableManagement(); table.NoOfChair = tableManagementModel.NoOfChair; table.TableNo = tableManagementModel.TableNo; table.RoomId = tableManagementModel.RoomId; posDatabase.TableManagements.Add(table); posDatabase.SaveChanges(); return(true); } } catch (Exception) { throw; } }
public IHttpActionResult insertTable(TableManagementModel tableManagementModel) { var Data = Table.InsertTable(tableManagementModel); return(Json(Data)); }