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 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 RechargeDTO GetRecharge(int iRechargeID)
{
RechargeDTO dtoRecharge = null;
string query = string.Format("SELECT * FROM RECHARGE WHERE RECHARGE_ID = @RECHARGE_ID");
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@RECHARGE_ID", SqlDbType.Int);
sqlParameters[0].Value = Convert.ToInt32(iRechargeID);
DataTable tblResult = m_dbConnection.ExecuteSelectQuery(query, sqlParameters);
if (tblResult.Rows.Count > 0)
{
dtoRecharge = new RechargeDTO();
foreach (DataRow dr in tblResult.Rows)
{
dtoRecharge.RechargeID = Int32.Parse(dr["RECHARGE_ID"].ToString());
dtoRecharge.RechargeDate = DateTime.Parse(dr["RECHARGE_DATE"].ToString());
dtoRecharge.RechargeGas92Price = Int32.Parse(dr["RECHARGE_GAS92_PRICE"].ToString());
dtoRecharge.RechargeGas95Price = Int32.Parse(dr["RECHARGE_GAS95_PRICE"].ToString());
dtoRecharge.RechargeGasDOPrice = Int32.Parse(dr["RECHARGE_GASDO_PRICE"].ToString());
dtoRecharge.RechargeMoney = Int32.Parse(dr["RECHARGE_MONEY"].ToString());
dtoRecharge.RechargeMoneyEx = Int32.Parse(dr["RECHARGE_MONEY_EX"].ToString());
dtoRecharge.RechargeNote = dr["RECHARGE_NOTE"].ToString();
dtoRecharge.CardID = dr["CARD_ID"].ToString();
}
}
return dtoRecharge;
}
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;
}
private void ScanCard(string cardId)
{
Task<String> task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() => {
return service.SGMSaleGas_ValidateCardId(cardId);
});
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)
{
EnableTransaction(true, true);
using (DataSet ds = dataResponse.ResponseDataSet)
{
DataTable tblCard = ds.Tables[0];
if (tblCard.Rows.Count == 1)
{
clearForm();
_cardDTO = new CardDTO();
_rechargeDTO = new RechargeDTO();
foreach (DataRow dr in tblCard.Rows)
{
_cardDTO.CardID = dr["CARD_ID"].ToString(); ;
_cardDTO.CardUnlockState = Boolean.Parse(dr["CARD_STATE"].ToString());
_cardDTO.CardRemainingMoney = Int32.Parse(dr["CARD_MONEY"].ToString());
_cardDTO.CardBuyDate = DateTime.Parse(dr["CARD_BUY_DATE"].ToString());
_cardDTO.RechargeID = Int32.Parse(dr["RECHARGE_ID"].ToString());
_cardDTO.CardMoneyEx = Int32.Parse(dr["CARD_MONEY_EX"].ToString());
_cardDTO.CustomerID = dr["CUS_ID"].ToString();
_rechargeDTO.RechargeID = Int32.Parse(dr["RECHARGE_ID"].ToString());
_rechargeDTO.RechargeDate = DateTime.Parse(dr["RECHARGE_DATE"].ToString());
_rechargeDTO.RechargeGas92Price = Int32.Parse(dr["RECHARGE_GAS92_PRICE"].ToString());
_rechargeDTO.RechargeGas95Price = Int32.Parse(dr["RECHARGE_GAS95_PRICE"].ToString());
_rechargeDTO.RechargeGasDOPrice = Int32.Parse(dr["RECHARGE_GASDO_PRICE"].ToString());
_rechargeDTO.RechargeMoney = Int32.Parse(dr["RECHARGE_MONEY"].ToString());
_rechargeDTO.RechargeNote = dr["RECHARGE_MONEY"].ToString();
_rechargeDTO.CardID = dr["CARD_ID"].ToString();
txtCardName.Text = dr["CUS_NAME"].ToString();
}
//txtCardID.Text = _cardDTO.CardID;
txtCardMoney.Text = _cardDTO.CardRemainingMoney.ToString(MONEY_FORMAT);
// get name customer
updateGasChoice(rbGas92.Checked ? gasTransactType.gas92 : rbGas95.Checked ? gasTransactType.gas95 : gasTransactType.gasDO);
if (_cardDTO.CardUnlockState == false)
{
frmMsg.ShowMsg(SGMText.SGM_INFO, SGMText.GAS_CARD_LOCK, SGMMessageType.SGM_MESSAGE_TYPE_INFO);
//_cardDTO = null;
//_rechargeDTO = null;
EnableTransaction(false, true);
}
grBill.Text = SGMText.SALEGAS_MAIN_BILL;
btnCardDetail.Enabled = true;
m_bBuy = false;
txtMoney.Focus();
m_iTimeOutReset = 0;
}
else
{
// >>>
}
}
}
else
{
resetForm();
frmMsg.ShowMsg(SGMText.SGM_ERROR, dataResponse.ResponseErrorMsg, SGMMessageType.SGM_MESSAGE_TYPE_ERROR);
EnableTransaction(false, true);
}
}, SynchronizationContext.Current);
}
private void resetForm()
{
_cardDTO = null;
_rechargeDTO = null;
txtCardID.Text = "";
txtCardName.Text = "";
txtCardMoney.Text = 0.ToString(MONEY_FORMAT);
rbGas92.Checked = true;
txtMoney.Text = 0.ToString(MONEY_FORMAT);
grBill.Text = SGMText.SALEGAS_MAIN_BILL;
txtGasBuying.Text = 0.ToString(MONEY_FORMAT);
txtGasType.Text = "";
txtPrice.Text = 0.ToString(MONEY_FORMAT);
txtMoneyBefore.Text = 0.ToString(MONEY_FORMAT);
txtMoneyBuying.Text = 0.ToString(MONEY_FORMAT);
txtMoneyAfter.Text = 0.ToString(MONEY_FORMAT);
txtMoneySaving.Text = 0.ToString(MONEY_FORMAT);
}
private void frmSGMSaleGas_Load(object sender, EventArgs e)
{
SGM_WaitingIdicator.WaitingForm.waitingFrm.SetParentForm(this);
serailReaderHandler = new SerialDataReceivedEventHandler(CardReaderReceivedHandler);
RFIDReader.RegistryReaderListener(Program.ReaderPort, serailReaderHandler);
_cardDTO = null;
_rechargeDTO = null;
txtMoney.Text = _moneyBuying.ToString(MONEY_FORMAT);
lblTitle.Text = _gasStationDTO.GasStationName;
resetForm();
lblCurrentPrice.Text = SGMText.SALEGAS_CURRENT_PRICE + SGMText.GAS_92_TEXT + " : " + m_iCurrentPriceGas92 + " - " + SGMText.GAS_95_TEXT + " : " + m_iCurrentPriceGas95 + " - " + SGMText.GAS_DO_TEXT + " : " + m_iCurrentPriceGasDO;
EnableTransaction(false, true);
}
public frmSGMCardDetail(CardDTO cardDTO, RechargeDTO rechargeDTO)
{
InitializeComponent();
m_dtoCard = cardDTO;
m_dtoRecharge = rechargeDTO;
}
private void btnUpdateCard_Click(object sender, EventArgs e)
{
if (ValidateDataInput())
{
DataTransfer response = null;
DataTransfer request = new DataTransfer();
Task<String> task;
if (m_bRecharge)
{
RechargeDTO dtoRecharge = new RechargeDTO();
dtoRecharge.RechargeDate = dtpRechargeDate.Value;
dtoRecharge.RechargeGas92Price = m_iPriceGas92;
dtoRecharge.RechargeGas95Price = m_iPriceGas95;
dtoRecharge.RechargeGasDOPrice = m_iPriceGasDO;
dtoRecharge.RechargeMoney = Int32.Parse(txtCardMoney.Text.Trim());
dtoRecharge.RechargeMoneyEx = Int32.Parse(txtExMoney.Text.Trim());
dtoRecharge.RechargeNote = txtRechargeNote.Text.Trim();
dtoRecharge.CardID = txtCardID.Text.Trim();
request.ResponseDataRechargeDTO = dtoRecharge;
task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() =>
{
return m_service.SGMManager_AddRechargeCard(JSonHelper.ConvertObjectToJSon(request));
});
SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task, () =>
{
String stResponse = task.Result as String;
response = JSonHelper.ConvertJSonToObject(stResponse);
if (response.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS)
{
task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() =>
{
return m_service.SGMManager_UpdateRechargeIDForCard(txtCardID.Text.Trim());
});
SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task, () =>
{
stResponse = task.Result as String;
response = JSonHelper.ConvertJSonToObject(stResponse);
if (response.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS)
{
task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() =>
{
return m_service.SGMManager_UpdateMoneyForCard(txtCardID.Text.Trim(), m_iCurrentCardMoney + Int32.Parse(txtCardMoney.Text.Trim()) + Int32.Parse(txtExMoney.Text.Trim()));
});
SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task, () =>
{
stResponse = task.Result as String;
response = JSonHelper.ConvertJSonToObject(stResponse);
if (response.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS)
{
this.Close();
}
}, SynchronizationContext.Current);
}
}, SynchronizationContext.Current);
}
}, SynchronizationContext.Current);
}
else
{
CardDTO dtoCard = new CardDTO();
dtoCard.CardID = txtCardID.Text.Trim();
dtoCard.CardUnlockState = true;
dtoCard.CardRemainingMoney = Int32.Parse(txtCardMoney.Text.Trim());
dtoCard.CardMoneyEx = 0;
dtoCard.CardBuyDate = dtpRechargeDate.Value;
dtoCard.RechargeID = -1;
dtoCard.CustomerID = m_stCusID;
request.ResponseDataCardDTO = dtoCard;
task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() =>
{
return m_service.SGMManager_AddNewCard(JSonHelper.ConvertObjectToJSon(request));
});
SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task, () =>
{
String stResponse = task.Result as String;
response = JSonHelper.ConvertJSonToObject(stResponse);
if (response.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS)
{
RechargeDTO dtoRecharge = new RechargeDTO();
dtoRecharge.RechargeDate = dtpRechargeDate.Value;
dtoRecharge.RechargeGas92Price = m_iPriceGas92;
dtoRecharge.RechargeGas95Price = m_iPriceGas95;
dtoRecharge.RechargeGasDOPrice = m_iPriceGasDO;
dtoRecharge.RechargeMoney = Int32.Parse(txtCardMoney.Text.Trim());
dtoRecharge.RechargeNote = txtRechargeNote.Text.Trim();
dtoRecharge.CardID = txtCardID.Text.Trim();
request.ResponseDataRechargeDTO = dtoRecharge;
task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() =>
{
if (m_bChangeCard)
return m_service.SGMManager_ChangeCard(m_stCardID, JSonHelper.ConvertObjectToJSon(request));
else
return m_service.SGMManager_AddRechargeCard(JSonHelper.ConvertObjectToJSon(request));
});
SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task, () =>
{
stResponse = task.Result as String;
response = JSonHelper.ConvertJSonToObject(stResponse);
if (response.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS)
{
task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask(
() =>
{
return m_service.SGMManager_UpdateRechargeIDForCard(txtCardID.Text.Trim());
});
SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task, () =>
{
stResponse = task.Result as String;
response = JSonHelper.ConvertJSonToObject(stResponse);
if (response.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS)
{
this.Close();
}
else
{
frmMsg.ShowMsg(SGMText.SGM_ERROR, response.ResponseErrorMsg + " : " + response.ResponseErrorMsgDetail, SGMMessageType.SGM_MESSAGE_TYPE_ERROR);
}
}, SynchronizationContext.Current);
}
}, SynchronizationContext.Current);
}
}, SynchronizationContext.Current);
}
}
}
