public VisaRequest GetAllByConferenceIdPersonId(int ConferenceID, int PersonID) { VisaRequestDAC _visaRequestComponent = new VisaRequestDAC(); IDataReader reader = _visaRequestComponent.GetAllVisaRequest(string.Format("ConferenceID = {0} and PersonID = {1}", ConferenceID, PersonID)).CreateDataReader(); VisaRequest _visaRequest = new VisaRequest(); while (reader.Read()) { if (reader["VisaRequestID"] != DBNull.Value) { _visaRequest.VisaRequestID = Convert.ToInt32(reader["VisaRequestID"]); } if (reader["ConferenceID"] != DBNull.Value) { _visaRequest.ConferenceID = Convert.ToInt32(reader["ConferenceID"]); } if (reader["PersonID"] != DBNull.Value) { _visaRequest.PersonID = Convert.ToInt32(reader["PersonID"]); } if (reader["Country"] != DBNull.Value) { _visaRequest.Country = Convert.ToString(reader["Country"]); } if (reader["City"] != DBNull.Value) { _visaRequest.City = Convert.ToString(reader["City"]); } if (reader["Religion"] != DBNull.Value) { _visaRequest.Religion = Convert.ToString(reader["Religion"]); } if (reader["JobTitle"] != DBNull.Value) { _visaRequest.JobTitle = Convert.ToString(reader["JobTitle"]); } if (reader["Company"] != DBNull.Value) { _visaRequest.Company = Convert.ToString(reader["Company"]); } if (reader["PassportAttachment"] != DBNull.Value) { _visaRequest.PassportAttachment = Convert.ToString(reader["PassportAttachment"]); } if (reader["IsOrganizationApproved"] != DBNull.Value) { _visaRequest.IsOrganizationApproved = Convert.ToBoolean(reader["IsOrganizationApproved"]); } if (reader["IsTaken"] != DBNull.Value) { _visaRequest.IsTaken = Convert.ToBoolean(reader["IsTaken"]); } if (reader["VisaAttachment"] != DBNull.Value) { _visaRequest.VisaAttachment = Convert.ToString(reader["VisaAttachment"]); } _visaRequest.NewRecord = false; } reader.Close(); return(_visaRequest); }
public List <VisaRequest> GetAll() { VisaRequestDAC _visaRequestComponent = new VisaRequestDAC(); IDataReader reader = _visaRequestComponent.GetAllVisaRequest().CreateDataReader(); List <VisaRequest> _visaRequestList = new List <VisaRequest>(); while (reader.Read()) { if (_visaRequestList == null) { _visaRequestList = new List <VisaRequest>(); } VisaRequest _visaRequest = new VisaRequest(); if (reader["VisaRequestID"] != DBNull.Value) { _visaRequest.VisaRequestID = Convert.ToInt32(reader["VisaRequestID"]); } if (reader["ConferenceID"] != DBNull.Value) { _visaRequest.ConferenceID = Convert.ToInt32(reader["ConferenceID"]); } if (reader["PersonID"] != DBNull.Value) { _visaRequest.PersonID = Convert.ToInt32(reader["PersonID"]); } if (reader["Country"] != DBNull.Value) { _visaRequest.Country = Convert.ToString(reader["Country"]); } if (reader["City"] != DBNull.Value) { _visaRequest.City = Convert.ToString(reader["City"]); } if (reader["Religion"] != DBNull.Value) { _visaRequest.Religion = Convert.ToString(reader["Religion"]); } if (reader["JobTitle"] != DBNull.Value) { _visaRequest.JobTitle = Convert.ToString(reader["JobTitle"]); } if (reader["Company"] != DBNull.Value) { _visaRequest.Company = Convert.ToString(reader["Company"]); } if (reader["PassportAttachment"] != DBNull.Value) { _visaRequest.PassportAttachment = Convert.ToString(reader["PassportAttachment"]); } if (reader["IsOrganizationApproved"] != DBNull.Value) { _visaRequest.IsOrganizationApproved = Convert.ToBoolean(reader["IsOrganizationApproved"]); } if (reader["IsTaken"] != DBNull.Value) { _visaRequest.IsTaken = Convert.ToBoolean(reader["IsTaken"]); } if (reader["VisaAttachment"] != DBNull.Value) { _visaRequest.VisaAttachment = Convert.ToString(reader["VisaAttachment"]); } _visaRequest.NewRecord = false; _visaRequestList.Add(_visaRequest); } reader.Close(); return(_visaRequestList); }