public bool remove_filled(string rid, int filled)
{
using (RMSDBEntities db = new RMSDBEntities())
{
R_Tables RowinDb = db.R_Tables.Where(d => d.Name == rid).SingleOrDefault();
{
RowinDb.filled = Convert.ToInt32(RowinDb.filled) - (filled);
db.SaveChanges();
return(true);
}
}
}
public bool Delete_R_tables(int id)
{
using (RMSDBEntities db = new RMSDBEntities())
{
if (id > 0)
{
R_Tables RowinDb = db.R_Tables.Where(d => d.id == id).SingleOrDefault();
if (RowinDb != null)
{
db.R_Tables.Remove(RowinDb);
db.SaveChanges();
return(true);
}
return(false);
}
return(false);
}
}
public bool SaveSaleReceivedBalance(string tn, double Received, double balance, int person, string tablename)
{
using (RMSDBEntities db = new RMSDBEntities())
{
{
Sale RowinDb = db.Sales.Where(d => d.TicketNo == tn).SingleOrDefault();
RowinDb.IsBillPending = 0;
RowinDb.ReceivedAmount = Received;
RowinDb.RemainingBalance = balance;
R_Tables RowinDb1 = db.R_Tables.Where(d => d.Name == tablename).SingleOrDefault();
RowinDb1.filled = Convert.ToInt32(RowinDb1.filled) - person;
db.SaveChanges();
return(true);
}
}
}
public bool Save_R_tables(R_Tables model)
{
using (RMSDBEntities db = new RMSDBEntities())
{
if (model.id == 0)
{
db.R_Tables.Add(model);
db.SaveChanges();
return(true);
}
else if (model.id > 0)
{
R_Tables RowinDb = db.R_Tables.Where(d => d.id == model.id).SingleOrDefault();
RowinDb.Name = model.Name;
RowinDb.capacity = model.capacity;
RowinDb.status = model.status;
db.SaveChanges();
return(true);
}
return(false);
}
}
