public List<DepartmentLanguages> GetAllByDepartmentId(int DepartmentId)
{
DepartmentLanguagesDAC _departmentLanguagesComponent = new DepartmentLanguagesDAC();
IDataReader reader = _departmentLanguagesComponent.GetAllDepartmentLanguages("DepartmentId = " + DepartmentId).CreateDataReader();
List<DepartmentLanguages> _departmentLanguagesList = new List<DepartmentLanguages>();
while (reader.Read())
{
if (_departmentLanguagesList == null)
_departmentLanguagesList = new List<DepartmentLanguages>();
DepartmentLanguages _departmentLanguages = new DepartmentLanguages();
if (reader["DepartmentLanguagesId"] != DBNull.Value)
_departmentLanguages.DepartmentLanguagesId = Convert.ToInt32(reader["DepartmentLanguagesId"]);
if (reader["DepartmentId"] != DBNull.Value)
_departmentLanguages.DepartmentId = Convert.ToInt32(reader["DepartmentId"]);
if (reader["LanguageId"] != DBNull.Value)
_departmentLanguages.LanguageId = Convert.ToInt32(reader["LanguageId"]);
if (reader["DepartmentName"] != DBNull.Value)
_departmentLanguages.DepartmentName = Convert.ToString(reader["DepartmentName"]);
if (reader["DepartmentDescription"] != DBNull.Value)
_departmentLanguages.DepartmentDescription = Convert.ToString(reader["DepartmentDescription"]);
if (reader["AddressLine1"] != DBNull.Value)
_departmentLanguages.AddressLine1 = Convert.ToString(reader["AddressLine1"]);
if (reader["AddressLine2"] != DBNull.Value)
_departmentLanguages.AddressLine2 = Convert.ToString(reader["AddressLine2"]);
_departmentLanguages.NewRecord = false;
_departmentLanguagesList.Add(_departmentLanguages);
} reader.Close();
return _departmentLanguagesList;
}
public DepartmentLanguages GetByID(int _departmentLanguagesId)
{
DepartmentLanguagesDAC _departmentLanguagesComponent = new DepartmentLanguagesDAC();
IDataReader reader = _departmentLanguagesComponent.GetByIDDepartmentLanguages(_departmentLanguagesId);
DepartmentLanguages _departmentLanguages = null;
while(reader.Read())
{
_departmentLanguages = new DepartmentLanguages();
if(reader["DepartmentLanguagesId"] != DBNull.Value)
_departmentLanguages.DepartmentLanguagesId = Convert.ToInt32(reader["DepartmentLanguagesId"]);
if(reader["DepartmentId"] != DBNull.Value)
_departmentLanguages.DepartmentId = Convert.ToInt32(reader["DepartmentId"]);
if(reader["LanguageId"] != DBNull.Value)
_departmentLanguages.LanguageId = Convert.ToInt32(reader["LanguageId"]);
if(reader["DepartmentName"] != DBNull.Value)
_departmentLanguages.DepartmentName = Convert.ToString(reader["DepartmentName"]);
if(reader["DepartmentDescription"] != DBNull.Value)
_departmentLanguages.DepartmentDescription = Convert.ToString(reader["DepartmentDescription"]);
if(reader["AddressLine1"] != DBNull.Value)
_departmentLanguages.AddressLine1 = Convert.ToString(reader["AddressLine1"]);
if(reader["AddressLine2"] != DBNull.Value)
_departmentLanguages.AddressLine2 = Convert.ToString(reader["AddressLine2"]);
_departmentLanguages.NewRecord = false; } reader.Close();
return _departmentLanguages;
}
public bool Update(DepartmentLanguages departmentlanguages ,int old_departmentLanguagesId)
{
DepartmentLanguagesDAC departmentlanguagesComponent = new DepartmentLanguagesDAC();
return departmentlanguagesComponent.UpdateDepartmentLanguages( departmentlanguages.DepartmentId, departmentlanguages.LanguageId, departmentlanguages.DepartmentName, departmentlanguages.DepartmentDescription, departmentlanguages.AddressLine1, departmentlanguages.AddressLine2, old_departmentLanguagesId);
}
public bool Insert(DepartmentLanguages departmentlanguages)
{
int autonumber = 0;
DepartmentLanguagesDAC departmentlanguagesComponent = new DepartmentLanguagesDAC();
bool endedSuccessfuly = departmentlanguagesComponent.InsertNewDepartmentLanguages( ref autonumber, departmentlanguages.DepartmentId, departmentlanguages.LanguageId, departmentlanguages.DepartmentName, departmentlanguages.DepartmentDescription, departmentlanguages.AddressLine1, departmentlanguages.AddressLine2);
if(endedSuccessfuly)
{
departmentlanguages.DepartmentLanguagesId = autonumber;
}
return endedSuccessfuly;
}