public Language GetByID(int _languageId)
{
LanguageDAC _languageComponent = new LanguageDAC();
IDataReader reader = _languageComponent.GetByIDLanguage(_languageId);
Language _language = null;
while(reader.Read())
{
_language = new Language();
if(reader["LanguageId"] != DBNull.Value)
_language.LanguageId = Convert.ToInt32(reader["LanguageId"]);
if(reader["LanguageCode"] != DBNull.Value)
_language.LanguageCode = Convert.ToString(reader["LanguageCode"]);
if(reader["Name"] != DBNull.Value)
_language.Name = Convert.ToString(reader["Name"]);
_language.NewRecord = false; } reader.Close();
return _language;
}
public List<Language> GetAll()
{
LanguageDAC _languageComponent = new LanguageDAC();
IDataReader reader = _languageComponent.GetAllLanguage().CreateDataReader();
List<Language> _languageList = new List<Language>();
while(reader.Read())
{
if(_languageList == null)
_languageList = new List<Language>();
Language _language = new Language();
if(reader["LanguageId"] != DBNull.Value)
_language.LanguageId = Convert.ToInt32(reader["LanguageId"]);
if(reader["LanguageCode"] != DBNull.Value)
_language.LanguageCode = Convert.ToString(reader["LanguageCode"]);
if(reader["Name"] != DBNull.Value)
_language.Name = Convert.ToString(reader["Name"]);
_language.NewRecord = false;
_languageList.Add(_language);
} reader.Close();
return _languageList;
}
public bool Insert(Language language)
{
int autonumber = 0;
LanguageDAC languageComponent = new LanguageDAC();
bool endedSuccessfuly = languageComponent.InsertNewLanguage( ref autonumber, language.LanguageCode, language.Name);
if(endedSuccessfuly)
{
language.LanguageId = autonumber;
}
return endedSuccessfuly;
}
public void Delete(int Original_LanguageId)
{
LanguageDAC languageComponent = new LanguageDAC();
languageComponent.DeleteLanguage(Original_LanguageId);
}
public int UpdateDataset(System.Data.DataSet dataset)
{
LanguageDAC languagecomponent = new LanguageDAC();
return languagecomponent.UpdateDataset(dataset);
}
public bool Update( string LanguageCode, string Name, int Original_LanguageId)
{
LanguageDAC languageComponent = new LanguageDAC();
return languageComponent.UpdateLanguage( LanguageCode, Name, Original_LanguageId);
}
public bool Update(Language language ,int old_languageId)
{
LanguageDAC languageComponent = new LanguageDAC();
return languageComponent.UpdateLanguage( language.LanguageCode, language.Name, old_languageId);
}
public bool Insert( string LanguageCode, string Name)
{
LanguageDAC languageComponent = new LanguageDAC();
int LanguageId = 0;
return languageComponent.InsertNewLanguage( ref LanguageId, LanguageCode, Name);
}