public bool CreateShortPayForApproval(Treasury objTreasury, ref int iShortPayID) { System.Data.SqlClient.SqlParameter ShortPayID = DataBaseServiceHandler.AddParameter <int>("@ShortPayID", DbType.Int32, 0, ParameterDirection.InputOutput); try { DataBaseServiceHandler.ExecuteNonQuery(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, DBConstants.CONST_SP_CREATE_SHORTPAY_FOR_APPROVAL, DataBaseServiceHandler.AddParameter <int>("@Installation_No", DbType.Int32, objTreasury.InstallationNumber), DataBaseServiceHandler.AddParameter <int>("@User_No", DbType.Int32, objTreasury.UserID), DataBaseServiceHandler.AddParameter <string>("@Treasury_Type", DbType.String, objTreasury.TreasuryType), DataBaseServiceHandler.AddParameter <string>("@Treasury_Reason", DbType.String, objTreasury.TreasuryReason), DataBaseServiceHandler.AddParameter <double>("@Treasury_Amount", DbType.Double, objTreasury.TreasuryAmount), DataBaseServiceHandler.AddParameter <int>("@Treasury_Reason_Code", DbType.Int32, objTreasury.TreasuryReasonCode), DataBaseServiceHandler.AddParameter <int>("@Treasury_Issuer_User_No", DbType.Int32, objTreasury.TreasuryIssuerUserNo), ShortPayID ); iShortPayID = int.Parse(ShortPayID.Value.ToString()); return(true); } catch (Exception ex) { ExceptionManager.Publish(ex); return(false); } }
public bool UpdateEventDetails(string clearType, string eventType, int eventNo, int installationNo) { int errorCode = 0; string errorMessage = string.Empty; try { LogManager.WriteLog("Inside Method", LogManager.enumLogLevel.Info); DataBaseServiceHandler.ExecuteNonQuery(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, DBConstants.CONST_SP_USP_CLEAREVENTDETAILS, DataBaseServiceHandler.AddParameter <int>(DBConstants.CONST_PARAM_USER_ID, DbType.Int32, BMC.Security.SecurityHelper.CurrentUser.SecurityUserID, ParameterDirection.Input), DataBaseServiceHandler.AddParameter <string>(DBConstants.CONST_PARAM_CLEAR_TYPE, DbType.String, clearType, ParameterDirection.Input), DataBaseServiceHandler.AddParameter <string>(DBConstants.CONST_PARAM_EVENTTYPE, DbType.String, eventType, ParameterDirection.Input), DataBaseServiceHandler.AddParameter <int>(DBConstants.CONST_PARAM_EVENT_NO, DbType.Int32, eventNo, ParameterDirection.Input), DataBaseServiceHandler.AddParameter <int>(DBConstants.CONST_PARAM_INSTALATION_NO, DbType.Int32, installationNo, ParameterDirection.Input), DataBaseServiceHandler.AddParameter <int>(DBConstants.CONST_PARAM_ERROR_CODE, DbType.Int32, errorCode, ParameterDirection.Output), DataBaseServiceHandler.AddParameter <string>(DBConstants.CONST_PARAM_ERROR_MESSAGE, DbType.String, errorMessage, ParameterDirection.Output)); LogManager.WriteLog(string.Format("{0} - {1}", "Error Code", errorCode.ToString()), LogManager.enumLogLevel.Info); LogManager.WriteLog(string.Format("{0} - {1}", "Error Message", errorMessage), LogManager.enumLogLevel.Info); return(errorCode == 0 ? true : false); } catch (Exception ex) { ExceptionManager.Publish(ex); return(false); } }
public bool SetMachinePreviousState(int installationNo) { int errorCode = 0; string errorMessage = string.Empty; try { LogManager.WriteLog("Inside Method", LogManager.enumLogLevel.Info); DataBaseServiceHandler.ExecuteNonQuery(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, DBConstants.CONST_SP_USP_UPDATEMACHINEMAINTENANCEDETAILS, DataBaseServiceHandler.AddParameter <int>(DBConstants.CONST_PARAM_INSTALATION_NO, DbType.Int32, installationNo, ParameterDirection.Input), DataBaseServiceHandler.AddParameter <int>(DBConstants.CONST_PARAM_ERROR_CODE, DbType.Int32, errorCode, ParameterDirection.Output), DataBaseServiceHandler.AddParameter <string>(DBConstants.CONST_PARAM_ERROR_MESSAGE, DbType.String, errorMessage, ParameterDirection.Output)); LogManager.WriteLog(string.Format("{0} - {1}", "Error Code", errorCode.ToString()), LogManager.enumLogLevel.Info); LogManager.WriteLog(string.Format("{0} - {1}", "Error Message", errorMessage), LogManager.enumLogLevel.Info); return(errorCode == 0 ? true : false); } catch (Exception ex) { ExceptionManager.Publish(ex); return(false); } }
public string GetSetting(string strSettingName) { SqlParameter ParamValue = new SqlParameter(); ParamValue.ParameterName = DBConstants.CONST_SP_PARAM_SETTINGVALUE; ParamValue.Direction = ParameterDirection.Output; ParamValue.Value = string.Empty; ParamValue.SqlDbType = SqlDbType.VarChar; ParamValue.Size = 200; try { if (strSettingName != null) { //DataBaseServiceHandler.ConnectionString = ExchangeConnectionString; DataBaseServiceHandler.ExecuteNonQuery(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, DBConstants.CONST_SP_GETSETTING, DataBaseServiceHandler.AddParameter <int>(DBConstants.CONST_SP_PARAM_SETTINGID, DbType.Int32, 0, ParameterDirection.Input), DataBaseServiceHandler.AddParameter <string>(DBConstants.CONST_SP_PARAM_SETTINGNAME, DbType.String, strSettingName.Trim()), DataBaseServiceHandler.AddParameter <string>(DBConstants.CONST_SP_PARAM_SETTINGDEFAULT, DbType.String, string.Empty), ParamValue); } } catch (Exception ex) { ExceptionManager.Publish(ex); } return(ParamValue.Value.ToString()); }
public int LogTitoTicketPrint(string BarCode, int Amount) { return(DataBaseServiceHandler.ExecuteNonQuery(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, "usp_LogTITOTicketPrint", DataBaseServiceHandler.AddParameter <string>("@TicketNumber", DbType.String, BarCode), DataBaseServiceHandler.AddParameter <string>("@Workstation", DbType.String, Environment.MachineName), DataBaseServiceHandler.AddParameter <int>("@Value", DbType.Int32, Amount), DataBaseServiceHandler.AddParameter <int>("@Installation_No", DbType.Int32, 0))); }
public static void UpdatePendingRecords() { try { DataBaseServiceHandler.ExecuteNonQuery(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "usp_UpdateInProgressVerificationRecords"); } catch (Exception Ex) { ExceptionManager.Publish(Ex); } }
public static void UpdateAFTPolling(int Installation_ID) { try { DataBaseServiceHandler.ExecuteNonQuery(GetConnectionString(), CommandType.StoredProcedure, "usp_UpdateAFTPolling", DataBaseServiceHandler.AddParameter <int>("@Installation_No", DbType.Int32, Installation_ID)); } catch (Exception Ex) { ExceptionManager.Publish(Ex); } }
public static void UpdateTicketExpireInstallations(int nInstallationNo) { try { DataBaseServiceHandler.ExecuteNonQuery(GetConnectionString(), CommandType.StoredProcedure, "usp_UpdateInstallationsForTicketExpire", DataBaseServiceHandler.AddParameter <int>("@Installation_No", DbType.Int32, nInstallationNo)); } catch (Exception Ex) { LogManager.WriteLog("usp_UpdateInstallationsForTicketExpire Database Hit Failed.", LogManager.enumLogLevel.Info); ExceptionManager.Publish(Ex); } }
public static void UpdateAAMSVerification(int ReferenceID, int IH_Status) { try { DataBaseServiceHandler.ExecuteNonQuery(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "usp_UpdateAAMSIHVerification", DataBaseServiceHandler.AddParameter <int>("@Reference_ID", DbType.Int32, ReferenceID), DataBaseServiceHandler.AddParameter <int>("@IH_Status", DbType.Int32, IH_Status)); } catch (Exception Ex) { ExceptionManager.Publish(Ex); } }
public static void UpdateEmployeeCardPolling(string EmployeecardNo, int InstallationNo) { try { DataBaseServiceHandler.ExecuteNonQuery(ExchangeConnectionString, CommandType.StoredProcedure, "usp_UpdateEmployeecardPolling", DataBaseServiceHandler.AddParameter <int>("@InstallationNo", DbType.Int32, InstallationNo), DataBaseServiceHandler.AddParameter <string>("@EmpCardNo ", DbType.String, EmployeecardNo)); } catch (Exception Ex) { ExceptionManager.Publish(Ex); } }
public int DeleteReasonDetails(ReasonCode objReason) { try { DataBaseServiceHandler.ExecuteNonQuery(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, DBConstants.CONST_SP_DELETE_REASON_PROC, DataBaseServiceHandler.AddParameter <string>(DBConstants.CONST_PARAM_REASONDESCRIPTION, DbType.String, objReason.ReasonDescription)); } catch (Exception ex) { ExceptionManager.Publish(ex); } return(1); }
public static void UpdateLP21Status(int ReferenceID, string Command, string UpdateType) { try { DataBaseServiceHandler.ExecuteNonQuery(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "usp_UpdateLP21Status", DataBaseServiceHandler.AddParameter <int>("@Reference_ID", DbType.Int32, ReferenceID), DataBaseServiceHandler.AddParameter <string>("@EntityCommand", DbType.String, Command), DataBaseServiceHandler.AddParameter <string>("@UpdateType", DbType.String, UpdateType)); } catch (Exception Ex) { ExceptionManager.Publish(Ex); } }
public static bool UpdateB5ReqStatus(int RefID) { try { DataBaseServiceHandler.ExecuteNonQuery(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "usp_UpdateB5ReqStatus", DataBaseServiceHandler.AddParameter <int>("@BAD_ID", DbType.Int32, RefID)); return(true); } catch (Exception Ex) { ExceptionManager.Publish(Ex); return(false); } }
// public static void UpdateTicketExpire(int value) { try { DataBaseServiceHandler.ExecuteNonQuery( GetTicketingConnectionString(), CommandType.StoredProcedure, "usp_SetTicketExpire", DataBaseServiceHandler.AddParameter <int>("Value", DbType.String, value)); } catch (Exception ex) { ExceptionManager.Publish(ex); } }
public static bool UpdatePortDisabledStatusForPortBlocking(int installationNo) { try { DataBaseServiceHandler.ExecuteNonQuery(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "usp_UpdatePortDisabledStatus", DataBaseServiceHandler.AddParameter <int>("@InstallationNo", DbType.Int32, installationNo)); return(true); } catch (Exception Ex) { ExceptionManager.Publish(Ex); return(false); } }
public static void InsertExportHistory(string Type, string Reference) { try { DataBaseServiceHandler.ExecuteNonQuery(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "usp_Export_History", DataBaseServiceHandler.AddParameter <string>("@Reference1", DbType.String, Reference), DataBaseServiceHandler.AddParameter <string>("@Reference2", DbType.String, ""), DataBaseServiceHandler.AddParameter <string>("@Type", DbType.String, Type), DataBaseServiceHandler.AddParameter <string>("@Status", DbType.String, "")); } catch (Exception Ex) { ExceptionManager.Publish(Ex); } }
public static bool SyncInstallationStatus(int Installation_No, char syncStatus) { try { DataBaseServiceHandler.ExecuteNonQuery(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "usp_SyncInstallationStatus", DataBaseServiceHandler.AddParameter <int>("@Installation_No", DbType.Int32, Installation_No), DataBaseServiceHandler.AddParameter <char>("@SyncStatus", DbType.String, syncStatus)); return(true); } catch (Exception Ex) { ExceptionManager.Publish(Ex); return(false); } }
public static void UpdateTicketExpire(int value) { try { DataBaseServiceHandler.ExecuteNonQuery( TicketingConnectionString, CommandType.StoredProcedure, DBConstants.CONSTANT_USP_SETTICKETEXPIRE, DataBaseServiceHandler.AddParameter <int>("Value", DbType.String, value)); } catch (Exception ex) { ExceptionManager.Publish(ex); } }
public void SaveFloorPosition(int slotID, int securityUserID, int topPosition, int leftPosition) { try { //DataBaseServiceHandler.ConnectionString = CommonDataAccess.ExchangeConnectionString; DataBaseServiceHandler.ExecuteNonQuery(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, "usp_SetBarPositionDetailsForCashDeskoperator", DataBaseServiceHandler.AddParameter <int>("@Bar_Pos_No", DbType.Int32, slotID), DataBaseServiceHandler.AddParameter <int>("@SecurityUserID", DbType.Int32, securityUserID), DataBaseServiceHandler.AddParameter <int>("@Top", DbType.Int32, topPosition), DataBaseServiceHandler.AddParameter <int>("@Left", DbType.Int32, leftPosition)); } catch (Exception Ex) { ExceptionManager.Publish(Ex); } }
public int UpdateTicketException(int ID, string TicketNumber, string Value) { try { //DataBaseServiceHandler.ConnectionString = CommonDataAccess.ExchangeConnectionString; return(DataBaseServiceHandler.ExecuteNonQuery(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, DBConstants.CONST_SP_UPDATE_TICKET_EXCEPTION_PROC, DataBaseServiceHandler.AddParameter <string>(DBConstants.CONST_PARAM_TE_TICKET_NUMBER, DbType.String, TicketNumber), DataBaseServiceHandler.AddParameter <int>(DBConstants.CONST_PARAM_TE_ID, DbType.Int32, ID), DataBaseServiceHandler.AddParameter <string>(DBConstants.CONST_PARAM_TE_STATUS, DbType.Int32, Value))); } catch (Exception ex) { ExceptionManager.Publish(ex); } return(-1); }
public static void UpdateGMUSiteCodeStatus(int Installation_No, int Status) { try { DataBaseServiceHandler.ExecuteNonQuery( ExchangeConnectionString, CommandType.StoredProcedure, DBConstants.CONSTANT_USP_SETGMUSITECODESTATUS, DataBaseServiceHandler.AddParameter <int>("@InstallationNo", DbType.Int32, Installation_No), DataBaseServiceHandler.AddParameter <int>("@Status", DbType.Int32, Status)); } catch (Exception ex) { ExceptionManager.Publish(ex); } }
public static void UpdateSettings(string SettingNamem, string SettingValue) { try { DataBaseServiceHandler.ExecuteNonQuery( ExchangeConnectionString, CommandType.StoredProcedure, DBConstants.CONSTANT_USP_SETSETTINGSVALUE, DataBaseServiceHandler.AddParameter <string>("SettingName", DbType.String, SettingNamem), DataBaseServiceHandler.AddParameter <string>("SettingValue", DbType.String, SettingValue)); } catch (Exception ex) { ExceptionManager.Publish(ex); } }
public static void UpdateAppSettings_SortOrder(string AppSettingKey, string AppSettingValue) { try { DataBaseServiceHandler.ExecuteNonQuery( ExchangeConnectionString, CommandType.StoredProcedure, DBConstants.CONSTANT_USP_APPSETTINGS_SORTORDER, DataBaseServiceHandler.AddParameter <string>("AppSettingName", DbType.String, AppSettingKey), DataBaseServiceHandler.AddParameter <string>("Value", DbType.String, AppSettingValue)); } catch (Exception ex) { ExceptionManager.Publish(ex); } }
public int DBUpdateVoucherPromotion(int PromoTicketID, String Barcode) { int UpdateVoucherPromotion = 0; try { SqlParameter[] parames = new SqlParameter[2]; parames[0] = DataBaseServiceHandler.AddParameter <int>("@PromotionID", DbType.Int32, PromoTicketID, ParameterDirection.Input); parames[1] = DataBaseServiceHandler.AddParameter <string>("@Barcode", DbType.String, Barcode, ParameterDirection.Input); UpdateVoucherPromotion = DataBaseServiceHandler.ExecuteNonQuery(CommonDataAccess.TicketingConnectionString, CommandType.StoredProcedure, "usp_UpdateVoucherPromotion", parames); } catch (Exception ex) { ExceptionManager.Publish(ex); } return(UpdateVoucherPromotion); }
public static bool UpdateInstallationcRC(int Installation_No, string cRC) { try { var output = DataBaseServiceHandler.AddParameter <bool>("@Out", DbType.Boolean, false); DataBaseServiceHandler.ExecuteNonQuery(DBBuilder.GetConnectionString(), CommandType.StoredProcedure, "usp_UpdateInstallationcRC", DataBaseServiceHandler.AddParameter <int>("@Installation_No", DbType.Int32, Installation_No), DataBaseServiceHandler.AddParameter <string>("@cRC", DbType.String, cRC), output); return(Convert.ToBoolean(output.Value)); } catch (Exception Ex) { ExceptionManager.Publish(Ex); return(false); } }
// public static void UpdatedTITOConfig(int Installation_ID, int SiteTITOEnabled, int SiteNonCashEnabled, int MachineTITOEnabled, int MachineNonCashEnabled, int EnableCommand) { try { DataBaseServiceHandler.ExecuteNonQuery(GetConnectionString(), CommandType.StoredProcedure, "usp_UpdatedTITOConfig", DataBaseServiceHandler.AddParameter <int>("@Installation_No", DbType.Int32, Installation_ID), DataBaseServiceHandler.AddParameter <int>("@SiteTITOEnabled", DbType.Int32, SiteTITOEnabled), DataBaseServiceHandler.AddParameter <int>("@SiteNonCashEnabled", DbType.Int32, SiteNonCashEnabled), DataBaseServiceHandler.AddParameter <int>("@MachineTITOEnabled", DbType.Int32, MachineTITOEnabled), DataBaseServiceHandler.AddParameter <int>("@MachineNonCashEnabled", DbType.Int32, MachineNonCashEnabled), DataBaseServiceHandler.AddParameter <int>("@EnableCommand", DbType.Int32, EnableCommand)); } catch (Exception Ex) { ExceptionManager.Publish(Ex); } }
//Cancel Print Status Update public int DBCancelPrintStatusUpdate(int PromoTicketID) { int RescancelPrintStatusUpdate = 0; try { SqlParameter[] parames = new SqlParameter[1]; parames[0] = DataBaseServiceHandler.AddParameter <int>("@PromotionID", DbType.Int32, PromoTicketID, ParameterDirection.Input); RescancelPrintStatusUpdate = DataBaseServiceHandler.ExecuteNonQuery(CommonDataAccess.TicketingConnectionString, CommandType.StoredProcedure, "usp_CancelPrintUpdateStatus", parames); } catch (Exception ex) { ExceptionManager.Publish(ex); } return(RescancelPrintStatusUpdate); }
//Insert Promotional public int InsertPromotionalTicket(int promTicketType, string promName, int promTotalTickets, double promAmount, DateTime promExpDate) { try { return(DataBaseServiceHandler.ExecuteNonQuery(CommonDataAccess.TicketingConnectionString, CommandType.StoredProcedure, "usp_InsertPromotionalTicket", DataBaseServiceHandler.AddParameter <int>("@PromotionalTicketType", DbType.Int32, promTicketType), DataBaseServiceHandler.AddParameter <string>("@PromotionName", DbType.String, promName), DataBaseServiceHandler.AddParameter <int>("@TotalTickets", DbType.Int32, promTotalTickets), DataBaseServiceHandler.AddParameter <double>("@TicketAmount", DbType.Decimal, promAmount), DataBaseServiceHandler.AddParameter <DateTime>("@ExpiryDate", DbType.DateTime, promExpDate))); } catch (Exception ex) { ExceptionManager.Publish(ex); return(-1); } }
public bool SaveAFTSettings(List <Transport.AFTSetting> lstAFTSettings) { bool bResult = false; int Executed = 0; SqlParameter[] parames = null; try { parames = new SqlParameter[] { DataBaseServiceHandler.AddParameter <bool>("AllowEFTTransactions", DbType.Boolean, lstAFTSettings[0].Name.ToUpper() == "AFTTRANSACTIONSALLOWED".Trim() ? Convert.ToBoolean(Convert.ToInt32(lstAFTSettings[0].Value)) : Convert.ToBoolean("false")), DataBaseServiceHandler.AddParameter <bool>("ALLOWCASHABLEDEPOSITS", DbType.Boolean, lstAFTSettings[1].Name.ToUpper() == "ALLOWCASHABLEDEPOSITS".Trim() ? Convert.ToBoolean(Convert.ToInt32(lstAFTSettings[1].Value)) : Convert.ToBoolean("false")), DataBaseServiceHandler.AddParameter <bool>("ALLOWNONCASHABLEDEPOSITS", DbType.Boolean, lstAFTSettings[2].Name.ToUpper() == "ALLOW NON-CASHABLE DEPOSITS".Trim() ? Convert.ToBoolean(Convert.ToInt32(lstAFTSettings[2].Value)) : Convert.ToBoolean("false")), DataBaseServiceHandler.AddParameter <bool>("ALLOWREDEEMOFFERS", DbType.Boolean, lstAFTSettings[3].Name.ToUpper() == "ALLOWREDEEMOFFERS".Trim() ? Convert.ToBoolean(Convert.ToInt32(lstAFTSettings[3].Value)) : Convert.ToBoolean("false")), DataBaseServiceHandler.AddParameter <bool>("ALLOWPOINTSWITHDRAWAL", DbType.Boolean, lstAFTSettings[4].Name.ToUpper() == "ALLOWPOINTSWITHDRAWAL".Trim() ? Convert.ToBoolean(Convert.ToInt32(lstAFTSettings[4].Value)) : Convert.ToBoolean("false")), DataBaseServiceHandler.AddParameter <bool>("ALLOWCASHWITHDRAWAL", DbType.Boolean, lstAFTSettings[5].Name.ToUpper() == "ALLOWCASHWITHDRAWAL".Trim() ? Convert.ToBoolean(Convert.ToInt32(lstAFTSettings[5].Value)) : Convert.ToBoolean("false")), DataBaseServiceHandler.AddParameter <bool>("ALLOWPARTIALTRANSFER", DbType.Boolean, lstAFTSettings[6].Name.ToUpper() == "ALLOWPARTIALTRANSFERS".Trim() ? Convert.ToBoolean(Convert.ToInt32(lstAFTSettings[6].Value)) : Convert.ToBoolean("false")), DataBaseServiceHandler.AddParameter <bool>("ALLOWAUTODEPOSITNONCASHABLECREDIT", DbType.Boolean, lstAFTSettings[7].Name.ToUpper() == "AUTODEPOSITNON-CASHABLECREDITSONCARDOUT".Trim() ? Convert.ToBoolean(Convert.ToInt32(lstAFTSettings[7].Value)) : Convert.ToBoolean("false")), DataBaseServiceHandler.AddParameter <bool>("ALLOWAUTODEPOSITCASHABLECREDIT", DbType.Boolean, lstAFTSettings[8].Name.ToUpper() == "AUTODEPOSITCASHABLECREDITSONCARDOUT".Trim() ? Convert.ToBoolean(Convert.ToInt32(lstAFTSettings[8].Value)) : Convert.ToBoolean("false")), DataBaseServiceHandler.AddParameter <bool>("ALLOWOFFERS", DbType.Boolean, lstAFTSettings[9].Name.ToUpper() == "ALLOWOFFERS".Trim() ? Convert.ToBoolean(Convert.ToInt32(lstAFTSettings[9].Value)) : Convert.ToBoolean("false")), DataBaseServiceHandler.AddParameter <int>("EFTTIMEOUT", DbType.Int32, lstAFTSettings[10].Name.ToUpper() == "EFTTIMEOUTVALUE".Trim() ? Convert.ToInt32(lstAFTSettings[10].Value) : Convert.ToInt32("0")), DataBaseServiceHandler.AddParameter <double>("OPTION1WITHDRAWALAMT", DbType.Double, lstAFTSettings[11].Name.ToUpper() == "OPTION1WITHDRAWALAMOUNT".Trim() ? Convert.ToDouble(lstAFTSettings[11].Value) : Convert.ToDouble("0")), DataBaseServiceHandler.AddParameter <double>("OPTION2WITHDRAWALAMT", DbType.Double, lstAFTSettings[12].Name.ToUpper() == "OPTION2WITHDRAWALAMOUNT".Trim() ? Convert.ToDouble(lstAFTSettings[12].Value) : Convert.ToDouble("0")), DataBaseServiceHandler.AddParameter <double>("OPTION3WITHDRAWALAMT", DbType.Double, lstAFTSettings[13].Name.ToUpper() == "OPTION3WITHDRAWALAMOUNT".Trim() ? Convert.ToDouble(lstAFTSettings[13].Value) : Convert.ToDouble("0")), DataBaseServiceHandler.AddParameter <double>("OPTION4WITHDRAWALAMT", DbType.Double, lstAFTSettings[14].Name.ToUpper() == "OPTION4WITHDRAWALAMOUNT".Trim() ? Convert.ToDouble(lstAFTSettings[14].Value) : Convert.ToDouble("0")), DataBaseServiceHandler.AddParameter <double>("OPTION5WITHDRAWALAMT", DbType.Double, lstAFTSettings[15].Name.ToUpper() == "OPTION5WITHDRAWALAMOUNT".Trim() ? Convert.ToDouble(lstAFTSettings[15].Value) : Convert.ToDouble("0")) }; Executed = DataBaseServiceHandler.ExecuteNonQuery(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, "usp_UpdateAFTSettings", parames); if (Executed > 1) { return(true); } else { return(false); } } catch (Exception ex) { ExceptionManager.Publish(ex); return(bResult); } }
public int InsertException(TicketException objException) { try { //DataBaseServiceHandler.ConnectionString = CommonDataAccess.ExchangeConnectionString; return(DataBaseServiceHandler.ExecuteNonQuery(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, DBConstants.CONST_SP_INSERT_EXCEPTION_PROC, DataBaseServiceHandler.AddParameter <int>(DBConstants.CONST_PARAM_INSTALLATION_ID, DbType.Int32, objException.InstallationNumber), DataBaseServiceHandler.AddParameter <int>(DBConstants.CONST_PARAM_EXCEPTION_TYPE, DbType.Int32, objException.ExceptionType), DataBaseServiceHandler.AddParameter <string>(DBConstants.CONST_PARAM_EXCEPTION_DETAILS, DbType.String, objException.ExceptionDetails), DataBaseServiceHandler.AddParameter <string>(DBConstants.CONST_PARAM_EXCEPTION_REFERENCE, DbType.String, objException.Reference), DataBaseServiceHandler.AddParameter <int>(DBConstants.CONST_PARAM_EXCEPTION_USER, DbType.Int32, objException.User))); } catch (Exception ex) { ExceptionManager.Publish(ex); return(-1); } }