public List<Departments> GetAllByOrganizationId(int OrganizationId)
{
DepartmentsDAC _departmentsComponent = new DepartmentsDAC();
IDataReader reader = _departmentsComponent.GetAllDepartments("OrganizationId = " + OrganizationId).CreateDataReader();
List<Departments> _departmentsList = new List<Departments>();
while (reader.Read())
{
if (_departmentsList == null)
_departmentsList = new List<Departments>();
Departments _departments = new Departments();
if (reader["DepartmentId"] != DBNull.Value)
_departments.DepartmentId = Convert.ToInt32(reader["DepartmentId"]);
if (reader["OrganizationId"] != DBNull.Value)
_departments.OrganizationId = Convert.ToInt32(reader["OrganizationId"]);
if (reader["DepartmentName"] != DBNull.Value)
_departments.DepartmentName = Convert.ToString(reader["DepartmentName"]);
if (reader["DepartmentDescription"] != DBNull.Value)
_departments.DepartmentDescription = Convert.ToString(reader["DepartmentDescription"]);
if (reader["Phone1"] != DBNull.Value)
_departments.Phone1 = Convert.ToString(reader["Phone1"]);
if (reader["Phone2"] != DBNull.Value)
_departments.Phone2 = Convert.ToString(reader["Phone2"]);
if (reader["Fax1"] != DBNull.Value)
_departments.Fax1 = Convert.ToString(reader["Fax1"]);
if (reader["Fax2"] != DBNull.Value)
_departments.Fax2 = Convert.ToString(reader["Fax2"]);
if (reader["AddressLine1"] != DBNull.Value)
_departments.AddressLine1 = Convert.ToString(reader["AddressLine1"]);
if (reader["AddressLine2"] != DBNull.Value)
_departments.AddressLine2 = Convert.ToString(reader["AddressLine2"]);
_departments.NewRecord = false;
_departmentsList.Add(_departments);
} reader.Close();
return _departmentsList;
}
public int UpdateDataset(System.Data.DataSet dataset)
{
DepartmentsDAC departmentscomponent = new DepartmentsDAC();
return departmentscomponent.UpdateDataset(dataset);
}
public void Delete(int Original_DepartmentId)
{
DepartmentsDAC departmentsComponent = new DepartmentsDAC();
departmentsComponent.DeleteDepartments(Original_DepartmentId);
}
public bool Update( int OrganizationId, string DepartmentName, string DepartmentDescription, string Phone1, string Phone2, string Fax1, string Fax2, string AddressLine1, string AddressLine2, int Original_DepartmentId)
{
DepartmentsDAC departmentsComponent = new DepartmentsDAC();
return departmentsComponent.UpdateDepartments( OrganizationId, DepartmentName, DepartmentDescription, Phone1, Phone2, Fax1, Fax2, AddressLine1, AddressLine2, Original_DepartmentId);
}
public bool Update(Departments departments ,int old_departmentId)
{
DepartmentsDAC departmentsComponent = new DepartmentsDAC();
return departmentsComponent.UpdateDepartments( departments.OrganizationId, departments.DepartmentName, departments.DepartmentDescription, departments.Phone1, departments.Phone2, departments.Fax1, departments.Fax2, departments.AddressLine1, departments.AddressLine2, old_departmentId);
}
public bool Insert( int OrganizationId, string DepartmentName, string DepartmentDescription, string Phone1, string Phone2, string Fax1, string Fax2, string AddressLine1, string AddressLine2)
{
DepartmentsDAC departmentsComponent = new DepartmentsDAC();
int DepartmentId = 0;
return departmentsComponent.InsertNewDepartments( ref DepartmentId, OrganizationId, DepartmentName, DepartmentDescription, Phone1, Phone2, Fax1, Fax2, AddressLine1, AddressLine2);
}
public bool Insert(Departments departments)
{
int autonumber = 0;
DepartmentsDAC departmentsComponent = new DepartmentsDAC();
bool endedSuccessfuly = departmentsComponent.InsertNewDepartments( ref autonumber, departments.OrganizationId, departments.DepartmentName, departments.DepartmentDescription, departments.Phone1, departments.Phone2, departments.Fax1, departments.Fax2, departments.AddressLine1, departments.AddressLine2);
if(endedSuccessfuly)
{
departments.DepartmentId = autonumber;
}
return endedSuccessfuly;
}
public Departments GetByID(int _departmentId)
{
DepartmentsDAC _departmentsComponent = new DepartmentsDAC();
IDataReader reader = _departmentsComponent.GetByIDDepartments(_departmentId);
Departments _departments = null;
while(reader.Read())
{
_departments = new Departments();
if(reader["DepartmentId"] != DBNull.Value)
_departments.DepartmentId = Convert.ToInt32(reader["DepartmentId"]);
if(reader["OrganizationId"] != DBNull.Value)
_departments.OrganizationId = Convert.ToInt32(reader["OrganizationId"]);
if(reader["DepartmentName"] != DBNull.Value)
_departments.DepartmentName = Convert.ToString(reader["DepartmentName"]);
if(reader["DepartmentDescription"] != DBNull.Value)
_departments.DepartmentDescription = Convert.ToString(reader["DepartmentDescription"]);
if(reader["Phone1"] != DBNull.Value)
_departments.Phone1 = Convert.ToString(reader["Phone1"]);
if(reader["Phone2"] != DBNull.Value)
_departments.Phone2 = Convert.ToString(reader["Phone2"]);
if(reader["Fax1"] != DBNull.Value)
_departments.Fax1 = Convert.ToString(reader["Fax1"]);
if(reader["Fax2"] != DBNull.Value)
_departments.Fax2 = Convert.ToString(reader["Fax2"]);
if(reader["AddressLine1"] != DBNull.Value)
_departments.AddressLine1 = Convert.ToString(reader["AddressLine1"]);
if(reader["AddressLine2"] != DBNull.Value)
_departments.AddressLine2 = Convert.ToString(reader["AddressLine2"]);
_departments.NewRecord = false; } reader.Close();
return _departments;
}
