public List<LookupLanguages> GetAllByLookupName(string LookupName,int LanguageId)
{
LookupLanguagesDAC _lookupLanguagesComponent = new LookupLanguagesDAC();
IDataReader reader = _lookupLanguagesComponent.GetByLanguageIDLookupLanguages(LookupName,LanguageId);
List<LookupLanguages> _lookupLanguagesList = new List<LookupLanguages>();
while (reader.Read())
{
if (_lookupLanguagesList == null)
_lookupLanguagesList = new List<LookupLanguages>();
LookupLanguages _lookupLanguages = new LookupLanguages();
if (reader["LookupLanguageId"] != DBNull.Value)
_lookupLanguages.LookupLanguageId = Convert.ToInt32(reader["LookupLanguageId"]);
if (reader["LookupId"] != DBNull.Value)
_lookupLanguages.LookupId = Convert.ToInt32(reader["LookupId"]);
if (reader["LanguageId"] != DBNull.Value)
_lookupLanguages.LanguageId = Convert.ToInt32(reader["LanguageId"]);
if (reader["RefId"] != DBNull.Value)
_lookupLanguages.RefId = Convert.ToInt32(reader["RefId"]);
if (reader["LookupValue"] != DBNull.Value)
_lookupLanguages.LookupValue = Convert.ToString(reader["LookupValue"]);
if (reader["LookupValueDescription"] != DBNull.Value)
_lookupLanguages.LookupValueDescription = Convert.ToString(reader["LookupValueDescription"]);
_lookupLanguages.NewRecord = false;
_lookupLanguagesList.Add(_lookupLanguages);
} reader.Close();
return _lookupLanguagesList;
}
public LookupLanguages GetByID(int _lookupLanguageId)
{
LookupLanguagesDAC _lookupLanguagesComponent = new LookupLanguagesDAC();
IDataReader reader = _lookupLanguagesComponent.GetByIDLookupLanguages(_lookupLanguageId);
LookupLanguages _lookupLanguages = null;
while(reader.Read())
{
_lookupLanguages = new LookupLanguages();
if(reader["LookupLanguageId"] != DBNull.Value)
_lookupLanguages.LookupLanguageId = Convert.ToInt32(reader["LookupLanguageId"]);
if(reader["LookupId"] != DBNull.Value)
_lookupLanguages.LookupId = Convert.ToInt32(reader["LookupId"]);
if(reader["LanguageId"] != DBNull.Value)
_lookupLanguages.LanguageId = Convert.ToInt32(reader["LanguageId"]);
if(reader["RefId"] != DBNull.Value)
_lookupLanguages.RefId = Convert.ToInt32(reader["RefId"]);
if(reader["LookupValue"] != DBNull.Value)
_lookupLanguages.LookupValue = Convert.ToString(reader["LookupValue"]);
if(reader["LookupValueDescription"] != DBNull.Value)
_lookupLanguages.LookupValueDescription = Convert.ToString(reader["LookupValueDescription"]);
_lookupLanguages.NewRecord = false; } reader.Close();
return _lookupLanguages;
}
public void Delete(int Original_LookupLanguageId)
{
LookupLanguagesDAC lookuplanguagesComponent = new LookupLanguagesDAC();
lookuplanguagesComponent.DeleteLookupLanguages(Original_LookupLanguageId);
}
public int UpdateDataset(System.Data.DataSet dataset)
{
LookupLanguagesDAC lookuplanguagescomponent = new LookupLanguagesDAC();
return lookuplanguagescomponent.UpdateDataset(dataset);
}
public bool Update( int LookupId, int LanguageId, int RefId, string LookupValue, string LookupValueDescription, int Original_LookupLanguageId)
{
LookupLanguagesDAC lookuplanguagesComponent = new LookupLanguagesDAC();
return lookuplanguagesComponent.UpdateLookupLanguages( LookupId, LanguageId, RefId, LookupValue, LookupValueDescription, Original_LookupLanguageId);
}
public bool Update(LookupLanguages lookuplanguages ,int old_lookupLanguageId)
{
LookupLanguagesDAC lookuplanguagesComponent = new LookupLanguagesDAC();
return lookuplanguagesComponent.UpdateLookupLanguages( lookuplanguages.LookupId, lookuplanguages.LanguageId, lookuplanguages.RefId, lookuplanguages.LookupValue, lookuplanguages.LookupValueDescription, old_lookupLanguageId);
}
public bool Insert( int LookupId, int LanguageId, int RefId, string LookupValue, string LookupValueDescription)
{
LookupLanguagesDAC lookuplanguagesComponent = new LookupLanguagesDAC();
int LookupLanguageId = 0;
return lookuplanguagesComponent.InsertNewLookupLanguages( ref LookupLanguageId, LookupId, LanguageId, RefId, LookupValue, LookupValueDescription);
}
public bool Insert(LookupLanguages lookuplanguages)
{
int autonumber = 0;
LookupLanguagesDAC lookuplanguagesComponent = new LookupLanguagesDAC();
bool endedSuccessfuly = lookuplanguagesComponent.InsertNewLookupLanguages( ref autonumber, lookuplanguages.LookupId, lookuplanguages.LanguageId, lookuplanguages.RefId, lookuplanguages.LookupValue, lookuplanguages.LookupValueDescription);
if(endedSuccessfuly)
{
lookuplanguages.LookupLanguageId = autonumber;
}
return endedSuccessfuly;
}
