public static string getQueryUpdateMeasure(Measure measure) { return string.Format("UPDATE {0} SET {1}='{2}', {3}='{4}',{5}='{6}'::timestamp without time zone WHERE {7}='{8}' AND {9}='{10}' AND {11}='{12}' AND {13}='{14}'::timestamp without time zone AND {15}={16}", ID_TABLE_MEASURE, ID_VALUE_MEASURE, measure.Value, ID_UPDATEUSER_MEASURE, measure.UpdateUser, ID_UPDATETIME_MEASURE, measure.UpdateLocalDateTime, ID_DEVICE_MEASURE, measure.DeviceId, ID_UNITTYPE_MEASURE, measure.UnitTypeId, ID_LOCALDATETIME_MEASURE, measure.LocalDateTime.ToString(DATETIMEFORMAT_MEASURE), ID_INSERTTIME_MEASURE, measure.LocalInsertTime, ID_INSERTUSER_MEASURE, measure.InsertUser); }
public void UpdateMeasure(Measure measure) { string query = MeasureQuery.getQueryUpdateMeasure(measure); MeasureQuery.ParseDataSetToMeasure(_provider.queryExecute(query,UPDATE_TYPE)); }
public void SaveMeasure(Measure measure) { string query = MeasureQuery.getQuerySaveMeasure(measure); MeasureQuery.ParseDataSetToMeasure(_provider.queryExecute(query,INSERT_TYPE)); }
public void Validate(Measure measure) { validateUtcHour(measure.LocalDateTime.Hour); validateUtcMinute((measure.LocalDateTime.Minute)); validateUtcSecond((measure.LocalDateTime.Second)); }
public static IList<Measure> ParseDataSetToMeasure(DataTable dataTable) { IList<Measure> measureList = new List<Measure>(); foreach (DataRow row in dataTable.Rows) { Measure measure = new Measure() { LocalDateTime = getDateTime(row[POSITION_LOCALDATETIME_MEASURE].ToString(), DATETIMEFORMAT_MEASURE), DeviceId = row[POSITION_DEVICE_MEASURE].ToString(), UnitTypeId = row[POSITION_UNITTYPE_MEASURE].ToString(), MeasureTypeId = row[POSITION_MEASURETYPE_MEASURE].ToString(), Value = Double.Parse(row[POSITION_VALUE_MEASURE].ToString()), LocalInsertTime = getDateTime(row[POSITION_INSERTTIME_MEASURE].ToString(), DATETIMEFORMATINSERT_MEASURE), InsertUser = row[POSITION_INSERTUSER_MEASURE].ToString(), UpdateLocalDateTime = getDateTime(row[POSITION_UPDATETIME_MEASURE].ToString(), DATETIMEFORMATINSERT_MEASURE), UpdateUser = row[POSITION_UPDATEUSER_MEASURE].ToString() }; measureList.Add(measure); } return measureList; }
public static string getQuerySaveMeasure(Measure measure) { return string.Format("INSERT INTO {0} VALUES('{1}','{2}','{3}','{4}','{5}','{6}'::timestamp without time zone,'{7}','{8}'::timestamp without time zone,'{9}')", ID_TABLE_MEASURE, measure.LocalDateTime.ToString(DATETIMEFORMAT_MEASURE), measure.Value,measure.DeviceId, measure.UnitTypeId, measure.MeasureTypeId, measure.LocalInsertTime, measure.InsertUser, measure.UpdateLocalDateTime, measure.UpdateUser); }
public void Update(Measure measure) { _repositoryHelper.UpdateMeasure(measure); }
public void Save(Measure measure) { _measureValidator.Validate(measure); _repositoryHelper.SaveMeasure(measure); }
public bool Exists(Measure measure) { return Get(measure.DeviceId,measure.MeasureTypeId,measure.LocalDateTime) != null; }