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