public static List <StaticListItem> GetCheckBoxList(string spName, Dictionary <string, object> parameterList) { List <StaticListItem> objStaticListItemLst = new List <StaticListItem>(); IDataAccess objDataAccess = DataAccess.NewDataAccess(); DbCommand objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.ReadCommitted); DbDataReader objDbDataReader = null; if (parameterList.Count > 0) { foreach (KeyValuePair <string, object> pair in parameterList) { objDbCommand.AddInParameter(pair.Key, pair.Value); } } try { objDbDataReader = objDataAccess.ExecuteReader(objDbCommand, spName, CommandType.StoredProcedure); if (objDbDataReader.HasRows) { while (objDbDataReader.Read()) { StaticListItem objStaticListItem = new StaticListItem(); objStaticListItem.DataValue = objDbDataReader[0].ToString(); objStaticListItem.DataText = objDbDataReader[1].ToString(); objStaticListItemLst.Add(objStaticListItem); } } } catch (Exception ex) { throw new Exception("Error : " + ex.Message); } finally { if (objDbDataReader != null) { objDbDataReader.Close(); } objDataAccess.Dispose(objDbCommand); } return(objStaticListItemLst); }
/// <summary> /// This method helps to fill the dropdown with specific stored procedure. /// </summary> /// <param name="spName">Provide stored procedure name</param> /// <returns></returns> public static List <StaticListItem> GetCombo(string spName) { List <StaticListItem> objStaticListItemLst = new List <StaticListItem>(); IDataAccess objDataAccess = DataAccess.NewDataAccess(); DbCommand objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.ReadCommitted); DbDataReader objDbDataReader = null; try { objDbDataReader = objDataAccess.ExecuteReader(objDbCommand, spName, CommandType.StoredProcedure); if (objDbDataReader.HasRows) { while (objDbDataReader.Read()) { StaticListItem objStaticListItem = new StaticListItem(); objStaticListItem.DataValue = objDbDataReader[0].ToString(); objStaticListItem.DataText = objDbDataReader[1].ToString(); objStaticListItemLst.Add(objStaticListItem); } } } catch (Exception ex) { throw new Exception("Error : " + ex.Message); } finally { if (objDbDataReader != null) { objDbDataReader.Close(); } objDataAccess.Dispose(objDbCommand); } objStaticListItemLst.Insert(0, new StaticListItem("", "--Select Option--")); return(objStaticListItemLst); }