public DataTransfer()
{
m_iResponseCode = RESPONSE_CODE_NONE;
m_stResponseErrorMsg = "";
m_stResponseErrorMsgDetail = "";
m_stResponseDataString = "";
m_bResponseDataBool = false;
m_dtoResponseDataCustomerDTO = null;
m_dtoResponseDataCardDTO = null;
m_dtoResponseDataGasStationDTO = null;
m_dtoResponseDataRechargeDTO = null;
m_dtoResponseDataSaleGasDTO = null;
m_dtoResponseDataSystemAdminDTO = null;
m_dtoResponseDataGasStoreDTO = null;
m_dtoResponseDataGasStoreUpdateDTO = null;
m_dsResponseDataSet = null;
m_iCurrentPriceGas92 = 0;
m_iCurrentPriceGas95 = 0;
m_iCurrentPriceGasDO = 0;
m_fGasStoreGas92Total = 0;
m_fGasStoreGas95Total = 0;
m_fGasStoreGasDOTotal = 0;
}
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 SaleGasDTO GetSaleGas(int iSaleGasID)
{
SaleGasDTO dtoSaleGas = null;
string query = string.Format("SELECT * FROM SALE_GAS WHERE SALEGAS_ID = @SALEGAS_ID");
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@SALEGAS_ID", SqlDbType.Int);
sqlParameters[0].Value = iSaleGasID;
DataTable tblResult = m_dbConnection.ExecuteSelectQuery(query, sqlParameters);
if (tblResult.Rows.Count > 0)
{
dtoSaleGas = new SaleGasDTO();
foreach (DataRow dr in tblResult.Rows)
{
dtoSaleGas.SaleGasID = Int32.Parse(dr["SALEGAS_ID"].ToString());
dtoSaleGas.SaleGasType = dr["SALEGAS_TYPE"].ToString();
dtoSaleGas.SaleGasCurrentPrice = Int32.Parse(dr["SALEGAS_CURRENT_PRICE"].ToString());
dtoSaleGas.SaleGasPriceOnCard = Int32.Parse(dr["SALEGAS_CARD_PRICE"].ToString());
dtoSaleGas.SaleGasCardMoneyBefore = Int32.Parse(dr["SALEGAS_CARD_MONEY_BEFORE"].ToString());
dtoSaleGas.SaleGasCardMoneyAfter = Int32.Parse(dr["SALEGAS_CARD_MONEY_AFTER"].ToString());
dtoSaleGas.GasStationID = dr["GASSTATION_ID"].ToString();
dtoSaleGas.SaleGasDate = DateTime.Parse(dr["SALEGAS_DATE"].ToString());
dtoSaleGas.CardID = dr["CARD_ID"].ToString();
dtoSaleGas.NumberBuyLit = float.Parse(dr["SALEGAS_LIT"].ToString());
}
}
return dtoSaleGas;
}
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;
}
private void btnBuy_Click(object sender, EventArgs e)
{
m_iTimeOutReset = 0;
if (txtMoney.Text == "0")
{
SGMHelper.ShowToolTip(txtMoney, SGMText.GAS_BUYING_INPUT_MONEY_INVALID);
return;
}
SaleGasDTO dto = new SaleGasDTO();
dto.CardID = _cardDTO.CardID;
dto.GasStationID = _gasStationDTO.GasStationID;
dto.SaleGasType = rbGas92.Checked ? SaleGasDTO.GAS_TYPE_92 : rbGas95.Checked ? SaleGasDTO.GAS_TYPE_95 : SaleGasDTO.GAS_TYPE_DO;
dto.SaleGasPriceOnCard = Int32.Parse(txtPrice.Text, System.Globalization.NumberStyles.Currency);
dto.SaleGasCardMoneyBefore = Int32.Parse(txtMoneyBefore.Text, System.Globalization.NumberStyles.Currency);
dto.SaleGasCardMoneyAfter = Int32.Parse(txtMoneyAfter.Text, System.Globalization.NumberStyles.Currency);
dto.SaleGasCardMoneySaving = Int32.Parse(txtMoneySaving.Text, System.Globalization.NumberStyles.Currency);
dto.SaleGasCurrentPrice = m_iCurrentPrice;
dto.NumberBuyLit = float.Parse(txtGasBuying.Text, System.Globalization.NumberStyles.Currency);
dto.GasStoreID = _gasStationDTO.GasStoreID;
DataTransfer df = new DataTransfer();
df.ResponseDataSaleGasDTO = dto;
Task<String> task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() =>
{
return service.SGMSaleGas_GasBuying(JSonHelper.ConvertObjectToJSon(df));
});
SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task, () =>
{
String stResponse = task.Result as String;
DataTransfer dataResponse = JSonHelper.ConvertJSonToObject(stResponse);
if (dataResponse.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS)
{
m_bBuy = true;
//frmMsg.ShowMsg(SGMText.SGM_INFO, SGMText.GAS_BUYING_SUCCESS, SGMMessageType.SGM_MESSAGE_TYPE_INFO);
// _cardDTO.CardRemainingMoney = _cardDTO.CardRemainingMoney - _moneyBuying;
// txtCardMoney.Text = _cardDTO.CardRemainingMoney.ToString(MONEY_FORMAT);
// calculatePay();
EnableTransaction(false, false);
grBill.Text = SGMText.SALEGAS_MAIN_BILL + txtCardName.Text;
txtCardID.Text = "";
txtCardMoney.Text = "";
txtMoney.Text = "0";
txtCardName.Text = "";
//rbGas92.Enabled = false;
//rbGas95.Enabled = false;
//rbGasDO.Enabled = false;
}
else
{
frmMsg.ShowMsg(SGMText.SGM_ERROR, dataResponse.ResponseErrorMsg + "\n" + dataResponse.ResponseErrorMsgDetail, SGMMessageType.SGM_MESSAGE_TYPE_ERROR);
}
}, SynchronizationContext.Current);
}
private DataTransfer GasBuyingAddSaleGas(SaleGasDTO saleGasDTO)
{
SaleGasDAL dal = new SaleGasDAL();
return dal.AddSaleGas(saleGasDTO);
}
private DataTransfer GasBuyingUpdateGasStore(SaleGasDTO saleGasDTO)
{
GasStoreDAL dal = new GasStoreDAL();
float money = saleGasDTO.SaleGasCardMoneyBefore - saleGasDTO.SaleGasCardMoneyAfter;
float amount = money / saleGasDTO.SaleGasCurrentPrice;
DataTransfer res = dal.UpdateGasStoreTotal(saleGasDTO.GasStoreID, saleGasDTO.SaleGasType, amount);
return res;
}
