public List<Person> GetAllCredentials()
{
PersonDAC _personComponent = new PersonDAC();
IDataReader reader = _personComponent.GetAllPerson("BusinessEntityId in (select BusinessEntityId from Person.Credential)").CreateDataReader();
List<Person> _personList = new List<Person>();
while (reader.Read())
{
if (_personList == null)
_personList = new List<Person>();
Person _person = new Person();
if (reader["BusinessEntityId"] != DBNull.Value)
_person.BusinessEntityId = Convert.ToInt32(reader["BusinessEntityId"]);
if (reader["NameStyle"] != DBNull.Value)
_person.NameStyle = Convert.ToBoolean(reader["NameStyle"]);
if (reader["EmailPromotion"] != DBNull.Value)
_person.EmailPromotion = Convert.ToInt32(reader["EmailPromotion"]);
if (reader["RowGuid"] != DBNull.Value)
_person.RowGuid = new Guid(reader["RowGuid"].ToString());
if (reader["ModifiedDate"] != DBNull.Value)
_person.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]);
if (reader["CreatedDate"] != DBNull.Value)
_person.CreatedDate = Convert.ToDateTime(reader["CreatedDate"]);
if (reader["NationalityCode"] != DBNull.Value)
_person.NationalityCode = Convert.ToString(reader["NationalityCode"]);
if (reader["Gender"] != DBNull.Value)
_person.Gender = Convert.ToString(reader["Gender"]);
if (reader["DateofBirth"] != DBNull.Value)
_person.DateofBirth = Convert.ToDateTime(reader["DateofBirth"]);
if (reader["PersonImage"] != DBNull.Value)
_person.PersonImage = Convert.ToString(reader["PersonImage"]);
_person.NewRecord = false;
_personList.Add(_person);
} reader.Close();
return _personList;
}
public bool Update(Person person ,int old_businessEntityId)
{
PersonDAC personComponent = new PersonDAC();
return personComponent.UpdatePerson( person.BusinessEntityId, person.NameStyle, person.EmailPromotion, person.RowGuid, DateTime.Now, person.CreatedDate, person.NationalityCode,person.Gender,person.DateofBirth,person.PersonImage, old_businessEntityId);
}
public Person GetByUserName(string UserName)
{
PersonDAC _personComponent = new PersonDAC();
IDataReader reader = _personComponent.GetByUserNamePerson(UserName);
Person _person = null;
while (reader.Read())
{
_person = new Person();
if (reader["BusinessEntityId"] != DBNull.Value)
_person.BusinessEntityId = Convert.ToInt32(reader["BusinessEntityId"]);
if (reader["NameStyle"] != DBNull.Value)
_person.NameStyle = Convert.ToBoolean(reader["NameStyle"]);
if (reader["EmailPromotion"] != DBNull.Value)
_person.EmailPromotion = Convert.ToInt32(reader["EmailPromotion"]);
if (reader["RowGuid"] != DBNull.Value)
_person.RowGuid = new Guid(reader["RowGuid"].ToString());
if (reader["ModifiedDate"] != DBNull.Value)
_person.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]);
if (reader["CreatedDate"] != DBNull.Value)
_person.CreatedDate = Convert.ToDateTime(reader["CreatedDate"]);
if (reader["NationalityCode"] != DBNull.Value)
_person.NationalityCode = Convert.ToString(reader["NationalityCode"]);
if (reader["Gender"] != DBNull.Value)
_person.Gender = Convert.ToString(reader["Gender"]);
if (reader["DateofBirth"] != DBNull.Value)
_person.DateofBirth = Convert.ToDateTime(reader["DateofBirth"]);
if (reader["PersonImage"] != DBNull.Value)
_person.PersonImage = Convert.ToString(reader["PersonImage"]);
_person.NewRecord = false;
} reader.Close();
return _person;
}
public bool Insert(Person person)
{
PersonDAC personComponent = new PersonDAC();
if (person.PersonDefaultLanguage != null)
{
int id = 0;
Common.BusinessEntityLogic.Insert(ref id, new Guid(), DateTime.Now);
personComponent.InsertNewPerson(id, person.NameStyle, person.EmailPromotion, new Guid(), DateTime.Now, DateTime.Now, person.NationalityCode,person.Gender,person.DateofBirth,person.PersonImage);
Common.PersonLanguagesLogic.Insert(id, Common.DefaultLanguage.LanguageId, person.Title, person.FirstName, person.MiddleName, person.LastName, person.Suffix, person.DisplayName);
person.BusinessEntityId = id;
return true;
}
return false;
}
//public static Employees getEmployee(Page currentPage)
//{
// Users user = getUser(currentPage);
// return user.CurrentEmployee;
//}
public static void UpdateUser(Page currentPage,Person person)
{
currentPage.Session["USER"] = person;
}