private void btnpicREviewUpdateCompanyInfo_Click(object sender, EventArgs e)
{
Data.Models.Enrollment EnrollmentObj = (Data.Models.Enrollment)(enrollmentBindingSourceMain.Current);
if (EnrollmentObj != null)
{
Boolean IsCompany = false;
foreach (StudentAssociatedCompany SAC in EnrollmentObj.StudentEnrollment.Student.StudentAssociatedCompanies)
{
if (SAC.IsCurrentCompany)
{
IsCompany = true;
}
}
if (IsCompany)
{
using (ViewEditCompanyDetails frm = new ViewEditCompanyDetails(EnrollmentObj.StudentEnrollment.Student.StudentAssociatedCompanies.Where(a => a.IsCurrentCompany == true).FirstOrDefault().Company.CompanyID))
{
//frm.txtCompaniesFilterCriteria.Text = EnrollmentObj.StudentEnrollment.Student.StudentAssociatedCompanies.Where(a => a.IsCurrentCompany == true).FirstOrDefault().Company.CompanyName;
frm.ShowDialog();
}
}
else
{
MessageBox.Show("Student is private no Company Details Avaiable, Allocate the student to a company by configuring the student details.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
private void btnEmailClient_Click(object sender, EventArgs e)
{
Data.Models.Enrollment EnrollmentObj = ((Data.Models.Enrollment)enrollmentBindingSource.Current);
CurriculumEnquiry CurriculumEnquiryObj;
Data.Models.Enquiry CurrentEnquiryObj;
using (var Dbconnection = new MCDEntities())
{
CurriculumEnquiryObj = (from a in Dbconnection.CurriculumEnquiries
from b in a.Enrollments
where
b.EnrollmentID == EnrollmentObj.EnrollmentID &&
a.CurriculumID == EnrollmentObj.CurriculumID
select a).FirstOrDefault <CurriculumEnquiry>();
CurrentEnquiryObj = (from a in Dbconnection.Enquiries
where a.EnquiryID == CurriculumEnquiryObj.EnquiryID
select a)
.Include("Individuals")
.Include("Individuals.ContactDetails")
.FirstOrDefault <Data.Models.Enquiry>();
};
frmEmailMessageV2 frm = new frmEmailMessageV2();
List <ContactDetail> CustomEmailPerson = (from a in CurrentEnquiryObj.Individuals
from b in a.ContactDetails
where b.ContactTypeID == (int)Common.Enum.EnumContactTypes.Email_Address
select b).ToList <ContactDetail>();
//Sets the Email Address For the Currently Selected Contact For this Enquiry
//foreach (ContactDetail ConDetObj in CustomEmailPerson)
//{
// if (frm.txtTestingToAddress.Text.Length > 0)
// {
// frm.txtTestingToAddress.Text += ";";
// }
// frm.txtTestingToAddress.Text += ConDetObj.ContactDetailValue;
//}
//frm.txtTestSubject.Text = "Enquiry No: ( " + CurrentEnquiryObj.EnquiryID + "-" + CurriculumEnquiryObj.CurriculumEnquiryID + " ) Enquiry Feed Back";
//frm.txtTestMessage.Text = "Good Day \nThis is regarding the processing of your Enrollemnt - Ref: " + EnrollmentObj.EnrollmentID + "\n";
frm.ShowDialog();
if (frm.IsSent)
{
using (var Dbconnection = new MCDEntities())
{
//EquiryHistory hist = new EquiryHistory
//{
// EnquiryID = CurrentEnquiryObj.EnquiryID,
// EmployeeID = this.CurrentEmployeeLoggedIn.EmployeeID,
// LookupEquiyHistoryTypeID = (int)EnumEquiryHistoryTypes.Enquiry_Custom_Email_Message_Sent,
// DateEnquiryUpdated = DateTime.Now,
// EnquiryNotes = "Custom Message Sent To Client Via Email\nSubject of the Message was:\n\n{" + frm.txtTestSubject.Text + "}\n\nBody Of the Message read:\n" + frm.txtTestMessage.Text
//};
//Dbconnection.EquiryHistories.Add(hist);
int IsSaved = Dbconnection.SaveChanges();
};
}
}
private void dgvEnrollment_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
Data.Models.Enrollment EnrollmentObj = ((Data.Models.Enrollment)enrollmentBindingSource.Current);
switch (e.ColumnIndex)
{
case 1:
break;
}
}
private void btnStudentInformation_Click(object sender, EventArgs e)
{
using (frmStudentAddUpdate frm = new frmStudentAddUpdate(CurrentEnrollment.StudentEnrollment.StudentID))
{
//frm.CurrentStudentID = CurrentEnrollment.Student.StudentID;
frm.ShowDialog();
if (frm.CurrentSelectedStudent != null)
{
Data.Models.Enrollment EnrollmentObj = (Data.Models.Enrollment)(enrollmentBindingSourceMain.Current);
EnrollmentObj.StudentEnrollment.Student = frm.CurrentSelectedStudent;
enrollmentBindingSourceMain.ResetCurrentItem();
}
}
}
private void btnpicEmailClient_Click(object sender, EventArgs e)
{
Data.Models.Enrollment EnrollmentObj = (Data.Models.Enrollment)(enrollmentBindingSourceMain.Current);
using (frmEmailMessageV2 frm = new frmEmailMessageV2())
{
frm.txtMessageSubject.Text = "MCD Communication - Follow up on Enrollment - " + EnrollmentObj.StudentEnrollment.Student.Individual.FullName;
frm.AddToEmailContact(new List <Individual>()
{
(Individual)EnrollmentObj.StudentEnrollment.Student.Individual
});
frm.txtMessageSubject.ReadOnly = true;
frm.ShowDialog();
}
}
private void populateApprenticeshipEnrollmentDocuments(int _EnrollentDocumentTypeID)
{
using (var Dbconnection = new MCDEntities())
{
Data.Models.Enrollment Enroll = ((Data.Models.Enrollment)(enrollmentBindingSource.Current));
//fileBindingSource.DataSource = (from a in Dbconnection.ApprenticeshipEnrollmentDocuments
// where a.EnrollmentID == Enroll.EnrollmentID
// && a.LookupEnrollentDocumentTypeID == _EnrollentDocumentTypeID
// select new
// {
// ImageID = a.File.ImageID,
// FileName = a.File.FileName + "." + a.File.FileExtension,
// DateCreated = a.File.DateCreated
// }).ToList();
};
}
private void enrollmentDataGridView_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
var gridView = (DataGridView)sender;
foreach (DataGridViewRow row in gridView.Rows)
{
if (!row.IsNewRow)
{
Data.Models.Enrollment EnrollmentObj = (Data.Models.Enrollment)(row.DataBoundItem);
row.Cells[colStudentIDNumber1.Index].Value = EnrollmentObj.StudentEnrollment.Student.StudentIDNumber.ToString();
row.Cells[colFirstName1.Index].Value = EnrollmentObj.StudentEnrollment.Student.Individual.IndividualFirstName.ToString();
row.Cells[colLastName1.Index].Value = EnrollmentObj.StudentEnrollment.Student.Individual.IndividualLastname.ToString();
//row.Cells[colStatus.Index].Value = EnrollmentObj.LookupEnrollmentProgressState.EnrollmentProgressCurrentState.ToString();
}
}
}
private void dgvPrerequisiteCourses_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
var gridView = (DataGridView)sender;
foreach (DataGridViewRow row in gridView.Rows)
{
if (!row.IsNewRow)
{
Data.Models.Enrollment EnrollmentObj = (Data.Models.Enrollment)(row.DataBoundItem);
row.Cells[colApprenticeshipPreRequisiteCurriculum.Index].Value = EnrollmentObj.Curriculum.CurriculumName.ToString();
CurriculumCourse CurriculumCourseObj = (from a in EnrollmentObj.CurriculumCourseEnrollments
where a.CurriculumCourse.CurriculumID == EnrollmentObj.CurriculumID
select a.CurriculumCourse)
.FirstOrDefault <CurriculumCourse>();
row.Cells[colApprenticeshipPreRequisiteCourse.Index].Value = CurriculumCourseObj.Course.CourseName.ToString();
row.Cells[colApprenticeshipPrerequisteProcessingStatus.Index].Value = EnrollmentObj.LookupEnrollmentProgressState.EnrollmentProgressCurrentState.ToString();
}
}
}
private void populateApprenticeshipCoursePreRequisites()
{
Data.Models.Enrollment EnrollObj = (Data.Models.Enrollment)enrollmentBindingSource.Current;
if (EnrollObj != null)
{
using (var Dbconnection = new MCDEntities())
{
enrollmentPrerequisitesBindingSource.DataSource = (from a in Dbconnection.Enrollments
from b in a.CurriculumCourseEnrollments
where a.EnrolmentParentID == EnrollObj.EnrollmentID
select a)
.Include("CurriculumCourseEnrollments")
//.Include("Curriculum.CurriculumCourses")
//.Include("Curriculum.CurriculumCourses.Course")
.ToList <Data.Models.Enrollment>();
};
}
else
{
enrollmentPrerequisitesBindingSource.Clear();
}
}
private void enrollmentBindingSourceMain_ListChanged(object sender, ListChangedEventArgs e)
{
Data.Models.Enrollment EnrollmentObj = (Data.Models.Enrollment)(enrollmentBindingSourceMain.Current);
if (EnrollmentObj != null)
{
Boolean IsCompany = false;
foreach (StudentAssociatedCompany SAC in EnrollmentObj.StudentEnrollment.Student.StudentAssociatedCompanies)
{
if (SAC.IsCurrentCompany)
{
IsCompany = true;
}
}
if (IsCompany)
{
txtCompanyNameDisplay.Text = EnrollmentObj.StudentEnrollment.Student.StudentAssociatedCompanies.Where(a => a.IsCurrentCompany == true).FirstOrDefault().Company.CompanyName;
}
else
{
txtCompanyNameDisplay.Text = "Private - " + EnrollmentObj.StudentEnrollment.Student.Individual.FullName;
}
}
}
private void dgvEnrollment_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
var gridView = (DataGridView)sender;
foreach (DataGridViewRow row in gridView.Rows)
{
if (!row.IsNewRow)
{
Data.Models.Enrollment EnrollmentObj = (Data.Models.Enrollment)(row.DataBoundItem);
row.Cells[colApprenticeshipCurriculum.Index].Value = EnrollmentObj.Curriculum.CurriculumName.ToString();
//if (EnrollmentObj.ApprienticeshipEnrollment != null)
//{
// row.Cells[colApprenticeshipSection.Index].Value = EnrollmentObj.ApprienticeshipEnrollment.LookupSectionalEnrollmentType.LookupSectionalEnrollmentTypeName.ToString();
//}
var CurriculumEnquiryObj = EnrollmentObj.CurriculumEnquiries.FirstOrDefault <CurriculumEnquiry>();;
if (CurriculumEnquiryObj != null)
{
row.Cells[colApprenticeshipEnqiry.Index].Value = CurriculumEnquiryObj.EnquiryID.ToString();
}
}
}
}
private void populateEnrollment()
{
int EnrollmentToLoadID = 0;
using (var Dbconnection = new MCDEntities())
{
//Load PreRequisteEnrollment
if (CurrentEnrollmentPreRequisiteID != 0)
{
EnrollmentToLoadID = this.CurrentEnrollmentPreRequisiteID;
}
else//Load Enrollment
{
EnrollmentToLoadID = this.CurrentEnrollmentID;
}
CurrentEnrollment = (from a in Dbconnection.Enrollments
where a.EnrollmentID == EnrollmentToLoadID
select a)
.Include(a => a.StudentEnrollment)
.Include(a => a.StudentEnrollment.Student.StudentAssociatedCompanies)
.Include(a => a.StudentEnrollment.Student.StudentAssociatedCompanies.Select(b => b.Company))
.Include(a => a.StudentEnrollment.Student)
.Include(a => a.StudentEnrollment.Student.Individual)
.Include(a => a.StudentEnrollment.Student.Individual.ContactDetails)
//.Include(a => a.CurriculumEnquiry)
.Include(a => a.CurriculumCourseEnrollments)
//LookupEnrollmentProgressState
.Include(a => a.CurriculumCourseEnrollments.Select(b => b.LookupEnrollmentProgressState))
.Include(a => a.CurriculumCourseEnrollments.Select(b => b.Schedules))
.Include(a => a.CurriculumCourseEnrollments.Select(b => b.CurriculumCourse).Select(c => c.CurriculumCourseMinimumMaximum))
.Include(a => a.CurriculumCourseEnrollments.Select(b => b.CurriculumCourse.CurriculumCourseDayCanBeScheduleds))
.Include(a => a.Curriculum)
.FirstOrDefault <Data.Models.Enrollment>();
if (CurrentEnrollmentPreRequisiteID != 0)
{
List <CurriculumCourseEnrollment> CurriculumCourseEnrollmentTemp = new List <CurriculumCourseEnrollment>();
foreach (CurriculumCourseEnrollment CurriculumCourseEnrollmentObj in CurrentEnrollment.CurriculumCourseEnrollments)
{
// //trying code
// CurrentEnrollment.CurriculumCourseEnrollments.Clear();
// Dbconnection.Entry(blog)
//.Collection("Posts")
//.Query()
//.Where(p => p.Tags.Contains("entity-framework")
//.Load();
// //end trying code
if (CurriculumCourseEnrollmentObj.CurriculumCourseEnrollmentID == this.CurrentCurriculumCourseEnrollmentID)
{
CurriculumCourseEnrollmentTemp.Add(CurriculumCourseEnrollmentObj);
}
}
CurrentEnrollment.CurriculumCourseEnrollments.Clear();
foreach (CurriculumCourseEnrollment CurriculumCourseEnrollmentObj in CurriculumCourseEnrollmentTemp)
{
CurrentEnrollment.CurriculumCourseEnrollments.Add(CurriculumCourseEnrollmentObj);
}
//SetControls
}
else
{
}
enrollmentBindingSourceMain.DataSource = CurrentEnrollment;
};
}
private void populateEnrollmentFiles()
{
using (var Dbconnection = new MCDEntities())
{
List <EnrollmentFiles> EF = new List <EnrollmentFiles>();
int filterID = Convert.ToInt32(cboAttachmentType.SelectedValue);
if (filterID == (int)Common.Enum.EnumEnrollentDocumentTypes.ID_Documents)
{
Data.Models.Enrollment EnrollmentObj = (Data.Models.Enrollment)(enrollmentBindingSourceMain.Current);
var ListOfFiles = (from a in Dbconnection.StudentIDDocuments
where a.StudentID == EnrollmentObj.StudentEnrollment.StudentID
select new
{
FileID = a.File.FileID,
FileName = a.File.FileName,
FileExtension = a.File.FileExtension,
EnrollentDocumentType = "Student ID Document",
EnrollmentDocumentTypeID = Common.Enum.EnumEnrollentDocumentTypes.ID_Documents
}).ToList();
foreach (var obj in ListOfFiles)
{
EF.Add(new EnrollmentFiles()
{
FileID = obj.FileID,
FileName = obj.FileName,
FileExtension = obj.FileExtension,
EnrollmentDocumentTypeID = (int)Common.Enum.EnumEnrollentDocumentTypes.ID_Documents,
EnrollentDocumentType = obj.EnrollentDocumentType
});
}
}
else
{
var ListOfFiles = (from a in Dbconnection.EnrollmentDocuments
where a.EnrollmentID == CurrentEnrollmentID &&
a.LookupEnrollmentDocumentTypeID == filterID
select new
{
FileID = a.File.FileID,
FileName = a.File.FileName,
FileExtension = a.File.FileExtension,
EnrollentDocumentType = a.LookupEnrollentDocumentType.EnrollmentDocumentType,
EnrollmentDocumentTypeID = a.LookupEnrollmentDocumentTypeID
}).ToList();
//List<File> AllFiles = new List<File>();
foreach (var obj in ListOfFiles)
{
EF.Add(new EnrollmentFiles()
{
FileID = obj.FileID,
FileName = obj.FileName,
FileExtension = obj.FileExtension,
EnrollmentDocumentTypeID = obj.EnrollmentDocumentTypeID,
EnrollentDocumentType = obj.EnrollentDocumentType
});
}
}
enrollmentFilesBindingSource.DataSource = EF;
};
}
private void frmApprenticeshipEnrollmentFormV2_FormClosing(object sender, FormClosingEventArgs e)
{
if (MustSaveItems)
{
using (var Dbconnection = new MCDEntities())
{
using (System.Data.Entity.DbContextTransaction dbTran = Dbconnection.Database.BeginTransaction())
{
try
{
//CRUD Operations
///Step 1 Begin - Saves Main Enrollment
Dbconnection.Students.Attach(CurrentEnrollment.StudentEnrollment.Student);
Dbconnection.Entry(CurrentEnrollment.ApprienticeshipEnrollment).State = EntityState.Added;
Dbconnection.Entry(CurrentEnrollment).State = EntityState.Added;
Dbconnection.Entry(CurrentEnrollment.StudentEnrollment).State = EntityState.Added;
Dbconnection.Entry(CurrentEnrollment.StudentEnrollment.Student).State = EntityState.Unchanged;
foreach (EnrollmentDocument ED in CurrentEnrollment.EnrollmentDocuments)
{
Dbconnection.Entry(ED).State = EntityState.Added;
Dbconnection.Entry(ED.File).State = EntityState.Added;
// ED.LookupEnrollentDocumentType = null;
Dbconnection.LookupEnrollentDocumentTypes.Attach(ED.LookupEnrollentDocumentType);
Dbconnection.Entry(ED.LookupEnrollentDocumentType).State = EntityState.Unchanged;
}
CurrentEnrollment.ProgressFileID = Impendulo.Common.Verifiction.OfProgressFiles.VerifyStudentProgressFile(CurrentEnrollment.StudentEnrollment.StudentID);
Dbconnection.Enrollments.Add(CurrentEnrollment);
Dbconnection.SaveChanges();
if (IsCompanyEnrollment)
{
Common.Verifiction.OfProgressFiles.VerifyCompanyStudentProgressFile(CurrentEnrollment.StudentEnrollment.StudentID, this.CompanyProgressFileID);
}
//End Step 1
//Step 2 Get PreRequiestes Courses and and load them with the main enrollment
List <CurriculumPrequisiteCourse> CPC = (from a in Dbconnection.CurriculumPrequisiteCourses
where a.CurriculumID == CurrentEnquiry.CurriculumID
select a)
.Include("CurriculumCourse")
.ToList <CurriculumPrequisiteCourse>();
//Get All The Possible Cuuriculum that for partof the Pre-Requisites
List <int> PreRequisiteCurriculumID = (from a in CPC
select a.CurriculumCourse.CurriculumID)
.Distinct <int>()
.ToList <int>();
//Create Enrollment for each possible Curriculum that that forms part of the list pre-requisite Courses.
foreach (int CurriculumIDForPreRquisiteCourseEnrollment in PreRequisiteCurriculumID)
{
//Creates a Enrollment Enrty for the Curriculum
Data.Models.Enrollment PreRequisisteCourseEnrollment = new Data.Models.Enrollment
{
EnrolmentParentID = CurrentEnrollment.EnrollmentID,
EnquiryID = this.CurrentEnquiry.EnquiryID,
ProgressFileID = CurrentEnrollment.ProgressFileID,
LookupEnrollmentProgressStateID = (int)EnumEnrollmentProgressStates.New_Enrollment,
CurriculumID = CurriculumIDForPreRquisiteCourseEnrollment,
StudentEnrollment = new StudentEnrollment()
{
StudentID = CurrentEnrollment.StudentEnrollment.StudentID,
DateUpdated = DateTime.Now
},
DateIntitiated = DateTime.Now,
EnrollmentExcempt = false
};
Dbconnection.Enrollments.Add(PreRequisisteCourseEnrollment);
Dbconnection.SaveChanges();
//links each pre-Requisite Course to the Curriculum Linked.
foreach (CurriculumCourse CurriculumCourseToLink in (from a in CPC
where a.CurriculumCourse.CurriculumID == CurriculumIDForPreRquisiteCourseEnrollment
select a.CurriculumCourse)
.Distinct <CurriculumCourse>().
ToList <CurriculumCourse>())
{
Dbconnection.CurriculumCourseEnrollments.Add(new CurriculumCourseEnrollment
{
LookupEnrollmentProgressStateID = (int)EnumEnrollmentProgressStates.New_Enrollment,
CurriculumCourseID = CurriculumCourseToLink.CurriculumCourseID,
EnrollmentID = PreRequisisteCourseEnrollment.EnrollmentID,
CourseCost = CurriculumCourseToLink.Cost // Set the linked course to the default Cost for the course
});
}
//Saves the sub set of Pre-Requisite Curriculum and linked courses.
Dbconnection.SaveChanges();
}
EquiryHistory hist = new EquiryHistory
{
EnquiryID = CurrentEnquiry.EnquiryID,
EmployeeID = CurrentEmployeeLoggedIn.EmployeeID,
LookupEquiyHistoryTypeID = (int)EnumEquiryHistoryTypes.Enrollment_Student_Successfully_Enrolled,
DateEnquiryUpdated = DateTime.Now,
EnquiryNotes = "Initial Enrollment Completed Successfully for the the Following Individual - " + CurrentEnrollment.StudentEnrollment.Student.Individual.FullName.ToString() + "\n Enquiry Ref# - " + CurrentEnquiry.EnquiryID
};
Dbconnection.EquiryHistories.Add(hist);
////saves all above operations within one transaction
Dbconnection.SaveChanges();
//commit transaction
dbTran.Commit();
IsSuccessfullySaved = true;
}
catch (Exception ex)
{
if (ex is DbEntityValidationException)
{
foreach (DbEntityValidationResult entityErr in ((DbEntityValidationException)ex).EntityValidationErrors)
{
foreach (DbValidationError error in entityErr.ValidationErrors)
{
//MessageBox.Show(error.ErrorMessage, "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
MetroMessageBox.Show(this, error.ErrorMessage, "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
//MessageBox.Show(ex.Message, "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
MetroMessageBox.Show(this, ex.Message, "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Rollback transaction if exception occurs
dbTran.Rollback();
}
}
};
}
}
