/// <summary> /// Create a new MesoscaleTabFile object. /// </summary> /// <param name="id">Initial value of the Id property.</param> /// <param name="databaseId">Initial value of the DatabaseId property.</param> /// <param name="latitude">Initial value of the Latitude property.</param> /// <param name="longitude">Initial value of the Longitude property.</param> /// <param name="text">Initial value of the Text property.</param> public static MesoscaleTabFile CreateMesoscaleTabFile(global::System.Int32 id, global::System.Int16 databaseId, global::System.Decimal latitude, global::System.Decimal longitude, global::System.String text) { MesoscaleTabFile mesoscaleTabFile = new MesoscaleTabFile(); mesoscaleTabFile.Id = id; mesoscaleTabFile.DatabaseId = databaseId; mesoscaleTabFile.Latitude = latitude; mesoscaleTabFile.Longitude = longitude; mesoscaleTabFile.Text = text; return(mesoscaleTabFile); }
private static void LoadFNL() { string home = ConfigurationManager.AppSettings["fnldir"]; using (var ctx = new OffwindEntities()) { var counter = 0; foreach (var d in Directory.EnumerateFiles(home, "*.dat.tab", SearchOption.TopDirectoryOnly)) { var filename = System.IO.Path.GetFileName(d); //Console.WriteLine(filename); var f = filename.Replace(".dat.tab", ""); var parts = f.Split('_'); var longitude = ParseDecimal(parts[0].TrimEnd("NESW".ToCharArray())); var latitude = ParseDecimal(parts[1].TrimEnd("NESW".ToCharArray())); if (parts[0].EndsWith("W")) { longitude = -longitude; } if (parts[1].EndsWith("S")) { latitude = -latitude; } var dbItem = new MesoscaleTabFile(); dbItem.Longitude = longitude; dbItem.Latitude = latitude; dbItem.DatabaseId = 1; var path = System.IO.Path.Combine(home, filename); using (var sr = new StreamReader(path)) { dbItem.Text = sr.ReadToEnd(); } ctx.MesoscaleTabFiles.AddObject(dbItem); counter++; if (counter > 100) { Console.Write("Writing... "); ctx.SaveChanges(); Console.Write("OK"); Console.WriteLine(); counter = 0; } } ctx.SaveChanges(); } }
private static void LoadMerra() { string home = ConfigurationManager.AppSettings["merradir"]; using (var ctx = new OffwindEntities()) { var counter = 0; var reader = new StreamReader(Path.Combine(home, "merraseries.cfg")); string line; while ((line = reader.ReadLine()) != null) { var val = line.Trim().Split("\t ".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); if (val.Length != 3) { Console.WriteLine("Error: {0}", line); continue; } var dbItem = new MesoscaleTabFile(); dbItem.Longitude = ParseDecimal(val[1]);; dbItem.Latitude = ParseDecimal(val[0]); dbItem.DatabaseId = 2; var path = System.IO.Path.Combine(home, String.Format("50mMERRAnear_{0}.dat.tab", val[2])); using (var sr = new StreamReader(path)) { dbItem.Text = sr.ReadToEnd(); } ctx.MesoscaleTabFiles.AddObject(dbItem); counter++; if (counter > 100) { Console.Write("Writing... "); ctx.SaveChanges(); Console.Write("OK"); Console.WriteLine(); counter = 0; } } ctx.SaveChanges(); } }
private static void LoadMerra() { string home = ConfigurationManager.AppSettings["merradir"]; using (var ctx = new OffwindEntities()) { var counter = 0; var reader = new StreamReader(Path.Combine(home, "merraseries.cfg")); string line; while ((line = reader.ReadLine()) != null) { var val = line.Trim().Split("\t ".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); if (val.Length != 3) { Console.WriteLine("Error: {0}", line); continue; } var dbItem = new MesoscaleTabFile(); dbItem.Longitude = ParseDecimal(val[1]); ; dbItem.Latitude = ParseDecimal(val[0]); dbItem.DatabaseId = 2; var path = System.IO.Path.Combine(home, String.Format("50mMERRAnear_{0}.dat.tab", val[2])); using (var sr = new StreamReader(path)) { dbItem.Text = sr.ReadToEnd(); } ctx.MesoscaleTabFiles.AddObject(dbItem); counter++; if (counter > 100) { Console.Write("Writing... "); ctx.SaveChanges(); Console.Write("OK"); Console.WriteLine(); counter = 0; } } ctx.SaveChanges(); } }
/// <summary> /// Create a new MesoscaleTabFile object. /// </summary> /// <param name="id">Initial value of the Id property.</param> /// <param name="databaseId">Initial value of the DatabaseId property.</param> /// <param name="latitude">Initial value of the Latitude property.</param> /// <param name="longitude">Initial value of the Longitude property.</param> /// <param name="text">Initial value of the Text property.</param> public static MesoscaleTabFile CreateMesoscaleTabFile(global::System.Int32 id, global::System.Int16 databaseId, global::System.Decimal latitude, global::System.Decimal longitude, global::System.String text) { MesoscaleTabFile mesoscaleTabFile = new MesoscaleTabFile(); mesoscaleTabFile.Id = id; mesoscaleTabFile.DatabaseId = databaseId; mesoscaleTabFile.Latitude = latitude; mesoscaleTabFile.Longitude = longitude; mesoscaleTabFile.Text = text; return mesoscaleTabFile; }
/// <summary> /// Deprecated Method for adding a new object to the MesoscaleTabFiles EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToMesoscaleTabFiles(MesoscaleTabFile mesoscaleTabFile) { base.AddObject("MesoscaleTabFiles", mesoscaleTabFile); }
private static void LoadFNL() { string home = ConfigurationManager.AppSettings["fnldir"]; using (var ctx = new OffwindEntities()) { var counter = 0; foreach (var d in Directory.EnumerateFiles(home, "*.dat.tab", SearchOption.TopDirectoryOnly)) { var filename = System.IO.Path.GetFileName(d); //Console.WriteLine(filename); var f = filename.Replace(".dat.tab", ""); var parts = f.Split('_'); var longitude = ParseDecimal(parts[0].TrimEnd("NESW".ToCharArray())); var latitude = ParseDecimal(parts[1].TrimEnd("NESW".ToCharArray())); if (parts[0].EndsWith("W")) longitude = -longitude; if (parts[1].EndsWith("S")) latitude = -latitude; var dbItem = new MesoscaleTabFile(); dbItem.Longitude = longitude; dbItem.Latitude = latitude; dbItem.DatabaseId = 1; var path = System.IO.Path.Combine(home, filename); using (var sr = new StreamReader(path)) { dbItem.Text = sr.ReadToEnd(); } ctx.MesoscaleTabFiles.AddObject(dbItem); counter++; if (counter > 100) { Console.Write("Writing... "); ctx.SaveChanges(); Console.Write("OK"); Console.WriteLine(); counter = 0; } } ctx.SaveChanges(); } }