public List<PersonExtra> GetAll()
{
PersonExtraDAC _personExtraComponent = new PersonExtraDAC();
IDataReader reader = _personExtraComponent.GetAllPersonExtra().CreateDataReader();
List<PersonExtra> _personExtraList = new List<PersonExtra>();
while(reader.Read())
{
if(_personExtraList == null)
_personExtraList = new List<PersonExtra>();
PersonExtra _personExtra = new PersonExtra();
if(reader["PersonExtraId"] != DBNull.Value)
_personExtra.PersonExtraId = Convert.ToInt32(reader["PersonExtraId"]);
if(reader["NationalIdType"] != DBNull.Value)
_personExtra.NationalIdType = Convert.ToString(reader["NationalIdType"]);
if(reader["NationalId"] != DBNull.Value)
_personExtra.NationalId = Convert.ToString(reader["NationalId"]);
if(reader["Gender"] != DBNull.Value)
_personExtra.Gender = Convert.ToString(reader["Gender"]);
if(reader["Religion"] != DBNull.Value)
_personExtra.Religion = Convert.ToString(reader["Religion"]);
if(reader["BirthDate"] != DBNull.Value)
_personExtra.BirthDate = Convert.ToDateTime(reader["BirthDate"]);
if(reader["BirthPlace"] != DBNull.Value)
_personExtra.BirthPlace = Convert.ToString(reader["BirthPlace"]);
if(reader["MaritalStatus"] != DBNull.Value)
_personExtra.MaritalStatus = Convert.ToString(reader["MaritalStatus"]);
if(reader["SpauseName"] != DBNull.Value)
_personExtra.SpauseName = Convert.ToString(reader["SpauseName"]);
if(reader["FatherGuardianName"] != DBNull.Value)
_personExtra.FatherGuardianName = Convert.ToString(reader["FatherGuardianName"]);
if(reader["FatherGuardianAddress"] != DBNull.Value)
_personExtra.FatherGuardianAddress = Convert.ToString(reader["FatherGuardianAddress"]);
if(reader["FatherGuardianContactNumber"] != DBNull.Value)
_personExtra.FatherGuardianContactNumber = Convert.ToString(reader["FatherGuardianContactNumber"]);
if(reader["EmergencyContactName"] != DBNull.Value)
_personExtra.EmergencyContactName = Convert.ToString(reader["EmergencyContactName"]);
if(reader["EmergencyContactAddress"] != DBNull.Value)
_personExtra.EmergencyContactAddress = Convert.ToString(reader["EmergencyContactAddress"]);
if(reader["EmergencyContactNumber"] != DBNull.Value)
_personExtra.EmergencyContactNumber = Convert.ToString(reader["EmergencyContactNumber"]);
if(reader["EmergencyContactEmail"] != DBNull.Value)
_personExtra.EmergencyContactEmail = Convert.ToString(reader["EmergencyContactEmail"]);
if(reader["SponsorId"] != DBNull.Value)
_personExtra.SponsorId = Convert.ToInt32(reader["SponsorId"]);
if(reader["SponsorStartDate"] != DBNull.Value)
_personExtra.SponsorStartDate = Convert.ToDateTime(reader["SponsorStartDate"]);
if(reader["SponsorEndDate"] != DBNull.Value)
_personExtra.SponsorEndDate = Convert.ToDateTime(reader["SponsorEndDate"]);
if(reader["SponsorCategoryId"] != DBNull.Value)
_personExtra.SponsorCategoryId = Convert.ToInt32(reader["SponsorCategoryId"]);
if(reader["IsGraduateTransfer"] != DBNull.Value)
_personExtra.IsGraduateTransfer = Convert.ToBoolean(reader["IsGraduateTransfer"]);
if(reader["ReasonForSeekingTransfer"] != DBNull.Value)
_personExtra.ReasonForSeekingTransfer = Convert.ToString(reader["ReasonForSeekingTransfer"]);
if(reader["LevelRequired"] != DBNull.Value)
_personExtra.LevelRequired = Convert.ToString(reader["LevelRequired"]);
if(reader["OtherInformation"] != DBNull.Value)
_personExtra.OtherInformation = Convert.ToString(reader["OtherInformation"]);
_personExtra.NewRecord = false;
_personExtraList.Add(_personExtra);
} reader.Close();
return _personExtraList;
}
public bool Update(PersonExtra personextra ,int old_personExtraId)
{
PersonExtraDAC personextraComponent = new PersonExtraDAC();
return personextraComponent.UpdatePersonExtra( personextra.PersonExtraId, personextra.NationalIdType, personextra.NationalId, personextra.Gender, personextra.Religion, personextra.BirthDate, personextra.BirthPlace, personextra.MaritalStatus, personextra.SpauseName, personextra.FatherGuardianName, personextra.FatherGuardianAddress, personextra.FatherGuardianContactNumber, personextra.EmergencyContactName, personextra.EmergencyContactAddress, personextra.EmergencyContactNumber, personextra.EmergencyContactEmail, personextra.SponsorId, personextra.SponsorStartDate, personextra.SponsorEndDate, personextra.SponsorCategoryId, personextra.IsGraduateTransfer, personextra.ReasonForSeekingTransfer, personextra.LevelRequired, personextra.OtherInformation, old_personExtraId);
}
