public decimal SummOfGoodsSold()
{
decimal summ = 0;
using (OnlineStoreEntities db = new OnlineStoreEntities())
{
List <orderDTO> orders = new List <orderDTO>();
orders = mapper.Map <List <orderDTO> >(db.C_order_.ToList());
DateTime now = DateTime.Now;
foreach (orderDTO order in orders)
{
// if ((now - order.sell_time).TotalDays < 30)
if (now.Month == order.sell_time.Month)
{
product_id prod = db.product_id
.Where(u => u.product_id1 == order.product_id)
.FirstOrDefault();
productDTO new_prod = mapper.Map <productDTO>(prod);
summ += new_prod.price;
}
}//дали розбити .сума куплениї можна прото поточний місяць і з знижкою 3 параметри брати ід продукт ід і знижку і ставити там
}
return(summ);
}
public void AddUser(userDTO user)
{
using (var db = new OnlineStoreEntities())
{
user_id target = mapper.Map <user_id>(user);
db.user_id.Add(target);
db.SaveChanges();
}
}
//[any methods]
protected void Session_Start()
{
// 'using' will call entity.Dispose() at the end of the block so you
// don't have to bother about disposing your entity
using (OnlineStoreEntities entity = new OnlineStoreEntities()){
// store your categories inside a Session variable as a List<Category>
Session["Categories"] = entity.Categories.ToList();
}
}
public List <productDTO> GetAllProducts()
{
List <productDTO> products = new List <productDTO>();
using (OnlineStoreEntities db = new OnlineStoreEntities())
{
products = mapper.Map <List <productDTO> >(db.product_id.ToList());
}
return(products);
}
public List <userDTO> GetAllUsers()
{
List <userDTO> users = new List <userDTO>();
using (OnlineStoreEntities db = new OnlineStoreEntities())
{
users = mapper.Map <List <userDTO> >(db.user_id.ToList());
return(users);
}
}
public userDTO GetUserByID(int Id)
{
using (OnlineStoreEntities db = new OnlineStoreEntities())
{
user_id target = db.user_id
.Where(u => u.id == Id)
.FirstOrDefault();
return(mapper.Map <userDTO>(target));
}
}
public void DeleteUser(int id)
{
using (OnlineStoreEntities db = new OnlineStoreEntities())
{
//db.user_id.Attach(user);
// db.user_id.Remove(user);
user_id target = db.user_id
.Where(u => u.id == id)
.FirstOrDefault();
db.Entry(target).State = EntityState.Deleted;
db.SaveChanges();
}
}
protected void Session_Start()
{
// 'using' will call entity.Dispose() at the end of the block so you
// don't have to bother about disposing your entity
using (OnlineStoreEntities entity = new OnlineStoreEntities()){
HttpContext context = HttpContext.Current;
if (context != null && context.Session != null)
{
// fill the Session var with the Categories from your database
context.Session["Categories"] = entity.Categories.ToList();
}
}
}
public void SetDiscountForUser(int Id, int productId, int discount)
{
using (OnlineStoreEntities db = new OnlineStoreEntities())
{
discountDTO add = new discountDTO
{
id = Id,
product_id = productId,
discount1 = discount
};
db.discounts.Add(mapper.Map <discount>(add));
db.SaveChanges();
}
}
public int UpdateUser(userDTO user)
{
using (OnlineStoreEntities db = new OnlineStoreEntities())
{
user_id target = db.user_id
.Where(u => u.id == user.id)
.FirstOrDefault();
//target = mapper.Map<user_id>(user);
target.user_name = user.user_name;
target.first_Name = user.first_Name;
target.last_Name = user.last_Name;
target.address = user.address;
db.SaveChanges();
return(target.id);
}
}
public ActionResult Register(RegisterModel model)
{
if (ModelState.IsValid)
{
User user = null;
using (OnlineStoreEntities db = new OnlineStoreEntities())
{
user = db.Users.FirstOrDefault(u => u.Login == model.Login);
}
if (user == null)
{
string salt = Hashing.Hashing.CreateSalt();
string hashPass = Hashing.Hashing.GenerateHash(model.Password + salt);
using (OnlineStoreEntities db = new OnlineStoreEntities())
{
db.Users.Add(new User {
Login = model.Login,
Password = hashPass,
RoleId = 2,
Salt = salt,
Email = "",
FullName = "",
Money = 1000000
});
db.SaveChanges();
user = db.Users.Where(u => u.Login == model.Login && u.Password == hashPass).FirstOrDefault();
}
if (user != null)
{
FormsAuthentication.SetAuthCookie(model.Login, true);
return(RedirectToAction("Index", "Test"));
}
}
else
{
ModelState.AddModelError("", "Пользователь с такими логином уже существует");
}
}
return(View(model));
}
public ActionResult Login(LoginModel model)
{
User user = null;
using (OnlineStoreEntities db = new OnlineStoreEntities())
{
user = db.Users.FirstOrDefault(u => u.Login == model.Login);
}
string hashPass = Hashing.Hashing.GenerateHash(model.Password + user.Salt);
if (hashPass == user.Password)
{
FormsAuthentication.SetAuthCookie(model.Login, true);
return(RedirectToAction("Index", "Test"));
}
else
{
ModelState.AddModelError("", "Неверный логин или пароль");
}
return(View(model));
}
public CartRepository(OnlineStoreEntities dbContext)
{
this.dbContext = dbContext;
}
public ShippingRepository(OnlineStoreEntities dbContext)
{
this.dbContext = dbContext;
}
public OrderDetailRepository(OnlineStoreEntities dbContext)
{
this.dbContext = dbContext;
}
