public static ATTPerson GetPersonWithPersonnelAttributeByID(double personID)
{
object conn;
try
{
conn = DLLPerson.GetConnection();
}
catch (Exception ex)
{
throw ex;
return(null);
}
try
{
DataRow row = DLLPerson.GetPersonWithPersonnelAttributeByID(conn, personID).Rows[0];
ATTPerson person = new ATTPerson();
person.PId = double.Parse(row["P_ID"].ToString());
person.FirstName = row["FIRST_NAME"].ToString();
person.MidName = row["MID_NAME"].ToString();
person.SurName = row["SUR_NAME"].ToString();
person.Gender = row["GENDER"].ToString();
person.DOB = row["DOB"].ToString();
person.MaritalStatus = row["MARTIAL_STATUS"].ToString();
person.CountryId = row["country_id"] == System.DBNull.Value ? (int?)null : int.Parse(row["country_id"].ToString());
person.BirthDistrict = row["birth_district"] == System.DBNull.Value ? (int?)null : int.Parse(row["birth_district"].ToString());
person.ReligionId = row["religion_id"] == System.DBNull.Value ? (int?)null : int.Parse(row["religion_id"].ToString());
person.Photo = row["p_photo"] as byte[];
person.LstPersonAddress = BLLPersonAddress.GetPersonAddress(conn, personID);
person.LstPersonPhone = BLLPersonPhone.GetPersonPhone(conn, personID);
person.LstPersonEMail = BLLPersonEMail.GetPersonEMail(conn, personID);
person.LstPersonQualification = BLLPersonQualification.GetPersonQualification(conn, personID);
//person.ls
return(person);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DLLPerson.CloseConnection(conn);
}
}
