public RecipeProductModels CheckInsertProduct(RecipeProductModels model, int ProductType, List <string> ListStoreId)
{
var item = new RecipeProductModels();
using (var cxt = new NuWebContext())
{
RecipeProductModels itemDb = null;
//Check StoreId | ProductId | IngredientId
if (ProductType == (byte)Commons.EProductType.Dish)
{
itemDb = cxt.I_Recipe_Item.Where(
s => s.StoreId.Equals(model.StoreId) &&
s.ItemId.Equals(model.ItemId) &&
s.IngredientId.Equals(model.IngredientId) &&
s.Status == (byte)Commons.EStatus.Actived &&
ListStoreId.Contains(s.StoreId)
).Select(x => new RecipeProductModels
{
Id = x.Id
}).FirstOrDefault();
}
else if (ProductType == (byte)Commons.EProductType.Modifier)
{
itemDb = cxt.I_Recipe_Modifier.Where(
s => s.StoreId.Equals(model.StoreId) &&
s.ModifierId.Equals(model.ItemId) &&
s.IngredientId.Equals(model.IngredientId) &&
s.Status == (byte)Commons.EStatus.Actived &&
ListStoreId.Contains(s.StoreId)
).Select(x => new RecipeProductModels
{
Id = x.Id
}).FirstOrDefault();
}
if (itemDb != null)
{
item = itemDb;
}
return(itemDb);
}
//return null;
}
public void UpdateRecipeProduct(RecipeProductModels model, int ProductType)
{
using (var cxt = new NuWebContext())
{
try
{
if (ProductType == (byte)Commons.EProductType.Dish)
{
var item = cxt.I_Recipe_Item.Where(s => s.Id == model.Id).FirstOrDefault();
if (item != null)
{
item.UOMId = model.UOMId;
item.Usage = model.Usage;
item.BaseUsage = model.BaseUsage;
item.UpdatedBy = model.UpdatedBy;
item.UpdatedDate = DateTime.Now;
cxt.SaveChanges();
}
}
else if (ProductType == (byte)Commons.EProductType.Modifier)
{
var item = cxt.I_Recipe_Modifier.Where(s => s.Id == model.Id).FirstOrDefault();
if (item != null)
{
item.UOMId = model.UOMId;
item.Usage = model.Usage;
item.BaseUsage = model.BaseUsage;
item.UpdatedBy = model.UpdatedBy;
item.UpdatedDate = DateTime.Now;
cxt.SaveChanges();
}
}
}
catch (Exception e)
{
_logger.Error("RecipeProduct_Update: " + e);
}
}
}
public bool Delete(string Id, ref string msg)
{
bool result = true;
using (NuWebContext cxt = new NuWebContext())
{
try
{
//
var isExist = (from mp in cxt.G_ModulePermission
from ro in cxt.G_RoleOrganization
where mp.ModuleID.Equals(Id) && mp.RoleID.Equals(ro.Id)
select new { mp, ro }).FirstOrDefault();
if (isExist != null)
{
result = false;
msg = "This module is already in use and unable to be deleted.";
}
else
{
G_Module itemDelete = (from tb in cxt.G_Module
where tb.Id == Id
select tb).FirstOrDefault();
cxt.G_Module.Remove(itemDelete);
cxt.SaveChanges();
}
}
catch (Exception ex)
{
_logger.Error(ex);
result = false;
}
finally
{
if (cxt != null)
{
cxt.Dispose();
}
}
}
return(result);
}
public List <BusinessDayDisplayModels> GetBusinessDays(DateTime dFrom, DateTime dTo, List <string> lstStoreId, int mode)
{
var result = new List <BusinessDayDisplayModels>();
using (var cxt = new NuWebContext())
{
//var query = cxt.G_BusinessDay.Where(ww =>
// ww.StartedOn >= dFrom && ww.StartedOn <= dTo
// && lstStoreId.Contains(ww.StoreId) && ww.Mode == mode)
// .ToList();
var query = (from b in cxt.G_BusinessDay.AsNoTracking()
where b.StartedOn >= dFrom && b.StartedOn <= dTo &&
lstStoreId.Contains(b.StoreId) && b.Mode == mode
select new BusinessDayModels()
{
StartedOn = b.StartedOn,
StoreId = b.StoreId,
ClosedOn = b.ClosedOn,
Id = b.Id
}).ToList();
foreach (var item in query)
{
var obj = new BusinessDayDisplayModels();
obj.DateFrom = item.StartedOn;
obj.StoreId = item.StoreId;
obj.Id = item.Id;
if (item.ClosedOn == Commons.MinDate)
{
obj.DateTo = new DateTime(item.StartedOn.Year, item.StartedOn.Month, item.StartedOn.Day, 23, 59, 59);
obj.DateDisplay = item.StartedOn.ToString("dd/MM/yyyy HH:mm") + " - ";
}
else
{
obj.DateTo = item.ClosedOn;
obj.DateDisplay = item.StartedOn.ToString("dd/MM/yyyy HH:mm") + " - " + item.ClosedOn.ToString("dd/MM/yyyy HH:mm");
}
result.Add(obj);
}
}
result = result.OrderBy(oo => oo.DateFrom).ToList();
return(result);
}
public bool Insert(List <PurchaseOrderDetailModels> models, ref string msg)
{
bool result = true;
using (NuWebContext cxt = new NuWebContext())
{
try
{
List <I_Purchase_Order_Detail> listInsert = new List <I_Purchase_Order_Detail>();
I_Purchase_Order_Detail item = null;
foreach (var model in models)
{
item = new I_Purchase_Order_Detail();
item.Id = Guid.NewGuid().ToString();
item.PurchaseOrderId = model.PurchaseOrderId;
item.IngredientId = model.IngredientId;
item.Qty = model.Qty;
item.UnitPrice = model.UnitPrice;
item.Amount = model.Amount;
item.ReceiptNoteQty = model.ReceiptNoteQty;
item.ReturnReceiptNoteQty = model.ReturnReceiptNoteQty;
listInsert.Add(item);
}
cxt.I_Purchase_Order_Detail.AddRange(listInsert);
cxt.SaveChanges();
}
catch (Exception ex)
{
_logger.Error(ex);
result = false;
}
finally
{
if (cxt != null)
{
cxt.Dispose();
}
}
}
return(result);
}
public List <string> GetDataForSupplier(string SupplierId, string CompanyId)
{
using (NuWebContext cxt = new NuWebContext())
{
try
{
var lstResult = (from IS in cxt.I_Ingredient_Supplier
from I in cxt.I_Ingredient
where IS.SupplierId.Equals(SupplierId) &&
I.IsActive && I.Id.Equals(IS.IngredientId) && I.CompanyId.Equals(CompanyId) && IS.IsActived == true
select IS.IngredientId).ToList();
return(lstResult);
}
catch (Exception ex)
{
_logger.Error(ex.Message);
return(null);
}
}
}
public List <NoIncludeOnSaleDataReportModels> GetListCateNoIncludeSaleForHourlySale(List <string> lstStoreIds, DateTime dFrom, DateTime dTo, int mode)
{
using (var cxt = new NuWebContext())
{
var lstResults = cxt.R_NoIncludeOnSaleDataReport.Where(ww => lstStoreIds.Contains(ww.StoreId) &&
ww.CreatedDate >= dFrom && ww.CreatedDate <= dTo && ww.Mode == mode)
.GroupBy(gg => new { StoreId = gg.StoreId, Time = (int?)SqlFunctions.DatePart("HH", gg.CreatedDate) })
.Select(ss => new NoIncludeOnSaleDataReportModels()
{
StoreId = ss.Key.StoreId,
Time = ss.Key.Time.HasValue? ss.Key.Time.Value:0,
Amount = ss.Sum(aa => aa.Amount),
DiscountAmount = ss.Sum(aa => aa.DiscountAmount),
PromotionAmount = ss.Sum(aa => aa.PromotionAmount),
Tax = ss.Sum(aa => aa.Tax)
}).ToList();
return(lstResults);
}
}
public async void DeleteTrackingLog()
{
using (var cxt = new NuWebContext())
{
try
{
int month = DateTime.Now.AddMonths(-1).Month, year = DateTime.Now.AddMonths(-1).Year;
var dataMonthBefore = cxt.G_TrackingLog.Where(ww => ww.CreatedDate.Month == month && ww.CreatedDate.Year == year).ToList();
if (dataMonthBefore != null && dataMonthBefore.Any())
{
cxt.G_TrackingLog.RemoveRange(dataMonthBefore);
cxt.SaveChanges();
}
}
catch (Exception ex)
{
_logger.Error(ex);
}
}
}
public async void InsertIngredientTrackLog(string code)
{
try
{
using (var cxt = new NuWebContext())
{
I_IngredientTrackLog trackingLog = new I_IngredientTrackLog();
trackingLog.Id = Guid.NewGuid().ToString();
trackingLog.Code = code;
trackingLog.CreatedDate = DateTime.Now;
cxt.I_IngredientTrackLog.Add(trackingLog);
cxt.SaveChanges();
}
}
catch (Exception ex)
{
_logger.Error(ex);
}
}
public List <OrderTipModels> GetDataTips(BaseReportModel model)
{
using (var cxt = new NuWebContext())
{
var lstData = (from tb in cxt.G_OrderTip
where model.ListStores.Contains(tb.StoreId) &&
(tb.CreatedDate >= model.FromDate &&
tb.CreatedDate <= model.ToDate)
select new OrderTipModels
{
StoreId = tb.StoreId,
CreatedDate = tb.CreatedDate,
PaymentId = tb.PaymentId,
PaymentName = tb.PaymentName,
Amount = tb.Amount,
OrderId = tb.OrderId
}).ToList();
return(lstData);
}
}
public bool _Update(List <PurchaseOrderDetailModels> models, List <string> listIdDelete, ref string msg)
{
bool result = true;
using (NuWebContext cxt = new NuWebContext())
{
try
{
//Delete Item
Delete(listIdDelete, ref msg);
//=========
List <I_Purchase_Order_Detail> listUpdate = new List <I_Purchase_Order_Detail>();
foreach (var model in models)
{
var itemUpdate = (from tb in cxt.I_Purchase_Order_Detail
where tb.Id == model.Id
select tb).FirstOrDefault();
if (itemUpdate != null)
{
itemUpdate.Qty = model.Qty;
itemUpdate.UnitPrice = model.UnitPrice;
itemUpdate.Amount = model.Amount;
cxt.SaveChanges();
}
}
}
catch (Exception ex)
{
_logger.Error(ex);
result = false;
}
finally
{
if (cxt != null)
{
cxt.Dispose();
}
}
}
return(result);
}
private List <string> ListIngInActive(List <string> lstId)
{
List <string> lstIdInActive = lstId;
using (var cxt = new NuWebContext())
{
var listIng = cxt.I_Ingredient.Where(aa => lstIdInActive.Contains(aa.BaseUOMId) && aa.Status != (int)Commons.EStatus.Deleted).Select(x => x.BaseUOMId).ToList();
listIng.AddRange(cxt.I_Ingredient.Where(aa => lstIdInActive.Contains(aa.ReceivingUOMId) && aa.Status != (int)Commons.EStatus.Deleted).Select(x => x.ReceivingUOMId).ToList());
listIng.AddRange(cxt.I_Ingredient_UOM.Where(aa => lstIdInActive.Contains(aa.UOMId) /* && aa.Status != (int)Commons.EStatus.Deleted*/).Select(x => x.UOMId).ToList());
listIng.AddRange(cxt.I_Recipe_Ingredient.Where(aa => (lstIdInActive.Contains(aa.UOMId)) && aa.Status != (int)Commons.EStatus.Deleted).Select(x => x.UOMId).ToList());
listIng.AddRange(cxt.I_Recipe_Item.Where(aa => lstIdInActive.Contains(aa.UOMId) && aa.Status != (int)Commons.EStatus.Deleted).Select(x => x.UOMId).ToList());
listIng.AddRange(cxt.I_Recipe_Modifier.Where(aa => lstIdInActive.Contains(aa.UOMId) && aa.Status != (int)Commons.EStatus.Deleted).Select(x => x.UOMId).ToList());
listIng.AddRange(cxt.I_Stock_Transfer_Detail.Where(aa => lstIdInActive.Contains(aa.UOMId) /*&& aa.Status != (int)Commons.EStatus.Deleted*/).Select(x => x.UOMId).ToList());
//Remove
lstIdInActive.RemoveAll(i => listIng.Contains(i));
return(lstIdInActive);
}
}
public List <string> GetStoreEmpAccess(string EmpID, string OrganizationId = null)
{
using (NuWebContext cxt = new NuWebContext())
{
try
{
var lstStoreId = new List <string>();
var lstRoleIds = cxt.G_UserRole.Where(ww => ww.EmployeeID == EmpID && ww.IsActive).Select(ss => ss.RoleID).ToList();
if (lstRoleIds != null && lstRoleIds.Any())
{
lstStoreId = cxt.G_RoleOnStore.Where(ww => lstRoleIds.Contains(ww.RoleId) && ww.IsActive).Select(ss => ss.StoreId).ToList();
}
return(lstStoreId);
}
catch (Exception ex)
{
_logger.Error(ex.Message);
return(new List <string>());
}
}
}
public List <NoSaleDetailReportModels> GetData(BaseReportModel model, string StoreId)
{
using (NuWebContext cxt = new NuWebContext())
{
var lstData = (from tb in cxt.R_NoSaleDetailReport
where tb.StoreId == StoreId &&
(tb.CreatedDate >= model.FromDate && tb.CreatedDate <= model.ToDate)
orderby tb.CreatedDate
select new NoSaleDetailReportModels
{
CashierId = tb.CashierId,
CashierName = tb.CashierName,
CreatedDate = tb.CreatedDate,
DrawerId = tb.DrawerId,
DrawerName = tb.DrawerName,
Reason = tb.Reason,
StoreId = tb.StoreId,
}).ToList();
return(lstData);
}
}
public async void InsertUsageXeroTrackLog(DateTime toDate, string storeId)
{
try
{
using (var cxt = new NuWebContext())
{
I_UsageManagementXeroTrackLog trackingLog = new I_UsageManagementXeroTrackLog();
trackingLog.Id = Guid.NewGuid().ToString();
trackingLog.ToDate = toDate;
trackingLog.StoreId = storeId;
trackingLog.CreatedDate = DateTime.Now;
cxt.I_UsageManagementXeroTrackLog.Add(trackingLog);
cxt.SaveChanges();
}
}
catch (Exception ex)
{
_logger.Error(ex);
}
}
public bool Insert(List <ReturnNoteDetailModels> models, ref string msg)
{
bool result = true;
using (NuWebContext cxt = new NuWebContext())
{
try
{
List <I_Return_Note_Detail> listInsert = new List <I_Return_Note_Detail>();
I_Return_Note_Detail item = null;
foreach (var model in models)
{
item = new I_Return_Note_Detail();
item.Id = Guid.NewGuid().ToString();
item.ReturnNoteId = model.ReturnNoteId;
item.ReceiptNoteDetailId = model.ReceiptNoteDetailId;
item.ReceivedQty = model.ReceivedQty;
item.ReturnQty = model.ReturnQty;
item.IsActived = model.IsActived;
listInsert.Add(item);
}
cxt.I_Return_Note_Detail.AddRange(listInsert);
cxt.SaveChanges();
}
catch (Exception ex)
{
_logger.Error(ex);
result = false;
}
finally
{
if (cxt != null)
{
cxt.Dispose();
}
}
}
return(result);
}
public bool Update(IngredientUOMModels model, ref string msg)
{
bool result = true;
using (NuWebContext cxt = new NuWebContext())
{
try
{
var itemUpdate = (from tb in cxt.I_Ingredient_UOM
where tb.Id == model.Id
select tb).FirstOrDefault();
itemUpdate.IngredientId = model.IngredientId;
itemUpdate.UOMId = model.UOMId;
itemUpdate.BaseUOM = model.BaseUOM;
itemUpdate.ReceivingQty = model.ReceivingQty;
itemUpdate.CreatedBy = model.CreatedBy;
itemUpdate.CreatedDate = model.CreatedDate;
itemUpdate.UpdatedBy = model.UpdatedBy;
itemUpdate.UpdatedDate = model.UpdatedDate;
itemUpdate.IsActived = model.IsActived;
cxt.SaveChanges();
}
catch (Exception ex)
{
_logger.Error(ex);
result = false;
}
finally
{
if (cxt != null)
{
cxt.Dispose();
}
}
}
return(result);
}
public bool Insert(List <DataEntryDetailModels> models, ref string msg)
{
bool result = true;
using (NuWebContext cxt = new NuWebContext())
{
try
{
List <I_DataEntryDetail> listInsert = new List <I_DataEntryDetail>();
I_DataEntryDetail item = null;
foreach (var model in models)
{
item = new I_DataEntryDetail();
item.Id = Guid.NewGuid().ToString();
item.DataEntryId = model.DataEntryId;
item.IngredientId = model.IngredientId;
//item.CloseBal = 0;//model.CloseBal;
listInsert.Add(item);
}
cxt.I_DataEntryDetail.AddRange(listInsert);
cxt.SaveChanges();
}
catch (Exception ex)
{
_logger.Error(ex);
result = false;
}
finally
{
if (cxt != null)
{
cxt.Dispose();
}
}
}
return(result);
}
public string ListRoleName(List <string> lstRoleId)
{
using (NuWebContext cxt = new NuWebContext())
{
try
{
var models = (from r in cxt.G_RoleOrganization
where r.IsActive && lstRoleId.Contains(r.Id)
select new RoleOrganizationModels()
{
Name = r.Name
}).ToList();
string RoleName = string.Join(", ", models.Select(x => x.Name));
return(RoleName);
}
catch (Exception ex)
{
_logger.Error(ex.Message);
return("");
}
}
}
public List <DiscountAndMiscReportModels> GetMiscDiscount(List <string> listStoreId, List <string> listReceiptId, int mode)
{
using (var cxt = new NuWebContext())
{
var lstData = (from ps in cxt.R_PosSale
from psd in cxt.R_PosSaleDetail.Where(ww => ww.StoreId == ps.StoreId && ww.OrderId == ps.OrderId)
where listStoreId.Contains(ps.StoreId) &&
listReceiptId.Contains(ps.OrderId) &&
psd.Mode == mode &&
(psd.ItemTypeId == (int)Commons.EProductType.Misc || psd.IsDiscountTotal == true)
select new DiscountAndMiscReportModels
{
StoreId = ps.StoreId,
CreatedDate = ps.ReceiptCreatedDate.Value,
MiscValue = psd.Price,
DiscountValue = psd.Discount,
IsDiscountTotal = (psd.IsDiscountTotal.HasValue && psd.IsDiscountTotal.Value == true) ? true : false,
ItemTypeId = psd.ItemTypeId
}).ToList();
return(lstData);
}
}
public RecipeIngredientModels CheckInsertIngredient(RecipeIngredientModels model)
{
var item = new RecipeIngredientModels();
using (var cxt = new NuWebContext())
{
RecipeIngredientModels itemDb = null;
//Check MixtureIngredientId | IngredientId
itemDb = cxt.I_Recipe_Ingredient.Where(s => s.MixtureIngredientId.Equals(model.MixtureIngredientId) &&
s.IngredientId.Equals(model.IngredientId) &&
s.Status == (byte)Commons.EStatus.Actived)
.Select(x => new RecipeIngredientModels
{
Id = x.Id
}).FirstOrDefault();
if (itemDb != null)
{
item = itemDb;
}
return(itemDb);
}
}
private List <RecipeItemModel> GetRecipeModifier(string storeId, string ingredientId)
{
using (var cxt = new NuWebContext())
{
var lstResult = (from i in cxt.I_Recipe_Modifier
join ing in cxt.I_Ingredient on i.IngredientId equals ing.Id
where i.StoreId == storeId && i.IngredientId == ingredientId &&
i.Status != (int)Commons.EStatus.Deleted
select new RecipeItemModel()
{
IngredientId = ing.Id,
ItemId = i.ModifierId,
IngredientCode = ing.Code,
IngredientName = ing.Name,
UOMName = ing.BaseUOMName,
Usage = 0,
BaseUsage = i.Usage
}).ToList();
return(lstResult);
}
}
public List <RecipeProductModels> GetListRecipeProduct(string ProductId, string StoreId, int ProductType, List <string> ListStoreId)
{
List <RecipeProductModels> listResults = new List <RecipeProductModels>();
using (NuWebContext cxt = new NuWebContext())
{
if (ProductType == (byte)Commons.EProductType.Dish)
{
var query = (from p in cxt.I_Recipe_Item
where p.ItemId.Equals(ProductId) && p.StoreId.Equals(StoreId) &&
p.Status == (byte)Commons.EStatus.Actived &&
ListStoreId.Contains(p.StoreId)
select new RecipeProductModels
{
IngredientId = p.IngredientId,
Usage = p.Usage,
UOMId = p.UOMId,
BaseUsage = p.BaseUsage ?? 0
}).ToList().AsQueryable();
listResults = query.ToList();
}
else if (ProductType == (byte)Commons.EProductType.Modifier)
{
var query = (from p in cxt.I_Recipe_Modifier
where p.ModifierId.Equals(ProductId) && p.StoreId.Equals(StoreId) &&
p.Status == (byte)Commons.EStatus.Actived &&
ListStoreId.Contains(p.StoreId)
select new RecipeProductModels
{
IngredientId = p.IngredientId,
Usage = p.Usage,
UOMId = p.UOMId,
BaseUsage = p.BaseUsage ?? 0
}).ToList().AsQueryable();
listResults = query.ToList();
}
}
return(listResults);
}
public List <NoIncludeOnSaleDataReportModels> GetListCateNoIncludeSaleForDailyReceipt(List <string> lstStoreIds, DateTime dFrom, DateTime dTo, int mode)
{
using (var cxt = new NuWebContext())
{
var lstResults = cxt.R_NoIncludeOnSaleDataReport.Where(ww => lstStoreIds.Contains(ww.StoreId) &&
ww.CreatedDate >= dFrom && ww.CreatedDate <= dTo && ww.Mode == mode)
.Select(ss => new NoIncludeOnSaleDataReportModels()
{
StoreId = ss.StoreId,
CreatedDate = ss.CreatedDate,
CategoryId = ss.CategoryId,
CategoryName = ss.CategoryName,
Amount = ss.Amount,
Tax = ss.Tax,
DiscountAmount = ss.DiscountAmount,
PromotionAmount = ss.PromotionAmount,
OrderId = ss.OrderId
}).ToList();
return(lstResults);
}
}
public bool Delete(string Id, ref string msg)
{
bool result = true;
using (NuWebContext cxt = new NuWebContext())
{
try
{
if (IsCanDelete(Id))
{
var item = cxt.I_Supplier.Where(tb => tb.Id == Id).FirstOrDefault();
if (item != null)
{
item.Status = (int)Commons.EStatus.Deleted;
cxt.SaveChanges();
}
}
else
{
msg = "This supplier has been in used. Please deactivate it only.";
result = false;
}
}
catch (Exception ex)
{
_logger.Error(ex);
result = false;
}
finally
{
if (cxt != null)
{
cxt.Dispose();
}
}
}
return(result);
}
public List <ItemizedSalesAnalysisReportModels> GetItemsNoIncludeSale(List <string> listAllReceiptId, List <string> listStoreId, int mode)
{
using (var cxt = new NuWebContext())
{
List <ItemizedSalesAnalysisReportModels> lstData = new List <ItemizedSalesAnalysisReportModels>();
lstData = (from ps in cxt.R_PosSale
from psd in cxt.R_PosSaleDetail.Where(ww => ww.StoreId == ps.StoreId && ww.OrderId == ps.OrderId)
where listStoreId.Contains(ps.StoreId) &&
listAllReceiptId.Contains(ps.OrderId) &&
psd.Mode == mode
select new ItemizedSalesAnalysisReportModels
{
StoreId = ps.StoreId,
CreatedDate = ps.ReceiptCreatedDate.Value,
CategoryId = psd.CategoryId,
CategoryName = psd.CategoryName,
ExtraPrice = psd.ExtraPrice,
TotalPrice = psd.TotalAmount - (psd.IsDiscountTotal != true ? psd.Discount : 0) - psd.PromotionAmount,
GLAccountCode = psd.GLAccountCode,
IsIncludeSale = psd.IsIncludeSale,
BusinessId = psd.BusinessId,
ServiceCharge = psd.ServiceCharge,
Tax = psd.Tax,
//ExtraAmount = tb.ExtraAmount.HasValue ? tb.ExtraAmount.Value : 0,
TotalAmount = psd.TotalAmount,
TotalDiscount = psd.IsDiscountTotal != true ? psd.Discount : 0,
ItemTotal = psd.TotalAmount - (psd.IsDiscountTotal != true ? psd.Discount : 0) - psd.PromotionAmount + psd.ExtraPrice,
PromotionAmount = psd.PromotionAmount,
ReceiptId = psd.OrderId,
TaxType = psd.TaxType,
GiftCardId = psd.GiftCardId,
PoinsOrderId = psd.PoinsOrderId
}).ToList();
return(lstData);
}
}
public bool Insert(ModuleModels model, ref string msg)
{
bool result = true;
using (NuWebContext cxt = new NuWebContext())
{
try
{
G_Module item = new G_Module();
item.Id = Guid.NewGuid().ToString();
item.Name = model.Name;
item.Controller = model.Controller;
item.ParentID = model.ParentID == null ? "" : model.ParentID;
item.CreatedDate = DateTime.Now;
item.CreatedUser = model.CreatedUser;
item.ModifiedDate = DateTime.Now;
item.ModifiedUser = model.ModifiedUser;
item.IndexNum = model.IndexNum;
cxt.G_Module.Add(item);
cxt.SaveChanges();
}
catch (Exception ex)
{
_logger.Error(ex);
result = false;
}
finally
{
if (cxt != null)
{
cxt.Dispose();
}
}
}
return(result);
}
public bool Update(ReturnNoteModels model, ref string msg)
{
bool result = true;
using (NuWebContext cxt = new NuWebContext())
{
try
{
var itemUpdate = (from tb in cxt.I_Return_Note
where tb.Id == model.Id
select tb).FirstOrDefault();
itemUpdate.ReceiptNoteId = model.ReceiptNoteId;
itemUpdate.ReturnNoteNo = model.ReturnNoteNo;
itemUpdate.CreatedBy = model.CreatedBy;
itemUpdate.CreatedDate = model.CreatedDate;
itemUpdate.ModifierBy = model.ModifierBy;
itemUpdate.ModifierDate = model.ModifierDate;
itemUpdate.IsActived = model.IsActived;
cxt.SaveChanges();
}
catch (Exception ex)
{
_logger.Error(ex);
result = false;
}
finally
{
if (cxt != null)
{
cxt.Dispose();
}
}
}
return(result);
}
public async void InsertTrackingLog(string tableName, string info, string storeId, bool result)
{
try
{
using (var cxt = new NuWebContext())
{
G_TrackingLog trackingLog = new G_TrackingLog();
trackingLog.Id = Guid.NewGuid().ToString();
trackingLog.TableName = tableName;
trackingLog.StoreId = storeId;
trackingLog.CreatedDate = DateTime.Now;
trackingLog.JsonContent = info;
trackingLog.IsDone = result;
cxt.G_TrackingLog.Add(trackingLog);
cxt.SaveChanges();
}
}
catch (Exception ex)
{
_logger.Error(ex);
}
}
public List <PaymentModels> GetDataPaymentItemsByGC(BaseReportModel model, List <string> lstGCId)
{
using (var cxt = new NuWebContext())
{
var lstData = (from tb in cxt.G_PaymentMenthod
where model.ListStores.Contains(tb.StoreId) &&
(tb.CreatedDate >= model.FromDate && tb.CreatedDate <= model.ToDate) &&
tb.Mode == model.Mode &&
(lstGCId.Contains(tb.PaymentId) || tb.PaymentCode == (int)Commons.EPaymentCode.GiftCard)
//&& (tb.IsInclude ==null ||(tb.IsInclude.HasValue && tb.IsInclude.Value))
select new PaymentModels
{
StoreId = tb.StoreId,
CreatedDate = tb.CreatedDate,
PaymentId = tb.PaymentId,
PaymentName = tb.PaymentName,
Amount = tb.Amount,
OrderId = tb.OrderId,
IsInclude = tb.IsInclude
}).ToList();
return(lstData);
}
}
