public static string getQueryUpdateWeather(Weather weather)
{
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_WEATHER,
ID_VALUE_WEATHER, weather.Value, ID_UPDATEUSER_WEATHER, weather.UpdateUser, ID_UPDATETIME_WEATHER, weather.UpdateLocalDateTime,
ID_MACROCELL_WEATHER, weather.MacrocellId,
ID_UNITTYPE_WEATHER, weather.UnitTypeId,
ID_LOCALDATETIME_WEATHER, weather.LocalDateTime.ToString(DATETIMEFORMAT_WEATHER),
ID_INSERTTIME_WEATHER, weather.LocalInsertTime,
ID_INSERTUSER_WEATHER, weather.InsertUser);
}
public void Update(Weather weather)
{
_repositoryHelper.UpdateWeather(weather);
}
public void Save(Weather weather)
{
_weatherValidator.Validate(weather);
_repositoryHelper.SaveWeather(weather);
}
public bool Exists(Weather weather)
{
return Get(weather.MacrocellId,weather.MeasureTypeId,weather.LocalDateTime) != null;
}
public void UpdateWeather(Weather weather)
{
string query = WeatherQuery.getQueryUpdateWeather(weather);
WeatherQuery.ParseDataSetToWeather(_provider.queryExecute(query,UPDATE_TYPE));
}
public void SaveWeather(Weather weather)
{
string query = WeatherQuery.getQuerySaveWeather(weather);
WeatherQuery.ParseDataSetToWeather(_provider.queryExecute(query,INSERT_TYPE));
}
public static IList<Weather> ParseDataSetToWeather(DataTable dataTable)
{
IList<Weather> weatherList = new List<Weather>();
foreach (DataRow row in dataTable.Rows)
{
Weather weather = new Weather()
{
LocalDateTime = getDateTime(row[POSITION_LOCALDATETIME_WEATHER].ToString(), DATETIMEFORMAT_WEATHER),
MacrocellId = row[POSITION_MACROCELL_WEATHER].ToString(),
UnitTypeId = row[POSITION_UNITTYPE_WEATHER].ToString(),
MeasureTypeId = row[POSITION_MEASURETYPE_WEATHER].ToString(),
Value = Double.Parse(row[POSITION_VALUE_WEATHER].ToString()),
LocalInsertTime = getDateTime(row[POSITION_INSERTTIME_WEATHER].ToString(), DATETIMEFORMATINSERT_WEATHER),
InsertUser = row[POSITION_INSERTUSER_WEATHER].ToString(),
UpdateLocalDateTime = getDateTime(row[POSITION_UPDATETIME_WEATHER].ToString(), DATETIMEFORMATINSERT_WEATHER),
UpdateUser = row[POSITION_UPDATEUSER_WEATHER].ToString()
};
weatherList.Add(weather);
}
return weatherList;
}
public static string getQuerySaveWeather(Weather weather)
{
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_WEATHER, weather.LocalDateTime.ToString(DATETIMEFORMAT_WEATHER),
weather.Value,weather.UnitTypeId, weather.MeasureTypeId, weather.MacrocellId, weather.LocalInsertTime,
weather.InsertUser, weather.UpdateLocalDateTime, weather.UpdateUser);
}
public void Validate(Weather weather)
{
validateUtcHour(weather.LocalDateTime.Hour);
validateUtcMinute((weather.LocalDateTime.Minute));
validateUtcSecond((weather.LocalDateTime.Second));
}