public bool UpdateSystemAdmin(SystemAdminDTO dtoSysAdmin) { bool result = true; string query = string.Format("UPDATE SYSTEM_ADMIN SET SYS_PWD = @SYS_PWD, SYS_GAS92_CURRENT_PRICE = @SYS_GAS92_CURRENT_PRICE, SYS_GAS95_CURRENT_PRICE = @SYS_GAS95_CURRENT_PRICE, SYS_GASDO_CURRENT_PRICE = @SYS_GASDO_CURRENT_PRICE " + "SYS_GAS92_NEW_PRICE = @SYS_GAS92_NEW_PRICE, SYS_GAS95_NEW_PRICE = @SYS_GAS95_NEW_PRICE, SYS_GASDO_NEW_PRICE = @SYS_GASDO_NEW_PRICE, SYS_APPLY_DATE = @SYS_APPLY_DATE " + " WHERE SYS_ADMIN = @SYS_ADMIN"); SqlParameter[] sqlParameters = new SqlParameter[9]; sqlParameters[0] = new SqlParameter("@SYS_ADMIN", SqlDbType.NVarChar); sqlParameters[0].Value = Convert.ToString(dtoSysAdmin.SysAdminAccount); sqlParameters[1] = new SqlParameter("@SYS_PWD", SqlDbType.NVarChar); sqlParameters[1].Value = Convert.ToString(dtoSysAdmin.SysAdminPwd); sqlParameters[2] = new SqlParameter("@SYS_GAS92_CURRENT_PRICE", SqlDbType.Int); sqlParameters[2].Value = Convert.ToInt32(dtoSysAdmin.SysGas92CurrentPrice); sqlParameters[3] = new SqlParameter("@SYS_GAS95_CURRENT_PRICE", SqlDbType.Int); sqlParameters[3].Value = Convert.ToInt32(dtoSysAdmin.SysGas95CurrentPrice); sqlParameters[4] = new SqlParameter("@SYS_GASDO_CURRENT_PRICE", SqlDbType.Int); sqlParameters[4].Value = Convert.ToInt32(dtoSysAdmin.SysGasDOCurrentPrice); sqlParameters[5] = new SqlParameter("@SYS_GAS92_NEW_PRICE", SqlDbType.Int); sqlParameters[5].Value = Convert.ToInt32(dtoSysAdmin.SysGas92NewPrice); sqlParameters[6] = new SqlParameter("@SYS_GAS95_NEW_PRICE", SqlDbType.Int); sqlParameters[6].Value = Convert.ToInt32(dtoSysAdmin.SysGas95NewPrice); sqlParameters[7] = new SqlParameter("@SYS_GASDO_NEW_PRICE", SqlDbType.Int); sqlParameters[7].Value = Convert.ToInt32(dtoSysAdmin.SysGasDONewPrice); sqlParameters[8] = new SqlParameter("@SYS_APPLY_DATE", SqlDbType.DateTime); sqlParameters[8].Value = Convert.ToDateTime(dtoSysAdmin.SysApplyDate); result = m_dbConnection.ExecuteUpdateQuery(query, sqlParameters); return(result); }
public DataTransfer UpdateGasStation(GasStationDTO dtoGasStation, string stGasStationID) { DataTransfer dataResult = new DataTransfer(); bool updateResult = true; try { string query = string.Format("UPDATE GAS_STATION SET GASSTATION_ID = @GASSTATION_ID_NEW, GASSTATION_NAME = @GASSTATION_NAME, GASSTATION_ADDRESS = @GASSTATION_ADDRESS, GASSTATION_DESCRIPTION = @GASSTATION_DESCRIPTION, GASSTATION_MACADDRESS = @GASSTATION_MACADDRESS, GASSTORE_ID = @GASSTORE_ID WHERE GASSTATION_ID = @GASSTATION_ID_OLD"); SqlParameter[] sqlParameters = new SqlParameter[7]; sqlParameters[0] = new SqlParameter("@GASSTATION_ID_NEW", SqlDbType.NVarChar); sqlParameters[0].Value = Convert.ToString(dtoGasStation.GasStationID); sqlParameters[1] = new SqlParameter("@GASSTATION_NAME", SqlDbType.NVarChar); sqlParameters[1].Value = Convert.ToString(dtoGasStation.GasStationName); sqlParameters[2] = new SqlParameter("@GASSTATION_ADDRESS", SqlDbType.NVarChar); sqlParameters[2].Value = Convert.ToString(dtoGasStation.GasStationAddress); sqlParameters[3] = new SqlParameter("@GASSTATION_DESCRIPTION", SqlDbType.NVarChar); sqlParameters[3].Value = Convert.ToString(dtoGasStation.GasStationDescription); sqlParameters[4] = new SqlParameter("@GASSTATION_MACADDRESS", SqlDbType.NVarChar); if (dtoGasStation.GasStationMacAddress.Equals("")) { sqlParameters[4].Value = DBNull.Value; } else { sqlParameters[4].Value = Convert.ToString(dtoGasStation.GasStationMacAddress); } sqlParameters[5] = new SqlParameter("@GASSTORE_ID", SqlDbType.NVarChar); sqlParameters[5].Value = Convert.ToString(dtoGasStation.GasStoreID); sqlParameters[6] = new SqlParameter("@GASSTATION_ID_OLD", SqlDbType.NVarChar); sqlParameters[6].Value = Convert.ToString(stGasStationID); updateResult = m_dbConnection.ExecuteUpdateQuery(query, sqlParameters); } catch (Exception ex) { updateResult = false; dataResult.ResponseErrorMsgDetail = ex.Message + " : " + ex.StackTrace; } if (updateResult) { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_SUCCESS; } else { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_FAIL; dataResult.ResponseErrorMsg = SGMText.GASSTATION_UPDATE_ERR; } return(dataResult); }
public bool UpdateSaleGas(SaleGasDTO dtoSaleGas) { bool result = true; string query = string.Format("UPDATE SALE_GAS SET SALEGAS_TYPE = @SALEGAS_TYPE, SALEGAS_CURRENT_PRICE = @SALEGAS_CURRENT_PRICE, SALEGAS_CARD_PRICE = @SALEGAS_CARD_PRICE, " + " SALEGAS_CARD_MONEY_BEFORE = @SALEGAS_CARD_MONEY_BEFORE, SALEGAS_CARD_MONEY_AFTER = @SALEGAS_CARD_MONEY_AFTER, SALEGAS_CARD_MONEY_SAVING = @SALEGAS_CARD_MONEY_SAVING, SALEGAS_LIT = @SALEGAS_LIT, SALEGAS_DATE = @SALEGAS_DATE, GASSTATION_ID = @GASSTATION_ID, CARD_ID = @CARD_ID " + " WHERE SALEGAS_ID = @SALEGAS_ID"); SqlParameter[] sqlParameters = new SqlParameter[11]; sqlParameters[0] = new SqlParameter("@SALEGAS_ID", SqlDbType.Int); sqlParameters[0].Value = Convert.ToInt32(dtoSaleGas.SaleGasID); sqlParameters[1] = new SqlParameter("@SALEGAS_TYPE", SqlDbType.NVarChar); sqlParameters[1].Value = Convert.ToString(dtoSaleGas.SaleGasType); sqlParameters[2] = new SqlParameter("@SALEGAS_CURRENT_PRICE", SqlDbType.Int); sqlParameters[2].Value = Convert.ToInt32(dtoSaleGas.SaleGasCurrentPrice); sqlParameters[3] = new SqlParameter("@SALEGAS_CARD_PRICE", SqlDbType.Int); sqlParameters[3].Value = Convert.ToInt32(dtoSaleGas.SaleGasPriceOnCard); sqlParameters[4] = new SqlParameter("@SALEGAS_CARD_MONEY_BEFORE", SqlDbType.Int); sqlParameters[4].Value = Convert.ToInt32(dtoSaleGas.SaleGasCardMoneyBefore); sqlParameters[5] = new SqlParameter("@SALEGAS_CARD_MONEY_AFTER", SqlDbType.Int); sqlParameters[5].Value = Convert.ToInt32(dtoSaleGas.SaleGasCardMoneyAfter); sqlParameters[6] = new SqlParameter("@SALEGAS_LIT", SqlDbType.Float); sqlParameters[6].Value = Convert.ToDouble(dtoSaleGas.NumberBuyLit); sqlParameters[7] = new SqlParameter("@SALEGAS_DATE", SqlDbType.DateTime); sqlParameters[7].Value = Convert.ToDateTime(dtoSaleGas.GasStationID); sqlParameters[8] = new SqlParameter("@GASSTATION_ID", SqlDbType.NVarChar); sqlParameters[8].Value = Convert.ToString(dtoSaleGas.GasStationID); sqlParameters[9] = new SqlParameter("@CARD_ID", SqlDbType.NVarChar); sqlParameters[9].Value = Convert.ToString(dtoSaleGas.CardID); sqlParameters[10] = new SqlParameter("@SALEGAS_CARD_MONEY_SAVING", SqlDbType.NVarChar); sqlParameters[10].Value = Convert.ToInt32(dtoSaleGas.SaleGasCardMoneySaving); result = m_dbConnection.ExecuteUpdateQuery(query, sqlParameters); return(result); }
public bool UpdateRecharge(RechargeDTO dtoRecharge) { bool result = true; string query = string.Format("UPDATE RECHARGE SET RECHARGE_DATE = @RECHARGE_DATE, RECHARGE_MONEY = @RECHARGE_MONEY, RECHARGE_MONEY_EX = @RECHARGE_MONEY_EX, RECHARGE_NOTE = @RECHARGE_NOTE, " + " RECHARGE_GAS92_PRICE = @RECHARGE_GAS92_PRICE, RECHARGE_GAS95_PRICE = @RECHARGE_GAS95_PRICE, RECHARGE_GASDO_PRICE = @RECHARGE_GASDO_PRICE, CARD_ID = @CARD_ID " + " WHERE RECHARGE_ID = @RECHARGE_ID" ); SqlParameter[] sqlParameters = new SqlParameter[9]; sqlParameters[0] = new SqlParameter("@RECHARGE_DATE", SqlDbType.DateTime); sqlParameters[0].Value = Convert.ToDateTime(dtoRecharge.RechargeDate); sqlParameters[1] = new SqlParameter("@RECHARGE_GAS92_PRICE", SqlDbType.Int); sqlParameters[1].Value = Convert.ToInt32(dtoRecharge.RechargeGas92Price); sqlParameters[2] = new SqlParameter("@RECHARGE_GAS95_PRICE", SqlDbType.Int); sqlParameters[2].Value = Convert.ToInt32(dtoRecharge.RechargeGas95Price); sqlParameters[3] = new SqlParameter("@RECHARGE_GASDO_PRICE", SqlDbType.Int); sqlParameters[3].Value = Convert.ToInt32(dtoRecharge.RechargeGasDOPrice); sqlParameters[4] = new SqlParameter("@RECHARGE_MONEY", SqlDbType.Int); sqlParameters[4].Value = Convert.ToInt32(dtoRecharge.RechargeMoney); sqlParameters[5] = new SqlParameter("@RECHARGE_MONEY_EX", SqlDbType.Int); sqlParameters[5].Value = Convert.ToInt32(dtoRecharge.RechargeMoneyEx); sqlParameters[6] = new SqlParameter("@RECHARGE_NOTE", SqlDbType.NVarChar); sqlParameters[6].Value = Convert.ToString(dtoRecharge.RechargeNote); sqlParameters[7] = new SqlParameter("@RECHARGE_ID", SqlDbType.NVarChar); sqlParameters[7].Value = Convert.ToString(dtoRecharge.RechargeID); result = m_dbConnection.ExecuteUpdateQuery(query, sqlParameters); return(result); }
public DataTransfer UpdateCustomer(CustomerDTO dtoCustomer, string cusID) { DataTransfer dataResult = new DataTransfer(); bool updateResult = true; try { string query = string.Format("UPDATE CUSTOMER SET CUS_ID = @CUS_ID_NEW, CUS_NAME = @CUS_NAME, CUS_VISA = @CUS_VISA, CUS_BIRTHDATE = @CUS_BIRTHDATE, CUS_ADDRESS = @CUS_ADDRESS, CUS_PHONE = @CUS_PHONE, CUS_NOTE = @CUS_NOTE WHERE CUS_ID = @CUS_ID_OLD"); SqlParameter[] sqlParameters = new SqlParameter[8]; sqlParameters[0] = new SqlParameter("@CUS_ID_NEW", SqlDbType.NVarChar); sqlParameters[0].Value = Convert.ToString(dtoCustomer.CustomerID); sqlParameters[1] = new SqlParameter("@CUS_NAME", SqlDbType.NVarChar); sqlParameters[1].Value = Convert.ToString(dtoCustomer.CustomerName); sqlParameters[2] = new SqlParameter("@CUS_VISA", SqlDbType.NVarChar); sqlParameters[2].Value = Convert.ToString(dtoCustomer.CustomerVisa); sqlParameters[3] = new SqlParameter("@CUS_BIRTHDATE", SqlDbType.NVarChar); sqlParameters[3].Value = Convert.ToString(dtoCustomer.CustomerBirthDate); sqlParameters[4] = new SqlParameter("@CUS_ADDRESS", SqlDbType.NVarChar); sqlParameters[4].Value = Convert.ToString(dtoCustomer.CustomerAddress); sqlParameters[5] = new SqlParameter("@CUS_PHONE", SqlDbType.NVarChar); sqlParameters[5].Value = Convert.ToString(dtoCustomer.CustomerPhone); sqlParameters[6] = new SqlParameter("@CUS_NOTE", SqlDbType.NVarChar); sqlParameters[6].Value = Convert.ToString(dtoCustomer.CustomerNote); sqlParameters[7] = new SqlParameter("@CUS_ID_OLD", SqlDbType.NVarChar); sqlParameters[7].Value = Convert.ToString(cusID); updateResult = m_dbConnection.ExecuteUpdateQuery(query, sqlParameters); } catch (Exception ex) { updateResult = false; dataResult.ResponseErrorMsgDetail = ex.Message + " : " + ex.StackTrace; } if (updateResult) { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_SUCCESS; } else { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_FAIL; dataResult.ResponseErrorMsg = SGMText.CUSTOMER_UPDATE_CUS_ERR; } return(dataResult); }
public bool UpdateCard(CardDTO dtoCard) { bool result = true; string query = string.Format("UPDATE CARD SET CARD_STATE = @CARD_STATE, CARD_MONEY = @CARD_MONEY, CARD_MONEY_EX = @CARD_MONEY_EX, CARD_BUY_DATE = @CARD_BUY_DATE, RECHARGE_ID = @RECHARGE_ID WHERE CARD_ID = @CARD_ID"); SqlParameter[] sqlParameters = new SqlParameter[6]; sqlParameters[0] = new SqlParameter("@CARD_ID", SqlDbType.NVarChar); sqlParameters[0].Value = Convert.ToString(dtoCard.CardID); sqlParameters[1] = new SqlParameter("@CARD_STATE", SqlDbType.Bit); sqlParameters[1].Value = Convert.ToBoolean(dtoCard.CardUnlockState); sqlParameters[2] = new SqlParameter("@CARD_MONEY", SqlDbType.Int); sqlParameters[2].Value = Convert.ToInt32(dtoCard.CardRemainingMoney); sqlParameters[3] = new SqlParameter("@CARD_MONEY_EX", SqlDbType.Int); sqlParameters[3].Value = Convert.ToInt32(dtoCard.CardMoneyEx); sqlParameters[4] = new SqlParameter("@CARD_BUY_DATE", SqlDbType.Int); sqlParameters[4].Value = Convert.ToDateTime(dtoCard.CardBuyDate); sqlParameters[5] = new SqlParameter("@RECHARGE_ID", SqlDbType.Int); sqlParameters[5].Value = Convert.ToInt32(dtoCard.RechargeID); result = m_dbConnection.ExecuteUpdateQuery(query, sqlParameters); return(result); }
public DataTransfer ValidateGasStoreLogin(string stGasStoreID, string stGasStoreMacAddress) { DataTransfer dataResult = new DataTransfer(); try { string query = string.Format("SELECT ISNULL(GASSTORE_MACADDRESS,'NULL') AS RESULT, * FROM GAS_STORE WHERE (GASSTORE_MACADDRESS IS NULL OR GASSTORE_MACADDRESS = @GASSTORE_MACADDRESS) AND GASSTORE_ID = @GASSTORE_ID"); SqlParameter[] sqlParameters = new SqlParameter[2]; sqlParameters[0] = new SqlParameter("@GASSTORE_MACADDRESS", SqlDbType.NVarChar); sqlParameters[0].Value = Convert.ToString(stGasStoreMacAddress); sqlParameters[1] = new SqlParameter("@GASSTORE_ID", SqlDbType.NVarChar); sqlParameters[1].Value = Convert.ToString(stGasStoreID); DataTable tblResult = m_dbConnection.ExecuteSelectQuery(query, sqlParameters); if (tblResult.Rows.Count > 0) { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_SUCCESS; DataRow dr = tblResult.Rows[0]; GasStoreDTO dtoGasStore = new GasStoreDTO(); dtoGasStore.GasStoreID = dr["GASSTORE_ID"].ToString(); dtoGasStore.GasStoreName = dr["GASSTORE_NAME"].ToString(); dtoGasStore.GasStoreAddress = dr["GASSTORE_ADDRESS"].ToString(); dtoGasStore.GasStoreDescription = dr["GASSTORE_DESCRIPTION"].ToString(); dtoGasStore.GasStoreMacAddress = dr["GASSTORE_MACADDRESS"].ToString(); dtoGasStore.GasStoreGas92Total = float.Parse(dr["GASSTORE_GAS92_TOTAL"].ToString()); dtoGasStore.GasStoreGas95Total = float.Parse(dr["GASSTORE_GAS95_TOTAL"].ToString()); dtoGasStore.GasStoreGasDOTotal = float.Parse(dr["GASSTORE_GASDO_TOTAL"].ToString()); dataResult.ResponseDataGasStoreDTO = dtoGasStore; string result = dr["RESULT"].ToString(); if (result.Equals("NULL")) //insert mac address { SqlParameter[] sqlParametersUpdate = new SqlParameter[2]; sqlParametersUpdate[0] = new SqlParameter("@GASSTORE_MACADDRESS", SqlDbType.NVarChar); sqlParametersUpdate[0].Value = Convert.ToString(stGasStoreMacAddress); sqlParametersUpdate[1] = new SqlParameter("@GASSTORE_ID", SqlDbType.NVarChar); sqlParametersUpdate[1].Value = Convert.ToString(stGasStoreID); query = string.Format("UPDATE GAS_STORE SET GASSTORE_MACADDRESS = @GASSTORE_MACADDRESS WHERE GASSTORE_ID = @GASSTORE_ID"); if (!m_dbConnection.ExecuteUpdateQuery(query, sqlParametersUpdate)) { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_FAIL; dataResult.ResponseErrorMsg = SGMText.GAS_STATION_LOGON_UPDATE_MACADR_ERR; } } } else { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_FAIL; dataResult.ResponseErrorMsg = SGMText.GAS_STATION_LOGON_ID_INVALID; } } catch (Exception ex) { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_FAIL; dataResult.ResponseErrorMsg = SGMText.GAS_STATION_LOGON_ERR; dataResult.ResponseErrorMsgDetail = ex.Message + " : " + ex.StackTrace; } return(dataResult); }