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