private void btnSave_Click(object sender, EventArgs e)
{
if (this.gData.Rows.Count == -1)
{
alert.Show("No data to save ....", alert.AlertType.info);
}
alert.Show("Saving ....", alert.AlertType.info);
using (var context = new SmartdbEntities())
{
for (int i = 0; i < this.gData.Rows.Count - 1; i++)
{
DataGridViewRow dr = gData.Rows[i];
if (dr != null && (dr.Cells["RegNo"].Value != null) && (dr.Cells["FullName"].Value != null))
{
try
{
context.Students.Add(new Student
{
//check for duplicate Admin number
Regno = dr.Cells["RegNo"].Value.ToString(),
FullName = dr.Cells["FullName"].Value.ToString(),
School = dr.Cells["School"].Value.ToString(),
SchoolCode = dr.Cells["SchoolCode"].Value.ToString(),
LearningMode = dr.Cells["LearningMode"].Value.ToString(),
});
}
catch (Exception)
{
MessageBox.Show("Check all entries are correct and retry", "Error");
// throw;
}
}
else
{
MetroMessageBox.Show(this, "Critical error contact developer immediately \n :( :( :( :( :( :(:( :( ", "Read Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
try
{
context.SaveChanges();
alert.Show("Saved Successfully", alert.AlertType.success);
}
catch (Exception) { }
}
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
//verification
if (currentStudent == null)
{
alert.Show("Required info \n Search for Student", alert.AlertType.warnig);
return;
}
if (disAction == 0 & disLevel == 0)
{
alert.Show("Required info \n Select provided options", alert.AlertType.warnig);
return;
}
//save the current student info
using (var context = new SmartdbEntities())
{
Disciplinary dd = new Disciplinary();
dd.Regno = currentStudent.Regno;
dd.Action = dropAction.selectedValue.ToString();
dd.Details = tbLegalInfo.Text;
dd.level = (disAction + disLevel);
try
{
context.Disciplinaries.Add(dd);
context.SaveChanges();
alert.Show("Saved Successfully", alert.AlertType.success);
//set ui again
UIset(currentStudent);
}
catch (Exception)
{
throw;
}
}
}
