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 AddNewGasStoreUpdate(GasStoreUpdateDTO dtoGasStoreUpdate) { DataTransfer dataResult = new DataTransfer(); bool insertResult = true; try { string query = string.Format("INSERT INTO GAS_STORE_UPDATE (GS_GAS92_TOTAL, GS_GAS95_TOTAL, GS_GASDO_TOTAL, GS_GAS92_ADD, GS_GAS95_ADD, GS_GASDO_ADD, GS_UPDATE_DATE, GS_DESCRIPTION, GASSTORE_ID) VALUES (@GS_GAS92_TOTAL, @GS_GAS95_TOTAL, @GS_GASDO_TOTAL, @GS_GAS92_ADD, @GS_GAS95_ADD, @GS_GASDO_ADD, @GS_UPDATE_DATE, @GS_DESCRIPTION, @GASSTORE_ID)"); SqlParameter[] sqlParameters = new SqlParameter[9]; sqlParameters[0] = new SqlParameter("@GS_GAS92_TOTAL", SqlDbType.Float); sqlParameters[0].Value = dtoGasStoreUpdate.GSUpdateGas92Total; sqlParameters[1] = new SqlParameter("@GS_GAS95_TOTAL", SqlDbType.Float); sqlParameters[1].Value = dtoGasStoreUpdate.GSUpdateGas95Total; sqlParameters[2] = new SqlParameter("@GS_GASDO_TOTAL", SqlDbType.Float); sqlParameters[2].Value = dtoGasStoreUpdate.GSUpdateGasDOTotal; sqlParameters[3] = new SqlParameter("@GS_GAS92_ADD", SqlDbType.NVarChar); sqlParameters[3].Value = dtoGasStoreUpdate.GSUpdateGas92Add; sqlParameters[4] = new SqlParameter("@GS_GAS95_ADD", SqlDbType.Float); sqlParameters[4].Value = dtoGasStoreUpdate.GSUpdateGas95Add; sqlParameters[5] = new SqlParameter("@GS_GASDO_ADD", SqlDbType.Float); sqlParameters[5].Value = dtoGasStoreUpdate.GSUpdateGasDOAdd; sqlParameters[6] = new SqlParameter("@GS_UPDATE_DATE", SqlDbType.DateTime); sqlParameters[6].Value = Convert.ToDateTime(dtoGasStoreUpdate.GSUpdateDate); sqlParameters[7] = new SqlParameter("@GS_DESCRIPTION", SqlDbType.NVarChar); sqlParameters[7].Value = Convert.ToString(dtoGasStoreUpdate.GSUpdateDescription); sqlParameters[8] = new SqlParameter("@GASSTORE_ID", SqlDbType.NVarChar); sqlParameters[8].Value = Convert.ToString(dtoGasStoreUpdate.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.GASSTORE_ADD_NEW_GSUPDATE_ERR; } return(dataResult); }
public DataTransfer GetGasStoreUpdateHistory(string stGasStoreID) { DataTransfer dataResult = new DataTransfer(); try { GasStoreUpdateDTO dtoGasStoreUpdate = null; string query = string.Format("SELECT * FROM GAS_STORE_UPDATE WHERE GASSTORE_ID = @GASSTORE_ID"); SqlParameter[] sqlParameters = new SqlParameter[1]; sqlParameters[0] = new SqlParameter("@GASSTORE_ID", SqlDbType.NVarChar); sqlParameters[0].Value = Convert.ToString(stGasStoreID); DataTable tblResult = m_dbConnection.ExecuteSelectQuery(query, sqlParameters); if (tblResult.Rows.Count > 0) { dtoGasStoreUpdate = new GasStoreUpdateDTO(); foreach (DataRow dr in tblResult.Rows) { dtoGasStoreUpdate.GasStoreID = dr["GASSTORE_ID"].ToString(); dtoGasStoreUpdate.GSUpdateGas92Total = float.Parse(dr["GS_GAS92_TOTAL"].ToString()); dtoGasStoreUpdate.GSUpdateGas95Total = float.Parse(dr["GS_GAS95_TOTAL"].ToString()); dtoGasStoreUpdate.GSUpdateGasDOTotal = float.Parse(dr["GS_GASDO_TOTAL"].ToString()); dtoGasStoreUpdate.GSUpdateGas92Add = float.Parse(dr["GS_GAS92_ADD"].ToString()); dtoGasStoreUpdate.GSUpdateGas95Add = float.Parse(dr["GS_GAS95_ADD"].ToString()); dtoGasStoreUpdate.GSUpdateGasDOAdd = float.Parse(dr["GS_GASDO_ADD"].ToString()); dtoGasStoreUpdate.GSUpdateDate = DateTime.Parse(dr["GS_UPDATE_DATE"].ToString()); dtoGasStoreUpdate.GSUpdateDescription = dr["GS_DESCRIPTION"].ToString(); } } dataResult.ResponseDataGasStoreUpdateDTO = dtoGasStoreUpdate; } catch (Exception ex) { dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_FAIL; dataResult.ResponseErrorMsg = SGMText.GASSTORE_GET_GSUPDATE_ERR; dataResult.ResponseErrorMsgDetail = ex.Message + " : " + ex.StackTrace; } return(dataResult); }
private void btnUpdate_Click(object sender, EventArgs e) { if (_storeDTO == null) { //frmMsg.ShowMsg(SGMText.SGM_ERROR, "DTO NULL", SGMMessageType.SGM_MESSAGE_TYPE_ERROR); return; } if (!ValidateDataInput()) { return; } float gas92Add = float.Parse(txtGas92New.Text); float gas95Add = float.Parse(txtGas95New.Text); float gasDOAdd = float.Parse(txtGasDONew.Text); DataTransfer request = new DataTransfer(); GasStoreDTO cloneStoreDTO = new GasStoreDTO(_storeDTO); cloneStoreDTO.GasStoreGas92Total = _storeDTO.GasStoreGas92Total + gas92Add; cloneStoreDTO.GasStoreGas95Total = _storeDTO.GasStoreGas95Total + gas95Add; cloneStoreDTO.GasStoreGasDOTotal = _storeDTO.GasStoreGasDOTotal + gasDOAdd; request.ResponseDataGasStoreDTO = cloneStoreDTO; string jsRequest = JSonHelper.ConvertObjectToJSon(request); Task <String> task = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask( () => { return(m_service.SGMManager_UpdateGasStore(jsRequest, cloneStoreDTO.GasStoreID)); }); 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) { DataTransfer request2 = new DataTransfer(); GasStoreUpdateDTO dto = new GasStoreUpdateDTO(); dto.GasStoreID = _storeDTO.GasStoreID; dto.GSUpdateDate = DateTime.Now; dto.GSUpdateDescription = txtNote.Text; dto.GSUpdateGas92Add = gas92Add; dto.GSUpdateGas95Add = gas95Add; dto.GSUpdateGasDOAdd = gasDOAdd; dto.GSUpdateGas92Total = _storeDTO.GasStoreGas92Total; dto.GSUpdateGas95Total = _storeDTO.GasStoreGas95Total; dto.GSUpdateGasDOTotal = _storeDTO.GasStoreGasDOTotal; request2.ResponseDataGasStoreUpdateDTO = dto; string jsRequest2 = JSonHelper.ConvertObjectToJSon(request2); Task <String> task2 = SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterTask( () => { return(m_service.SGMManager_AddNewGasStoreUpdate(jsRequest2)); }); SGM_WaitingIdicator.WaitingForm.waitingFrm.progressReporter.RegisterContinuation(task2, () => { String stResponse2 = task2.Result as String; DataTransfer dataResponse2 = JSonHelper.ConvertJSonToObject(stResponse); if (dataResponse.ResponseCode == DataTransfer.RESPONSE_CODE_SUCCESS) { frmMsg.ShowMsg(SGMText.SGM_INFO, SGMText.GASSTORE_UPDATE_TOTAL_SUCCESS, SGMMessageType.SGM_MESSAGE_TYPE_INFO); _storeDTO.GasStoreGas92Total += gas92Add; _storeDTO.GasStoreGas95Total += gas95Add; _storeDTO.GasStoreGasDOTotal += gasDOAdd; DataToUIView(); RefreshUpdateHistory(); } else { frmMsg.ShowMsg(SGMText.SGM_ERROR, dataResponse.ResponseErrorMsgDetail, SGMMessageType.SGM_MESSAGE_TYPE_ERROR); } }, SynchronizationContext.Current); } else { frmMsg.ShowMsg(SGMText.SGM_ERROR, dataResponse.ResponseErrorMsgDetail, SGMMessageType.SGM_MESSAGE_TYPE_ERROR); } }, SynchronizationContext.Current); }