public List<PersonLanguages> GetAllByPersonId(int PersonId)
{
PersonLanguagesDAC _personLanguagesComponent = new PersonLanguagesDAC();
IDataReader reader = _personLanguagesComponent.GetAllPersonLanguages(String.Format("PersonId = {0}", PersonId)).CreateDataReader();
List<PersonLanguages> _personLanguagesList = new List<PersonLanguages>();
while (reader.Read())
{
if (_personLanguagesList == null)
_personLanguagesList = new List<PersonLanguages>();
PersonLanguages _personLanguages = new PersonLanguages();
if (reader["PersonLanguageId"] != DBNull.Value)
_personLanguages.PersonLanguageId = Convert.ToInt32(reader["PersonLanguageId"]);
if (reader["PersonId"] != DBNull.Value)
_personLanguages.PersonId = Convert.ToInt32(reader["PersonId"]);
if (reader["LanguageId"] != DBNull.Value)
_personLanguages.LanguageId = Convert.ToInt32(reader["LanguageId"]);
if (reader["Title"] != DBNull.Value)
_personLanguages.Title = Convert.ToString(reader["Title"]);
if (reader["FirstName"] != DBNull.Value)
_personLanguages.FirstName = Convert.ToString(reader["FirstName"]);
if (reader["MiddleName"] != DBNull.Value)
_personLanguages.MiddleName = Convert.ToString(reader["MiddleName"]);
if (reader["LastName"] != DBNull.Value)
_personLanguages.LastName = Convert.ToString(reader["LastName"]);
if (reader["Suffix"] != DBNull.Value)
_personLanguages.Suffix = Convert.ToString(reader["Suffix"]);
if (reader["DisplayName"] != DBNull.Value)
_personLanguages.DisplayName = Convert.ToString(reader["DisplayName"]);
_personLanguages.NewRecord = false;
_personLanguagesList.Add(_personLanguages);
} reader.Close();
return _personLanguagesList;
}
public PersonLanguages GetByLanguageID(int LangID)
{
if (LangID == 0)
{
if (_PersonDefaultLanguage == null && Common.DefaultLanguage != null)
{
var lang = from n in PersonLanguages
where n.LanguageId == Common.DefaultLanguage.LanguageId
select n;
foreach (PersonLanguages x in lang)
_PersonDefaultLanguage = x as PersonLanguages;
if (_PersonDefaultLanguage == null)
_PersonDefaultLanguage = new PersonLanguages();
}
else if (_PersonDefaultLanguage == null)
_PersonDefaultLanguage = new PersonLanguages();
return _PersonDefaultLanguage;
}
else
{
var lang = (from n in PersonLanguages
where n.LanguageId == LangID
select n).FirstOrDefault();
if (lang == null)
lang = new PersonLanguages();
return lang;
}
}
public bool Insert(PersonLanguages personlanguages)
{
int autonumber = 0;
PersonLanguagesDAC personlanguagesComponent = new PersonLanguagesDAC();
bool endedSuccessfuly = personlanguagesComponent.InsertNewPersonLanguages( ref autonumber, personlanguages.PersonId, personlanguages.LanguageId, personlanguages.Title, personlanguages.FirstName, personlanguages.MiddleName, personlanguages.LastName, personlanguages.Suffix, personlanguages.DisplayName);
if(endedSuccessfuly)
{
personlanguages.PersonLanguageId = autonumber;
}
return endedSuccessfuly;
}
public bool Update(PersonLanguages personlanguages ,int old_personLanguageId)
{
PersonLanguagesDAC personlanguagesComponent = new PersonLanguagesDAC();
return personlanguagesComponent.UpdatePersonLanguages( personlanguages.PersonId, personlanguages.LanguageId, personlanguages.Title, personlanguages.FirstName, personlanguages.MiddleName, personlanguages.LastName, personlanguages.Suffix, personlanguages.DisplayName, old_personLanguageId);
}
public PersonLanguages GetByID(int _personLanguageId)
{
PersonLanguagesDAC _personLanguagesComponent = new PersonLanguagesDAC();
IDataReader reader = _personLanguagesComponent.GetByIDPersonLanguages(_personLanguageId);
PersonLanguages _personLanguages = null;
while(reader.Read())
{
_personLanguages = new PersonLanguages();
if(reader["PersonLanguageId"] != DBNull.Value)
_personLanguages.PersonLanguageId = Convert.ToInt32(reader["PersonLanguageId"]);
if(reader["PersonId"] != DBNull.Value)
_personLanguages.PersonId = Convert.ToInt32(reader["PersonId"]);
if(reader["LanguageId"] != DBNull.Value)
_personLanguages.LanguageId = Convert.ToInt32(reader["LanguageId"]);
if(reader["Title"] != DBNull.Value)
_personLanguages.Title = Convert.ToString(reader["Title"]);
if(reader["FirstName"] != DBNull.Value)
_personLanguages.FirstName = Convert.ToString(reader["FirstName"]);
if(reader["MiddleName"] != DBNull.Value)
_personLanguages.MiddleName = Convert.ToString(reader["MiddleName"]);
if(reader["LastName"] != DBNull.Value)
_personLanguages.LastName = Convert.ToString(reader["LastName"]);
if(reader["Suffix"] != DBNull.Value)
_personLanguages.Suffix = Convert.ToString(reader["Suffix"]);
if(reader["DisplayName"] != DBNull.Value)
_personLanguages.DisplayName = Convert.ToString(reader["DisplayName"]);
_personLanguages.NewRecord = false; } reader.Close();
return _personLanguages;
}
