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 bool Update(int BusinessEntityId, bool NameStyle, int EmailPromotion, Guid RowGuid, DateTime ModifiedDate, DateTime CreatedDate, string NationalityCode, string Title, string FirstName, string MiddleName, string LastName, string DisplayName, string Suffix, string Gender, DateTime DateofBirth, string PersonImage)
{
PersonDAC personComponent = new PersonDAC();
personComponent.UpdatePerson(BusinessEntityId, NameStyle, EmailPromotion, new Guid(), DateTime.Now, DateTime.Now, NationalityCode, Gender, DateofBirth, PersonImage,BusinessEntityId);
PersonLanguagesDAC plangComponent = new PersonLanguagesDAC();
Person person= new PersonLogic().GetByID(BusinessEntityId);
return plangComponent.UpdatePersonLanguages(BusinessEntityId, Common.DefaultLanguage.LanguageId, Title, FirstName, MiddleName, LastName, Suffix, DisplayName,person.PersonDefaultLanguage.PersonLanguageId);
}
public bool Insert(ref int BusinessEntityId, bool NameStyle, int EmailPromotion, Guid RowGuid, DateTime ModifiedDate, DateTime CreatedDate, string NationalityCode, string Title, string FirstName, string MiddleName, string LastName, string DisplayName, string Suffix, string Gender, DateTime DateofBirth, string PersonImage)
{
PersonDAC personComponent = new PersonDAC();
Common.BusinessEntityLogic.Insert(ref BusinessEntityId, new Guid(), DateTime.Now);
personComponent.InsertNewPerson(BusinessEntityId, NameStyle, EmailPromotion, new Guid(), DateTime.Now, DateTime.Now, NationalityCode,Gender,DateofBirth,PersonImage);
PersonLanguagesDAC plangComponent = new PersonLanguagesDAC();
int plangId = 0;
return plangComponent.InsertNewPersonLanguages(ref plangId, BusinessEntityId, Common.DefaultLanguage.LanguageId, Title, FirstName, MiddleName, LastName, Suffix, DisplayName);
}
public int UpdateDataset(System.Data.DataSet dataset)
{
PersonLanguagesDAC personlanguagescomponent = new PersonLanguagesDAC();
return personlanguagescomponent.UpdateDataset(dataset);
}
public void Delete(int Original_PersonLanguageId)
{
PersonLanguagesDAC personlanguagesComponent = new PersonLanguagesDAC();
personlanguagesComponent.DeletePersonLanguages(Original_PersonLanguageId);
}
public bool Update( int PersonId, int LanguageId, string Title, string FirstName, string MiddleName, string LastName, string Suffix, string DisplayName, int Original_PersonLanguageId)
{
PersonLanguagesDAC personlanguagesComponent = new PersonLanguagesDAC();
return personlanguagesComponent.UpdatePersonLanguages( PersonId, LanguageId, Title, FirstName, MiddleName, LastName, Suffix, DisplayName, Original_PersonLanguageId);
}
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 bool Insert( int PersonId, int LanguageId, string Title, string FirstName, string MiddleName, string LastName, string Suffix, string DisplayName)
{
PersonLanguagesDAC personlanguagesComponent = new PersonLanguagesDAC();
int PersonLanguageId = 0;
return personlanguagesComponent.InsertNewPersonLanguages( ref PersonLanguageId, PersonId, LanguageId, Title, FirstName, MiddleName, LastName, Suffix, DisplayName);
}
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 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;
}
