public void SyncStats(List <Investment.Portable.TblStats> result) { for (int i = 0; i < result.Count; i++) { try{ String id = result[i].ID.ToUpper(); TblStats item = (from s in Table <TblStats>() where s.FieldID.ToUpper().Equals(id) select s).FirstOrDefault(); if (item == null) { AddStats(result[i].ID, result[i].StatsTypeID, result[i].CountryID, result[i].Year, result[i].Month, result[i].Value); } else { item.FieldID = result[i].ID; item.StatsTypeID = result[i].StatsTypeID; item.CountryID = result[i].CountryID; item.Year = result[i].Year; item.Month = result[i].Month; item.Value = result[i].Value; Update(item); } } catch (Exception e) { } } }
public void AddStats(String fieldID, String statusTypeID, String countryID, int year, int month, float value) { TblStats newItem = new TblStats { FieldID = fieldID, StatsTypeID = statusTypeID, CountryID = countryID, Year = year, Month = month, Value = value, Deleted = 0 }; Insert(newItem); }