public frmEnrollmentSelectionForEquiry(Data.Models.Enquiry EnquiryObj)
{
this.CurrentlySelectedEnquiry = EnquiryObj;
InitializeComponent();
//this.CurrentlySelectedCurriculumEnquiry = CurrentlySelectedCurriculumEnquiry;
SelectedEnrollmentID = 0;
}
private void btnUpdateCurriculumEnquiryItemEnrollmentQty_Click(object sender, EventArgs e)
{
using (frmUpdateSelectedCurriculumEnrollQty frm = new frmUpdateSelectedCurriculumEnrollQty())
{
//CurriculumEnquiry CE = (CurriculumEnquiry)curriculumEnquiryInprogressBindingSource.Current;
using (var Dbconnection = new MCDEntities())
{
Data.Models.Enquiry EnquiryObj = (Data.Models.Enquiry)enquiryInprogressBindingSource.Current;
Dbconnection.Enquiries.Attach(EnquiryObj);
//Dbconnection.Entry(CE).Collection(a => a.Enrollments).Load();
};
//int EnrollomentQty = CE.Enrollments.Where(a => a.EnrolmentParentID == 0).Count() + 1;
//frm.nudQtyToEnroll.Minimum = EnrollomentQty;
//frm.nudQtyToEnroll.Value = EnrollomentQty;
//frm.CurrentCurriculumEnquiry = CE;
frm.ShowDialog();
//any change to the Qty will be saved.
using (var Dbconnection = new MCDEntities())
{
//Dbconnection.CurriculumEnquiries.Attach(CE);
//Dbconnection.Entry(CE).State = EntityState.Modified;
Dbconnection.SaveChanges();
};
this.curriculumEnquiryInprogressBindingSource.ResetCurrentItem();
//this.refreshInProgressEnquiry(CurrentSelectedEnquiryID);
}
}
public frmApprenticeshipEnrollmentFormV2(Data.Models.Enquiry CurrentEnquiry, Boolean bIsCompanyEnrollment, int CompanyProgressFileID = 0)
{
this._CurrentEnquiry = CurrentEnquiry;
this.IsCompanyEnrollment = IsCompanyEnrollment;
this.CompanyProgressFileID = CompanyProgressFileID;
this.CurrentEnrollment = new Data.Models.Enrollment()
{
EnrolmentParentID = 0,
EnquiryID = this.CurrentEnquiry.EnquiryID,
ProgressFileID = 0,
EnrollmentExcempt = false,
LookupEnrollmentProgressStateID = (int)Common.Enum.EnumEnrollmentProgressStates.New_Enrollment,
CurriculumID = CurrentEnquiry.CurriculumID,
DateIntitiated = DateTime.Now.Date,
ApprienticeshipEnrollment = new ApprienticeshipEnrollment()
{
DateUpdated = DateTime.Now.Date,
LookupSectionalEnrollmentTypeID = (int)EnumSectionalEnrollmentTypes.Section_13
}
};
InitializeComponent();
//this.txtSummaryFinaciallyResponsible.Text = "Private";
lblSummaryEnrollmentSelectionType.Text = lblCurentlySelectedEnrollmentType.Text;
IsSuccessfullySaved = false;
}
public frmNewEnquiry()
{
InitializeComponent();
CurrentEnquiry = new Data.Models.Enquiry
{
EnquiryDate = DateTime.Now
};
}
public frmNewEnquiry()
{
InitializeComponent();
CurrentEnquiry = new Data.Models.Enquiry
{
EnquiryDate = DateTime.Now,
EnquiryStatusID = (int)EnumEnquiryStatuses.New
};
}
/// <summary>
/// Attachs the Selected Enquiry and updates the status of the
/// Equiry's Curriculum Enquiry to "Enrollment In Progress"
/// and then save the update and referesh the list of NEW Quiries
/// in the datagridview.
/// </summary>
/// <param name="SelectedEnquiry"></param>
private void acceptNewEnquiry(Data.Models.Enquiry SelectedEnquiry)
{
using (var Dbconnection = new MCDEntities())
{
Dbconnection.Enquiries.Attach(SelectedEnquiry);
//Gets the Curriculum Enquiry details
CurriculumEnquiry SelectedCurriculumEnquiry = SelectedEnquiry.CurriculumEnquiries.FirstOrDefault <CurriculumEnquiry>();
};
}
private void enquiryInprogressBindingSource_BindingComplete(object sender, BindingCompleteEventArgs e)
{
Data.Models.Enquiry EnquiryObj = (Data.Models.Enquiry)(enquiryInprogressBindingSource.Current);
if (EnquiryObj != null)
{
if (EnquiryObj.Companies.Count == 0)
{
txtInprogressCompanyName.Text = "NA - Private Enquiry";
}
}
}
private void populateInprogressEnquiry(int _EnquiryID)
{
using (var Dbconnection = new MCDEntities())
{
Data.Models.Enquiry x = (from a in Dbconnection.Enquiries
where a.EnquiryID == _EnquiryID
&& a.EnquiryStatusID != (int)EnumEnquiryStatuses.Enquiry_Closed
select a)
.Include("Individuals")
.Include("Individuals.ContactDetails")
.Include("Individuals.ContactDetails.LookupContactType")
.Include("CurriculumEnquiries")
.Include("CurriculumEnquiries.Curriculum")
.Include("Companies")
.FirstOrDefault<Data.Models.Enquiry>();
if (x != null)
{
////filter out closed enquiries.
List<CurriculumEnquiry> DataSourceList;
//Filters the Curriculum Enquiry for the current Loggin Employee (Only The One THat they May View).
DataSourceList = new List<CurriculumEnquiry>();
foreach (CurriculumEnquiry CE in x.CurriculumEnquiries)
{
if (DetermineIfPartOfDepartment(CE.Curriculum.DepartmentID))
{
//if (CE.EnquiryStatusID != (int)EnumEnquiryStatuses.Enquiry_Closed)
//{
DataSourceList.Add(CE);
//}
}
}
x.CurriculumEnquiries.Clear();
foreach (CurriculumEnquiry CE in DataSourceList)
{
x.CurriculumEnquiries.Add(CE);
}
CurrentSelectedEnquiryID = x.EnquiryID;
enquiryInprogressBindingSource.DataSource = x;
}
else
{
enquiryInprogressBindingSource.Clear();
contactDetailsInprogressBindingSource.Clear();
curriculumEnquiryInprogressBindingSource.Clear();
}
};
}
private void dgvEquirySearchResults_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
var gridView = (DataGridView)sender;
foreach (DataGridViewRow row in gridView.Rows)
{
if (!row.IsNewRow)
{
Data.Models.Enquiry EnquiryObj = (Data.Models.Enquiry)(row.DataBoundItem);
row.Cells[colEnquiryStatus.Index].Value = EnquiryObj.LookupEnquiryStatus.EnquiryStatus.ToString();
}
}
}
private void btnInProgressChangeContact_Click(object sender, EventArgs e)
{
if (((Data.Models.Enquiry)enquiryInprogressBindingSource.Current).Companies.Count > 0)
{
using (frmSelectCompanyContact frm = new frmSelectCompanyContact())
{
Data.Models.Enquiry _CurentSelectedEnquiry = (Data.Models.Enquiry)enquiryInprogressBindingSource.Current;
using (var Dbconnection = new MCDEntities())
{
Dbconnection.Enquiries.Attach(_CurentSelectedEnquiry);
Dbconnection.Entry(_CurentSelectedEnquiry).Collection(a => a.Companies).Load();
frm.CurrentCompany = ((Data.Models.Enquiry)enquiryInprogressBindingSource.Current).Companies.FirstOrDefault<Data.Models.Company>();
frm.ShowDialog();
if (frm.SelectedIndividual != null)
{
Individual CurrentEnquiryContact = ((Data.Models.Enquiry)enquiryInprogressBindingSource.Current).Individuals.FirstOrDefault<Individual>();
//REmove C=urrent Contact
Dbconnection.Enquiries.Attach(_CurentSelectedEnquiry);
_CurentSelectedEnquiry.Individuals.Remove(CurrentEnquiryContact);
Dbconnection.SaveChanges();
//Link Selected Contact
Dbconnection.Individuals.Attach(frm.SelectedIndividual);
_CurentSelectedEnquiry.Individuals.Add(frm.SelectedIndividual);
Dbconnection.SaveChanges();
};
//REfresh Enquiry
this.refreshInProgressEnquiry(CurrentSelectedEnquiryID);
}
}
}
else
{
MetroMessageBox.Show(this, "Can Only Change Company Contacts, Not Private Contacts", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void NewEnquiryTab_NewEnquiryBindingSource_PositionChanged(object sender, EventArgs e)
{
Data.Models.Enquiry EnquiryObj = (Data.Models.Enquiry)(NewEnquiryTab_NewEnquiryBindingSource.Current);
if (EnquiryObj != null)
{
if (EnquiryObj != null)
{
if (EnquiryObj.Companies.Count == 0)
{
txtNewEnquiryTab_CompanyName.Text = "NA - Private Enquiry";
}
}
}
}
private void dgvNewEnquiryTab_NewEnquiry_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
Data.Models.Enquiry En = null;
if (curriculumEnquiriesBindingSource.List.Count > 0)
{
En = (Data.Models.Enquiry)dgvNewEnquiryTab_NewEnquiry.Rows[e.RowIndex].DataBoundItem;
}
switch (e.ColumnIndex)
{
case 2:
if (En != null)
{
if (!(Boolean)En.InitialConsultationComplete)
{
DialogResult Rtn1 = MessageBox.Show("Is Intial Consultation Completed?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (Rtn1 == DialogResult.Yes)
{
frmEnquiryInitialConsultation frm3 = new frmEnquiryInitialConsultation();
frm3.CurrentEnquiry = En;
frm3.EmployeeID = CurrentEmployeeLoggedIn.EmployeeID;
frm3.ShowDialog();
dgvNewEnquiryTab_NewEnquiry.Refresh();
}
}
else
{
MessageBox.Show("Consultation Already Completed,See History.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
break;
//SEnd Email Message
case 4:
frmSendEmail frm = new frmSendEmail();
frm.ShowDialog();
if (dgvNewEnquiryTab_CurriculumEnquiry.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString() == "Send Mail")
{
}
break;
}
}
private void btnAddSelectedCurriculum_Click(object sender, EventArgs e)
{
Data.Models.Enquiry NewEnquiry = new Data.Models.Enquiry()
{
ProgressFileID = this.ProgressFileID,
EnquiryDate = DateTime.Now,
EnquiryStatusID = (int)Common.Enum.EnumEnquiryStatuses.New,
InitialConsultationComplete = false,
InitialCurriculumEnquiryDocumentationSent = false,
CurriculumID = CurrentlySelectedCurriculumFromForm.CurriculumID,
LastUpdated = DateTime.Now,
EnrollmentQuanity = (int)nudQtyToEnroll.Value,
};
CurrentlySelectedCurriculum.Add(CurrentlySelectedCurriculumFromForm);
EL.Add(NewEnquiry);
this.resetCurriculumSelectionControls();
this.refreshSelectedEnqiuries();
}
public frmEnquiryInitialConsultation(Data.Models.Enquiry CurrentEnquiry)
{
this.CurrentEnquiry = CurrentEnquiry;
InitializeComponent();
}
private void dgvInProgressCurriculumEnquiries_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
Data.Models.Enquiry CurrentEnquiry = (Data.Models.Enquiry)enquiryInprogressBindingSource.Current;
CurriculumEnquiry CE = (CurriculumEnquiry)dgvInProgressCurriculumEnquiries.Rows[e.RowIndex].DataBoundItem;
switch (e.ColumnIndex)
{
case 1:
if (CE.EnquiryStatusID != (int)EnumEnquiryStatuses.Enquiry_Closed)
{
DialogResult Rtn = MessageBox.Show("Are you sure that you wish to Close this Enquiry Item?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (Rtn == DialogResult.Yes)
{
using (var Dbconnection = new MCDEntities())
{
Dbconnection.CurriculumEnquiries.Attach(CE);
CE.EnquiryStatusID = (int)EnumEnquiryStatuses.Enquiry_Closed;
CE.LastUpdated = DateTime.Now;
Dbconnection.Entry <CurriculumEnquiry>(CE).State = System.Data.Entity.EntityState.Modified;
Dbconnection.SaveChanges();
EquiryHistory hist = new EquiryHistory
{
EnquiryID = CurrentEnquiry.EnquiryID,
EmployeeID = this.CurrentEmployeeLoggedIn.EmployeeID,
LookupEquiyHistoryTypeID = (int)EnumEquiryHistoryTypes.Curriculum_Enquiry_Item_Closed,
DateEnquiryUpdated = DateTime.Now,
EnquiryNotes = "Curriculum Enquiry Line Item Closed, Item Removed - " + CE.Curriculum.CurriculumName + "- For Enquiry Ref: " + CurrentEnquiry.EnquiryID
};
Dbconnection.EquiryHistories.Add(hist);
int IsSaved = Dbconnection.SaveChanges();
refreshInProgressEnquiry(CurrentSelectedEnquiryID);
};
}
}
else
{
DialogResult Rtn = MessageBox.Show("Are you sure that you wish to Close this Enquiry Item?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (Rtn == DialogResult.Yes)
{
using (var Dbconnection = new MCDEntities())
{
Dbconnection.CurriculumEnquiries.Attach(CE);
CE.EnquiryStatusID = (int)EnumEnquiryStatuses.Enrollment_In_Progress;
CE.LastUpdated = DateTime.Now;
Dbconnection.Entry <CurriculumEnquiry>(CE).State = System.Data.Entity.EntityState.Modified;
Dbconnection.SaveChanges();
EquiryHistory hist = new EquiryHistory
{
EnquiryID = CurrentEnquiry.EnquiryID,
EmployeeID = this.CurrentEmployeeLoggedIn.EmployeeID,
LookupEquiyHistoryTypeID = (int)EnumEquiryHistoryTypes.Curriculum_Enquiry_Item_Reinstated,
DateEnquiryUpdated = DateTime.Now,
EnquiryNotes = "Curriculum Enquiry Line Item Reinstated, Item Reinstated - " + CE.Curriculum.CurriculumName + "- For Enquiry Ref: " + CurrentEnquiry.EnquiryID
};
Dbconnection.EquiryHistories.Add(hist);
int IsSaved = Dbconnection.SaveChanges();
refreshInProgressEnquiry(CurrentSelectedEnquiryID);
};
}
}
break;
case 6:
if (CE.Curriculum.DepartmentID == (int)EnumDepartments.Apprenticeship)
{
using (var Dbconnection = new MCDEntities())
{
Dbconnection.CurriculumEnquiries.Attach(CE);
if (!(Dbconnection.Entry(CE).Collection(a => a.Enrollments).IsLoaded))
{
Dbconnection.Entry(CE).Collection(a => a.Enrollments).Load();
}
};
if (CE.EnrollmentQuanity > CE.Enrollments.Count)
{
using (frmApprenticeshipEnrollmentForm frm = new frmApprenticeshipEnrollmentForm())
{
frm.CurrentCurriculumEnquiry = CE;
frm.ShowDialog();
curriculumEnquiryInprogressBindingSource.ResetCurrentItem();
//this.refreshInProgressEnquiry(CurrentSelectedEnquiryID);
if (frm.IsSuccessfullySaved)
{
DialogResult Rtn1 = MessageBox.Show("Do you wish to process this new enrollment now?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (Rtn1 == DialogResult.Yes)
{
using (frmEnrolmmentInprogress frmInner = new frmEnrolmmentInprogress())
{
frmInner.CurrentEmployeeLoggedIn = this.CurrentEmployeeLoggedIn;
frmInner.CurrentSelectedDepartment = (Common.Enum.EnumDepartments)CE.Curriculum.DepartmentID;
// frmStudentCourseEnrollmentV2 frm7 = new frmStudentCourseEnrollmentV2();
frmInner.ShowDialog();
}
}
}
}
}
}
break;
case 7:
//ensure that the Enrollments are refershed
using (var Dbconnection = new MCDEntities())
{
Dbconnection.CurriculumEnquiries.Attach(CE);
if (!(Dbconnection.Entry(CE).Collection(a => a.Enrollments).IsLoaded))
{
Dbconnection.Entry(CE).Collection(a => a.Enrollments).Load();
}
};
//IF any enrollments exists then open Selection list else Do Nothing.
if (CE.Enrollments.Count > 0)
{
//Open thje list of linked Enrollments that are in progress
using (frmEnrollmentSelectionForEquiry frm = new frmEnrollmentSelectionForEquiry())
{
frm.SelectedCurriculumEnquiryID = CE.CurriculumEnquiryID;
frm.ShowDialog();
if (frm.SelectedEnrollmentID != 0)
{
using (frmEnrolmmentInprogress innerFrm = new frmEnrolmmentInprogress())
{
innerFrm.CurrentEmployeeLoggedIn = this.CurrentEmployeeLoggedIn;
innerFrm.CurrentSelectedDepartment = (Common.Enum.EnumDepartments)CE.Curriculum.DepartmentID;
innerFrm.CurrentEnrollmentID = frm.SelectedEnrollmentID;
innerFrm.ShowDialog();
}
}
}
}
else
{
MessageBox.Show("There are currently no enrollments for this enquiry.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
break;
}
}
private void dgvNewEnquiryTab_CurriculumEnquiry_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
//colNewEnquiry_Curriculum.Name
//dgvNewEnquiryTab_CurriculumEnquiry.Rows[e.RowIndex].Cells[e.ColumnIndex].
//row.Cells[colNewEnquiry_Curriculum.Index].Value
// MessageBox.Show("Col Index : " + dgvNewEnquiryTab_CurriculumEnquiry.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString());
CurriculumEnquiry CE = (CurriculumEnquiry)dgvNewEnquiryTab_CurriculumEnquiry.Rows[e.RowIndex].DataBoundItem;
Data.Models.Enquiry CurrentEnquiryObj = (Data.Models.Enquiry)NewEnquiryTab_NewEnquiryBindingSource.Current;
switch (e.ColumnIndex)
{
case 1:
//Close the enquiry
DialogResult Rtn = MessageBox.Show("Are you Sure that you wish to Close this Enquiry?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (Rtn == DialogResult.Yes)
{
using (var Dbconnection = new MCDEntities())
{
Dbconnection.CurriculumEnquiries.Attach(CE);
CE.EnquiryStatusID = (int)EnumEnquiryStatuses.Enquiry_Closed;
CE.LastUpdated = DateTime.Now;
Dbconnection.Entry <CurriculumEnquiry>(CE).State = System.Data.Entity.EntityState.Modified;
Dbconnection.SaveChanges();
Dbconnection.CurriculumEnquiries.Remove(CE);
};
}
if (curriculumEnquiriesBindingSource.Count == 0)
{
refreshNewEnquiry();
}
break;
//Accept the Enquiry
case 2:
using (frmSendEmail frm = new frmSendEmail())
{
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: ( " + CE.EnquiryID + "-" + CE.CurriculumEnquiryID + " ) Enquiry Feed Back";
frm.ShowDialog();
using (var Dbconnection = new MCDEntities())
{
EquiryHistory hist = new EquiryHistory
{
EnquiryID = CE.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();
if (IsSaved > 0)
{
Dbconnection.CurriculumEnquiries.Attach(CE);
CE.LastUpdated = DateTime.Now;
Dbconnection.Entry <CurriculumEnquiry>(CE).State = EntityState.Modified;
Dbconnection.SaveChanges();
}
dgvNewEnquiryTab_CurriculumEnquiry.Refresh();
};
}
break;
//Close the Equiry
case 3:
frmEnquiryViewHistory frm5 = new frmEnquiryViewHistory();
frm5.CurrentEnquiryID = CurrentEnquiryObj.EnquiryID;
frm5.ShowDialog();
break;
case 8:
if (CurrentEnquiryObj.InitialConsultationComplete)
{
if (!CE.InitialCurriculumEnquiryDocumentationSent)
{
frmInitailDocumentation frm3 = new frmInitailDocumentation();
frm3.ShowDialog();
if (!frm3.IsCanceled)
{
if (frm3.UseEmail)
{
frmSendEmail frm1 = new frmSendEmail();
List <ContactDetail> you = (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 you)
{
if (frm1.txtTestingToAddress.Text.Length > 0)
{
frm1.txtTestingToAddress.Text += ";";
}
frm1.txtTestingToAddress.Text += ConDetObj.ContactDetailValue;
}
frm1.txtTestSubject.Text = "Enquiry No: ( " + CurrentEnquiryObj.EnquiryID + "-" + CE.CurriculumEnquiryID + " ) Enquiry Feed Back";
using (var Dbconnection = new MCDEntities())
{
List <MessageTemplate> MT = (from a in Dbconnection.MessageTemplates
from b in a.Files
where a.ProcessStepID == (int)EnumProcessSteps.Enquiry__Apprenticeship__Step_1__Documentation_To_Send
select a).ToList <MessageTemplate>();
MessageTemplate CurrentMessageTemplate = MT.FirstOrDefault <MessageTemplate>();
string Mess = "Good Day " + txtNewEnquiryTab_ContactPersonTitle.Text + " " + txtNewEnquiryTab_ContactPersonFirstName.Text + " " + txtNewEnquiryTab_ContactPersonLastName.Text + "\n \n";
frm1.txtTestMessage.Text = "Please Reference the Following Line Equiry Number when returning any documentation: \n" +
"Enquiry No " + CE.EnquiryID + "-" + CE.CurriculumEnquiryID + "\n" + Mess + CurrentMessageTemplate.Message;
foreach (MessageTemplate MTObj in MT)
{
foreach (Data.Models.File FileObj in MTObj.Files)
{
frm1.AttachmentsUsingDbImageFileID.Add(FileObj.FileID);
}
}
};
frm1.ShowDialog();
using (var Dbconnection = new MCDEntities())
{
EquiryHistory hist = new EquiryHistory
{
EnquiryID = CE.EnquiryID,
EmployeeID = this.CurrentEmployeeLoggedIn.EmployeeID,
LookupEquiyHistoryTypeID = (int)EnumEquiryHistoryTypes.Enquiry_Initial_Documentation_Sent,
DateEnquiryUpdated = DateTime.Now,
EnquiryNotes = "Documentation Sent To Client Via Email"
};
Dbconnection.EquiryHistories.Add(hist);
int IsSaved = Dbconnection.SaveChanges();
if (IsSaved > 0)
{
Dbconnection.CurriculumEnquiries.Attach(CE);
CE.InitialCurriculumEnquiryDocumentationSent = true;
CE.LastUpdated = DateTime.Now;
Dbconnection.Entry <CurriculumEnquiry>(CE).State = EntityState.Modified;
Dbconnection.SaveChanges();
}
dgvNewEnquiryTab_CurriculumEnquiry.Refresh();
};
}
else
{
using (var Dbconnection = new MCDEntities())
{
EquiryHistory hist = new EquiryHistory
{
EnquiryID = CE.EnquiryID,
EmployeeID = this.CurrentEmployeeLoggedIn.EmployeeID,
LookupEquiyHistoryTypeID = (int)EnumEquiryHistoryTypes.Enquiry_Initial_Documentation_Sent,
DateEnquiryUpdated = DateTime.Now,
EnquiryNotes = "Documentation Manually Given To Client"
};
Dbconnection.EquiryHistories.Add(hist);
int IsSaved = Dbconnection.SaveChanges();
if (IsSaved > 0)
{
Dbconnection.CurriculumEnquiries.Attach(CE);
CE.InitialCurriculumEnquiryDocumentationSent = true;
CE.LastUpdated = DateTime.Now;
Dbconnection.Entry <CurriculumEnquiry>(CE).State = EntityState.Modified;
Dbconnection.SaveChanges();
dgvNewEnquiryTab_CurriculumEnquiry.Refresh();
}
};
}
}
}
else
{
MessageBox.Show("Documentation Already Sent,\nUse Send Mail Option to send additional Mail.\nSee History For Details.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("Initial Contsultation Not Completed!", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
break;
case 10:
if (CE.Curriculum.DepartmentID == (int)EnumDepartments.Apprenticeship)
{
if (CE.EnrollmentQuanity >= CE.Enrollments.Count)
{
frmApprenticeshipEnrollmentFormV2 frm6 = new frmApprenticeshipEnrollmentFormV2();
frm6.CurrentCurriculumEnquiry = CE;
curriculumEnquiriesBindingSource.ResetItem(e.RowIndex);
frm6.ShowDialog();
//Check to see if the amoount required to be enrolled equal the amount that have been enrolled.
//if (CE.EnrollmentQuanity <= CE.Enrollments.Count)
//{
// using (var Dbconnection = new MCDEntities())
// {
// Dbconnection.CurriculumEnquiries.Attach(CE);
// CE.EnquiryStatusID = (int)EnumEnquiryStatuses.Enquiry_Closed;
// CE.LastUpdated = DateTime.Now;
// Dbconnection.Entry<CurriculumEnquiry>(CE).State = System.Data.Entity.EntityState.Modified;
// Dbconnection.SaveChanges();
// Dbconnection.CurriculumEnquiries.Remove(CE);
// int currentIndex = NewEnquiryTab_NewEnquiryBindingSource.Position;
// refreshNewEnquiry();
// NewEnquiryTab_NewEnquiryBindingSource.Position = currentIndex;
// dgvNewEnquiryTab_CurriculumEnquiry.Refresh();
// };
//}
DialogResult Rtn1 = MessageBox.Show("Do you wish to View the Enrollment,and course selection?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (Rtn1 == DialogResult.Yes)
{
using (frmEnrolmmentInprogress frm = new frmEnrolmmentInprogress())
{
frm.CurrentEmployeeLoggedIn = this.CurrentEmployeeLoggedIn;
frm.CurrentSelectedDepartment = (Common.Enum.EnumDepartments)CE.Curriculum.DepartmentID;
// frmStudentCourseEnrollmentV2 frm7 = new frmStudentCourseEnrollmentV2();
frm.ShowDialog();
}
}
}
}
//frm6.CurrentEnrollments.ApprienticeshipEnrollment.(CE);
break;
case 11:
using (frmEnrollmentSelectionForEquiry frm = new frmEnrollmentSelectionForEquiry())
{
frm.SelectedCurriculumEnquiryID = CE.CurriculumEnquiryID;
frm.ShowDialog();
if (frm.SelectedEnrollmentID != 0)
{
using (frmEnrolmmentInprogress innerFrm = new frmEnrolmmentInprogress())
{
innerFrm.CurrentEmployeeLoggedIn = this.CurrentEmployeeLoggedIn;
innerFrm.CurrentSelectedDepartment = (Common.Enum.EnumDepartments)CE.Curriculum.DepartmentID;
innerFrm.CurrentEnrollmentID = frm.SelectedEnrollmentID;
innerFrm.ShowDialog();
}
}
}
break;
}
}
private void dgvNewEnquiryCurrent_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
//toolStrip1 catch which of the options where selected
switch (e.ColumnIndex)
{
//Accept the Enquiry
case 1:
frmEnquiryViewContactInformation frm = new frmEnquiryViewContactInformation();
frm.CurrentEnquiry = (Data.Models.Enquiry)NewEnquiryWorkbench_NewEnquiryBindingSource.Current;
frm.ShowDialog();
break;
//Close the Equiry
case 2:
frmEmailMessageV2 frm1 = new frmEmailMessageV2();
Data.Models.Enquiry CurrentEnquiryObj = (Data.Models.Enquiry)NewEnquiryWorkbench_NewEnquiryBindingSource.Current;
List <ContactDetail> you = (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 you)
//{
// if (frm1.txtTestingToAddress.Text.Length > 0)
// {
// frm1.txtTestingToAddress.Text += ";";
// }
// frm1.txtTestingToAddress.Text += ConDetObj.ContactDetailValue;
//}
using (var Dbconnection = new MCDEntities())
{
List <MessageTemplate> MT = (from a in Dbconnection.MessageTemplates
from b in a.Files
where a.ProcessStepID == (int)EnumProcessSteps.Enquiry__Apprenticeship__Step_1__Documentation_To_Send
select a).ToList <MessageTemplate>();
MessageTemplate CurrentMessageTemplate = MT.FirstOrDefault <MessageTemplate>();
//frm1.txtTestMessage.Text = CurrentMessageTemplate.Message;
//foreach (MessageTemplate MTObj in MT)
//{
// foreach (Data.Models.File FileObj in MTObj.Files)
// {
// frm1.AttachmentsUsingDbImageFileID.Add(FileObj.FileID);
// }
//}
};
frm1.ShowDialog();
break;
//SEnd Email Message
case 3:
break;
//View Enquiry History
case 4:
break;
}
}
private void dgvInProgressCurriculumEnquiries_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
Data.Models.Enquiry CurrentEnquiry = (Data.Models.Enquiry)enquiryInprogressBindingSource.Current;
//CurriculumEnquiry CE = (CurriculumEnquiry)dgvInProgressCurriculumEnquiries.Rows[e.RowIndex].DataBoundItem;
switch (e.ColumnIndex)
{
case 1:
if (true) //CE.EnquiryStatusID != (int)EnumEnquiryStatuses.Enquiry_Closed)
{
DialogResult Rtn = MessageBox.Show("Are you sure that you wish to Close this Enquiry Item?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (Rtn == DialogResult.Yes)
{
using (var Dbconnection = new MCDEntities())
{
//Dbconnection.CurriculumEnquiries.Attach(CE);
//CE.EnquiryStatusID = (int)EnumEnquiryStatuses.Enquiry_Closed;
//CE.LastUpdated = DateTime.Now;
//Dbconnection.Entry<CurriculumEnquiry>(CE).State = System.Data.Entity.EntityState.Modified;
Dbconnection.SaveChanges();
EquiryHistory hist = new EquiryHistory
{
EnquiryID = CurrentEnquiry.EnquiryID,
EmployeeID = this.CurrentEmployeeLoggedIn.EmployeeID,
LookupEquiyHistoryTypeID = (int)EnumEquiryHistoryTypes.Curriculum_Enquiry_Item_Closed,
DateEnquiryUpdated = DateTime.Now,
//EnquiryNotes = "Curriculum Enquiry Line Item Closed, Item Removed - " + CE.Curriculum.CurriculumName + "- For Enquiry Ref: " + CurrentEnquiry.EnquiryID
};
Dbconnection.EquiryHistories.Add(hist);
int IsSaved = Dbconnection.SaveChanges();
refreshInProgressEnquiry(CurrentSelectedEnquiryID);
};
}
}
else
{
DialogResult Rtn = MessageBox.Show("Are you sure that you wish to Re-Instate this Enquiry Item?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (Rtn == DialogResult.Yes)
{
using (var Dbconnection = new MCDEntities())
{
//Dbconnection.CurriculumEnquiries.Attach(CE);
//CE.EnquiryStatusID = (int)EnumEnquiryStatuses.Enrollment_In_Progress;
//CE.LastUpdated = DateTime.Now;
//Dbconnection.Entry<CurriculumEnquiry>(CE).State = System.Data.Entity.EntityState.Modified;
Dbconnection.SaveChanges();
EquiryHistory hist = new EquiryHistory
{
EnquiryID = CurrentEnquiry.EnquiryID,
EmployeeID = this.CurrentEmployeeLoggedIn.EmployeeID,
LookupEquiyHistoryTypeID = (int)EnumEquiryHistoryTypes.Curriculum_Enquiry_Item_Reinstated,
DateEnquiryUpdated = DateTime.Now,
//EnquiryNotes = "Curriculum Enquiry Line Item Reinstated, Item Reinstated - " + CE.Curriculum.CurriculumName + "- For Enquiry Ref: " + CurrentEnquiry.EnquiryID
};
Dbconnection.EquiryHistories.Add(hist);
int IsSaved = Dbconnection.SaveChanges();
refreshInProgressEnquiry(CurrentSelectedEnquiryID);
};
}
}
break;
case 6:
//if (CE.Curriculum.DepartmentID == (int)EnumDepartments.Apprenticeship)
//{
if (((Data.Models.Enquiry)enquiryInprogressBindingSource.Current).InitialConsultationComplete)
{
//gbInProgressEnquiryEnrrolmentQueries.Enabled = true;
DialogResult Rtn = MessageBox.Show("Do you have a copy of the individuals ID document or relevant details, These details are rquired to process initial enrollment! Else Select No and send an email Notification to the contact requesting these details.", "ID Document Requirement", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (Rtn == DialogResult.Yes)
{
using (var Dbconnection = new MCDEntities())
{
//Dbconnection.CurriculumEnquiries.Attach(CE);
//if (!(Dbconnection.Entry(CE).Collection(a => a.Enrollments).IsLoaded))
//{
// Dbconnection.Entry(CE).Collection(a => a.Enrollments).Load();
//}
};
if (true) //CE.EnrollmentQuanity > CE.Enrollments.Where(a => a.EnrolmentParentID == 0).Count())
{
using (frmApprenticeshipEnrollmentFormV2 frm = new frmApprenticeshipEnrollmentFormV2(null, false))
{
//frm.CurrentCurriculumEnquiry = CE;
frm.ShowDialog();
//CE.Enrollments.Add(frm.CurrentEnrollment);
curriculumEnquiryInprogressBindingSource.ResetCurrentItem();
//this.refreshInProgressEnquiry(CurrentSelectedEnquiryID);
if (frm.IsSuccessfullySaved)
{
DialogResult Rtn1 = MessageBox.Show("Do you wish to process this new enrollment now?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (Rtn1 == DialogResult.Yes)
{
using (frmEnrollmentProgress innerFrm = new frmEnrollmentProgress(frm.CurrentEnrollment.EnrollmentID))
{
innerFrm.CurrentEmployeeLoggedIn = this.CurrentEmployeeLoggedIn;
innerFrm.CurrentEquiryID = this.CurrentSelectedEnquiryID;
//innerFrm.CurrentSelectedDepartment = (Common.Enum.EnumDepartments)CE.Curriculum.DepartmentID;
innerFrm.ShowDialog();
}
}
}
}
}
}
}
else
{
MessageBox.Show("Initial Consultation Is Not Yet Completed, Please complete before proceeding with the enrollment!", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information);
//gbInProgressEnquiryEnrrolmentQueries.Enabled = false;
}
//}
break;
case 7:
//ensure that the Enrollments are refershed
using (var Dbconnection = new MCDEntities())
{
//Dbconnection.CurriculumEnquiries.Attach(CE);
//if (!(Dbconnection.Entry(CE).Collection(a => a.Enrollments).IsLoaded))
//{
// Dbconnection.Entry(CE).Collection(a => a.Enrollments).Load();
//}
};
//IF any enrollments exists then open Selection list else Do Nothing.
if (true) //CE.Enrollments.Count > 0)
{
//Open thje list of linked Enrollments that are in progress
using (frmEnrollmentSelectionForEquiry frm = new frmEnrollmentSelectionForEquiry(new Data.Models.Enquiry()))
{
frm.ShowDialog();
if (frm.SelectedEnrollmentID != 0)
{
using (frmEnrollmentProgress innerFrm = new frmEnrollmentProgress(frm.SelectedEnrollmentID))
{
innerFrm.CurrentEmployeeLoggedIn = this.CurrentEmployeeLoggedIn;
innerFrm.CurrentEquiryID = this.CurrentSelectedEnquiryID;
//innerFrm.CurrentSelectedDepartment = (Common.Enum.EnumDepartments)CE.Curriculum.DepartmentID;
innerFrm.ShowDialog();
}
}
}
}
else
{
MessageBox.Show("There are currently no enrollments for this enquiry.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
break;
}
}
private void btnInProgressSwitchBetweenCompanyANdPrivate_Click(object sender, EventArgs e)
{
if (((Data.Models.Enquiry)enquiryInprogressBindingSource.Current).Companies.Count == 0)
{
using (frmSelectCompanyContact frm = new frmSelectCompanyContact())
{
Data.Models.Enquiry CurrentEnquiry = (Data.Models.Enquiry)enquiryInprogressBindingSource.Current;
Individual CurrentContact = CurrentEnquiry.Individuals.FirstOrDefault <Individual>();
//frm.CurrentCompany = CurrentEnquiry.Companies.FirstOrDefault<Data.Models.Company>();
//frm.SelectedIndividual = CurrentEnquiry.Individuals.FirstOrDefault<Individual>();
frm.ShowDialog();
if (frm.CurrentCompany != null)
{
using (var Dbconnection = new MCDEntities())
{
Dbconnection.Enquiries.Attach(CurrentEnquiry);
//REmova Current Contact from tthe Enquiry
Dbconnection.Enquiries.Attach(CurrentEnquiry);
CurrentEnquiry.Individuals.Clear();
CurrentEnquiry.Companies.Clear();
Dbconnection.SaveChanges();
}
//Link Company That Is responible for the Enquiry
using (var Dbconnection = new MCDEntities())
{
Dbconnection.Enquiries.Attach(CurrentEnquiry);
Data.Models.Company CompanyToLink = new Data.Models.Company
{
CompanyID = frm.CurrentCompany.CompanyID
};
Dbconnection.Companies.Attach(CompanyToLink);
CurrentEnquiry.Companies.Add(CompanyToLink);
Dbconnection.SaveChanges();
};
using (var Dbconnection = new MCDEntities())
{
Dbconnection.Enquiries.Attach(CurrentEnquiry);
Individual NewContact = new Individual
{
IndividualID = frm.SelectedIndividual.IndividualID
};
Dbconnection.Individuals.Attach(NewContact);
CurrentEnquiry.Individuals.Add(NewContact);
Dbconnection.SaveChanges();
};
//Link the Copmpany Contact
// Dbconnection.Individuals.Add(frm.SelectedIndividual);
//Remove the current Contact
//Dbconnection.Entry(CompanyToLink).Reload();
//CurrentEnquiry.Companies.Add(frm.CurrentCompany);
}
}
refreshInProgressEnquiry(CurrentSelectedEnquiryID);
}
else
{
//Selects From List Of All Students from the Custom Student Search Form
using (frmSelectIndividualContact frm = new frmSelectIndividualContact())
{
frm.ShowDialog();
//get the Individual Selected Which represents the Student Selected.
if (frm.SelectedIndividual.IndividualID != 0)
{
using (var Dbconnection = new MCDEntities())
{
/*1. Removes the current Slected Company Contact*/
Data.Models.Enquiry CurrentEnquiry = ((Data.Models.Enquiry)enquiryInprogressBindingSource.Current);
Dbconnection.Enquiries.Attach(CurrentEnquiry);
List <Individual> temp = ((Data.Models.Enquiry)enquiryInprogressBindingSource.Current).Individuals.ToList <Individual>();
List <Data.Models.Company> tempCompanies = ((Data.Models.Enquiry)enquiryInprogressBindingSource.Current).Companies.ToList <Data.Models.Company>();
foreach (Individual individ in temp)
{
((Data.Models.Enquiry)enquiryInprogressBindingSource.Current).Individuals.Remove(individ);
}
foreach (Data.Models.Company comp in tempCompanies)
{
((Data.Models.Enquiry)enquiryInprogressBindingSource.Current).Companies.Remove(comp);
}
// Dbconnection.Entry(CurrentEnquiry).State = EntityState.Modified;
Dbconnection.SaveChanges();
/*1. End Removal of Current Enquiry Contact*/
/*2. Adds The Cuurentlty Selected Student Contact to be linked with the Enquiry for future contacting*/
Individual IndividualToLink = (from a in Dbconnection.Individuals
where a.IndividualID == frm.SelectedIndividual.IndividualID
select a).FirstOrDefault <Individual>();
CurrentEnquiry.Individuals.Add(IndividualToLink);
Dbconnection.SaveChanges();
/*2. End Adding the Student Contact Details To the Enquiry.*/
};
}
this.refreshInProgressEnquiry(CurrentSelectedEnquiryID);
}
}
}
private void toolStripButton8_Click(object sender, EventArgs e)
{
Data.Models.Enquiry x = (Data.Models.Enquiry)NewEnquiryWorkbench_NewEnquiryBindingSource.Current;
}
