private void Form1_Load(object sender, EventArgs e)
{
dataGridView1.ColumnCount = 4;
dataGridView1.Columns[0].Name = "Department ID";
dataGridView1.Columns[1].Name = "Name";
dataGridView1.Columns[2].Name = "Group Name";
dataGridView1.Columns[3].Name = "Modified Date";
Object[] rows = new Object[4];
dataGridView1.Update();
dataGridView1.Refresh();
dataGridView1.Rows.Clear();
using (var context = new AdventureWorks2017Entities())
{
var queryDepartment = (from x in context.Departments
orderby x.DepartmentID
select x);
foreach (var item in queryDepartment)
{
rows[0] = item.DepartmentID;
rows[1] = item.Name;
rows[2] = item.GroupName;
rows[3] = item.ModifiedDate;
dataGridView1.Rows.Add(rows);
}
}
}
private void edit_Load(object sender, EventArgs e)
{
using (var context = new AdventureWorks2017Entities())
{
var queryInfo = (from x in context.Departments
where x.DepartmentID == dID
select x).First();
departmentID.Text = dID.ToString();
nameBox.Text = queryInfo.Name;
grpNameBox.Text = queryInfo.GroupName;
}
}
private void Delete_Click(object sender, EventArgs e)
{
using (var context = new AdventureWorks2017Entities())
{
var rowDelete = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value);
var deleting = (from x in context.Departments
where x.DepartmentID == rowDelete
select x).FirstOrDefault();
context.Departments.Remove(deleting);
context.SaveChanges();
Form1_Load(null, null);
}
}
private void updateBtn_Click(object sender, EventArgs e)
{
using (var context = new AdventureWorks2017Entities())
{
var update = (from x in context.Departments
where x.DepartmentID == dID
select x).First();
update.Name = nameBox.Text;
update.GroupName = grpNameBox.Text;
update.ModifiedDate = DateTime.Now;
context.SaveChanges();
this.Hide();
Form1 form = new Form1();
form.ShowDialog();
this.Close();
}
}
private void addBtn_Click(object sender, EventArgs e)
{
using (var context = new AdventureWorks2017Entities())
{
context.Departments.Add(new Department()
{
DepartmentID = Convert.ToInt16(dID),
Name = nameBox.Text,
GroupName = grpNameBox.Text,
ModifiedDate = DateTime.Now
});
context.SaveChanges();
this.Hide();
Form1 form = new Form1();
form.ShowDialog();
this.Close();
}
}
private void Add_Click(object sender, EventArgs e)
{
using (var context = new AdventureWorks2017Entities())
{
var queryLast = (from x in context.Departments
orderby x.DepartmentID descending
select x.DepartmentID).FirstOrDefault();
if (dataGridView1.CurrentRow == null)
{
MessageBox.Show("Please select a department", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
var newID = queryLast + 1;
this.Hide();
(new add(newID)).ShowDialog();
this.Close();
}
}
}
