public void Registration(User us)
{
using (var db = new BaseDataContext())
{
var Log = db.Users.FirstOrDefault(b => b.Login == us.Login);
if (Log == null)
{
ViewBag.UserAuth = true;
us.Role = 0;
db.Users.Add(us);
db.SaveChanges();
Response.Cookies["UserId"].Value = Convert.ToString(us.Id);
Response.Cookies["UserId"].Expires = DateTime.Now.AddDays(1);
Response.Cookies["UserName"].Value = Convert.ToString(us.Name);
Response.Cookies["UserName"].Expires = DateTime.Now.AddDays(1);
Response.Cookies["UserRole"].Value = Convert.ToString(us.Role);
Response.Cookies["UserRole"].Expires = DateTime.Now.AddDays(1);
Response.Redirect("/");
}else
{
ModelState.AddModelError("", "Логин уже занят");
//return View();
}
}
}
public Perchase GetPerchase(int id)
{
using (var db = new BaseDataContext())
{
return db.Perchases.FirstOrDefault(b => b.Id == id);
}
}
public User GetUser(int id)
{
using (var db = new BaseDataContext())
{
return db.Users.FirstOrDefault(b => b.Id == id);
}
}
public Lot GetLot(int id)
{
using (var db = new BaseDataContext())
{
return db.Lots.FirstOrDefault(b => b.Id == id);
}
}
public void Login(string username, string password)
{
using (var db = new BaseDataContext())
{
User us = db.Users.FirstOrDefault(b => b.Login == username);
if (us.Pass == password)
{
Response.Cookies["UserId"].Value = Convert.ToString(us.Id);
Response.Cookies["UserId"].Expires = DateTime.Now.AddDays(1);
Response.Cookies["UserName"].Value = Convert.ToString(us.Name);
Response.Cookies["UserName"].Expires = DateTime.Now.AddDays(1);
Response.Cookies["UserRole"].Value = Convert.ToString(us.Role);
Response.Cookies["UserRole"].Expires = DateTime.Now.AddDays(1);
//FormsAuthentication.SetAuthCookie(username, false);
ViewBag.UserAuth = true;
if (us.Role == 1)
{
ViewBag.Admin = true;
Response.Redirect("/");
}
else
{
ViewBag.Admin = false;
Response.Redirect("/");
}
}
else
{
ModelState.AddModelError("", "Некорректное имя пользователя или пароль");
//return View();
}
}
}
public void DeletePerchase(int id)
{
using (var db = new BaseDataContext())
{
db.Perchases.Remove(db.Perchases.FirstOrDefault(b => b.Id == id));
}
}
public IEnumerable<Perchase> GetAllPerchases()
{
using (var db = new BaseDataContext())
{
IEnumerable<Perchase> Perchases = db.Perchases.ToArray();
return Perchases;
}
}
public ActionResult ViewList()
{
using (var dbBooks = new BaseDataContext())
{
IEnumerable<Lot> Lots = dbBooks.Lots.ToArray();
ViewBag.Lots = Lots;
}
return View("ViewList");
}
public ActionResult ViewListPerchases()
{
using (var db = new BaseDataContext())
{
IEnumerable<Perchase> Perchases = db.Perchases.ToArray();
ViewBag.Perchases = Perchases;
}
return View();
}
/*public User GetUser(int id)
{
using (var db = new BaseDataContext())
{
return db.Users.FirstOrDefault(b => b.Id == id);
}
}
public Lot GetLot(int id)
{
using (var db = new BaseDataContext())
{
return db.Lots.FirstOrDefault(b => b.Id == id);
}
}*/
public void DeletePerchase(int id)
{
using (var db = new BaseDataContext())
{
var p = db.Perchases.First(b => b.Id == id);
db.Perchases.Remove(p);
db.SaveChanges();
}
}
public ActionResult ViewListUsers()
{
using (var db = new BaseDataContext())
{
IEnumerable<User> Users = db.Users.ToArray();
ViewBag.Users = Users;
}
return View();
}
public ActionResult GetUser(int id)
{
using (var db = new BaseDataContext())
{
User us = db.Users.FirstOrDefault(b => b.Id == id);
if (us == null)
return HttpNotFound();
return View(us);
};
}
public ActionResult DeleteLot(int id)
{
using (var db = new BaseDataContext())
{
Lot l = db.Lots.Find(id);
if (l == null)
{
return HttpNotFound();
}
return View(l);
}
}
public ActionResult DeletePerchase(int id)
{
using (var db = new BaseDataContext())
{
Perchase l = db.Perchases.Find(id);
if (l == null)
{
return HttpNotFound();
}
return View(l);
}
}
public ActionResult DeleteConfirmed(int id)
{
using (var db = new BaseDataContext())
{
Lot l = db.Lots.Find(id);
if (l != null)
{
db.Lots.Remove(l);
db.SaveChanges();
}
}
return RedirectToRoute(new { controller = "List", action = "ViewList" });
}
public void DeleteConfirmed(int id)
{
using (var db = new BaseDataContext())
{
Perchase l = db.Perchases.Find(id);
if (l != null)
{
db.Perchases.Remove(l);
db.SaveChanges();
}
}
Response.Redirect("~/Admin/ViewListPerchases");
//return RedirectToRoute(new { controller = "Admin", action = "ViewList" });
}
public ActionResult AddLot(Lot _lot)
{
using (var db = new BaseDataContext())
{
if (_lot.ExpirationDateTime == null)
{
DateTime dt = DateTime.Today;
dt.AddDays(5);
_lot.ExpirationDateTime = dt;
}
db.Lots.Add(_lot);
db.SaveChanges();
}
return RedirectToRoute(new {controller="List",action="ViewList" });//!!!!!!!!!!!!!!!!
}
public ActionResult ViewList()
{
using (var dbBooks = new BaseDataContext())
{
IEnumerable<Lot> Lots = dbBooks.Lots.ToArray();
ViewBag.Lots = Lots;
ViewBag.Admin = false;
try
{
if (Request.Cookies["UserRole"].Value == "1")
ViewBag.Admin = true;
}catch { }
}
return View("ViewList");
}
public ActionResult EditLot(int? id)
{
if (id == null)
{
return HttpNotFound();
}
using (var db = new BaseDataContext())
{
Lot _lot = db.Lots.Find(id);
if (_lot != null)
{
return View(_lot);
}
}
return HttpNotFound();
}
public ActionResult EditLot(Lot _lot)
{
using (var db = new BaseDataContext())
{
db.Entry(_lot).State = EntityState.Modified;
db.SaveChanges();
}
return RedirectToRoute(new { controller = "List", action = "ViewList" });
}
public ActionResult GetLot(int id)
{
using (var db = new BaseDataContext())
{
Lot lot = db.Lots.FirstOrDefault(b => b.Id == id);
if (lot == null)
return HttpNotFound();
return View(lot);
};
}
public ActionResult Raise(string price, int id)
{
using (var db = new BaseDataContext())
{
int newPrice = int.Parse(price);
Lot lot = db.Lots.FirstOrDefault(b => b.Id == id);
if (lot == null)
return HttpNotFound();
if (lot.Price < newPrice)
{
Perchase _perchase = db.Perchases.FirstOrDefault(b => b.LotId == lot.Id);
if(_perchase!=null)
{
_perchase.UserId = int.Parse(Request.Cookies["UserId"].Value);
db.Entry(_perchase).State = EntityState.Modified;
}else
{
_perchase = new Perchase();
_perchase.LotId = lot.Id;
_perchase.UserId = int.Parse(Request.Cookies["UserId"].Value);
db.Perchases.Add(_perchase);
}
db.SaveChanges();
lot.Price = int.Parse(price);
db.Entry(lot).State = EntityState.Modified;
try
{
db.SaveChanges();
return RedirectToRoute(new { controller = "List", action = "ViewList" });
}
catch (DbEntityValidationException ex)
{
foreach (DbEntityValidationResult validationError in ex.EntityValidationErrors)
{
Response.Write("Object: " + validationError.Entry.Entity.ToString());
foreach (DbValidationError err in validationError.ValidationErrors)
{
Response.Write(" ");
Response.Write(err.ErrorMessage + "");
}
}
};
}
Response.Write("Цена слишком мала!");
return View();
}
//return RedirectToRoute(new { controller = "List", action = "ViewList" });
}
public ActionResult EditLot(Lot _lot)
{
using (var db = new BaseDataContext())
{
db.Entry(_lot).State = EntityState.Modified;
try
{
db.SaveChanges();
return RedirectToRoute(new { controller = "List", action = "ViewList" });
}
catch (DbEntityValidationException ex)
{
foreach (DbEntityValidationResult validationError in ex.EntityValidationErrors)
{
Response.Write("Object: " + validationError.Entry.Entity.ToString());
foreach (DbValidationError err in validationError.ValidationErrors)
{
Response.Write(" ");
Response.Write(err.ErrorMessage + "");
}
}
};
return View();
}
}
