Example #1
0
        public void SaveSite(IObservationsSite s)
        {
            string sql = "";

            sql = string.Format("select * from Sites where SiteID={0}", s.ID);
            if (ODMDB.Exists(sql))
            {
                sql = string.Format("update Sites set SiteName='{1}', SiteCode='{2}',  SiteType='{3}',Longitude={4},Latitude={5},Elevation_m={6}," +
                                    "State='{7}',Country='{8}',MonitorType={9},Comments='{10}' where SiteID={0}",
                                    s.ID, s.Name, s.Code, s.SiteType, s.Longitude, s.Latitude, s.Elevation, s.State, s.Country, s.MonitorType, s.Comments
                                    );
            }
            else
            {
                sql = string.Format("insert into Sites (SiteID, SiteName,SiteCode,SiteType,Longitude,Latitude,Elevation_m,State,Country,MonitorType,Comments)" +
                                    "values ({0}, '{1}', '{2}','{3}', {4}, {5},{6}, '{7}', '{8}','{9}', '{10}')",
                                    s.ID, s.Name, s.Code, s.SiteType, s.Longitude, s.Latitude, s.Elevation, s.State, s.Country, s.MonitorType, s.Comments);
            }

            ODMDB.CreateNonQueryCommand(sql);
        }
Example #2
0
 public DataSeries(IObservationsSite site, IVariable variable)
 {
     Site     = site;
     Variable = variable;
 }