private static SortedList <string, IEnumerable> GetAllADConfigValueFromDataBase()
{
ADConfigValuesController objConfigValuesController = new ADConfigValuesController();
DataSet ds = objConfigValuesController.GetAllObjects();
List <ADConfigValuesInfo> configValueList = new List <ADConfigValuesInfo>();
if (ds.Tables.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
ADConfigValuesInfo objConfigValuesInfo = (ADConfigValuesInfo)objConfigValuesController.GetObjectFromDataRow(row);
configValueList.Add(objConfigValuesInfo);
}
}
SortedList <string, IEnumerable> result = new SortedList <string, IEnumerable>();
if (configValueList.Count() == 0)
{
return(result);
}
var group = configValueList.GroupBy(o => o.ADConfigKeyGroup).OrderBy(o => o.Key);
foreach (var item in group)
{
result.Add(item.Key, group.SelectMany(o => o.Where(o1 => o1.ADConfigKeyGroup == item.Key).OrderBy(o1 => o1.ADConfigKeySortOrder)));
}
return(result);
}
public object GetValueByConfigKey(string configKey)
{
ADConfigValuesInfo configValue = GetObjectByConfigKey(configKey);
if (configKey != null)
{
return(configValue.ADConfigKeyValue);
}
return(null);
}
public ADConfigValuesInfo GetObjectByGroupAndValue(string group, string value)
{
DataSet ds = dal.GetDataSet("ADConfigValues_GetObjectByGroupAndValue", group, value);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
ADConfigValuesInfo objConfigValuesInfo = (ADConfigValuesInfo)dal.GetObjectFromDataRow(ds.Tables[0].Rows[0]);
ds.Dispose();
return(objConfigValuesInfo);
}
return(null);
}
public ADConfigValuesInfo GetObjectByConfigKey(String configKey)
{
String sql = String.Format("SELECT * FROM ADConfigValues WHERE AAStatus = 'Alive' AND ADConfigKey = N'{0}'", configKey);
DataSet ds = dal.GetDataSet(sql);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
ADConfigValuesInfo objConfigValuesInfo = (ADConfigValuesInfo)dal.GetObjectFromDataRow(ds.Tables[0].Rows[0]);
ds.Dispose();
return(objConfigValuesInfo);
}
return(null);
}