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