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; }