public bool Insert(SaleRate rate)
{
try
{
db.SaleRates.Add(rate);
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public long Insert(long id, int point)
{
var rating = new Rating();
rating.IDMer = id;
rating.Point = point;
db.Ratings.Add(rating);
db.SaveChanges();
var quantityRating = GetAllbyIDMerchant(id);
var Ratepoint = GetPointByIDMerchant(id);
var user = new AccountDAO().GetInfoByID(id);
if (quantityRating.Count == 5)
{
int?totalpoint = 0;
foreach (var item in quantityRating)
{
totalpoint += item.Point;
}
user.Rating = totalpoint / 5;
new AccountDAO().UpdateUserRating(id, user.Rating);
}
else if (quantityRating.Count > 5)
{
user.Rating = ((quantityRating.Count() * Ratepoint) + point) / (quantityRating.Count() + 1);
new AccountDAO().UpdateUserRating(id, user.Rating);
}
return(rating.ID);
}
public void SetAdOutOfDate()
{
var date = DateTime.Now;
var listad = db.advertisements.ToList();
foreach (var item in listad)
{
if (item.ActiveDate.HasValue)
{
if (date > item.EndDate)
{
item.Status = false;
}
}
}
db.SaveChanges();
}
public void SetAdAvailable()
{
var listad = db.advertisements.ToList();
foreach (var item in listad)
{
if (item.ActiveDate.HasValue)
{
var date = DateTime.Now;
if (date <= item.EndDate)
{
item.Status = true;
}
else
{
item.Status = false;
}
}
}
db.SaveChanges();
}
public bool Insert(OrderDetail detail)
{
try
{
db.OrderDetails.Add(detail);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public long Insert(BillAd bill)
{
db.BillAds.Add(bill);
db.SaveChanges();
return(bill.ID);
}
public long Insert(Product entity)
{
db.Products.Add(entity);
db.SaveChanges();
return(entity.ID);
}
public long Insert(Account entity)
{
db.Accounts.Add(entity);
db.SaveChanges();
return(entity.ID);
}
public long Insert(TotalOrder totaloder)
{
db.TotalOrders.Add(totaloder);
db.SaveChanges();
return(totaloder.ID);
}
public long Insert(ShopOrder shoporder)
{
db.ShopOrders.Add(shoporder);
db.SaveChanges();
return(shoporder.ID);
}
public void ResetPassWord(string pass, string email)
{
var user = GetAccountByEmail(email);
user.Password = pass;
db.SaveChanges();
}
public long Insert(OrderAdvertisement entity)
{
db.OrderAdvertisements.Add(entity);
db.SaveChanges();
return(entity.ID);
}