public bool Insert(int BusinessEntityId, string PhoneNumber, int PhoneNumberTypeId, DateTime ModifiedDate, bool PhoneVerified, string PhoneVerificationCode)
{
PersonPhoneDAC personphoneComponent = new PersonPhoneDAC();
int Id = 0;
return(personphoneComponent.InsertNewPersonPhone(ref Id, BusinessEntityId, PhoneNumber, PhoneNumberTypeId, DateTime.Now, PhoneVerified, PhoneVerificationCode));
}
public bool Insert(PersonPhone personphone)
{
int autonumber = 0;
PersonPhoneDAC personphoneComponent = new PersonPhoneDAC();
bool endedSuccessfuly = personphoneComponent.InsertNewPersonPhone(ref autonumber, personphone.BusinessEntityId, personphone.PhoneNumber, personphone.PhoneNumberTypeId, DateTime.Now, personphone.PhoneVerified, personphone.PhoneVerificationCode);
if (endedSuccessfuly)
{
personphone.Id = autonumber;
}
return(endedSuccessfuly);
}
public List <PersonPhone> GetByPersonId(int PersonId)
{
PersonPhoneDAC _personPhoneComponent = new PersonPhoneDAC();
IDataReader reader = _personPhoneComponent.GetByPersonIdPersonPhones(PersonId);
List <PersonPhone> _personPhoneList = new List <PersonPhone>();
while (reader.Read())
{
if (_personPhoneList == null)
{
_personPhoneList = new List <PersonPhone>();
}
PersonPhone _personPhone = new PersonPhone();
if (reader["Id"] != DBNull.Value)
{
_personPhone.Id = Convert.ToInt32(reader["Id"]);
}
if (reader["BusinessEntityId"] != DBNull.Value)
{
_personPhone.BusinessEntityId = Convert.ToInt32(reader["BusinessEntityId"]);
}
if (reader["PhoneNumber"] != DBNull.Value)
{
_personPhone.PhoneNumber = Convert.ToString(reader["PhoneNumber"]);
}
if (reader["PhoneNumberTypeId"] != DBNull.Value)
{
_personPhone.PhoneNumberTypeId = Convert.ToInt32(reader["PhoneNumberTypeId"]);
}
if (reader["ModifiedDate"] != DBNull.Value)
{
_personPhone.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]);
}
if (reader["PhoneVerified"] != DBNull.Value)
{
_personPhone.PhoneVerified = Convert.ToBoolean(reader["PhoneVerified"]);
}
if (reader["PhoneVerificationCode"] != DBNull.Value)
{
_personPhone.PhoneVerificationCode = Convert.ToString(reader["PhoneVerificationCode"]);
}
_personPhone.NewRecord = false;
_personPhoneList.Add(_personPhone);
}
reader.Close();
return(_personPhoneList);
}
public PersonPhone GetByID(int _id)
{
PersonPhoneDAC _personPhoneComponent = new PersonPhoneDAC();
IDataReader reader = _personPhoneComponent.GetByIDPersonPhone(_id);
PersonPhone _personPhone = null;
while (reader.Read())
{
_personPhone = new PersonPhone();
if (reader["Id"] != DBNull.Value)
{
_personPhone.Id = Convert.ToInt32(reader["Id"]);
}
if (reader["BusinessEntityId"] != DBNull.Value)
{
_personPhone.BusinessEntityId = Convert.ToInt32(reader["BusinessEntityId"]);
}
if (reader["PhoneNumber"] != DBNull.Value)
{
_personPhone.PhoneNumber = Convert.ToString(reader["PhoneNumber"]);
}
if (reader["PhoneNumberTypeId"] != DBNull.Value)
{
_personPhone.PhoneNumberTypeId = Convert.ToInt32(reader["PhoneNumberTypeId"]);
}
if (reader["ModifiedDate"] != DBNull.Value)
{
_personPhone.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]);
}
if (reader["PhoneVerified"] != DBNull.Value)
{
_personPhone.PhoneVerified = Convert.ToBoolean(reader["PhoneVerified"]);
}
if (reader["PhoneVerificationCode"] != DBNull.Value)
{
_personPhone.PhoneVerificationCode = Convert.ToString(reader["PhoneVerificationCode"]);
}
_personPhone.NewRecord = false;
}
reader.Close();
return(_personPhone);
}
public int UpdateDataset(System.Data.DataSet dataset)
{
PersonPhoneDAC personphonecomponent = new PersonPhoneDAC();
return(personphonecomponent.UpdateDataset(dataset));
}
public void DeleteByPersonId(int PersonId)
{
PersonPhoneDAC personphoneComponent = new PersonPhoneDAC();
personphoneComponent.DeletePersonPhoneByPersonId(PersonId);
}
public void Delete(int Original_Id)
{
PersonPhoneDAC personphoneComponent = new PersonPhoneDAC();
personphoneComponent.DeletePersonPhone(Original_Id);
}
public bool Update(int BusinessEntityId, string PhoneNumber, int PhoneNumberTypeId, DateTime ModifiedDate, bool PhoneVerified, string PhoneVerificationCode, int Original_Id)
{
PersonPhoneDAC personphoneComponent = new PersonPhoneDAC();
return(personphoneComponent.UpdatePersonPhone(BusinessEntityId, PhoneNumber, PhoneNumberTypeId, DateTime.Now, PhoneVerified, PhoneVerificationCode, Original_Id));
}
public bool Update(PersonPhone personphone, int old_id)
{
PersonPhoneDAC personphoneComponent = new PersonPhoneDAC();
return(personphoneComponent.UpdatePersonPhone(personphone.BusinessEntityId, personphone.PhoneNumber, personphone.PhoneNumberTypeId, DateTime.Now, personphone.PhoneVerified, personphone.PhoneVerificationCode, old_id));
}
