Exemple #1
0
        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;
        }
Exemple #2
0
 public frmSGMRechargeCard()
 {
     InitializeComponent();
     m_bRecharge = false;
     m_bChangeCard = false;
     m_stCusID = "";
     m_stCardID = "";
     m_cardDTO = null;
     m_iPriceGas95 = 0;
     m_iPriceGas92 = 0;
     m_iPriceGasDO = 0;
     m_service = new SGM_Service.ServiceSoapClient();
     frmMsg = new frmSGMMessage();
     serialDatahandler = new SerialDataReceivedEventHandler(CardReaderReceivedHandler);
     RFIDReader.RegistryReaderListener(Program.ReaderPort, serialDatahandler);
 }
Exemple #3
0
        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;
        }
Exemple #4
0
        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);
        }
Exemple #5
0
 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);
 }
Exemple #6
0
        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);
        }
Exemple #7
0
 public frmSGMCardDetail(CardDTO cardDTO, RechargeDTO rechargeDTO)
 {
     InitializeComponent();
     m_dtoCard = cardDTO;
     m_dtoRecharge = rechargeDTO;
 }
Exemple #8
0
        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);
                }
            }
        }
Exemple #9
0
 private DataTransfer GasBuyingUpdateCard(string strCardId, int money, int moneyEx)
 {
     CardDAL dalCard = new CardDAL();
     CardDTO dtoCard = new CardDTO();
     dtoCard.CardID = strCardId;
     dtoCard.CardRemainingMoney = money;
     dtoCard.CardMoneyEx = moneyEx;
     return dalCard.UpdateSaleGas(dtoCard);
 }
Exemple #10
0
 public CardDTO GetCard(string stCardID)
 {
     CardDTO dtoCard = null;
     string query = string.Format("SELECT * FROM CARD WHERE CARD_ID = @CARD_ID");
     SqlParameter[] sqlParameters = new SqlParameter[1];
     sqlParameters[0] = new SqlParameter("@CARD_ID", SqlDbType.NVarChar);
     sqlParameters[0].Value = Convert.ToString(stCardID);
     DataTable tblResult = m_dbConnection.ExecuteSelectQuery(query, sqlParameters);
     if (tblResult.Rows.Count > 0)
     {
         dtoCard = new CardDTO();
         foreach (DataRow dr in tblResult.Rows)
         {
             dtoCard.CardID = dr["CARD_ID"].ToString(); ;
             dtoCard.CardUnlockState = Boolean.Parse(dr["CARD_STATE"].ToString());
             dtoCard.CardRemainingMoney = Int32.Parse(dr["CARD_MONEY"].ToString());
             dtoCard.CardMoneyEx = Int32.Parse(dr["CARD_MONEY_EX"].ToString());
             dtoCard.CardBuyDate = DateTime.Parse(dr["CARD_BUY_DATE"].ToString());
             dtoCard.RechargeID = Int32.Parse(dr["RECHARGE_ID"].ToString());
             dtoCard.CustomerID = dr["CUS_ID"].ToString();
         }
     }
     return dtoCard;
 }
Exemple #11
0
        public DataTransfer UpdateSaleGas(CardDTO dtoCard)
        {
            DataTransfer dataResult = new DataTransfer();
            bool result = true;
            try
            {
                string query = string.Format("UPDATE CARD SET CARD_MONEY = @CARD_MONEY, CARD_MONEY_EX = CARD_MONEY_EX + @CARD_MONEY_EX WHERE CARD_ID = @CARD_ID");
                SqlParameter[] sqlParameters = new SqlParameter[3];
                sqlParameters[0] = new SqlParameter("@CARD_ID", SqlDbType.NVarChar);
                sqlParameters[0].Value = Convert.ToString(dtoCard.CardID);
                sqlParameters[1] = new SqlParameter("@CARD_MONEY", SqlDbType.Int);
                sqlParameters[1].Value = Convert.ToInt32(dtoCard.CardRemainingMoney);
                sqlParameters[2] = new SqlParameter("@CARD_MONEY_EX", SqlDbType.Int);
                sqlParameters[2].Value = Convert.ToInt32(dtoCard.CardMoneyEx);
                result = m_dbConnection.ExecuteUpdateQuery(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 = 2 + SGMText.CARD_INSERT_ERR;
            }

            return dataResult;
        }
Exemple #12
0
 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;
 }