private void btnAdd_Click(object sender, EventArgs e)
{
var syexist = from s in db.Schoolyears
where s.Year == txtSchoolyear.Text
select s;
if (syexist.Count() > 0)
{
MessageBox.Show("Duplicate Schoolyear!");
}
else
{
if (btnAdd.Text == "Add")
{
Schoolyear sy = new Schoolyear();
sy.Year = txtSchoolyear.Text;
db.Schoolyears.InsertOnSubmit(sy);
db.SubmitChanges();
displaySchoolyear();
MessageBox.Show("Successfully!");
}
else
{
var updatesy = db.Schoolyears.SingleOrDefault(x => x.SchoolyearID == id);
updatesy.Year = txtSchoolyear.Text;
db.SubmitChanges();
btnAdd.Text = "Add";
btnClear.Text = "Clear";
}
}
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Year6orEarlier,Year7,Year8,Year9,Year10,Year11,Year12,Year13,Other")] Schoolyear schoolyear)
{
if (id != schoolyear.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(schoolyear);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SchoolyearExists(schoolyear.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(schoolyear));
}
public async Task <IActionResult> Create([Bind("Id,Year6orEarlier,Year7,Year8,Year9,Year10,Year11,Year12,Year13,Other")] Schoolyear schoolyear)
{
if (ModelState.IsValid)
{
_context.Add(schoolyear);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(schoolyear));
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (btnAdd.Text == "Add")
{
Schoolyear sy = new Schoolyear();
sy.Year = txtSchoolyear.Text;
db.Schoolyears.InsertOnSubmit(sy);
db.SubmitChanges();
displaySchoolyear();
MessageBox.Show("Successfully!");
}
else
{
var updatesy = db.Schoolyears.SingleOrDefault(x => x.SchoolyearID == id);
updatesy.Year = txtSchoolyear.Text;
db.SubmitChanges();
btnAdd.Text = "Add";
btnClear.Text = "Clear";
}
}
