public List <ModelDepartment> GetListOfDepartments(EnumDepartmentsType.DepartmentType departmentType)
{
List <ModelDepartment> myListOfCompanies = new List <ModelDepartment>();
RepositoryManager.ExecuteSqlCommand((command) =>
{
command.CommandText = @"select * from [dbo].[Department]
where DepartmentType=@DepartmentType";
command.Parameters.Add("@DepartmentType", SqlDbType.NVarChar).Value = departmentType.ToString();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ModelDepartment company = new ModelDepartment
{
Id = reader.GetInt32(0),
Name = reader.GetString(1),
Code = reader.GetString(2),
DepartmentType = departmentType,
SuperiorDepartmentId = reader.IsDBNull(4) ? null : (int?)reader.GetInt32(4),
ManagerEmployeeId = reader.IsDBNull(5) ? null : (int?)reader.GetInt32(5)
};
myListOfCompanies.Add(company);
}
}
});
return(myListOfCompanies);
}
public bool UpdateDepartment(string name, string code, int?managerId, EnumDepartmentsType.DepartmentType departmentType,
int?superiorDepartmentId, int id)
{
ModelDepartment department = new ModelDepartment
{
Id = id,
Name = name,
Code = code,
SuperiorDepartmentId = superiorDepartmentId,
ManagerEmployeeId = managerId,
DepartmentType = departmentType
};
return(RepositoryManager.RepositoryDepartment.UpdateDepartment(department));
}
public FrmCreateEditDepartment(EnumDepartmentsType.DepartmentType departmentType, int superiorDepId)
{
InitializeComponent();
_superiorDepId = superiorDepId;
_departmentType = departmentType;
}
public FrmCreateEditDepartment(EnumDepartmentsType.DepartmentType departmentType)
{
InitializeComponent();
_departmentType = departmentType;
}
public bool UpdateDepartment(string name, string code, int?managerId,
EnumDepartmentsType.DepartmentType departmentType, int?superiorDepartmentId, int id)
{
return(_logic.UpdateDepartment(name, code, managerId, departmentType, superiorDepartmentId, id));
}
public bool CreateDepartment(string name, string code, int employeeId,
EnumDepartmentsType.DepartmentType departmentType, int?superiorDepartmentId)
{
return(_logic.CreateDepartment(name, code, departmentType, employeeId, superiorDepartmentId));
}
