public void SaveTopWeather(int UserID, int segID, int wspd, string loc, int stars, string epoch, string timestamp) { var DataContext = new DataClasses1DataContext(); var allw = from e in DataContext.TopWeathers where e.SegID == segID where e.Timestamp >= DateTime.Now.AddHours(-1) select e; if (allw.Count() > 0) { } else { TopWeather wnew = new Models.TopWeather(); wnew.UserID = UserID; wnew.SegID = segID; wnew.Stars = stars; wnew.latlng = loc; //wnew.SegName = segName; //wnew.Polyline = poly; wnew.Windspeed = wspd; wnew.epoch = epoch; wnew.Timestamp = DateTime.Now; wnew.TS_pretty = timestamp; datarepo.Add(wnew); datarepo.Save(); } }
public void SaveTopWeather(int UserID, int segID, int wspd, string loc, int stars, string epoch, string timestamp) { var DataContext = new DataClasses1DataContext(); var userct = from u in DataContext.TopWeathers where u.SegID == segID where u.epoch == epoch select u; var priv = from u in DataContext.Segments where u.SegmentID == segID where u.PrivateSeg == 1 select u; if (userct.Count() == 0 && priv.Count() == 0) { TopWeather wnew = new Models.TopWeather(); wnew.UserID = UserID; wnew.SegID = segID; wnew.Stars = stars; wnew.latlng = loc; wnew.Windspeed = wspd; wnew.epoch = epoch; wnew.Timestamp = DateTime.Now; wnew.TS_pretty = timestamp; datarepo.Add(wnew); datarepo.Save(); } }