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