public async Task <IActionResult> GetBasicByCategory(Guid id)
{
try
{
var data = _context.Set <Item>().Include(x => x.ItemCategory)
.Where(x => x.ItemCategoryID == id && x.IsEnable == true).ToList();
var json = new JsonResult(data.Select(x => new ItemBasicModel()
{
ID = x.ID,
Name = x.Name,
ShortDescription = x.ShortDescription,
ItemCategory = x.ItemCategory?.Name,
Price = x.Price,
CashBack = x.CashBack,
Quantity = x.Quantity,
ItemCategoryID = x.ItemCategoryID,
ThumbnailImagePath = x.ThumbnailImagePath,
AccountID = x.AccountID,
IsEnable = x.IsEnable,
DaysToBeAvilable = x.DaysToBeAvailable
}));
#region Add Open View History
var clickContext = _context as IClickHistoryContext;
if (clickContext != null)
{
var cat = _context.Set <ItemCategory>().FirstOrDefault(x => x.ID == id)?.Name;
var clickView = clickContext.OpenViewHistories.FirstOrDefault(x =>
x.View == NavaraView.Item.ToString() &&
x.Date.GetValueOrDefault().Date == DateTime.Now.Date &&
x.Remark == cat);
if (clickView == null)
{
clickView = new OpenViewHistory()
{
ClickTime = 0,
View = NavaraView.Item.ToString(),
Date = DateTime.Now.Date,
Remark = cat
};
clickContext.OpenViewHistories.Add(clickView);
}
clickView.ClickTime++;
clickContext.SubmitAsync();
}
#endregion
return(json);
}
catch (Exception ex)
{
return(BadRequest());
}
}
public async Task <IActionResult> GetBasic()
{
try
{
var data = _context.Set <Offer>().Include(x => x.Item).ToList();
var json = new JsonResult(data.Select(x => new OfferBasicModel()
{
ID = x.ID,
Title = x.Title,
ItemName = x.Item?.Name,
ThumbnailImagePath = x.ThumbnailImagePath,
ShortDescription = x.ShortDescription,
OfferType = x.OfferType,
Discount = x.Discount,
UnitNetPrice = x.Price ?? ((x.Item?.Price ?? 0) - ((x.Item?.Price ?? 0) * (x.Discount ?? 0) / 100.0)),
UnitPrice = x.Item?.Price
}));
#region Add Open View History
var clickContext = _context as IClickHistoryContext;
if (clickContext != null)
{
var clickView = clickContext.OpenViewHistories.FirstOrDefault(x =>
x.View == NavaraView.Offer.ToString() &&
x.Date.GetValueOrDefault().Date == DateTime.Now.Date);
if (clickView == null)
{
clickView = new OpenViewHistory()
{
ClickTime = 0,
View = NavaraView.Offer.ToString(),
Date = DateTime.Now.Date
};
clickContext.OpenViewHistories.Add(clickView);
}
clickView.ClickTime++;
clickContext.SubmitAsync();
}
#endregion
return(json);
}
catch (Exception ex)
{
return(BadRequest());
}
}
public override async Task <IActionResult> Get()
{
try
{
var data = _context.Set <ItemCategory>()?.Where(s => !s.Name.Contains("Used Items")).ToList();
var json = new JsonResult(data.Select(x => new ViewModels.ItemCategoryModel()
{
ID = x.ID,
Name = x.Name,
Name2 = x.Name2,
Description = x.Description,
ImagePath = x.ImagePath
}));
#region Add Open View History
var clickContext = _context as IClickHistoryContext;
if (clickContext != null)
{
var clickView = clickContext.OpenViewHistories.FirstOrDefault(x =>
x.View == NavaraView.Categories.ToString() &&
x.Date.GetValueOrDefault().Date == DateTime.Now.Date);
if (clickView == null)
{
clickView = new OpenViewHistory()
{
ClickTime = 0,
View = NavaraView.Categories.ToString(),
Date = DateTime.Now.Date
};
clickContext.OpenViewHistories.Add(clickView);
}
clickView.ClickTime++;
clickContext.SubmitAsync();
}
#endregion
return(json);
}
catch (Exception ex)
{
return(BadRequest());
}
}
