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