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