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