protected async override Task UpdateAsync(FarmingEntities db, UserViewModel model) { var user = await db.Users.FindAsync(model.Id); if (user != null) { user.Login = model.Login; user.Password = model.Password; user.LastName = model.LastName; user.FirstName = model.FirstName; user.MiddleName = model.MiddleName; user.Phone = model.Phone.Value; user.UserTypeId = model.UserTypeId; await db.SaveChangesAsync(); var userVm = Models.FirstOrDefault(u => u.Id == user.Id); if (userVm != null) { userVm.Login = model.Login; userVm.Password = model.Password; userVm.LastName = model.LastName; userVm.FirstName = model.FirstName; userVm.MiddleName = model.MiddleName; userVm.Phone = model.Phone.Value; userVm.UserTypeId = model.UserTypeId; userVm.UserType = model.UserType; } } }
protected async override Task UpdateAsync(FarmingEntities db, ReproductionViewModel model) { var reproduction = await db.Reproductions.FindAsync(model.Id); if (reproduction != null) { reproduction.BullId = model.BullId; reproduction.CowId = model.CowId; reproduction.MethodSluchkiId = model.MethodSluchkiId; reproduction.DateOsemeneniya = model.DateOsemeneniya.Value; reproduction.ChisloSuhihDney = model.ChisloSuhihDney.Value; reproduction.SerPeriod = model.SerPeriod.Value; reproduction.DateOtela = model.DateOtela.Value; await db.SaveChangesAsync(); var reproductionVm = Models.FirstOrDefault(r => r.Id == reproduction.Id); if (reproductionVm != null) { reproductionVm.BullId = model.BullId; reproductionVm.Bull = model.Bull; reproductionVm.CowId = model.CowId; reproductionVm.Cow = model.Cow; reproductionVm.MethodSluchkiId = model.MethodSluchkiId; reproductionVm.MethodSluchki = model.MethodSluchki; reproductionVm.DateOsemeneniya = model.DateOsemeneniya; reproductionVm.ChisloSuhihDney = model.ChisloSuhihDney; reproductionVm.SerPeriod = model.SerPeriod; reproductionVm.DateOtela = model.DateOtela; } } }
protected async override Task UpdateAsync(FarmingEntities db) { await _cowsViewModel.UpdateAsync(); await _methodsSluchkiViewModel.UpdateAsync(); var reproductions = await db.Reproductions.ToArrayAsync(); foreach (var r in reproductions) { Models.Add(new ReproductionViewModel() { Id = r.Id, CowId = r.CowId, MethodSluchkiId = r.MethodSluchkiId, BullId = r.BullId, DateOsemeneniya = r.DateOsemeneniya, ChisloSuhihDney = r.ChisloSuhihDney, SerPeriod = r.SerPeriod, DateOtela = r.DateOtela, Bull = _cowsViewModel.BullsViewModel.Models.FirstOrDefault(b => b.Id == r.BullId), Cow = _cowsViewModel.Models.FirstOrDefault(c => c.Id == r.CowId), MethodSluchki = _methodsSluchkiViewModel.Models.FirstOrDefault(m => m.Id == r.MethodSluchkiId) }); } }
protected async override Task UpdateAsync(FarmingEntities db) { await _cowsViewModel.UpdateAsync(); var productivities = await db.Productivities.ToArrayAsync(); ProductivityViewModel productivity; foreach (var p in productivities) { productivity = new ProductivityViewModel() { Id = p.Id, CowId = p.CowId, UchtenoLaktacij = p.UchtenoLaktacij, UdojKg = p.UdojKg, ZhirProz = p.ZhirProz, BelokProz = p.BelokProz, Date = p.Date, Cow = _cowsViewModel.Models.FirstOrDefault(c => c.Id == p.CowId) }; Models.Add(productivity); } }
protected async override Task UpdateAsync(FarmingEntities db, ProductivityViewModel model) { var productivity = await db.Productivities.FindAsync(model.Id); if (productivity != null) { productivity.CowId = model.CowId; productivity.UchtenoLaktacij = model.UchtenoLaktacij.Value; productivity.UdojKg = model.UdojKg.Value; productivity.ZhirProz = model.ZhirProz.Value; productivity.BelokProz = model.BelokProz.Value; productivity.Date = model.Date.Value; await db.SaveChangesAsync(); var productivityVm = Models.FirstOrDefault(p => p.Id == productivity.Id); if (productivityVm != null) { productivityVm.CowId = model.CowId; productivityVm.Cow = model.Cow; productivityVm.UchtenoLaktacij = model.UchtenoLaktacij; productivityVm.UdojKg = model.UdojKg; productivityVm.ZhirProz = model.ZhirProz; productivityVm.BelokProz = model.BelokProz; productivityVm.Date = model.Date; } } }
protected async override Task AddAsync(FarmingEntities db, CowViewModel model) { var cow = new Cow() { BreedId = model.BreedId, LineId = model.LineId, FamilyId = model.FamilyId, CategoryId = model.CategoryId, BloodTypeId = model.BloodTypeId, MotherId = model.MotherId, FatherId = model.FatherId, Porodnost = model.Porodnost.Value, Name = model.Name, BDay = model.BDay.Value, BPlace = model.BPlace, Weight = model.Weight.Value, Age = model.Age.Value, IsInHerd = model.IsInHerd.Value, }; db.Cows.Add(cow); await db.SaveChangesAsync(); model.Id = cow.Id; Models.Add(model); }
protected async override Task UpdateAsync(FarmingEntities db) { await _cowsViewModel.UpdateAsync(); await _gendersViewModel.UpdateAsync(); var priplods = await db.Priplods.ToArrayAsync(); PriplodViewModel priplod; foreach (var p in priplods) { priplod = new PriplodViewModel() { Id = p.Id, CowId = p.CowId, GenderId = p.GenderId, Weight = p.Weight, Gender = _gendersViewModel.Models.FirstOrDefault(g => g.Id == p.GenderId), Mother = _cowsViewModel.Models.FirstOrDefault(c => c.Id == p.CowId) }; Models.Add(priplod); } }
public async Task SignInAsync(string login, SecureString password) { if (string.IsNullOrWhiteSpace(login) || password == null || password.Length == 0) { throw new ArgumentException("Логин или пароль не должен быть пустым"); } password.MakeReadOnly(); User user = null; using (var db = new FarmingEntities()) { var pwd = password.Unsecure(); user = await db.Users.SingleOrDefaultAsync( u => u.Login == login && u.Password == pwd); if (user != null) { user.Password = string.Empty; user.UserType = await db.UsersTypes.FindAsync(user.UserTypeId); } } if (user == null) { throw new InvalidOperationException("Неверный логин или пароль."); } else { OnSuccessfulSignIn(new ConnectionEventArgs(user, password)); } }
protected async override Task UpdateAsync(FarmingEntities db) { await _bullsViewModel.UpdateAsync(); await _bloodTypesViewModel.UpdateAsync(); await _categoriesViewModel.UpdateAsync(); await _linesViewModel.UpdateAsync(); await _familiesViewModel.UpdateAsync(); await _breedsViewModel.UpdateAsync(); var cows = await db.Cows.ToArrayAsync(); CowViewModel cow; foreach (var c in cows) { cow = new CowViewModel() { Id = c.Id, BreedId = c.BreedId, LineId = c.LineId, FamilyId = c.FamilyId, CategoryId = c.CategoryId, BloodTypeId = c.BloodTypeId, MotherId = c.MotherId, FatherId = c.FatherId, Porodnost = c.Porodnost, Name = c.Name, BDay = c.BDay, BPlace = c.BPlace, Weight = c.Weight, Age = c.Age, IsInHerd = c.IsInHerd, Father = _bullsViewModel.Models.FirstOrDefault(b => b.Id == c.FatherId), BloodType = _bloodTypesViewModel.Models.FirstOrDefault(b => b.Id == c.BloodTypeId), Category = _categoriesViewModel.Models.FirstOrDefault(_c => _c.Id == c.CategoryId), Line = _linesViewModel.Models.FirstOrDefault(l => l.Id == c.LineId), Breed = _breedsViewModel.Models.FirstOrDefault(b => b.Id == c.BreedId), Family = _familiesViewModel.Models.FirstOrDefault(f => f.Id == c.FamilyId) }; Models.Add(cow); } foreach (var c in Models) { c.Mother = Models.FirstOrDefault(m => m.Id == c.MotherId); } }
protected async override Task UpdateAsync(FarmingEntities db) { var bulls = await db.Bulls.ToArrayAsync(); var cows = await db.Cows.ToArrayAsync(); var rpds = await db.Reproductions.ToArrayAsync(); BullViewModel _bull; foreach (var bull in bulls) { _bull = new BullViewModel() { Id = bull.Id, Location = bull.Location, OtherId = bull.OtherId }; foreach (var children in cows.Where(c => c.FatherId == bull.Id)) { _bull.Childrens.Add(new CowViewModel() { Id = children.Id, Name = children.Name, Porodnost = children.Porodnost, Weight = children.Weight, Age = children.Age, BPlace = children.BPlace, BDay = children.BDay, FatherId = _bull.Id, Father = _bull }); } foreach (var rep in rpds.Where(r => r.BullId == bull.Id)) { _bull.Reproductions.Add(new ReproductionViewModel() { Id = rep.Id, DateOsemeneniya = rep.DateOsemeneniya, ChisloSuhihDney = rep.ChisloSuhihDney, SerPeriod = rep.SerPeriod, DateOtela = rep.DateOtela, Bull = _bull, BullId = _bull.Id }); } Models.Add(_bull); } }
protected async override Task DeleteAsync(FarmingEntities db, GenderViewModel model) { var gender = await db.Genders.FindAsync(model.Id); if (gender != null) { db.Genders.Remove(gender); await db.SaveChangesAsync(); Models.Remove(model); } }
protected async override Task DeleteAsync(FarmingEntities db, ProductivityViewModel model) { var productivity = await db.Productivities.FindAsync(model.Id); if (productivity != null) { db.Productivities.Remove(productivity); await db.SaveChangesAsync(); Models.Remove(model); } }
protected async override Task UpdateAsync(FarmingEntities db) { var families = await db.Families.ToArrayAsync(); foreach (var family in families) { Models.Add(new FamilyViewModel() { Id = family.Id, Name = family.Name }); } }
protected async override Task DeleteAsync(FarmingEntities db, CowViewModel model) { var cow = await db.Cows.FindAsync(model.Id); if (cow != null) { db.Cows.Remove(cow); await db.SaveChangesAsync(); Models.Remove(model); } }
protected async override Task DeleteAsync(FarmingEntities db, BloodTypeViewModel model) { var bType = await db.BloodTypes.FindAsync(model.Id); if (bType != null) { db.BloodTypes.Remove(bType); await db.SaveChangesAsync(); Models.Remove(model); } }
protected async override Task UpdateAsync(FarmingEntities db) { var categories = await db.Categories.ToArrayAsync(); foreach (var category in categories) { Models.Add(new CategoryViewModel() { Id = category.Id, Name = category.Name }); } }
protected async override Task DeleteAsync(FarmingEntities db, BreedViewModel model) { var breed = await db.Breeds.FindAsync(model.Id); if (breed != null) { db.Breeds.Remove(breed); await db.SaveChangesAsync(); Models.Remove(model); } }
protected async override Task DeleteAsync(FarmingEntities db, UserViewModel model) { var user = await db.Users.FindAsync(model.Login); if (user != null) { db.Users.Remove(user); await db.SaveChangesAsync(); Models.Remove(model); } }
protected async override Task UpdateAsync(FarmingEntities db) { var methodsSluchki = await db.MethodsSluchki.ToArrayAsync(); foreach (var methodSluchki in methodsSluchki) { Models.Add(new MethodSluchkiViewModel() { Id = methodSluchki.Id, Name = methodSluchki.Name }); } }
protected async override Task UpdateAsync(FarmingEntities db) { var usersTypes = await db.UsersTypes.ToArrayAsync(); foreach (var userType in usersTypes) { Models.Add(new UserTypeViewModel() { Id = userType.Id, Name = userType.Name }); } }
protected async override Task DeleteAsync(FarmingEntities db, LineViewModel model) { var line = await db.Lines.FindAsync(model.Id); if (line != null) { db.Lines.Remove(line); await db.SaveChangesAsync(); Models.Remove(model); } }
protected async override Task UpdateAsync(FarmingEntities db) { var lines = await db.Lines.ToArrayAsync(); foreach (var line in lines) { Models.Add(new LineViewModel() { Id = line.Id, Name = line.Name }); } }
protected async override Task UpdateAsync(FarmingEntities db) { var genders = await db.Genders.ToArrayAsync(); foreach (var gender in genders) { Models.Add(new GenderViewModel() { Id = gender.Id, Name = gender.Name }); } }
protected async override Task DeleteAsync(FarmingEntities db, CategoryViewModel model) { var category = await db.Categories.FindAsync(model.Id); if (category != null) { db.Categories.Remove(category); await db.SaveChangesAsync(); Models.Remove(model); } }
protected async override Task UpdateAsync(FarmingEntities db) { var breeds = await db.Breeds.ToArrayAsync(); foreach (var breed in breeds) { Models.Add(new BreedViewModel() { Id = breed.Id, Name = breed.Name }); } }
protected async override Task DeleteAsync(FarmingEntities db, ReproductionViewModel model) { var reproduction = await db.Reproductions.FindAsync(model.Id); if (reproduction != null) { db.Reproductions.Remove(reproduction); await db.SaveChangesAsync(); Models.Remove(model); } }
protected async override Task DeleteAsync(FarmingEntities db, MethodSluchkiViewModel model) { var methodSluchki = await db.MethodsSluchki.FindAsync(model.Id); if (methodSluchki != null) { db.MethodsSluchki.Remove(methodSluchki); await db.SaveChangesAsync(); Models.Remove(model); } }
protected async override Task DeleteAsync(FarmingEntities db, FamilyViewModel model) { var family = await db.Families.FindAsync(model.Id); if (family != null) { db.Families.Remove(family); await db.SaveChangesAsync(); Models.Remove(model); } }
protected async override Task DeleteAsync(FarmingEntities db, RetirementViewModel model) { var retirement = await db.Retirements.FindAsync(model.Id); if (retirement != null) { db.Retirements.Remove(retirement); await db.SaveChangesAsync(); Models.Remove(model); } }
protected async override Task UpdateAsync(FarmingEntities db) { var bloodyTypes = await db.BloodTypes.ToArrayAsync(); foreach (var bType in bloodyTypes) { Models.Add(new BloodTypeViewModel() { Id = bType.Id, Name = bType.Name }); } }