public IEnumerable <DepartmentsEntity> ReadAll() { List <DepartmentsEntity> departments = new List <DepartmentsEntity>(); string _procedure = "READ_Departments"; var(_connection, _command, _transaction) = new ConnectionManager().CreateConnection(_procedure); using (_connection) { try { using (SqlDataReader _dataReader = _command.ExecuteReader()) { while (_dataReader.Read()) { DepartmentsEntity _department = new DepartmentsEntity() { Id = _dataReader.GetInt32("id"), Name = _dataReader.GetString("name") }; departments.Add(_department); } _dataReader.Close(); //_transaction.Commit(); } } catch (Exception ex) { Debug.Write(ex.Message); //_transaction.Rollback(); } } return(departments); }
public void AddDepartment(DepartmentsViewModel _department) { DepartmentsEntity department = new DepartmentsEntity(); department.Id = _department.Id; department.Name = _department.Name; new DepartmentsRepository().Insert(department); }
//----------------------------------------------------------- public DepartmentsEntity Insert(DepartmentsEntity _department) { string _procedure = "CRT_Departments"; var(_connection, _command, _transaction) = new ConnectionManager().CreateConnection(_procedure); _command.Parameters.Add(new SqlParameter("@_depname", _department.Name)); new ConnectionManager().ExecuteNonQuery(_connection, _command, _transaction); return(_department); }
public DepartmentsViewModel UpdateDepartment(DepartmentsViewModel _department) { DepartmentsEntity upd_department = new DepartmentsEntity() { Id = _department.Id, Name = _department.Name }; new DepartmentsRepository().Update(upd_department.Id, upd_department); return(this.ReadOneDepartment(_department.Id)); }
//----------------------------------------------------------- public DepartmentsEntity ReadOne(int _id) { DepartmentsEntity departments = new DepartmentsEntity(); string _procedure = "READ_Departments_one"; var(_connection, _command, _transaction) = new ConnectionManager().CreateConnection(_procedure); _command.Parameters.Add(new SqlParameter("@_id", _id)); using (_connection) { try { using (SqlDataReader _dataReader = _command.ExecuteReader()) { while (_dataReader.Read()) { DepartmentsEntity _department = new DepartmentsEntity() { Id = _dataReader.GetInt32("id"), Name = _dataReader.GetString("name") }; departments = _department; } _dataReader.Close(); //_transaction.Commit(); } } catch (Exception ex) { Debug.Write(ex.Message); //_transaction.Rollback(); } } return(departments); }