private void SetRangeForPrice(int startYear, int startQuarter, int endYear, int endQuarter)
{
using (var db = new AnalyzerDBContext())
{
bool firstTime = true;
for (int i = startYear; i <= endYear; i++)
{
for (int j = 1; j <= 4; j++)
{
if (firstTime)
{
firstTime = false;
j = startQuarter;
}
var priceItem = new T_Price
{
Year = i,
Quarter = j,
};
db.T_Price.Add(priceItem);
if (i == endYear && j == endQuarter)
{
break;
}
}
}
db.SaveChanges();
}
}
private void T_Dispo_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == 13)
{
T_Price.Focus();
}
}
public void TestDB()
{
using (var db = new AnalyzerDBContext())
{
//Create and save a new Student
//Console.Write("Enter a name for a new Student: ");
//var firstName = Console.ReadLine();
var priceItem = new T_Price
{
Year = 2016,
Quarter = 1,
// COCR = 1.55,
//PARQ = 1.03m,
//LALU = 1.45m
};
db.T_Price.Add(priceItem);
db.SaveChanges();
var query = from b in db.T_Price
select b;
Console.WriteLine("All student in the database:");
foreach (var item in query)
{
Console.WriteLine(item.COCR);
}
Console.WriteLine("Press any key to exit...");
Console.ReadKey();
}
}
