public bool Save_MenuItems_tables(menuItem model)
{
using (RMSDBEntities db = new RMSDBEntities())
{
if (model.id == 0)
{
db.menuItems.Add(model);
db.SaveChanges();
return(true);
}
else if (model.id > 0)
{
menuItem RowinDb = db.menuItems.Where(d => d.id == model.id).SingleOrDefault();
RowinDb.itemName = model.itemName;
RowinDb.color = model.color;
RowinDb.Price = model.Price;
RowinDb.discountpercnt = model.discountpercnt;
RowinDb.status = model.status;
RowinDb.cat_id = model.cat_id;
RowinDb.section_id = model.section_id;
db.SaveChanges();
return(true);
}
return(false);
}
}
public bool SaveSaleDetailItems(SaleDetail model, int checkupdate)
{
using (RMSDBEntities db = new RMSDBEntities())
{
if (checkupdate == 0)
{
db.SaleDetails.Add(model);
db.SaveChanges();
return(true);
}
else
{
SaleDetail RowinDb = db.SaleDetails.Where(d => d.TicketNo == model.TicketNo && d.ItemId == model.ItemId).SingleOrDefault();
RowinDb.ItemId = model.ItemId;
RowinDb.itemName = model.itemName;
RowinDb.Price = model.Price;
RowinDb.Discount = model.Discount;
RowinDb.Quantity = model.Quantity;
RowinDb.Total = model.Total;
RowinDb.TicketNo = model.TicketNo;
RowinDb.RecordID = model.RecordID;
RowinDb.Aed_Vat = model.Aed_Vat;
RowinDb.Aed_Vat_Amount = model.Aed_Vat_Amount;
RowinDb.Date = model.Date;
db.SaveChanges();
return(true);
}
}
}
public bool SaveUser(UserTable model, int checkupdate)
{
using (RMSDBEntities db = new RMSDBEntities())
{
if (checkupdate == 0)
{
db.UserTables.Add(model);
db.SaveChanges();
return(true);
}
else
{
UserTable RowinDb = db.UserTables.Where(d => d.UserName == model.UserName).SingleOrDefault();
RowinDb.FullName = model.FullName;
RowinDb.Password = model.Password;
RowinDb.ConfirmPassword = model.ConfirmPassword;
RowinDb.IsAdmin = model.IsAdmin;
db.SaveChanges();
return(true);
}
}
}
public bool SaveCounter(section model)
{
using (RMSDBEntities db = new RMSDBEntities())
{
if (model.id == 0)
{
db.sections.Add(model);
db.SaveChanges();
return(true);
}
else if (model.id > 0)
{
section RowinDb = db.sections.Where(d => d.id == model.id).SingleOrDefault();
RowinDb.sectionname = model.sectionname;
db.SaveChanges();
return(true);
}
return(false);
}
}
public bool Save_MenuCatogery_tables(menuCategory model)
{
using (RMSDBEntities db = new RMSDBEntities())
{
if (model.id == 0)
{
db.menuCategories.Add(model);
db.SaveChanges();
return(true);
}
else if (model.id > 0)
{
menuCategory RowinDb = db.menuCategories.Where(d => d.id == model.id).SingleOrDefault();
RowinDb.name = model.name;
RowinDb.color = model.color;
db.SaveChanges();
return(true);
}
return(false);
}
}
public bool Save_DayStartTime(CashierTable model)
{
using (RMSDBEntities db = new RMSDBEntities())
{
if (model.id == 0)
{
db.CashierTables.Add(model);
db.SaveChanges();
return(true);
}
else if (model.id > 0)
{
CashierTable RowinDb = db.CashierTables.Where(d => d.CashierId == model.CashierId && d.id == model.id).SingleOrDefault();
RowinDb.EndTime = model.EndTime;
RowinDb.TotalHour = model.TotalHour;
db.SaveChanges();
return(true);
}
return(false);
}
}
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);
}
}
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_SaleRowFromSale(string s)
{
using (RMSDBEntities db = new RMSDBEntities())
{
Sale RowinDb = db.Sales.Where(d => d.TicketNo == s).SingleOrDefault();
{
RowinDb.IsDeleted = 1;
RowinDb.IsBillPending = 0;
db.SaveChanges();
return(true);
}
}
}
public bool SaveSale(Sale model, int checkupdate)
{
using (RMSDBEntities db = new RMSDBEntities())
{
// Sale RowinDb = db.Sales.Where(d => d.TicketNo == model.TicketNo).SingleOrDefault();
if (checkupdate == 0)
{
db.Sales.Add(model);
db.SaveChanges();
return(true);
}
else
{
Sale RowinDb = db.Sales.Where(d => d.TicketNo == model.TicketNo).SingleOrDefault();
RowinDb.TicketNo = model.TicketNo;
RowinDb.TableName = model.TableName;
RowinDb.CustomerName = model.CustomerName;
RowinDb.OrderType = model.OrderType;
RowinDb.Balance = model.Balance;
RowinDb.TicketNote = model.TicketNote;
RowinDb.IsDeleted = model.IsDeleted;
RowinDb.PhoneNumber = model.PhoneNumber;
RowinDb.DeliveryAddress = model.DeliveryAddress;
RowinDb.IsBillPending = model.IsBillPending;
RowinDb.NumberOfPerson = model.NumberOfPerson;
RowinDb.ReceivedAmount = model.ReceivedAmount;
RowinDb.RemainingBalance = model.RemainingBalance;
RowinDb.cashier_id = model.cashier_id;
RowinDb.Cahier_Name = model.Cahier_Name;
RowinDb.IsRefund = model.IsRefund;
db.SaveChanges();
return(true);
}
}
}
public bool SaveSaleReceivedBalanceGen(string tn, double Received, double balance)
{
using (RMSDBEntities db = new RMSDBEntities())
{
{
Sale RowinDb = db.Sales.Where(d => d.TicketNo == tn).SingleOrDefault();
RowinDb.ReceivedAmount = Received;
RowinDb.RemainingBalance = balance;
db.SaveChanges();
return(true);
}
}
}
public bool Delete_MenuCatogery_tables(int id)
{
using (RMSDBEntities db = new RMSDBEntities())
{
if (id > 0)
{
menuCategory RowinDb = db.menuCategories.Where(d => d.id == id).SingleOrDefault();
if (RowinDb != null)
{
db.menuCategories.Remove(RowinDb);
db.SaveChanges();
}
}
}
return(true);
}
public bool DeleteCounter(int id)
{
using (RMSDBEntities db = new RMSDBEntities())
{
if (id > 0)
{
section RowinDb = db.sections.Where(d => d.id == id).SingleOrDefault();
if (RowinDb != null)
{
db.sections.Remove(RowinDb);
db.SaveChanges();
return(true);
}
return(false);
}
return(false);
}
}
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 Delete_SaleItemFromSaleDetail(int id)
{
using (RMSDBEntities db = new RMSDBEntities())
{
if (id != 0)
{
SaleDetail RowinDb = db.SaleDetails.Where(d => d.RecordID == id).SingleOrDefault();
{
db.SaleDetails.Remove(RowinDb);
db.SaveChanges();
return(true);
}
}
else
{
return(false);
}
}
}
