public static void DeleteUser(int id)
{
using (var context = new RaPContext())
{
User user = context.Users.FirstOrDefault(u => u.Id == id);
user.CompanyId = null;
context.SaveChanges();
}
}
public static void DeleteCompany(int id)
{
using (var context = new RaPContext())
{
Company company = context.Companies.FirstOrDefault(c => c.Id == id);
context.Companies.Remove(company);
context.SaveChanges();
}
}
public static void EditUser(int id, string login, string password, Company company)
{
using (var context = new RaPContext())
{
User old = context.Users.FirstOrDefault(u => u.Id == id);
old.Login = login;
old.Password = password;
old.CompanyId = company.Id;
context.SaveChanges();
}
}
public static void EditCompany(int id, string name, string status)
{
using (var context = new RaPContext())
{
Company old = context.Companies.FirstOrDefault(c => c.Id == id);
old.Name = name;
old.ContractStatus = status;
context.SaveChanges();
}
}
public static void AddCompany(string name, string status)
{
using (var context = new RaPContext())
{
context.Companies.Add(new Company()
{
Name = name,
ContractStatus = status
});
context.SaveChanges();
}
}
public static void AddUser(string login, string password, Company company)
{
using (var context = new RaPContext())
{
context.Users.Add(new User()
{
Login = login,
Password = password,
CompanyId = company.Id
});
context.SaveChanges();
}
}
