private async void button1_Click(object sender, EventArgs e)
{
using (var db = new AstronomyLogsEntities())
{
foreach (AstronomyEntry entry in AstronomyParser.fillSQLEntry(dt))
{
db.AstronomyEntries.Add(entry);
}
db.SaveChanges();
}
}
public constellationForm()
{
InitializeComponent();
using (var db = new AstronomyLogsEntities())
{
top10Entries = db.AstronomyEntries.Take(10).ToList();
}
PointF sunPoint = new PointF(this.ClientSize.Width / 5F, this.ClientSize.Height / 2F);
sun = new RectangleF(sunPoint, new SizeF(10 * 2F, 10 * 2F));
}
public EditForm()
{
InitializeComponent();
using (var db = new AstronomyLogsEntities())
{
dbGrid.DataSource = db.AstronomyEntries.Where(e => !String.IsNullOrEmpty(e.Proper)).ToList();
dbGrid.Columns["Name"].DisplayIndex = 1;
for (int i = 0; i < dbGrid.Columns.Count; i++)
{
dbGrid.Columns[i].ReadOnly = dbGrid.Columns[i].Name != "Name";
}
}
}
private void saveBtn_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow row in dbGrid.Rows)
{
using (var db = new AstronomyLogsEntities())
{
int id = int.Parse(row.Cells[0].Value.ToString());
AstronomyEntry entry = db.AstronomyEntries.Where(en => en.IDEntry == id).FirstOrDefault();
string name = row.Cells["Name"].Value.ToString();
if (!string.IsNullOrEmpty(name))
{
entry.Name = row.Cells["Name"].Value.ToString();
db.Entry(entry).State = EntityState.Modified;
}
db.SaveChanges();
}
}
}