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); } }
public static ATTPerson GetPersonnelDetails(object obj, double personID) { ATTPerson person = new ATTPerson(); try { person.LstPersonAddress = BLLPersonAddress.GetPersonAddress(obj, personID); person.LstPersonEMail = BLLPersonEMail.GetPersonEMail(obj, personID); person.LstPersonPhone = BLLPersonPhone.GetPersonPhone(obj, personID); person.LstPersonQualification = BLLPersonQualification.GetPersonQualification(obj, personID); person.LstPersonTraining = BLLPersonTraining.GetPersonTraining(obj, personID); person.LstPersonDocuments = BLLPersonDocuments.GetPersonDocuments(obj, personID, null); return(person); } catch (Exception ex) { throw ex; } }