public List <Transport.AFTSetting> GetAFTSettingsDetails(int iDenom)
{
List <Transport.AFTSetting> lstAFTSettings = new List <Transport.AFTSetting>();
Transport.AFTSetting tspAFTSettings = null;
List <string> SettingNames = new List <string>()
{
"AFTTransactionsAllowed",
"AllowCashableDeposits",
"AllowNonCashableDeposits",
"AllowRedeemOffers",
"AllowPointsWithdrawal",
"AllowCashWithdrawal",
"AllowPartialTransfers",
"AutoDepositNonCashableCreditsonCardOut",
"AutoDepositCashableCreditsonCardOut",
"AllowOffers"
};
DataTable dtAFTSettings = new DataTable();
try
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Denom", iDenom);
dtAFTSettings = SqlHelper.ExecuteDataset(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure,
"rsp_UIGetAFTSettings", param).Tables[0];
foreach (DataRow row in dtAFTSettings.Rows)
{
tspAFTSettings = new BMC.Transport.AFTSetting();
tspAFTSettings.Name = row["SettingName"].ToString();
tspAFTSettings.Value = row["SettingValue"].ToString();
try
{
if (row["SettingValue"] != null)
{
if (SettingNames.Contains(row["SettingName"].ToString()))
{
tspAFTSettings.IsCheckBox = row["SettingValue"].ToString() == "0" ? true :
row["SettingValue"].ToString() == "1" ? true : false;
}
else
{
tspAFTSettings.IsCheckBox = false;
}
}
}
catch (Exception ex)
{
tspAFTSettings.IsCheckBox = false;
}
if (SettingNames.Contains(row["SettingName"].ToString()))
{
tspAFTSettings.IsActive = row["SettingValue"].ToString() == "1" ? true : row["SettingValue"].ToString() == "0" ? false : false;
}
else
{
tspAFTSettings.IsActive = false;
}
lstAFTSettings.Add(tspAFTSettings);
}
return(lstAFTSettings);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
return(lstAFTSettings);
}
}
public List<Transport.AFTSetting> GetAFTSettingsDetails(int iDenom)
{
List<Transport.AFTSetting> lstAFTSettings = new List<Transport.AFTSetting>();
Transport.AFTSetting tspAFTSettings=null;
List<string> SettingNames = new List<string>(){"AFTTransactionsAllowed",
"AllowCashableDeposits",
"AllowNonCashableDeposits",
"AllowRedeemOffers",
"AllowPointsWithdrawal",
"AllowCashWithdrawal",
"AllowPartialTransfers",
"AutoDepositNonCashableCreditsonCardOut",
"AutoDepositCashableCreditsonCardOut",
"AllowOffers"};
DataTable dtAFTSettings = new DataTable();
try
{
SqlParameter[] param=new SqlParameter[1] ;
param[0]=new SqlParameter("@Denom", iDenom);
dtAFTSettings = SqlHelper.ExecuteDataset(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure,
"rsp_UIGetAFTSettings", param).Tables[0];
foreach (DataRow row in dtAFTSettings.Rows)
{
tspAFTSettings = new BMC.Transport.AFTSetting();
tspAFTSettings.Name = row["SettingName"].ToString();
tspAFTSettings.Value = row["SettingValue"].ToString();
try
{
if (row["SettingValue"] != null)
{
if (SettingNames.Contains(row["SettingName"].ToString()))
{
tspAFTSettings.IsCheckBox = row["SettingValue"].ToString() == "0" ? true :
row["SettingValue"].ToString() == "1" ? true : false;
}
else
{
tspAFTSettings.IsCheckBox = false;
}
}
}
catch (Exception ex)
{
tspAFTSettings.IsCheckBox = false;
}
if (SettingNames.Contains(row["SettingName"].ToString()))
{
tspAFTSettings.IsActive = row["SettingValue"].ToString() == "1" ? true : row["SettingValue"].ToString() == "0" ? false : false;
}
else
{
tspAFTSettings.IsActive = false;
}
lstAFTSettings.Add(tspAFTSettings);
}
return lstAFTSettings;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
return lstAFTSettings;
}
}
