public List <CommonDropDownBO> CountriesList()
{
DataSet objDataSet = null;
CommonDropDownBO objCommonDropDownBO = null;
List <CommonDropDownBO> objCommonDropDownBOList = new List <CommonDropDownBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDBAccess.execuitDataSet(ProcCountriesList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objCommonDropDownBO = new CommonDropDownBO();
objCommonDropDownBO.Id = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objCommonDropDownBO.Value = objDataSet.Tables[0].Rows[i][1].ToString();
objCommonDropDownBOList.Add(objCommonDropDownBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "CountriesList");
throw ex;
}
return(objCommonDropDownBOList);
}
public List <CommonDropDownBO> getDonorProgramList(int iUserId)
{
DataSet objDataSet = null;
CommonDropDownBO objCommonDropDownBO = null;
List <CommonDropDownBO> objCommonDropDownBOList = new List <CommonDropDownBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
ProcParameterBO objParameterBO = new ProcParameterBO();
objParameterBO.Direction = ParameterDirection.Input;
objParameterBO.ParameterName = "@iUserId";
objParameterBO.dbType = DbType.Int32;
objParameterBO.ParameterValue = iUserId;
objProcParameterBOList.Add(objParameterBO);
objDataSet = objDBAccess.execuitDataSet(ProcDonorDropDown, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objCommonDropDownBO = new CommonDropDownBO();
objCommonDropDownBO.Id = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objCommonDropDownBO.Value = objDataSet.Tables[0].Rows[i][1].ToString();
objCommonDropDownBOList.Add(objCommonDropDownBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getDonorProgramList");
throw ex;
}
return(objCommonDropDownBOList);
}
