/// <summary> /// Read water meter reading with matching guid from database. /// </summary> /// <param name="context">VesiPortal DbContext</param> /// <param name="waterMeterReadingGuid">Guid used for searching the database</param> /// <returns></returns> public static WaterMeterReading Get(VesiPortalDbContext context, Guid waterMeterReadingGuid) { try { WaterMeterReading waterMeterReading = context.WaterMeterReadings.Where(x => x.Guid == waterMeterReadingGuid) .FirstOrDefault(); return(waterMeterReading); } catch (Exception) { throw; } }
/// <summary> /// Add new water meter reading to database /// </summary> /// <param name="context">VesiPortal DbContext</param> /// <param name="waterMeterReading">Reading to be added</param> /// <returns></returns> public static WaterMeterReading Add(VesiPortalDbContext context, WaterMeterReading waterMeterReading) { try { if (waterMeterReading.Guid == null || waterMeterReading.Guid == Guid.Empty) { waterMeterReading.Guid = Guid.NewGuid(); } waterMeterReading.Timestamp = DateTimeOffset.Now; context.WaterMeterReadings.Create(); context.WaterMeterReadings.Add(waterMeterReading); context.SaveChanges(); return(waterMeterReading); } catch (Exception) { throw; } }