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