public Branch GetItem(int branchId)
{
using (dataBase = new FinancialInstitutionEntities())
{
return(dataBase.Branches.Find(branchId));
}
}
public Client GetItem(int clientId)
{
using (dataBase = new FinancialInstitutionEntities())
{
return(dataBase.Clients.Find(clientId));
}
}
public IEnumerable <Employee> GetList()
{
using (dataBase = new FinancialInstitutionEntities())
{
return(dataBase.Employees.ToList());
}
}
public IEnumerable <Position> GetList()
{
using (dataBase = new FinancialInstitutionEntities())
{
return(dataBase.Positions.AsEnumerable());
}
}
public Position GetItem(int positionId)
{
using (dataBase = new FinancialInstitutionEntities())
{
return(dataBase.Positions.Where(p => p.Id == positionId).First());
}
}
public List <ServicesDirectory> GetAll()
{
using (dataBase = new FinancialInstitutionEntities())
{
return(dataBase.ServicesDirectories.ToList());
}
}
public IEnumerable <Branch> GetList()
{
using (dataBase = new FinancialInstitutionEntities())
{
return(dataBase.Branches.ToList());
}
}
public Employee GetItem(int employeeId)
{
using (dataBase = new FinancialInstitutionEntities())
{
return(dataBase.Employees.Where(e => e.Id == employeeId).First());
}
}
public IEnumerable <Employee> GetListWithBranchAndPosition()
{
using (dataBase = new FinancialInstitutionEntities())
{
return(dataBase.Employees.Include(e => e.Position).Include(e => e.Branch).ToList());
}
}
public IEnumerable <Client> GetList()
{
using (dataBase = new FinancialInstitutionEntities())
{
return(dataBase.Clients.ToList());
}
}
public Employee GetItemWithBranchAndPosition(int employeeId)
{
using (dataBase = new FinancialInstitutionEntities())
{
return(dataBase.Employees.Include(e => e.Branch).Include(e => e.Position).Where(e => e.Id == employeeId).First());
}
}
public IEnumerable <ServicesHistory> GetList()
{
using (dataBase = new FinancialInstitutionEntities())
{
return(dataBase.ServicesHistories.ToList());
}
}
public IEnumerable <ServicesHistory> GetAll()
{
using (dataBase = new FinancialInstitutionEntities())
{
return(dataBase.ServicesHistories.Include(sh => sh.Client).Include(sh => sh.Employee).Include(sh => sh.Employee.Branch).Include(sh => sh.ServicesDirectory).Include(sh => sh.Employee.Position).ToList());
}
}
public ServicesHistory GetItem(int serviceHistoryId)
{
using (dataBase = new FinancialInstitutionEntities())
{
return(dataBase.ServicesHistories.Find(serviceHistoryId));
}
}
public void Insert(Position position)
{
using (dataBase = new FinancialInstitutionEntities())
{
dataBase.Positions.Add(position);
dataBase.SaveChanges();
}
}
public void Insert(Client client)
{
using (dataBase = new FinancialInstitutionEntities())
{
dataBase.Clients.Add(client);
dataBase.SaveChanges();
}
}
public void Delete(int posiitonId)
{
using (dataBase = new FinancialInstitutionEntities())
{
dataBase.Positions.Remove(dataBase.Positions.Where(p => p.Id == posiitonId).First());
dataBase.SaveChanges();
}
}
public ServicesDirectory GetItem(int serviceId)
{
using (dataBase = new FinancialInstitutionEntities())
{
ServicesDirectory sd = dataBase.ServicesDirectories.Find(serviceId);
return(sd);
}
}
public void Insert(Branch branch)
{
using (dataBase = new FinancialInstitutionEntities())
{
dataBase.Branches.Add(branch);
dataBase.SaveChanges();
}
}
public void Insert(ServicesHistory serviceHistory)
{
using (dataBase = new FinancialInstitutionEntities())
{
dataBase.ServicesHistories.Add(serviceHistory);
dataBase.SaveChanges();
}
}
public void Delete(int employeeId)
{
using (dataBase = new FinancialInstitutionEntities())
{
dataBase.Employees.Remove(dataBase.Employees.Where(e => e.Id == employeeId).First());
dataBase.SaveChanges();
}
}
public void Delete(int serviceHistoryId)
{
using (dataBase = new FinancialInstitutionEntities())
{
ServicesHistory sh = dataBase.ServicesHistories.Find(serviceHistoryId);
dataBase.ServicesHistories.Remove(sh);
}
}
public void Insert(Employee employee)
{
using (dataBase = new FinancialInstitutionEntities())
{
dataBase.Employees.Add(employee);
dataBase.SaveChanges();
}
}
public void Delete(int Id)
{
using (dataBase = new FinancialInstitutionEntities())
{
Branch removableBranch = dataBase.Branches.Find(Id);
dataBase.Branches.Remove(removableBranch);
dataBase.SaveChanges();
}
}
public void Update(int Id, Branch branch)
{
using (dataBase = new FinancialInstitutionEntities())
{
Client changeableBranch = dataBase.Clients.Find(Id);
dataBase.SaveChanges();
}
}
public void Update(int serviceId, ServicesDirectory service)
{
using (dataBase = new FinancialInstitutionEntities())
{
ServicesDirectory sd = dataBase.ServicesDirectories.Find(serviceId);
sd.Name = service.Name;
dataBase.SaveChanges();
}
}
public void Update(int clientId, Client client)
{
using (dataBase = new FinancialInstitutionEntities())
{
Client changeableClient = dataBase.Clients.Find(clientId);
dataBase.SaveChanges();
}
}
public void Delete(int clientId)
{
using (dataBase = new FinancialInstitutionEntities())
{
Client removableClient = dataBase.Clients.Find(clientId);
dataBase.Clients.Remove(removableClient);
dataBase.SaveChanges();
}
}
public void Delete(int serviceId)
{
using (dataBase = new FinancialInstitutionEntities())
{
ServicesDirectory sd = dataBase.ServicesDirectories.Find(serviceId);
dataBase.ServicesDirectories.Remove(sd);
dataBase.SaveChanges();
}
}
public void Update(int positionId, Position position)
{
using (dataBase = new FinancialInstitutionEntities())
{
Position changeablePosition = dataBase.Positions.Find(positionId);
changeablePosition = position;
changeablePosition.Id = positionId;
dataBase.SaveChanges();
}
}
