public DataTransfer DeleteGasStation(string stGasStationID)
{
bool delResult = true;
DataTransfer dataResult = new DataTransfer();
try
{
string query = string.Format("DELETE 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);
delResult = m_dbConnection.ExecuteDeleteQuery(query, sqlParameters);
}
catch (Exception ex)
{
delResult = false;
dataResult.ResponseErrorMsgDetail = ex.Message + " : " + ex.StackTrace;
}
if (delResult)
{
dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_SUCCESS;
}
else
{
dataResult.ResponseCode = DataTransfer.RESPONSE_CODE_FAIL;
dataResult.ResponseErrorMsg = SGMText.GASSTATION_DEL_ERR;
}
return(dataResult);
}
public bool DeleteSystemAdmin(string stAdminAcount)
{
bool result = true;
string query = string.Format("DELETE FROM SYSTEM_ADMIN WHERE SYS_ADMIN = @SYS_ADMIN");
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@SYS_ADMIN", SqlDbType.NVarChar);
sqlParameters[0].Value = Convert.ToString(stAdminAcount);
result = m_dbConnection.ExecuteDeleteQuery(query, sqlParameters);
return(result);
}
public bool DeleteSaleGas(int iSaleGasID)
{
bool result = true;
string query = string.Format("DELETE FROM SALE_GAS WHERE SALEGAS_ID = @SALEGAS_ID");
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@SALEGAS_ID", SqlDbType.Int);
sqlParameters[0].Value = Convert.ToInt32(iSaleGasID);
result = m_dbConnection.ExecuteDeleteQuery(query, sqlParameters);
return(result);
}
public bool DeleteCard(string stCardID)
{
bool result = true;
string query = string.Format("DELETE 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);
result = m_dbConnection.ExecuteDeleteQuery(query, sqlParameters);
return(result);
}
public bool DeleteCard(int iRechargeID)
{
bool result = true;
string query = string.Format("DELETE FROM RECHARGE WHERE RECHARGE_ID = @RECHARGE_ID");
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@RECHARGE_ID", SqlDbType.Int);
sqlParameters[0].Value = Convert.ToInt32(iRechargeID);
result = m_dbConnection.ExecuteDeleteQuery(query, sqlParameters);
return(result);
}
