private void LoadTraineeCourses()
{
BusinessLogic.TraineeCourseManager traineeCourseManager = new BusinessLogic.TraineeCourseManager();
List <BusinessEntity.TraineeCourseEntity> traineeCourseEntities = traineeCourseManager.GetAll();
listViewTraineeCourse.Items.Clear();
if (traineeCourseEntities == null)
{
MessageBox.Show("Sorry database error occured, please try again.");
}
else
{
foreach (BusinessEntity.TraineeCourseEntity traineeCourseEntity in traineeCourseEntities)
{
ListViewItem item = new ListViewItem(traineeCourseEntity.ID.ToString());
item.SubItems.Add(traineeCourseEntity.TraineeEntity.Fullname);
item.SubItems.Add(traineeCourseEntity.CourseEntity.Title);
item.SubItems.Add(traineeCourseEntity.RegistrationDate.ToString());
item.SubItems.Add(traineeCourseEntity.Duration);
item.SubItems.Add(traineeCourseEntity.Cost.ToString());
listViewTraineeCourse.Items.Add(item);
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (listViewTraineeCourse.SelectedItems.Count > 0)
{
try
{
DialogResult result = MessageBox.Show("Are you sure you want to delete the selected record?", "Training Information Management System", MessageBoxButtons.YesNo);
if (result == DialogResult.OK)
{
int traineeCourseID = int.Parse(listViewTraineeCourse.SelectedItems[0].SubItems[0].Text);
BusinessLogic.TraineeCourseManager traineeCourseManager = new BusinessLogic.TraineeCourseManager();
BusinessEntity.TraineeCourseEntity oldTraineeCourse = traineeCourseManager.GetSingle(traineeCourseID);
traineeCourseManager.Delete(oldTraineeCourse);
MessageBox.Show("Trainee's Course Information Deleted Successfully.");
LoadTraineeCourses();
}
}
catch (Exception ex)
{
//save to log table
MessageBox.Show("Delete Failed, Please try again.");
}
}
else
{
MessageBox.Show("Please select trainee from the list first.");
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (listViewTraineeCourse.SelectedItems.Count > 0)
{
try
{
if (IsValid())
{
int traineeCourseID = int.Parse(listViewTraineeCourse.SelectedItems[0].SubItems[0].Text);
BusinessLogic.TraineeCourseManager traineeCourseManager = new BusinessLogic.TraineeCourseManager();
BusinessEntity.TraineeCourseEntity oldTraineeCourse = traineeCourseManager.GetSingle(traineeCourseID);
BusinessEntity.TraineeCourseEntity newTraineeCourse = new BusinessEntity.TraineeCourseEntity();
newTraineeCourse.ID = traineeCourseID;
newTraineeCourse.TraineeEntity = new BusinessEntity.TraineeEntity();
newTraineeCourse.TraineeEntity.ID = int.Parse(cboTrainee.SelectedValue.ToString());
newTraineeCourse.CourseEntity = new BusinessEntity.CourseEntity();
newTraineeCourse.CourseEntity.ID = int.Parse(cboCourse.SelectedValue.ToString());
newTraineeCourse.RegistrationDate = dtpRegistrationDate.Value;
newTraineeCourse.Duration = cboDuration.Text;
newTraineeCourse.Cost = decimal.Parse(txtCost.Text);
newTraineeCourse.CreatedBy = oldTraineeCourse.CreatedBy;
newTraineeCourse.CreatedDate = oldTraineeCourse.CreatedDate;
newTraineeCourse.UpdatedBy = this.Tag.ToString();
newTraineeCourse.UpdatedDate = DateTime.Now;
traineeCourseManager.Update(newTraineeCourse);
MessageBox.Show("Trainee's Course Information Updated Successfully.");
LoadTraineeCourses();
}
}
catch (Exception ex)
{
//save to log table
MessageBox.Show("Update Failed, Please try again.");
}
}
else
{
MessageBox.Show("Please select trainee's course from the list first.");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (IsValid())
{
BusinessLogic.TraineeCourseManager traineeCourseManager = new BusinessLogic.TraineeCourseManager();
BusinessEntity.TraineeCourseEntity traineeCourse = new BusinessEntity.TraineeCourseEntity();
traineeCourse.TraineeEntity = new BusinessEntity.TraineeEntity();
traineeCourse.TraineeEntity.ID = int.Parse(cboTrainee.SelectedValue.ToString());
traineeCourse.CourseEntity = new BusinessEntity.CourseEntity();
traineeCourse.CourseEntity.ID = int.Parse(cboCourse.SelectedValue.ToString());
traineeCourse.RegistrationDate = dtpRegistrationDate.Value;
traineeCourse.Duration = cboDuration.Text;
traineeCourse.Cost = decimal.Parse(txtCost.Text);
traineeCourse.CreatedBy = this.Tag.ToString();
traineeCourse.CreatedDate = DateTime.Now;
int traineeCourseID = traineeCourseManager.Save(traineeCourse);
///////////////////////// manage trainee payment for initial payment
BusinessLogic.TraineePaymentManager traineePaymentManager = new BusinessLogic.TraineePaymentManager();
BusinessEntity.TraineePaymentEntity traineePayment = new BusinessEntity.TraineePaymentEntity();
traineePayment.TraineeCourseEntity = new BusinessEntity.TraineeCourseEntity();
traineePayment.TraineeCourseEntity.ID = traineeCourseID;
traineePayment.PaymentDate = dtpRegistrationDate.Value;
traineePayment.PaymentAmount = decimal.Parse(txtInitialPayment.Text);
traineePayment.CreatedBy = this.Tag.ToString();
traineePayment.CreatedDate = DateTime.Now;
traineePaymentManager.Save(traineePayment);
/////////////////////////
MessageBox.Show("Trainee's Course Information Saved Successfully.");
LoadTraineeCourses();
}
}
catch (Exception ex)
{
//save to log table
MessageBox.Show("Save Failed, Please try again.");
}
}
