private static MicroSetting DataRowToObject(DataRow dr)
{
MicroSetting TheSetting;
if (dr != null)
{
TheSetting = new MicroSetting
{
SettingID = int.Parse(dr["SettingID"].ToString()),
SettingKeyID = int.Parse(dr["SettingKeyID"].ToString()),
SettingKeyName = dr["SettingKeyName"].ToString(),
SettingKeyModuleID = int.Parse(dr["SettingKeyModuleID"].ToString()),
SettingKeyModuleName = dr["SettingKeyModuleName"].ToString(),
SettingDataType = dr["SettingDataType"].ToString(),
SettingValue = dr["SettingValue"].ToString(),
EffectiveDateFrom = DateTime.Parse(dr["EffectiveDateFrom"].ToString()).ToString(MicroConstants.DateFormat)
};
}
else
{
TheSetting = new MicroSetting();
}
return(TheSetting);
}
public static List <MicroSetting> GetSettingList()
{
List <MicroSetting> TheSettingList = new List <MicroSetting>();
DataTable TheSettingTable = MicroSettingDataAccess.GetInstance.GetSettingList();
foreach (DataRow dr in TheSettingTable.Rows)
{
MicroSetting TheSetting = DataRowToObject(dr);
TheSettingList.Add(TheSetting);
}
return(TheSettingList);
}
public static MicroSetting GetSettingByName(string settingKeyName, int moduleID)
{
MicroSetting TheSetting;
List <MicroSetting> TheSettingList = GetSettingList();
if (TheSettingList.Count > 0)
{
TheSetting = (from MicroSettings in TheSettingList
where MicroSettings.SettingKeyName == settingKeyName && MicroSettings.SettingKeyModuleID == moduleID
orderby MicroSettings.EffectiveDateFrom
select MicroSettings).Last();
}
else
{
TheSetting = new MicroSetting();
}
return(TheSetting);
}
public decimal GetSettingValue(string settingKeyName, int moduleID)
{
decimal ReturnValue = 0;
MicroSetting TheSetting = GetSettingByName(settingKeyName, moduleID);
if (TheSetting.SettingID > 0)
{
if (TheSetting.SettingDataType == MicroEnums.GetStringValue(MicroEnums.SettingDataType.Decimal))
{
ReturnValue = decimal.Parse(TheSetting.SettingValue);
}
else if (TheSetting.SettingDataType == MicroEnums.GetStringValue(MicroEnums.SettingDataType.Percentage))
{
ReturnValue = (decimal.Parse(TheSetting.SettingValue) / 100);
}
}
return(ReturnValue);
}
