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