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);
}
