public bool AddSystemAdmin(SystemAdminDTO dtoSysAdmin) { bool result = true; string query = string.Format("INSERT INTO SYSTEM_ADMIN (SYS_ADMIN, SYS_PWD, SYS_GAS92_CURRENT_PRICE, SYS_GAS95_CURRENT_PRICE, SYS_GASDO_CURRENT_PRICE, SYS_GAS92_NEW_PRICE, SYS_GAS95_NEW_PRICE, SYS_GASDO_NEW_PRICE, SYS_APPLY_DATE) " + " VALUES (@SYS_ADMIN, @SYS_PWD, @SYS_GAS92_TOTAL, @SYS_GAS95_TOTAL, @SYS_GASDO_TOTAL, @SYS_GAS92_CURRENT_PRICE, @SYS_GAS95_CURRENT_PRICE, @SYS_GASDO_CURRENT_PRICE, @SYS_GAS92_NEW_PRICE, @SYS_GAS95_NEW_PRICE, @SYS_GASDO_NEW_PRICE, @SYS_APPLY_DATE)"); 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.ExecuteInsertQuery(query, sqlParameters); return(result); }
public DataTransfer AddNewGasStore(GasStoreDTO dtoGasStore) { DataTransfer dataResult = new DataTransfer(); bool insertResult = true; try { string query = string.Format("INSERT INTO GAS_STORE (GASSTORE_ID, GASSTORE_NAME, GASSTORE_ADDRESS, GASSTORE_DESCRIPTION, GASSTORE_GAS92_TOTAL, GASSTORE_GAS95_TOTAL, GASSTORE_GASDO_TOTAL) VALUES (@GASSTORE_ID, @GASSTORE_NAME, @GASSTORE_ADDRESS, @GASSTORE_DESCRIPTION, @GASSTORE_GAS92_TOTAL, @GASSTORE_GAS95_TOTAL, @GASSTORE_GASDO_TOTAL)"); SqlParameter[] sqlParameters = new SqlParameter[7]; sqlParameters[0] = new SqlParameter("@GASSTORE_ID", SqlDbType.NVarChar); sqlParameters[0].Value = Convert.ToString(dtoGasStore.GasStoreID); sqlParameters[1] = new SqlParameter("@GASSTORE_NAME", SqlDbType.NVarChar); sqlParameters[1].Value = Convert.ToString(dtoGasStore.GasStoreName); sqlParameters[2] = new SqlParameter("@GASSTORE_ADDRESS", SqlDbType.NVarChar); sqlParameters[2].Value = Convert.ToString(dtoGasStore.GasStoreAddress); sqlParameters[3] = new SqlParameter("@GASSTORE_DESCRIPTION", SqlDbType.NVarChar); sqlParameters[3].Value = Convert.ToString(dtoGasStore.GasStoreDescription); sqlParameters[4] = new SqlParameter("@GASSTORE_GAS92_TOTAL", SqlDbType.Float); sqlParameters[4].Value = dtoGasStore.GasStoreGas92Total; sqlParameters[5] = new SqlParameter("@GASSTORE_GAS95_TOTAL", SqlDbType.Float); sqlParameters[5].Value = dtoGasStore.GasStoreGas95Total; sqlParameters[6] = new SqlParameter("@GASSTORE_GASDO_TOTAL", SqlDbType.Float); sqlParameters[6].Value = dtoGasStore.GasStoreGasDOTotal; insertResult = m_dbConnection.ExecuteInsertQuery(query, sqlParameters); } catch (Exception ex) { insertResult = false; dataResult.ResponseErrorMsgDetail = ex.Message + " : " + ex.StackTrace; } if (insertResult) { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_SUCCESS; } else { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_FAIL; dataResult.ResponseErrorMsg = SGMText.GASSTORE_ADD_NEW_GS_ERR; } return(dataResult); }
public DataTransfer AddSaleGas(SaleGasDTO dtoSaleGas) { bool result = true; DataTransfer dataResult = new DataTransfer(); try { string query = string.Format("INSERT INTO SALE_GAS (SALEGAS_TYPE, SALEGAS_CURRENT_PRICE, SALEGAS_CARD_PRICE, SALEGAS_CARD_MONEY_BEFORE, SALEGAS_CARD_MONEY_AFTER, SALEGAS_CARD_MONEY_SAVING, SALEGAS_LIT, SALEGAS_DATE, GASSTATION_ID, CARD_ID)" + " VALUES (@SALEGAS_TYPE, @SALEGAS_CURRENT_PRICE, @SALEGAS_CARD_PRICE, @SALEGAS_CARD_MONEY_BEFORE, @SALEGAS_CARD_MONEY_AFTER, @SALEGAS_CARD_MONEY_SAVING, @SALEGAS_LIT, @SALEGAS_DATE, @GASSTATION_ID, @CARD_ID)"); SqlParameter[] sqlParameters = new SqlParameter[10]; sqlParameters[0] = new SqlParameter("@SALEGAS_TYPE", SqlDbType.NVarChar); sqlParameters[0].Value = Convert.ToString(dtoSaleGas.SaleGasType); sqlParameters[1] = new SqlParameter("@SALEGAS_CURRENT_PRICE", SqlDbType.Int); sqlParameters[1].Value = Convert.ToInt32(dtoSaleGas.SaleGasCurrentPrice); sqlParameters[2] = new SqlParameter("@SALEGAS_CARD_PRICE", SqlDbType.Int); sqlParameters[2].Value = Convert.ToInt32(dtoSaleGas.SaleGasPriceOnCard); sqlParameters[3] = new SqlParameter("@SALEGAS_CARD_MONEY_BEFORE", SqlDbType.Int); sqlParameters[3].Value = Convert.ToInt32(dtoSaleGas.SaleGasCardMoneyBefore); sqlParameters[4] = new SqlParameter("@SALEGAS_CARD_MONEY_AFTER", SqlDbType.Int); sqlParameters[4].Value = Convert.ToInt32(dtoSaleGas.SaleGasCardMoneyAfter); sqlParameters[5] = new SqlParameter("@SALEGAS_LIT", SqlDbType.Float); sqlParameters[5].Value = Convert.ToDouble(dtoSaleGas.NumberBuyLit); sqlParameters[6] = new SqlParameter("@SALEGAS_DATE", SqlDbType.DateTime); sqlParameters[6].Value = (dtoSaleGas.SaleGasDate); sqlParameters[7] = new SqlParameter("@GASSTATION_ID", SqlDbType.NVarChar); sqlParameters[7].Value = Convert.ToString(dtoSaleGas.GasStationID); sqlParameters[8] = new SqlParameter("@CARD_ID", SqlDbType.NVarChar); sqlParameters[8].Value = Convert.ToString(dtoSaleGas.CardID); sqlParameters[9] = new SqlParameter("@SALEGAS_CARD_MONEY_SAVING", SqlDbType.Int); sqlParameters[9].Value = Convert.ToInt32(dtoSaleGas.SaleGasCardMoneySaving); result = m_dbConnection.ExecuteInsertQuery(query, sqlParameters); } catch (Exception ex) { result = false; dataResult.ResponseErrorMsgDetail = ex.Message + " : " + ex.StackTrace; } if (result) { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_SUCCESS; } else { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_FAIL; dataResult.ResponseErrorMsg = 1 + SGMText.CARD_INSERT_ERR; } return(dataResult); }
public DataTransfer AddRecharge(RechargeDTO dtoRecharge) { DataTransfer dataResult = new DataTransfer(); bool insertResult = true; try { string query = string.Format("INSERT INTO RECHARGE (RECHARGE_DATE, RECHARGE_GAS92_PRICE, RECHARGE_GAS95_PRICE, RECHARGE_GASDO_PRICE, RECHARGE_MONEY, RECHARGE_MONEY_EX, RECHARGE_NOTE, CARD_ID)" + " VALUES (@RECHARGE_DATE, @RECHARGE_GAS92_PRICE, @RECHARGE_GAS95_PRICE, @RECHARGE_GASDO_PRICE, @RECHARGE_MONEY, @RECHARGE_MONEY_EX, @RECHARGE_NOTE, @CARD_ID)"); SqlParameter[] sqlParameters = new SqlParameter[8]; 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("@CARD_ID", SqlDbType.NVarChar); sqlParameters[7].Value = Convert.ToString(dtoRecharge.CardID); insertResult = m_dbConnection.ExecuteInsertQuery(query, sqlParameters); } catch (Exception ex) { insertResult = false; dataResult.ResponseErrorMsgDetail = ex.Message + " : " + ex.StackTrace; } if (insertResult) { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_SUCCESS; } else { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_FAIL; dataResult.ResponseErrorMsg = SGMText.CARD_RECHARGE_INSERT_ERR; } return(dataResult); }
public DataTransfer AddNewCustomer(CustomerDTO dtoCustomer) { DataTransfer dataResult = new DataTransfer(); bool insertResult = true; try { string query = string.Format("INSERT INTO CUSTOMER (CUS_ID, CUS_NAME, CUS_VISA, CUS_BIRTHDATE, CUS_ADDRESS, CUS_PHONE, CUS_NOTE) VALUES (@CUS_ID, @CUS_NAME, @CUS_VISA, @CUS_BIRTHDATE, @CUS_ADDRESS, @CUS_PHONE, @CUS_NOTE)"); SqlParameter[] sqlParameters = new SqlParameter[7]; sqlParameters[0] = new SqlParameter("@CUS_ID", 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); insertResult = m_dbConnection.ExecuteInsertQuery(query, sqlParameters); } catch (Exception ex) { insertResult = false; dataResult.ResponseErrorMsgDetail = ex.Message + " : " + ex.StackTrace; } if (insertResult) { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_SUCCESS; } else { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_FAIL; dataResult.ResponseErrorMsg = SGMText.CUSTOMER_ADD_NEW_CUS_ERR; } return(dataResult); }
public DataTransfer AddNewCard(CardDTO dtoCard) { DataTransfer dataResult = new DataTransfer(); bool insertResult = true; try { string query = string.Format("INSERT INTO CARD (CARD_ID, CARD_STATE, CARD_MONEY, CARD_MONEY_EX, CARD_BUY_DATE, RECHARGE_ID, CUS_ID) VALUES (@CARD_ID, @CARD_STATE, @CARD_MONEY, @CARD_MONEY_EX, @CARD_BUY_DATE, @RECHARGE_ID, @CUS_ID)"); SqlParameter[] sqlParameters = new SqlParameter[7]; 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.DateTime); sqlParameters[4].Value = Convert.ToDateTime(dtoCard.CardBuyDate); sqlParameters[5] = new SqlParameter("@RECHARGE_ID", SqlDbType.Int); sqlParameters[5].Value = Convert.ToInt32(dtoCard.RechargeID); sqlParameters[6] = new SqlParameter("@CUS_ID", SqlDbType.NVarChar); sqlParameters[6].Value = Convert.ToString(dtoCard.CustomerID); insertResult = m_dbConnection.ExecuteInsertQuery(query, sqlParameters); } catch (Exception ex) { insertResult = false; dataResult.ResponseErrorMsgDetail = ex.Message + " : " + ex.StackTrace; } if (insertResult) { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_SUCCESS; } else { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_FAIL; dataResult.ResponseErrorMsg = SGMText.CARD_INSERT_ERR; } return(dataResult); }