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