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