public void Insert(VisitorBindingModel model) { using (var context = new ForumDatabase()) { Visitor visitor = CreateModel(model, new Visitor()); context.Visitor.Add(visitor); context.SaveChanges(); } }
private Visitor CreateModel(VisitorBindingModel model, Visitor visitor) { visitor.Countmessages = model.CountOfMessages; visitor.Decency = model.Decency; visitor.Status = model.Status; visitor.Login = model.LoginUser; visitor.Password = model.Password; visitor.Email = model.Email; visitor.TotalTime = model.TotalTime; return(visitor); }
public void Delete(VisitorBindingModel model) { var element = visitorStorage.GetElement(new VisitorBindingModel { LoginUser = model.LoginUser }); if (element == null) { throw new Exception("Элемент не найден"); } visitorStorage.Delete(model); }
public void Update(VisitorBindingModel model) { using (var context = new ForumDatabase()) { var visitor = context.Visitor.FirstOrDefault(rec => rec.Login == model.LoginUser); if (visitor == null) { throw new Exception("Элемент не найден"); } CreateModel(model, visitor); context.SaveChanges(); } }
public List <VisitorViewModel> Read(VisitorBindingModel model) { if (model == null) { return(visitorStorage.GetFullList()); } if (model.LoginUser != null) { return(new List <VisitorViewModel> { visitorStorage.GetElement(model) }); } return(visitorStorage.GetFilteredList(model)); }
public void CreateOrUpdate(VisitorBindingModel model) { if (visitorStorage.GetElement(new VisitorBindingModel { LoginUser = model.LoginUser, Password = model.Password }) != null) { visitorStorage.Update(model); } else { visitorStorage.Insert(model); } }
public void Delete(VisitorBindingModel model) { using (var context = new ForumDatabase()) { var element = context.Visitor.FirstOrDefault(rec => rec.Login == model.LoginUser); if (element != null) { context.Visitor.Remove(element); context.SaveChanges(); } else { throw new Exception("Элемент не найден"); } } }
public List <VisitorViewModel> GetFilteredList(VisitorBindingModel model) { using (var context = new ForumDatabase()) { return(context.Visitor.Where(rec => rec.Countmessages > model.CountOfMessages) .Select(rec => new VisitorViewModel { LoginUser = rec.Login, Password = rec.Password, Email = rec.Email, TotalTime = rec.TotalTime, Status = rec.Status, Decency = rec.Decency, CountOfMessages = rec.Countmessages, }).ToList()); } }
public VisitorViewModel GetElement(VisitorBindingModel model) { if (model == null) { return(null); } using (var context = new ForumDatabase()) { var visitor = context.Visitor.FirstOrDefault(rec => rec.Login == model.LoginUser && rec.Password == model.Password); return(visitor != null ? new VisitorViewModel { LoginUser = visitor.Login, Password = visitor.Password, Email = visitor.Email, TotalTime = visitor.TotalTime, Status = visitor.Status, Decency = visitor.Decency, CountOfMessages = visitor.Countmessages, } : null); } }