public void Get(int departmentId) { using (SchneiderSqlModel _database = new SchneiderSqlModel()) { Entity = _database.Departments.Find(departmentId); } }
public void Get(int employeeId) { using (SchneiderSqlModel _database = new SchneiderSqlModel()) { Entity = _database.Employees.Find(employeeId); } }
public void Get() { using (SchneiderSqlModel _database = new SchneiderSqlModel()) { Departments = _database.Departments.OrderBy(d => d.Name).ToList(); } }
public void Get() { using (SchneiderSqlModel _database = new SchneiderSqlModel()) { Employees = _database.Employees.OrderBy(d => d.Name).ToList(); } }
public void Delete(int departmentId) { using (SchneiderSqlModel _database = new SchneiderSqlModel()) { var department = _database.Departments.Find(departmentId); if (department != null) { _database.Departments.Remove(department); } _database.SaveChanges(); Get(); } }
public void Delete(int employeeId) { using (SchneiderSqlModel _database = new SchneiderSqlModel()) { var employee = _database.Employees.Find(employeeId); if (employee != null) { _database.Employees.Remove(employee); } _database.SaveChanges(); Get(); } }
private void SaveChangesToDataBase(SchneiderSqlModel _database) { //Check if it update of insert if (PageMode == PageConstants.Edit) { _database.Entry(Entity).State = EntityState.Modified; _database.SaveChanges(); } else if (PageMode == PageConstants.Add) { _database.Departments.Add(Entity); _database.SaveChanges(); } }
public void Save() { Messages.Clear(); using (SchneiderSqlModel _database = new SchneiderSqlModel()) { try { SaveChangesToDataBase(_database); //Get All Changes Get(); } catch (DbEntityValidationException exception) { CatchErrorToDispaly(exception); } } }
public void LoadSearchDepartments() { using (SchneiderSqlModel _database = new SchneiderSqlModel()) { if (Departments.Count == 0)//load from DB { SearchDepartments.AddRange(_database.Departments); } else // load from deparmtments list { SearchDepartments.AddRange(Departments); } //Add Search All Categories for Search All Department department = new Department(); department.Id = 0; department.Name = "-- Search All Departments --"; //Insert Department At th e top SearchDepartments.Insert(0, department); } }