public static List <GlobalConfig> getGlobalConfigs()
{
List <GlobalConfig> xConfig = new List <GlobalConfig>();
using (SqlConnection xCon = new SqlConnection(DB.GetDBConn()))
{
xCon.Open();
System.Data.IDataReader xRdr = DB.GetRS
(sqlRetrieve,
new SqlParameter[] { new SqlParameter("@Name", DBNull.Value) },
xCon);
while (xRdr.Read())
{
GlobalConfig cfg = new GlobalConfig(xRdr.FieldInt("GlobalConfigID"),
xRdr.FieldGuid("GlobalConfigGUID"),
xRdr.Field("Name"),
xRdr.Field("Description"),
xRdr.Field("ConfigValue"),
xRdr.Field("GroupName"),
xRdr.FieldBool("SuperOnly"),
xRdr.Field("ValueType"),
xRdr.FieldDateTime("CreatedOn"),
xRdr.Field("EnumValues"));
xConfig.Add(cfg);
}
}
return(xConfig);
}
public static GlobalConfig getGlobalConfig(string setting)
{
using (SqlConnection xCon = new SqlConnection(DB.GetDBConn()))
{
xCon.Open();
//System.Data.IDataReader xRdr= DB.GetRS(sqlRetrieve, xCon);
System.Data.IDataReader xRdr = DB.GetRS(sqlRetrieve, new SqlParameter[] { new SqlParameter("@Name", setting) }, xCon);
while (xRdr.Read())
{
return(new GlobalConfig(xRdr.FieldInt("GlobalConfigID"),
xRdr.FieldGuid("GlobalConfigGUID"),
xRdr.Field("Name"),
xRdr.Field("Description"),
xRdr.Field("ConfigValue"),
xRdr.Field("GroupName"),
xRdr.FieldBool("SuperOnly"),
xRdr.Field("ValueType"),
xRdr.FieldDateTime("CreatedOn"),
xRdr.Field("EnumValues")));
}
}
return(null);
}
