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