private void BtnAdd_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(TxtName.Text) && !string.IsNullOrEmpty(TxtBudget.Text) && !string.IsNullOrEmpty(TxtName.Text) && comboBoxInstructors.Text != null)
{
using (var db = new SchoolEntities())
{
// parsing budget if correct
decimal budget = default;
decimal.TryParse(TxtBudget.Text, out budget);
if (budget.ToString() == "0")
{
MessageBox.Show("Invalid budget value.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
// parsing deptid if correct
int deptID = default;
int.TryParse(TxtId.Text, out deptID);
if (deptID.ToString() == "0")
{
MessageBox.Show("Invalid department ID value.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
// getting dept admin id from name + surname
var findAdmin = from o in db.Person
where (o.FirstName + " " + o.LastName).Equals(comboBoxInstructors.Text)
select o.PersonID;
var dept = new Department()
{
Name = TxtName.Text,
Budget = budget,
DepartmentID = deptID,
StartDate = dateTimeStart.Value,
Administrator = findAdmin.First()
};
TxtId.ResetText();
TxtBudget.ResetText();
TxtName.ResetText();
dateTimeStart.ResetText();
comboBoxInstructors.SelectedItem = null;
db.Department.Add(dept);
db.SaveChanges();
dataGridViewDepartments.DataSource = db.Department.ToList();
}
}
else
{
MessageBox.Show("Please enter missing information.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
