public bool DeleteResultFromDB(MeasurementResults obj, string Status)
{
bool isSuccess = false;
try
{
/// Create new record in YXbsMeastask
YXbsMeasurementres measRes = new YXbsMeasurementres(ConnectDB.Connect_Main_);
measRes.Format("*");
if (obj != null)
{
if ((obj.Id.MeasTaskId != null) && (obj.StationMeasurements != null) && (obj.Id.SubMeasTaskId != ConnectDB.NullI) && (obj.Id.SubMeasTaskStationId != ConnectDB.NullI))
{
if (obj.StationMeasurements.StationId != null)
{
if (measRes.Fetch(string.Format(" (meastaskid={0}) and (sensorid={1}) and (submeastaskid={2}) and (submeastaskstationid={3})", obj.Id.MeasTaskId.Value, obj.StationMeasurements.StationId.Value, obj.Id.SubMeasTaskId, obj.Id.SubMeasTaskStationId)))
{
isSuccess = true;
measRes.m_status = Status;
measRes.Save();
}
}
}
else if (obj.Id.MeasTaskId != null)
{
{
measRes.Filter = string.Format(" (meastaskid={0}) ", obj.Id.MeasTaskId.Value);
for (measRes.OpenRs(); !measRes.IsEOF(); measRes.MoveNext())
{
isSuccess = true;
measRes.m_status = Status;
measRes.Save();
}
}
}
measRes.Close();
measRes.Dispose();
}
}
catch (Exception)
{ isSuccess = false; }
return(isSuccess);
}
public bool DeleteResultFromDB(MeasurementResults obj)
{
bool isSuccess = false;
try
{
/// Create new record in YXbsMeastask
YXbsMeasurementres measRes = new YXbsMeasurementres(ConnectDB.Connect_Main_);
measRes.Format("*");
if (obj != null)
{
if ((obj.Id.MeasTaskId != null) && (obj.StationMeasurements != null) && (obj.Id.SubMeasTaskId != ConnectDB.NullI) && (obj.Id.SubMeasTaskStationId != ConnectDB.NullI))
{
if (obj.StationMeasurements.StationId != null)
{
if (measRes.Fetch(string.Format(" (meastaskid={0}) and (sensorid={1}) and (submeastaskid={2}) and (submeastaskstationid={3})", obj.Id.MeasTaskId.Value, obj.StationMeasurements.StationId.Value, obj.Id.SubMeasTaskId, obj.Id.SubMeasTaskStationId)))
{
foreach (FrequencyMeasurement dt_param in obj.FrequenciesMeasurements.ToArray())
{
YXbsFrequencymeas dtr = new YXbsFrequencymeas(ConnectDB.Connect_Main_);
dtr.Format("*");
if (dt_param != null)
{
if (dtr.Fetch(string.Format("id_xbs_measurementres={0}", measRes.m_id)))
{
dtr.Delete();
}
}
dtr.Close();
dtr.Dispose();
}
foreach (LocationSensorMeasurement dt_param in obj.LocationSensorMeasurement.ToArray())
{
YXbsLocationsensorm dtr = new YXbsLocationsensorm(ConnectDB.Connect_Main_);
dtr.Format("*");
if (dt_param != null)
{
if (dtr.Fetch(string.Format("id_xbs_measurementres={0}", measRes.m_id)))
{
dtr.Delete();
}
}
dtr.Close();
dtr.Dispose();
}
foreach (MeasurementResult dt_param in obj.MeasurementsResults.ToArray())
{
if (obj.TypeMeasurements == MeasurementType.Level)
{
YXbsLevelmeasres dtr = new YXbsLevelmeasres(ConnectDB.Connect_Main_);
dtr.Format("*");
if (dt_param != null)
{
if (dtr.Fetch(string.Format("id_xbs_measurementres={0}", measRes.m_id)))
{
dtr.Delete();
}
}
dtr.Close();
dtr.Dispose();
}
else if (obj.TypeMeasurements == MeasurementType.SpectrumOccupation)
{
YXbsSpectoccupmeas dtr = new YXbsSpectoccupmeas(ConnectDB.Connect_Main_);
dtr.Format("*");
if (dt_param != null)
{
if (dtr.Fetch(string.Format("id_xbs_measurementres={0}", measRes.m_id)))
{
dtr.Delete();
}
}
dtr.Close();
dtr.Dispose();
}
}
isSuccess = true;
measRes.Delete();
}
}
}
else if (obj.Id.MeasTaskId != null)
{
{
measRes.Filter = string.Format(" (meastaskid={0}) ", obj.Id.MeasTaskId.Value);
for (measRes.OpenRs(); !measRes.IsEOF(); measRes.MoveNext())
{
foreach (FrequencyMeasurement dt_param in obj.FrequenciesMeasurements.ToArray())
{
YXbsFrequencymeas dtr = new YXbsFrequencymeas(ConnectDB.Connect_Main_);
dtr.Format("*");
if (dt_param != null)
{
dtr.Filter = string.Format("id_xbs_measurementres={0}", measRes.m_id);
for (dtr.OpenRs(); !dtr.IsEOF(); dtr.MoveNext())
{
dtr.Delete();
}
}
dtr.Close();
dtr.Dispose();
}
foreach (LocationSensorMeasurement dt_param in obj.LocationSensorMeasurement.ToArray())
{
YXbsLocationsensorm dtr = new YXbsLocationsensorm(ConnectDB.Connect_Main_);
dtr.Format("*");
if (dt_param != null)
{
dtr.Filter = string.Format("id_xbs_measurementres={0}", measRes.m_id);
for (dtr.OpenRs(); !dtr.IsEOF(); dtr.MoveNext())
{
dtr.Delete();
}
}
dtr.Close();
dtr.Dispose();
}
foreach (MeasurementResult dt_param in obj.MeasurementsResults.ToArray())
{
if (obj.TypeMeasurements == MeasurementType.Level)
{
YXbsLevelmeasres dtr = new YXbsLevelmeasres(ConnectDB.Connect_Main_);
dtr.Format("*");
if (dt_param != null)
{
dtr.Filter = string.Format("id_xbs_measurementres={0}", measRes.m_id);
for (dtr.OpenRs(); !dtr.IsEOF(); dtr.MoveNext())
{
dtr.Delete();
}
}
dtr.Close();
dtr.Dispose();
}
else if (obj.TypeMeasurements == MeasurementType.SpectrumOccupation)
{
YXbsSpectoccupmeas dtr = new YXbsSpectoccupmeas(ConnectDB.Connect_Main_);
dtr.Format("*");
if (dt_param != null)
{
dtr.Filter = string.Format("id_xbs_measurementres={0}", measRes.m_id);
for (dtr.OpenRs(); !dtr.IsEOF(); dtr.MoveNext())
{
dtr.Delete();
}
}
dtr.Close();
dtr.Dispose();
}
}
isSuccess = true;
measRes.Delete();
}
}
}
measRes.Close();
measRes.Dispose();
}
}
catch (Exception)
{ isSuccess = false; }
return(isSuccess);
}