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));
}
