/// <summary> /// Function for add menu schedule /// </summary> /// <param name="menuSchedule_VM"></param> /// <param name="loginUserId"></param> /// <returns></returns> public int Add(MenuSchedule_VM menuSchedule_VM, int loginUserId) { string[] dates = menuSchedule_VM.DateRange.Split('-'); var startDate = DateTime.Parse(dates[0]); var endDate = DateTime.Parse(dates[1]); var isOnSameDate = _context.Emenu_MenuSchedules. Where(x => x.ConceptId == menuSchedule_VM.ConceptId && x.StoreId == menuSchedule_VM.StoreId && x.Status && !x.IsDeleted && ((x.StartDate >= startDate && x.StartDate <= endDate) || (x.EndDate >= startDate && x.EndDate <= endDate)) ) .FirstOrDefault(); if (isOnSameDate == null) { var menuSchedule = new Emenu_MenuSchedules(); menuSchedule.ConceptId = menuSchedule_VM.ConceptId; menuSchedule.Code = menuSchedule_VM.Code; menuSchedule.MenuId = menuSchedule_VM.MenuId; menuSchedule.StartDate = startDate; menuSchedule.EndDate = endDate; menuSchedule.Status = menuSchedule_VM.Status; menuSchedule.CreatedOn = DateTime.Now; menuSchedule.CreatedBy = loginUserId; menuSchedule.UniqueCode = Guid.NewGuid().ToString().Replace("-", "").Substring(0, 12); menuSchedule.StoreId = menuSchedule_VM.StoreId; _context.Emenu_MenuSchedules.Add(menuSchedule); return(_context.SaveChanges()); } else { return(Helper.onsamedate_code); } }
/// <summary> /// Function for add voucher issuance /// </summary> /// <param name="voucherIssuance_VM"></param> /// <param name="loginUserId"></param> /// <returns></returns> public int Add(VoucherIssuance_VM voucherIssuance_VM, int loginUserId) { var ret = 1; using (var dbcxtransaction = _context.Database.BeginTransaction()) { try { var voucherIssuance = new VoucherIssuance(); voucherIssuance.VoucherId = voucherIssuance_VM.VoucherId; voucherIssuance.CustomerId = voucherIssuance_VM.CustomerId; voucherIssuance.ReasonCategoryId = voucherIssuance_VM.ReasonCategoryId; voucherIssuance.ReasonSubCategoryId = voucherIssuance_VM.ReasonSubCategoryId; voucherIssuance.Source = voucherIssuance_VM.Source; voucherIssuance.UniqueId = Guid.NewGuid().ToString().Replace("-", "").Substring(0, 10); voucherIssuance.CampaignText = voucherIssuance_VM.Source == (int)VoucherIssuanceSource.Campaign ? voucherIssuance_VM.CampaignText : string.Empty; voucherIssuance.CreatedOn = DateTime.Now; voucherIssuance.CreatedBy = loginUserId; _context.VoucherIssuance.Add(voucherIssuance); _context.SaveChanges(); dbcxtransaction.Commit(); } catch (Exception ex) { dbcxtransaction.Rollback(); ret = 0; } } return(ret); }
/// <summary> /// Function for add client /// </summary> /// <param name="client_VM"></param> /// <param name="loginUserId"></param> /// <returns></returns> public int Add(Client_VM client_VM, int loginUserId) { var ret = 1; using (var dbcxtransaction = _context.Database.BeginTransaction()) { try { var client = new Sec_Client(); client.FirstName = client_VM.FirstName; client.LastName = client_VM.LastName; client.CompanyName = client_VM.CompanyName; client.Address1 = client_VM.Address1; client.Address2 = client_VM.Address2; client.EmailAddress = client_VM.EmailAddress; client.PhoneNo = client_VM.PhoneNo; client.Status = client_VM.Status; client.CreatedOn = DateTime.Now; client.CreatedBy = loginUserId; _context.Sec_Client.Add(client); _context.SaveChanges(); dbcxtransaction.Commit(); } catch (Exception ex) { dbcxtransaction.Rollback(); ret = 0; } } return(ret); }
/// <summary> /// Function for delete country /// </summary> /// <param name="id"></param> /// <param name="loginUserId"></param> /// <returns></returns> public int Delete(int id, int loginUserId) { var country = _context.Set_CountryCodes.Where(x => x.CountryID == id && x.IsDeleted == false).FirstOrDefault(); if (country != null) { country.IsDeleted = true; country.DeletedOn = DateTime.Now; country.DeletedBy = loginUserId; return(_context.SaveChanges()); } return(0); }
/// <summary> /// Function for add currency /// </summary> /// <param name="currency_VM"></param> /// <param name="loginUserId"></param> /// <returns></returns> public int Add(Currency_VM currency_VM, int loginUserId) { var obj = new Emenu_Currency(); obj.Currency = currency_VM.Currency; obj.Symbol = currency_VM.Symbol; obj.SymbolAR = currency_VM.SymbolAR; obj.CreatedOn = DateTime.Now; obj.CreatedBy = loginUserId; obj.ClientId = currency_VM.ClientId; _context.Emenu_Currency.Add(obj); return(_context.SaveChanges()); }
/// <summary> /// Function for delete region /// </summary> /// <param name="id"></param> /// <param name="loginUserId"></param> /// <returns></returns> public int Delete(int id, int loginUserId) { var region = _context.Set_Region.Where(x => x.Id == id && x.IsDeleted == false).FirstOrDefault(); if (region != null) { region.IsDeleted = true; region.DeletedOn = DateTime.Now; region.DeletedBy = loginUserId; return(_context.SaveChanges()); } return(0); }
/// <summary> /// Function for add concept theme /// </summary> /// <param name="theme_VM"></param> /// <param name="loginUserId"></param> /// <returns></returns> public int Add(ConceptTheme_VM conceptTheme_VM, int loginUserId) { var conceptTheme = new Concept_Theme(); conceptTheme.ConceptId = conceptTheme_VM.ConceptId; conceptTheme.LogoName = conceptTheme_VM.LogoName; conceptTheme.FeedBackIconName = conceptTheme_VM.FeedBackIconName; conceptTheme.ColorCode = conceptTheme_VM.ColorCode; conceptTheme.Status = conceptTheme_VM.Status; conceptTheme.CreatedOn = DateTime.Now; conceptTheme.CreatedBy = loginUserId; _context.Concept_Theme.Add(conceptTheme); return(_context.SaveChanges()); }
/// <summary> /// Function for delete the user /// </summary> /// <param name="id"></param> /// <returns></returns> public int Delete(int id, int loginUserId) { var user = _context.Sec_Users.Where(x => x.Id == id && x.IsDeleted.Value != true).FirstOrDefault(); if (user != null) { user.IsDeleted = true; user.DeletedOn = DateTime.Now; user.DeletedBy = loginUserId; return(_context.SaveChanges()); } return(0); }
/// <summary> /// Function for add menu /// </summary> /// <param name="menu_VM"></param> /// <param name="loginUserId"></param> /// <returns></returns> public int Add(Menu_VM menu_VM, int loginUserId) { if (menu_VM != null) { using (var dbcxtransaction = _context.Database.BeginTransaction()) { try { var menu = new Emenu_Menus(); menu.Code = menu_VM.Code; menu.Name = menu_VM.Name; menu.ConceptId = menu_VM.ConceptId; menu.Status = menu_VM.Status; menu.CreatedOn = DateTime.Now; menu.CreatedBy = loginUserId; _context.Emenu_Menus.Add(menu); _context.SaveChanges(); var menuItems = new List <Emenu_MenuMItems>(); foreach (var menuItemId in menu_VM.MenuItemIds) { var menuItem = new Emenu_MenuMItems() { EMenusId = menu.Id, EMenuItemsId = menuItemId, }; menuItems.Add(menuItem); } _context.Emenu_MenuMItems.AddRange(menuItems); _context.SaveChanges(); dbcxtransaction.Commit(); return(1); } catch (Exception ex) { dbcxtransaction.Rollback(); return(0); } } } else { return(0); } }
/// <summary> /// Function for detele sub-category /// </summary> /// <param name="id"></param> /// <param name="loginUserId"></param> /// <returns></returns> public int Delete(int id, int loginUserId) { var subcategory = _context.VoucherReasonSubCategoryMaster.Where(x => x.Id == id && x.IsDeleted == false).FirstOrDefault(); if (subcategory != null) { var isSubCategoryRef = _context.VoucherIssuance.Where(x => x.IsDeleted != true && x.ReasonSubCategoryId == id).FirstOrDefault(); if (isSubCategoryRef == null) { subcategory.IsDeleted = true; subcategory.DeletedOn = DateTime.Now; subcategory.DeletedBy = loginUserId; return(_context.SaveChanges()); } else { return(Helper.refernce_error_code); } } return(0); }
/// <summary> /// Function for delete store /// </summary> /// <param name="id"></param> /// <returns></returns> public int Delete(int id, int loginUserId) { var ret = 1; using (var dbcxtransaction = _context.Database.BeginTransaction()) { try { var store = _context.Set_Stores.Where(x => x.Id == id && x.IsDeleted == false && x.CreatedBy == loginUserId).FirstOrDefault(); if (store != null) { var userStores = _context.Sec_UserStores.Where(x => x.StoreId == store.Id && x.IsDeleted == false && x.CreatedBy == loginUserId).ToList(); if (userStores.Any()) { foreach (var userStore in userStores) { userStore.IsDeleted = true; userStore.DeletedBy = loginUserId; userStore.CreatedOn = DateTime.Now; _context.SaveChanges(); } } store.IsDeleted = true; store.DeletedOn = DateTime.Now; store.DeletedBy = loginUserId; _context.SaveChanges(); dbcxtransaction.Commit(); } else { ret = 0; } } catch (Exception ex) { dbcxtransaction.Rollback(); ret = 0; } } return(ret); }
/// <summary> /// Function for add category /// </summary> /// <param name="category_VM"></param> /// <returns></returns> public int Add(Category_VM category_VM, int loginUserId) { var ret = 1; using (var dbcxtransaction = _context.Database.BeginTransaction()) { try { var category = new Emenu_Category(); category.Code = category_VM.Code; category.Name = category_VM.Name; category.LabelAR = category_VM.LabelAR; category.LabelEN = category_VM.LabelEN; category.DetailsAR = category_VM.DetailsAR; category.DetailsEN = category_VM.DetailsEN; category.ImageName = category_VM.ImageName; category.Status = category_VM.Status; category.CreatedOn = DateTime.Now; category.CreatedBy = loginUserId; _context.Emenu_Category.Add(category); _context.SaveChanges(); var categoryConcepts = new List <Emenu_CategoryConcepts>(); foreach (var conceptId in category_VM.ConceptIds) { var categoryConcept = new Emenu_CategoryConcepts(); categoryConcept.CategoryId = category.Id; categoryConcept.ConceptId = conceptId; categoryConcepts.Add(categoryConcept); } _context.Emenu_CategoryConcepts.AddRange(categoryConcepts); _context.SaveChanges(); dbcxtransaction.Commit(); } catch (Exception ex) { dbcxtransaction.Rollback(); ret = 0; } } return(ret); }
/// <summary> /// Function for add item tag /// </summary> /// <param name="itemTags_VM"></param> /// <param name="loginUserId"></param> /// <returns></returns> public int Add(ItemTag_VM itemTag_VM, int loginUserId) { var ret = 1; using (var dbcxtransaction = _context.Database.BeginTransaction()) { try { var itemTag = new Emenu_ItemTags(); itemTag.Name = itemTag_VM.Name; itemTag.Status = itemTag_VM.Status; itemTag.CreatedOn = DateTime.Now; itemTag.CreatedBy = loginUserId; itemTag.IconTagName = itemTag_VM.IconTagName; itemTag.LabelEN = itemTag_VM.LabelEN; itemTag.LabelAR = itemTag_VM.LabelAR; _context.Emenu_ItemTags.Add(itemTag); _context.SaveChanges(); var itemTagConcepts = new List <Emenu_ItemTagsConcepts>(); foreach (var conceptId in itemTag_VM.ConceptIds) { var itemTagConcept = new Emenu_ItemTagsConcepts(); itemTagConcept.ItemTagId = itemTag.Id; itemTagConcept.ConceptId = conceptId; itemTagConcepts.Add(itemTagConcept); } _context.Emenu_ItemTagsConcepts.AddRange(itemTagConcepts); _context.SaveChanges(); dbcxtransaction.Commit(); } catch (Exception ex) { dbcxtransaction.Rollback(); ret = 0; } } return(ret); }
/// <summary> /// Function for add voucher /// </summary> /// <param name="voucherSetup_VM"></param> /// <param name="loginUserId"></param> /// <returns></returns> public int Add(VoucherSetup_VM voucherSetup_VM, int loginUserId) { var ret = 1; using (var dbcxtransaction = _context.Database.BeginTransaction()) { try { var voucherSetup = new VoucherSetup(); voucherSetup.Name = voucherSetup_VM.Name; voucherSetup.Description = voucherSetup_VM.Description; voucherSetup.Terms = voucherSetup_VM.Terms; voucherSetup.Limitations = voucherSetup_VM.Limitations; voucherSetup.Type = voucherSetup_VM.Type; voucherSetup.Value = voucherSetup_VM.Value; voucherSetup.IsMultipleTimeUsage = voucherSetup_VM.IsMultipleTimeUsage; voucherSetup.StartDate = voucherSetup_VM.StartDate; voucherSetup.EndDate = voucherSetup_VM.EndDate; voucherSetup.Status = voucherSetup_VM.Status; voucherSetup.CreatedOn = DateTime.Now; voucherSetup.CreatedBy = loginUserId; _context.VoucherSetup.Add(voucherSetup); _context.SaveChanges(); //Add voucher stores var voucherStores = new List <Set_VoucherStore>(); foreach (var storeId in voucherSetup_VM.StoreIds) { var obj = new Set_VoucherStore(); obj.VoucherId = voucherSetup.Id; obj.StoreId = storeId; voucherStores.Add(obj); } _context.Set_VoucherStore.AddRange(voucherStores); _context.SaveChanges(); if (voucherSetup_VM.Type == (int)VoucherSetupType.ItemType) { //Add voucher menu item var voucherItemTypes = new List <VoucherItemType>(); foreach (var menuItemId in voucherSetup_VM.MenuItemIds) { var obj = new VoucherItemType(); obj.VoucherId = voucherSetup.Id; obj.MenuItemId = menuItemId; voucherItemTypes.Add(obj); } _context.VoucherItemType.AddRange(voucherItemTypes); _context.SaveChanges(); } //Add voucher survey var voucherSurveys = new List <Set_VoucherSurvey>(); foreach (var surveyId in voucherSetup_VM.SurveyIds) { var obj = new Set_VoucherSurvey(); obj.VoucherId = voucherSetup.Id; obj.SurveyId = surveyId; voucherSurveys.Add(obj); } _context.Set_VoucherSurvey.AddRange(voucherSurveys); _context.SaveChanges(); dbcxtransaction.Commit(); } catch (Exception ex) { dbcxtransaction.Rollback(); ret = 0; } } return(ret); }
/// <summary> /// Save fill-up survey /// </summary> /// <param name="surveyForm"></param> /// <returns></returns> public int Save(SurveyForm_VM surveyForm) { int ret = 0; using (var dbcxtransaction = _context.Database.BeginTransaction()) { try { // Save user's info var obj = new CRM_CommentCardResultsHeader(); obj.cc_id = surveyForm.CommentCard.cc_id; obj.Customer_ID = Guid.NewGuid(); obj.Store_ID = surveyForm.Store_ID; obj.Storeno = surveyForm.Storeno; foreach (var user in surveyForm.SysFields) { if (user.FieldID == USERINFO.FirstName.ToString()) { obj.FirstName = user.UserAnswer; } else if (user.FieldID == USERINFO.LastName.ToString()) { obj.LastName = user.UserAnswer; } else if (user.FieldID == USERINFO.Email.ToString()) { obj.Email = user.UserAnswer; } else if (user.FieldID == USERINFO.Mobile.ToString()) { obj.Mobile = user.UserAnswer; } else if (user.FieldID == USERINFO.Birthday.ToString() && user.UserAnswer != null) { obj.Birthday = DateTime.Parse(user.UserAnswer); } else if (user.FieldID == USERINFO.Gender.ToString()) { obj.Gender = user.UserAnswer; } else if (user.FieldID == USERINFO.Nationality.ToString() && user.UserAnswer != null) { obj.Nationality = Convert.ToInt32(user.UserAnswer); } else if (user.FieldID == USERINFO.COR.ToString() && user.UserAnswer != null) { obj.COR = Convert.ToInt32(user.UserAnswer); } } obj.CreatedOn = DateTime.Now; _context.CRM_CommentCardResultsHeader.Add(obj); _context.SaveChanges(); // Save the question's answer var commentCardResults = new List <CRM_CommentCardResults>(); foreach (var qm in surveyForm.QuestionMaster) { foreach (var que in qm.Questions) { var answer = new CRM_CommentCardResults(); answer.CCR_ID = obj.CCR_ID; answer.q_id = que.q_id; answer.ctr_answer = que.userAnswer; answer.ctr_AnswerText = que.options.Where(x => x.Value == que.userAnswer).Select(x => x.Text).FirstOrDefault(); answer.q_type = que.q_type; commentCardResults.Add(answer); } } _context.CRM_CommentCardResults.AddRange(commentCardResults); _context.SaveChanges(); dbcxtransaction.Commit(); ret = 1; } catch (Exception ex) { dbcxtransaction.Rollback(); } } return(ret); }
/// <summary> /// Funtion for add menu item /// </summary> /// <param name="menuItem_VM"></param> /// <param name="loginUserId"></param> /// <returns></returns> public int Add(MenuItem_VM menuItem_VM, int loginUserId) { var ret = 1; using (var dbcxtransaction = _context.Database.BeginTransaction()) { try { var menuItem = new Emenu_MenuItems(); menuItem.PLU = menuItem_VM.PLU; menuItem.Name = menuItem_VM.Name; menuItem.CategoryId = menuItem_VM.CategoryId; menuItem.CurrencyId = menuItem_VM.CurrencyId; menuItem.Price = menuItem_VM.Price.Value; menuItem.Status = menuItem_VM.Status; menuItem.DetailsEN = menuItem_VM.DetailsEN; menuItem.DetailsAR = menuItem_VM.DetailsAR; menuItem.ThumbnailImageName = menuItem_VM.ThumbnailImageName; menuItem.LargeImageName = menuItem_VM.LargeImageName; menuItem.LargeDetailsEN = menuItem_VM.LargeDetailsEN; menuItem.LargeDetailsAR = menuItem_VM.LargeDetailsAR; menuItem.OverLayImageName = menuItem_VM.OverLayImageName; menuItem.OverlayDetailsEN = menuItem_VM.OverlayDetailsEN; menuItem.OverlayDetailsAR = menuItem_VM.OverlayDetailsAR; menuItem.CreatedOn = DateTime.Now; menuItem.CreatedBy = loginUserId; menuItem.CommentsEN = menuItem_VM.CommentsEN; menuItem.CommentsAR = menuItem_VM.CommentsAR; menuItem.LabelEN = menuItem_VM.LabelEN; menuItem.LabelAR = menuItem_VM.LabelAR; _context.Emenu_MenuItems.Add(menuItem); _context.SaveChanges(); var menuItemTags = new List <Emenu_MenuItemTags>(); foreach (var itemTagId in menuItem_VM.ItemTagsId) { var menuItemTag = new Emenu_MenuItemTags() { EMenuItemId = menuItem.Id, ItemTagId = itemTagId, }; menuItemTags.Add(menuItemTag); } _context.Emenu_MenuItemTags.AddRange(menuItemTags); _context.SaveChanges(); var menuItemConcepts = new List <Emenu_MenuItemsConcepts>(); foreach (var conceptId in menuItem_VM.ConceptIds) { var menuItemConcept = new Emenu_MenuItemsConcepts(); menuItemConcept.MenuItemId = menuItem.Id; menuItemConcept.ConceptId = conceptId; menuItemConcepts.Add(menuItemConcept); } _context.Emenu_MenuItemsConcepts.AddRange(menuItemConcepts); _context.SaveChanges(); dbcxtransaction.Commit(); } catch (Exception ex) { dbcxtransaction.Rollback(); ret = 0; } } return(ret); }
/// <summary> /// Function for add concept /// </summary> /// <param name="concepts_VM"></param> /// <param name="loginUserId"></param> /// <returns></returns> public int Add(Concepts_VM concepts_VM, int loginUserId) { var concept = new Set_Concepts(); concept.ConceptName = concepts_VM.ConceptName; concept.Active = concepts_VM.Active; concept.ClientId = concepts_VM.ClientId; concept.CreatedOn = DateTime.Now; concept.CreatedBy = loginUserId; _context.Set_Concepts.Add(concept); return(_context.SaveChanges()); }