public override void AddNextOfKin(NextOfKin nextOfKin)
{
DataBase db = new NextOfKinData();
int nextofKinId = db.Add(nextOfKin, Student.PersonId);
nextOfKin.PersonId = nextofKinId;
}
private void PopulateNextOfKin()
{
cmbNextOfKinName.DisplayMember = "FullName";
cmbNextOfKinName.ValueMember = "PersonId";
DataBase db = new NextOfKinData();
List <NextOfKin> list = db.GetList().ConvertAll(x => x as NextOfKin);
List <NextOfKin> nextOfKin = list.Except(_student.Doctors.ConvertAll(x => x as NextOfKin)).ToList();
cmbNextOfKinName.DataSource = GetOtherNextOfKin(list, _student.NextOfKin.ConvertAll(x => x as NextOfKin));// db.GetList();
cmbNextOfKinName.SelectedIndex = -1;
cmbNextOfKinName.Refresh();
}
private void addNextOfKin_Click(object sender, EventArgs e)
{
//AddNextOfKin ad = new AddNextOfKin(_student);
NextOfKinAdd ad = new NextOfKinAdd(new AddNextOfKinToExistingStudent(_student));
ad.ShowDialog();
if (ad.DialogResult == DialogResult.OK)
{
DataBase db = new NextOfKinData();
_student.NextOfKin = db.GetList(_student.PersonId).ConvertAll(x => x as NextOfKin);
PopulateNextOfKin();
}
}
private void removeNextOfKin_Click(object sender, EventArgs e)
{
int rowindex = nextOfKinGridView1.CurrentCell.RowIndex;
int nextOfKinId = (int)nextOfKinGridView1.Rows[rowindex].Cells[0].Value;
Person nextOfKin = _student.NextOfKin.Find(x => x.PersonId == nextOfKinId);
if (nextOfKin != null)
{
if (MessageBox.Show("Are you sure you want to remove Next of kin '" + nextOfKin.FullName + "' from this student?", "Remove Doctor", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
DataBase db = new NextOfKinData();
db.Remove(nextOfKin, _student.PersonId);
_student.Doctors = db.GetList(_student.PersonId);
PopulateNextOfKin();
}
}
}
public override void Save()
{
DBCommand dbc = new DBCommand(DBCommand.TransactionType.WithTransaction);
try
{
DataBase db = new StudentData(dbc);
if (Student.PersonId == 0)
{
int studentId = db.Add(Student);
if (Student.Doctors.Count > 0)
{
db = new DoctorData(dbc);
foreach (Doctor doctor in Student.Doctors)
{
db.Allocate(doctor, studentId);
}
}
if (Student.NextOfKin.Count > 0)
{
db = new NextOfKinData(dbc);
foreach (NextOfKin nok in Student.NextOfKin)
{
if (nok.PersonId == 0)
{
nok.PersonId = db.Add(nok, studentId);
}
else
{
db.Allocate(nok, studentId);
}
}
}
if (Student.EmergencyContacts.Count > 0)
{
db = new EmergencyContactData(dbc);
foreach (EmergencyContact ec in Student.EmergencyContacts)
{
//if (ec.PersonId == 0)
//{
ec.PersonId = db.Add(ec, studentId);
//}
//db.Allocate(ec, studentId);
}
}
if (Student.MedicalConditions.Count > 0)
{
MedicalConditionData mdc = new MedicalConditionData(dbc);
foreach (MedicalCondition mc in Student.MedicalConditions)
{
mdc.Add(mc, studentId);
}
}
}
else
{
db.Update(Student);
}
dbc.CommitTransactions();
dbc.CloseConnection();
Student.RemovedObjects.Clear();
}
catch (Exception ex)
{
dbc.rollbackTransactions();
dbc.CloseConnection();
throw new Exception(ex.Message);
}
}
public override void Commit()
{
DataBase db = new NextOfKinData();
_doctorAddEdit.NextOfKin.PersonId = db.Add(_doctorAddEdit.NextOfKin);
}
public override void AllocateNextOfKin(NextOfKin nextOfKin)
{
DataBase db = new NextOfKinData();
db.Allocate(nextOfKin, Student.PersonId);
}
