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