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