public ProviderViewModel GetElement(ProviderBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new TechiqueShopDatabase())
{
var provider = context.Providers
.FirstOrDefault(rec => rec.ProviderName == model.ProviderName ||
rec.Id == model.Id);
return(provider != null ?
new ProviderViewModel
{
Id = provider.Id,
ProviderName = provider.ProviderName,
ProviderSurname = provider.ProviderSurname,
Patronymic = provider.Patronymic,
Telephone = provider.Telephone,
Email = provider.Email,
Password = provider.Password,
UserType = provider.UserType
} :
null);
}
}
public void Insert(ProviderBindingModel model)
{
using (var context = new TechiqueShopDatabase())
{
context.Providers.Add(CreateModel(model, new Provider()));
context.SaveChanges();
}
}
public void Update(ProviderBindingModel model)
{
using (var context = new TechiqueShopDatabase())
{
var element = context.Providers.FirstOrDefault(rec => rec.Id ==
model.Id);
if (element == null)
{
throw new Exception("Провайдер не найден");
}
CreateModel(model, element);
context.SaveChanges();
}
}
public void Delete(ProviderBindingModel model)
{
using (var context = new TechiqueShopDatabase())
{
Provider element = context.Providers.FirstOrDefault(rec => rec.Id ==
model.Id);
if (element != null)
{
context.Providers.Remove(element);
context.SaveChanges();
}
else
{
throw new Exception("Провайдер не найден");
}
}
}
public List <ProviderViewModel> GetFullList()
{
using (var context = new TechiqueShopDatabase())
{
return(context.Providers
.Select(rec => new ProviderViewModel
{
Id = rec.Id,
ProviderName = rec.ProviderName,
ProviderSurname = rec.ProviderSurname,
Patronymic = rec.Patronymic,
Telephone = rec.Telephone,
Email = rec.Email,
Password = rec.Password,
UserType = rec.UserType
})
.ToList());
}
}
public List <ProviderViewModel> GetFilteredList(ProviderBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new TechiqueShopDatabase())
{
return(context.Providers
.Where(rec => rec.ProviderName.Contains(model.ProviderName))
.Select(rec => new ProviderViewModel
{
Id = rec.Id,
ProviderName = rec.ProviderName,
ProviderSurname = rec.ProviderSurname,
Patronymic = rec.Patronymic,
Telephone = rec.Telephone,
Email = rec.Email,
Password = rec.Password,
UserType = rec.UserType
})
.ToList());
}
}
