public Int32 SavePayment(Payment payment, PaymentCC paymentCC, Int32 UserId)
{
Payment queryPayment;
PaymentCC queryPaymentCC;
try {
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
queryPayment = new Payment();
queryPayment.CheckId = payment.CheckId;
queryPayment.Type = payment.Type;
queryPayment.Amount = payment.Amount;
queryPayment.UserId = UserId;
db.Payments.InsertOnSubmit(queryPayment);
db.SubmitChanges();
if (paymentCC != null)
{
queryPaymentCC = new PaymentCC();
queryPaymentCC.PaymentId = queryPayment.id;
queryPaymentCC.FirstName = paymentCC.FirstName;
queryPaymentCC.LastName = paymentCC.LastName;
queryPaymentCC.Number = paymentCC.Number;
queryPaymentCC.ExpiredMonth = paymentCC.ExpiredMonth;
queryPaymentCC.ExpiredYear = paymentCC.ExpiredYear;
db.PaymentCCs.InsertOnSubmit(queryPaymentCC);
db.SubmitChanges();
}
}
}
catch (Exception ex) {
return(0);
}
return(queryPayment.id);
}
public Int32 SaveMenu(Menus menu)
{
Menus query = new Menus();
try {
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
if (menu.id != 0)
{
query = db.Menus.Where(m => m.id == menu.id).FirstOrDefault();
}
if (query != default(Menus))
{
query.CustomerId = menu.CustomerId;
query.Name = menu.Name;
query.Description = menu.Description;
}
if (menu.id == 0)
{
db.Menus.InsertOnSubmit(query);
}
db.SubmitChanges();
}
}
catch (Exception ex) {
return(0);
}
return(query.id);
}
public Boolean DeleteMenu(Int32?id)
{
Menus query = new Menus();
id = id.HasValue ? id : 0;
try {
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
query = db.Menus.Where(m => m.id == id).FirstOrDefault();
if (query != default(Menus))
{
IEnumerable <MenuItem> menuItems = db.MenuItems.Where(m => m.MenuId == id);
if (menuItems != null)
{
db.MenuItems.DeleteAllOnSubmit(menuItems);
}
db.Menus.DeleteOnSubmit(query);
db.SubmitChanges();
}
}
}
catch (Exception ex) {
return(false);
}
return(true);
}
public Int32 SaveAlert(Alert alert)
{
Alert query;
try {
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
query = db.Alerts.FirstOrDefault(m => m.id == alert.id);
if (query == default(Alert))
{
query = new Alert();
}
query.CheckMenuId = alert.CheckMenuId;
query.Type = alert.Type;
query.Status = alert.Status;
if (alert.id == 0)
{
db.Alerts.InsertOnSubmit(query);
}
db.SubmitChanges();
}
}
catch (Exception ex) {
return(0);
}
return(query.id);
}
public Int32 SaveFloor(Floor floor)
{
Floor query = new Floor();
try {
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
if (floor.id != 0)
{
query = db.Floors.FirstOrDefault(m => m.id == floor.id);
}
if (query != default(Floor))
{
query.CustomerId = floor.CustomerId;
query.Name = floor.Name;
query.Description = floor.Description;
query.Height = floor.Height;
query.Width = floor.Width;
}
if (floor.id == 0)
{
db.Floors.InsertOnSubmit(query);
}
db.SubmitChanges();
}
}
catch (Exception ex) {
return(0);
}
return(query.id);
}
public Boolean DeleteItemProduct(Int32?id)
{
ItemProduct itemProduct = new ItemProduct();
IEnumerable <ItemProductAssociation> itemProductAssocoation;;
id = id.HasValue ? id : 0;
try {
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
itemProductAssocoation = db.ItemProductAssociations.Where(m => m.ItemProductId == id);
if (itemProductAssocoation != default(ItemProductAssociation))
{
db.ItemProductAssociations.DeleteAllOnSubmit(itemProductAssocoation);
}
itemProduct = db.ItemProducts.Where(m => m.id == id).FirstOrDefault();
if (itemProduct != default(ItemProduct))
{
db.ItemProducts.DeleteOnSubmit(itemProduct);
}
db.SubmitChanges();
}
}
catch (Exception ex) {
return(false);
}
return(true);
}
public Boolean DeleteFloor(Int32?id)
{
Floor query = new Floor();
id = id.HasValue ? id : 0;
try {
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
query = db.Floors.FirstOrDefault(m => m.id == id);
if (query != default(Floor))
{
IEnumerable <Table> tables = db.Tables.Where(m => m.FloorId == id);
if (tables != null)
{
db.Tables.DeleteAllOnSubmit(tables);
}
db.Floors.DeleteOnSubmit(query);
db.SubmitChanges();
}
}
}
catch (Exception ex) {
return(false);
}
return(true);
}
public Boolean DeleteMenu(Int32 id)
{
ItemService _itemService = new ItemService();
InventoryService _inventoryService = new InventoryService();
try {
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
ChecksMenu menuItem = db.ChecksMenus.FirstOrDefault(m => m.id == id);
if (menuItem != default(ChecksMenu))
{
db.ChecksMenus.DeleteOnSubmit(menuItem);
IEnumerable <ChecksMenuProduct> products = db.ChecksMenuProducts.Where(m => m.CheckMenuId == id);
if (products.Any())
{
db.ChecksMenuProducts.DeleteAllOnSubmit(products);
foreach (ChecksMenuProduct product in products)
{
IEnumerable <ChecksMenuProductItem> items = db.ChecksMenuProductItems.Where(m => m.ProductId == product.id);
db.ChecksMenuProductItems.DeleteAllOnSubmit(items);
}
}
}
db.SubmitChanges();
}
}
catch (Exception ex) {
return(false);
}
return(true);
}
public Boolean SaveInventoryAssociation(ItemInventoryAssociation item)
{
ItemInventoryAssociation itemQuery = new ItemInventoryAssociation();
try {
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
if (item.id != 0)
{
itemQuery = db.ItemInventoryAssociations.Where(m => m.id == item.id).FirstOrDefault();
}
if (itemQuery != default(ItemInventoryAssociation))
{
itemQuery.ItemInventoryId = item.ItemInventoryId;
itemQuery.AssociatedItemId = item.AssociatedItemId;
itemQuery.Quantity = item.Quantity;
}
if (item.id == 0)
{
db.ItemInventoryAssociations.InsertOnSubmit(itemQuery);
}
db.SubmitChanges();
}
}
catch (Exception ex) {
return(false);
}
return(true);
}
public void UpdateModules(Int32 id, Int32 moduleId)
{
CustomerModule query;
try {
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
// Negative - stops service by ending it as of today
if (moduleId < 0)
{
query = db.CustomerModules.Where(m => m.CustomerId == id && m.ModulePriceId == Math.Abs(moduleId) && m.EndDate == null).FirstOrDefault();
if (query != default(CustomerModule))
{
query.EndDate = DateTime.Now.Date;
}
}
// Positive - inserts
else if (moduleId > 0)
{
query = new CustomerModule();
query.CustomerId = id;
query.ModulePriceId = moduleId;
db.CustomerModules.InsertOnSubmit(query);
}
else if (moduleId == 0)
{
}
db.SubmitChanges();
}
}
catch (Exception ex) {
throw ex;
}
return;
}
public Boolean DeletePayment(Int32 id)
{
PaymentCC cards = null;
Payment payments = null;
try {
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
cards = db.PaymentCCs.Where(m => m.PaymentId == id).FirstOrDefault();
if (cards != null)
{
db.PaymentCCs.DeleteOnSubmit(cards);
}
payments = db.Payments.Where(m => m.id == id).FirstOrDefault();
if (payments != null)
{
db.Payments.DeleteOnSubmit(payments);
}
db.SubmitChanges();
}
}
catch (Exception ex) {
return(false);
}
return(true);
}
public Boolean SaveMenuItems(List <MenuItem> model)
{
MenuItem query = new MenuItem();
MenuItem toDelete;
IEnumerable <Int32> itemsToDelete;
if (model == null)
{
return(false);
}
try {
query = model[0];
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
// Deleting
itemsToDelete = db.MenuItems.Where(m => m.MenuId == query.MenuId).Select(m => m.ItemId).Where(m => !model.Select(x => x.ItemId).Contains(m));
if (itemsToDelete.Any())
{
foreach (Int32 item in itemsToDelete)
{
toDelete = db.MenuItems.Where(m => m.MenuId == query.MenuId && m.ItemId == item).FirstOrDefault();
db.MenuItems.DeleteOnSubmit(toDelete);
}
db.SubmitChanges();
}
//Saving
foreach (MenuItem item in model)
{
query = db.MenuItems.Where(m => m.MenuId == item.MenuId && m.ItemId == item.ItemId).FirstOrDefault();
if (query == default(MenuItem))
{
query = new MenuItem();
query.MenuId = item.MenuId;
query.ItemId = item.ItemId;
db.MenuItems.InsertOnSubmit(query);
}
}
db.SubmitChanges();
}
}
catch (Exception ex) {
return(false);
}
return(true);
}
public Boolean SaveTables(List <Table> tables, Int32 floorId)
{
Table table;
IEnumerable <Table> tablesToDelete;
try {
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
tablesToDelete = db.Tables.Where(m => m.FloorId == floorId && !tables.Contains(m));
if (tablesToDelete.Any())
{
db.Tables.DeleteAllOnSubmit(tablesToDelete);
db.SubmitChanges();
}
if (tables.Any())
{
foreach (Table t in tables)
{
table = new Table();
if (t.id != 0)
{
table = db.Tables.FirstOrDefault(m => m.id == t.id);
}
table.Top = t.Top;
table.FloorId = floorId;
table.Name = t.Name;
table.Left = t.Left;
table.Status = (Int32)CommonUnit.Status.Active;
table.Type = t.Type;
table.Width = t.Width;
table.Height = t.Height;
if (t.id == 0)
{
db.Tables.InsertOnSubmit(table);
}
db.SubmitChanges();
}
}
}
}
catch (Exception ex) {
return(false);
}
return(true);
}
public Int32 SaveUser(User user)
{
User query = new User();
try {
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
if (user.id != 0)
{
query = db.Users.Where(m => m.id == user.id).FirstOrDefault();
}
if (query != default(User))
{
query.CustomerId = user.CustomerId;
query.Active = user.Active;
query.FirstName = user.FirstName;
query.LastName = user.LastName;
query.MobilePhone = user.MobilePhone;
query.WorkPhone = user.WorkPhone;
query.Email = user.Email;
query.Password = user.Password;
query.ImageUrl = user.ImageUrl;
query.Type = user.Type;
query.Hash = user.Hash;
}
if (user.id == 0)
{
db.Users.InsertOnSubmit(query);
}
db.SubmitChanges();
// Update ImageName for new user
if (user.id == 0 && query.ImageUrl != null)
{
query.ImageUrl = String.Format("{0}{1}", query.id, user.ImageUrl);
db.SubmitChanges();
}
}
}
catch (Exception ex) {
return(0);
}
return(query.id);
}
public Int32 SaveItem(Item item)
{
Item query = new Item();
try {
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
if (item.id != 0)
{
query = db.Items.Where(m => m.id == item.id).FirstOrDefault();
}
if (query != default(Item))
{
query.CategoryId = item.CategoryId;
query.Status = item.Status;
query.Name = item.Name;
query.Description = item.Description;
query.ImageUrl = item.ImageUrl;
query.UOM = item.UOM;
}
if (item.id == 0)
{
db.Items.InsertOnSubmit(query);
}
db.SubmitChanges();
// Update ImageName for new category
if (item.id == 0 && query.ImageUrl != null)
{
query.ImageUrl = String.Format("{0}{1}", query.id, item.ImageUrl);
db.SubmitChanges();
}
}
}
catch (Exception ex) {
return(0);
}
return(query.id);
}
public Int32 SaveCategory(Category category)
{
Category query = new Category();
try {
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
if (category.id != 0)
{
query = db.Categories.Where(m => m.id == category.id && m.Status != (Int32)CommonUnit.Status.NotActive).FirstOrDefault();
}
if (query != default(Category))
{
query.Status = category.Status;
query.CustomerId = category.CustomerId;
query.Name = category.Name;
query.Description = category.Description;
query.ImageUrl = category.ImageUrl;
query.Type = category.Type;
}
if (category.id == 0)
{
db.Categories.InsertOnSubmit(query);
}
db.SubmitChanges();
// Update ImageName for new category
if (category.id == 0 && query.ImageUrl != null)
{
query.ImageUrl = String.Format("{0}{1}", query.id, category.ImageUrl);
db.SubmitChanges();
}
}
}
catch (Exception ex) {
return(0);
}
return(query.id);
}
public Boolean SaveItemProduct(ItemProduct item)
{
ItemProduct itemQuery = new ItemProduct();
try {
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
if (item.id != 0)
{
itemQuery = db.ItemProducts.Where(m => m.id == item.id).FirstOrDefault();
}
if (itemQuery != default(ItemProduct))
{
itemQuery.id = item.id;
itemQuery.Type = item.Type;
itemQuery.ItemId = item.ItemId;
}
if (item.id == 0)
{
db.ItemProducts.InsertOnSubmit(itemQuery);
}
db.SubmitChanges();
DeleteItemProductAssociations(itemQuery.id);
foreach (ItemProductAssociation ipa in item.ItemProductAssociations)
{
ItemProductAssociation itemsQuery = new ItemProductAssociation();
itemsQuery.ItemProductId = itemQuery.id;
itemsQuery.ItemId = ipa.ItemId;
db.ItemProductAssociations.InsertOnSubmit(itemsQuery);
}
db.SubmitChanges();
}
}
catch (Exception ex) {
return(false);
}
return(true);
}
public User Confirm(String hash)
{
try {
menuzRusDataContext db = new menuzRusDataContext(base.connectionString);
user = db.Users.Where(m => m.Hash == hash).FirstOrDefault();
if (user != default(User))
{
user.Active = true;
user.EmailConfirmed = true;
db.SubmitChanges();
}
}
catch (Exception ex) {
return(null);
}
return(user);
}
public Boolean DeleteItemProductAssociations(Int32 id)
{
try {
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
IEnumerable <ItemProductAssociation> query = db.ItemProductAssociations.Where(m => m.ItemProductId == id);
if (query != default(ItemProductAssociation))
{
db.ItemProductAssociations.DeleteAllOnSubmit(query);
}
db.SubmitChanges();
}
}
catch (Exception ex) {
return(false);
}
return(true);
}
public Int32 SaveComment(Int32 id, Int32 parentId, CommonUnit.CommentType type)
{
CheckMenuComment query = new CheckMenuComment();
try {
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
query.Type = (Int32)type;
query.ParentId = parentId;
query.CommentId = id;
db.CheckMenuComments.InsertOnSubmit(query);
db.SubmitChanges();
}
}
catch (Exception ex) {
}
return(query.id);
}
public void UpdateMenuItemStatus(Int32 id, CommonUnit.MenuItemStatus status)
{
try {
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
ChecksMenu menuItem = db.ChecksMenus.FirstOrDefault(m => m.id == id);
if (menuItem != default(ChecksMenu))
{
menuItem.Status = (Int32)status;
db.SubmitChanges();
}
}
}
catch (Exception ex) {
}
finally {
}
}
public Boolean AddItemPrice(Int32 id, Decimal price)
{
ItemPrice query = new ItemPrice();
try {
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
query.Price = price;
query.ItemId = id;
db.ItemPrices.InsertOnSubmit(query);
db.SubmitChanges();
}
}
catch (Exception ex) {
return(false);
}
return(true);
}
public Int32 Save(String commentText, Int32 customerId)
{
Comment query = new Comment();
try {
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
query.CommentText = commentText;
query.CustomerId = customerId;
query.DateModified = DateTime.UtcNow;
db.Comments.InsertOnSubmit(query);
db.SubmitChanges();
}
}
catch (Exception ex) {
}
return(query.id);
}
public Boolean UpdateCheckType(Int32 checkId, CommonUnit.CheckType type)
{
Check query = new Check();
if (checkId != 0)
{
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
query = db.Checks.FirstOrDefault(m => m.id == checkId);
if (query != default(Check))
{
query.Type = (Int32)type;
db.SubmitChanges();
return(true);
}
}
}
return(false);
}
public Boolean UpdateKitchenOrderPrintStatus(Int32 id)
{
Printout query = new Printout();
if (id != 0)
{
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
query = db.Printouts.FirstOrDefault(m => m.id == id);
if (query != default(Printout))
{
query.Status = (Int32)CommonUnit.PrintStatus.Printed;
db.SubmitChanges();
return(true);
}
}
}
return(false);
}
public Boolean DeleteComment(Int32 id, Int32 parentId, CommonUnit.CommentType type)
{
CheckMenuComment query;
try {
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
query = db.CheckMenuComments.FirstOrDefault(m => m.CommentId == id && m.ParentId == parentId && m.Type == (Int32)type);
if (query != default(CheckMenuComment))
{
db.CheckMenuComments.DeleteOnSubmit(query);
db.SubmitChanges();
}
}
}
catch (Exception ex) {
return(false);
}
return(true);
}
private void SendToLogger(CommonUnit.LogType type, Int32 userId, String sessionId, String trace, String route, params Object[] data)
{
try {
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
Log log = new Log();
log.IP = CommonUnit.GetIP();
log.LogType = (Int32)type;
log.UserId = userId;
log.SessionId = sessionId != null ? sessionId : "N/A";
log.Trace = String.Format("{0}{1}", trace, BuildParameters(data));
log.Route = route;
db.Logs.InsertOnSubmit(log);
db.SubmitChanges();
}
}
catch (Exception ex) {
throw ex;
}
}
public Boolean DeleteInventoryAssociation(Int32 id)
{
ItemInventoryAssociation item = new ItemInventoryAssociation();
try {
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
item = db.ItemInventoryAssociations.Where(m => m.id == id).FirstOrDefault();
if (item != default(ItemInventoryAssociation))
{
db.ItemInventoryAssociations.DeleteOnSubmit(item);
db.SubmitChanges();
}
}
}
catch (Exception ex) {
return(false);
}
return(true);
}
public Boolean UpdateTableStatus(Int32 tableOrderId, CommonUnit.TableOrderStatus status)
{
TableOrder query = new TableOrder();
if (tableOrderId != 0)
{
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
query = db.TableOrders.FirstOrDefault(m => m.id == tableOrderId);
if (query != default(TableOrder))
{
query.Status = (Int32)status;
db.SubmitChanges();
return(true);
}
}
}
return(false);
}
public void SaveModulesByCustomer(Int32 id, Int32[] modulesIds)
{
try {
using (menuzRusDataContext db = new menuzRusDataContext(base.connectionString)) {
CustomerModule customerModule = new CustomerModule();
customerModule.CustomerId = id;
foreach (Int32 priceId in modulesIds)
{
customerModule.ModulePriceId = priceId;
db.CustomerModules.InsertOnSubmit(customerModule);
}
db.SubmitChanges();
}
}
catch (Exception ex) {
throw ex;
}
}