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); }