private float m_fGasStoreGasDOTotal; //total gasDO in store 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 ValidateGasStationLogin(string stGasStationID, string stGasStationMacAddress) { DataTransfer dataResult = new DataTransfer(); try { string query = string.Format("SELECT ISNULL(GASSTATION_MACADDRESS,'NULL') AS RESULT, * FROM GAS_STATION WHERE (GASSTATION_MACADDRESS IS NULL OR GASSTATION_MACADDRESS = @GASSTATION_MACADDRESS) AND GASSTATION_ID = @GASSTATION_ID"); SqlParameter[] sqlParameters = new SqlParameter[2]; sqlParameters[0] = new SqlParameter("@GASSTATION_MACADDRESS", SqlDbType.NVarChar); sqlParameters[0].Value = Convert.ToString(stGasStationMacAddress); sqlParameters[1] = new SqlParameter("@GASSTATION_ID", SqlDbType.NVarChar); sqlParameters[1].Value = Convert.ToString(stGasStationID); DataTable tblResult = m_dbConnection.ExecuteSelectQuery(query, sqlParameters); if (tblResult.Rows.Count > 0) { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_SUCCESS; DataRow dr = tblResult.Rows[0]; GasStationDTO dtoGasStation = new GasStationDTO(); dtoGasStation.GasStationID = dr["GASSTATION_ID"].ToString(); dtoGasStation.GasStationName = dr["GASSTATION_NAME"].ToString(); dtoGasStation.GasStationAddress = dr["GASSTATION_ADDRESS"].ToString(); dtoGasStation.GasStationDescription = dr["GASSTATION_DESCRIPTION"].ToString(); dtoGasStation.GasStationMacAddress = dr["GASSTATION_MACADDRESS"].ToString(); dtoGasStation.GasStoreID = dr["GASSTORE_ID"].ToString(); dataResult.ResponseDataGasStationDTO = dtoGasStation; string result = dr["RESULT"].ToString(); if (result.Equals("NULL")) //insert mac address { SqlParameter[] sqlParametersUpdate = new SqlParameter[2]; sqlParametersUpdate[0] = new SqlParameter("@GASSTATION_MACADDRESS", SqlDbType.NVarChar); sqlParametersUpdate[0].Value = Convert.ToString(stGasStationMacAddress); sqlParametersUpdate[1] = new SqlParameter("@GASSTATION_ID", SqlDbType.NVarChar); sqlParametersUpdate[1].Value = Convert.ToString(stGasStationID); query = string.Format("UPDATE GAS_STATION SET GASSTATION_MACADDRESS = @GASSTATION_MACADDRESS WHERE GASSTATION_ID = @GASSTATION_ID"); if (!m_dbConnection.ExecuteUpdateQuery(query, sqlParametersUpdate)) { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_FAIL; dataResult.ResponseErrorMsg = SGMText.GAS_STATION_LOGON_UPDATE_MACADR_ERR; } } } else { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_FAIL; dataResult.ResponseErrorMsg = SGMText.GAS_STATION_LOGON_ID_INVALID; } } catch (Exception ex) { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_FAIL; dataResult.ResponseErrorMsg = SGMText.GAS_STATION_LOGON_ERR; dataResult.ResponseErrorMsgDetail = ex.Message + " : " + ex.StackTrace; } return(dataResult); }
private void btnEdit_Click(object sender, EventArgs e) { if (m_iCurrentGSIndex >= 0) { if (btnEdit.Text.Equals("&Sửa")) { m_stGSIDEdit = m_dsGasStation.Tables[0].Rows[m_iCurrentGSIndex]["GASSTATION_ID"].ToString(); btnEdit.Text = "&Lưu"; UpdateStateControls(true); btnReset.Enabled = true; txtGSCode.Focus(); } else { if (!ValidateDataInput()) { return; } GasStationDTO gas = new GasStationDTO(); gas.GasStationID = txtGSCode.Text.Trim(); gas.GasStationName = txtGSName.Text.Trim(); gas.GasStationAddress = txtGSAddress.Text.Trim(); gas.GasStationDescription = txtGSDes.Text.Trim(); gas.GasStationMacAddress = txtMacAddress.Text.Trim(); gas.GasStoreID = ((ComboboxItem)cboGasStore.SelectedItem).Value.ToString(); DataTransfer request = new DataTransfer(); request.ResponseDataGasStationDTO = gas; string jsRequest = JSonHelper.ConvertObjectToJSon(request); Task <String> task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask( () => { return(m_service.SGMManager_UpdateGasStation(jsRequest, m_stGSIDEdit)); }); 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) { frmMsg.ShowMsg(SGMText.SGM_ERROR, dataResponse.ResponseErrorMsg + "\n" + dataResponse.ResponseErrorMsgDetail, SGMMessageType.SGM_MESSAGE_TYPE_ERROR); return; } m_stGSIDEdit = ""; btnEdit.Text = "&Sửa"; btnReset.Enabled = false; LoadGasStationList(); SelectGSRow(gas.GasStationID); UpdateStateControls(false); }, SynchronizationContext.Current); } } }
public DataTransfer UpdateGasStation(GasStationDTO dtoGasStation, string stGasStationID) { DataTransfer dataResult = new DataTransfer(); bool updateResult = true; try { string query = string.Format("UPDATE GAS_STATION SET GASSTATION_ID = @GASSTATION_ID_NEW, GASSTATION_NAME = @GASSTATION_NAME, GASSTATION_ADDRESS = @GASSTATION_ADDRESS, GASSTATION_DESCRIPTION = @GASSTATION_DESCRIPTION, GASSTATION_MACADDRESS = @GASSTATION_MACADDRESS, GASSTORE_ID = @GASSTORE_ID WHERE GASSTATION_ID = @GASSTATION_ID_OLD"); SqlParameter[] sqlParameters = new SqlParameter[7]; sqlParameters[0] = new SqlParameter("@GASSTATION_ID_NEW", SqlDbType.NVarChar); sqlParameters[0].Value = Convert.ToString(dtoGasStation.GasStationID); sqlParameters[1] = new SqlParameter("@GASSTATION_NAME", SqlDbType.NVarChar); sqlParameters[1].Value = Convert.ToString(dtoGasStation.GasStationName); sqlParameters[2] = new SqlParameter("@GASSTATION_ADDRESS", SqlDbType.NVarChar); sqlParameters[2].Value = Convert.ToString(dtoGasStation.GasStationAddress); sqlParameters[3] = new SqlParameter("@GASSTATION_DESCRIPTION", SqlDbType.NVarChar); sqlParameters[3].Value = Convert.ToString(dtoGasStation.GasStationDescription); sqlParameters[4] = new SqlParameter("@GASSTATION_MACADDRESS", SqlDbType.NVarChar); if (dtoGasStation.GasStationMacAddress.Equals("")) { sqlParameters[4].Value = DBNull.Value; } else { sqlParameters[4].Value = Convert.ToString(dtoGasStation.GasStationMacAddress); } sqlParameters[5] = new SqlParameter("@GASSTORE_ID", SqlDbType.NVarChar); sqlParameters[5].Value = Convert.ToString(dtoGasStation.GasStoreID); sqlParameters[6] = new SqlParameter("@GASSTATION_ID_OLD", SqlDbType.NVarChar); sqlParameters[6].Value = Convert.ToString(stGasStationID); updateResult = m_dbConnection.ExecuteUpdateQuery(query, sqlParameters); } catch (Exception ex) { updateResult = false; dataResult.ResponseErrorMsgDetail = ex.Message + " : " + ex.StackTrace; } if (updateResult) { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_SUCCESS; } else { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_FAIL; dataResult.ResponseErrorMsg = SGMText.GASSTATION_UPDATE_ERR; } return(dataResult); }
public frmSGMSaleGas(SystemAdminDTO adminDTO, GasStationDTO gasStationDTO, int priceGas92, int priceGas95, int priceGasDO, float totalGas92, float totalGas95, float totalGasDO) { InitializeComponent(); _adminDTO = adminDTO; _gasStationDTO = gasStationDTO; m_iCurrentPriceGas92 = priceGas92; m_iCurrentPriceGas95 = priceGas95; m_iCurrentPriceGasDO = priceGasDO; m_iCurrentTotalGas92 = totalGas92; m_iCurrentTotalGas95 = totalGas95; m_iCurrentTotalGasDO = totalGasDO; m_jsHelper = new JSonHelper(); frmMsg = new frmSGMMessage(); frmCardInfo = new frmSGMCardDetail(_cardDTO, _rechargeDTO); lblCurrentPrice.Text = SGMText.SALEGAS_CURRENT_PRICE + SGMText.GAS_92_TEXT + " : " + m_iCurrentPriceGas92 + " , " + SGMText.GAS_95_TEXT + " : " + m_iCurrentPriceGas95 + " , " + SGMText.GAS_DO_TEXT + " : " + m_iCurrentPriceGasDO; }
public DataTransfer AddNewGasStation(GasStationDTO dtoGasStation) { DataTransfer dataResult = new DataTransfer(); bool insertResult = true; try { string query = string.Format("INSERT INTO GAS_STATION (GASSTATION_ID, GASSTATION_NAME, GASSTATION_ADDRESS, GASSTATION_DESCRIPTION, GASSTORE_ID) VALUES (@GASSTATION_ID, @GASSTATION_NAME, @GASSTATION_ADDRESS, @GASSTATION_DESCRIPTION, @GASSTORE_ID)"); SqlParameter[] sqlParameters = new SqlParameter[5]; sqlParameters[0] = new SqlParameter("@GASSTATION_ID", SqlDbType.NVarChar); sqlParameters[0].Value = Convert.ToString(dtoGasStation.GasStationID); sqlParameters[1] = new SqlParameter("@GASSTATION_NAME", SqlDbType.NVarChar); sqlParameters[1].Value = Convert.ToString(dtoGasStation.GasStationName); sqlParameters[2] = new SqlParameter("@GASSTATION_ADDRESS", SqlDbType.NVarChar); sqlParameters[2].Value = Convert.ToString(dtoGasStation.GasStationAddress); sqlParameters[3] = new SqlParameter("@GASSTATION_DESCRIPTION", SqlDbType.NVarChar); sqlParameters[3].Value = Convert.ToString(dtoGasStation.GasStationDescription); sqlParameters[4] = new SqlParameter("@GASSTORE_ID", SqlDbType.NVarChar); sqlParameters[4].Value = Convert.ToString(dtoGasStation.GasStoreID); 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.GASSTATION_ADD_NEW_GS_ERR; } return(dataResult); }
public DataTransfer GetGasStation(string stGasStationID) { DataTransfer dataResult = new DataTransfer(); try { GasStationDTO dtoGasStation = null; string query = string.Format("SELECT * FROM GAS_STATION WHERE GASSTATION_ID = @GASSTATION_ID"); SqlParameter[] sqlParameters = new SqlParameter[1]; sqlParameters[0] = new SqlParameter("@GASSTATION_ID", SqlDbType.NVarChar); sqlParameters[0].Value = Convert.ToString(stGasStationID); DataTable tblResult = m_dbConnection.ExecuteSelectQuery(query, sqlParameters); if (tblResult.Rows.Count > 0) { dtoGasStation = new GasStationDTO(); foreach (DataRow dr in tblResult.Rows) { dtoGasStation.GasStationID = dr["GASSTATION_ID"].ToString(); dtoGasStation.GasStationName = dr["GASSTATION_NAME"].ToString(); dtoGasStation.GasStationAddress = dr["GASSTATION_ADDRESS"].ToString(); dtoGasStation.GasStationDescription = dr["GASSTATION_DESCRIPTION"].ToString(); dtoGasStation.GasStationMacAddress = dr["GASSTATION_MACADDRESS"].ToString(); dtoGasStation.GasStoreID = dr["GASSTORE_ID"].ToString(); } } dataResult.ResponseDataGasStationDTO = dtoGasStation; } catch (Exception ex) { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_FAIL; dataResult.ResponseErrorMsg = SGMText.GASSTATION_GET_GS_ERR; dataResult.ResponseErrorMsgDetail = ex.Message + " : " + ex.StackTrace; } return(dataResult); }