private void btnAddTrainingDepartmentCourseMetaData_Click(object sender, EventArgs e)
{
if (this.txtCourseCost.Text.Length > 0)
{
using (var DbConnection = new MCDEntities())
{
CurriculumCourse newCourseObj = new CurriculumCourse
{
CourseID = Convert.ToInt32(this.lstCourses.SelectedValue),
CurriculumID = this.CurriculumID,
EnrollmentTypeID = Convert.ToInt32(cboEnrollmentTypes.SelectedValue),
Cost = Convert.ToDecimal(txtCourseCost.Text.Replace(".", ",")),
Duration = Convert.ToInt32(nudCourseDuration.Value),
CurricullumCourseCode = new CurricullumCourseCode
{
CurricullumCourseCodeValue = txtCourseCourseCode.Text
},
CurriculumCourseMinimumMaximum = new CurriculumCourseMinimumMaximum
{
CurriculumCourseMaximum = Convert.ToInt32(nudCourseMaximumAllowed.Value),
CurriculumCourseMinimum = Convert.ToInt32(nudCourseMinimumAllowed.Value)
}
};
DbConnection.CurriculumCourses.Add(newCourseObj);
DbConnection.SaveChanges();
this.Close();
};
}
else
{
MessageBox.Show("Ensure that the cost has been allocated!", "Add Warning", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void AddCurriculumCoursePreRequesiteCourse(int _CurrCourseParentID, int _CurrCourseChildID)
{
using (var Dbconnection = new MCDEntities())
{
CurriculumCourse currCourseObj = (from a in Dbconnection.CurriculumCourses
where a.CurriculumCourseID == _CurrCourseChildID
select a).FirstOrDefault <CurriculumCourse>();
currCourseObj.CurriculumCourseParentID = _CurrCourseParentID;
Dbconnection.Entry(currCourseObj).State = System.Data.Entity.EntityState.Modified;
Dbconnection.SaveChanges();
};
}
private void dgvApprenticeshipEnrollmentLinkedCurriculumCourses_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
var gridView = (DataGridView)sender;
foreach (DataGridViewRow row in gridView.Rows)
{
if (!row.IsNewRow)
{
CurriculumCourse CurriculumCourseObj = (CurriculumCourse)(row.DataBoundItem);
row.Cells[colApprenticeshipEnrollmentLinkedCourse.Index].Value = CurriculumCourseObj.Course.CourseName.ToString();
}
}
}
private void dgvPrerequestiteCoursesForSelection_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 0)
{
CurriculumCourse CurrCourseParentObject = ((CurriculumCourse)curriculumCourseBindingSourceForPredessesorSelection.List[e.RowIndex]);
CurriculumCourse CurrCourseChildObject = ((CurriculumCourse)curriculumCourseBindingSourceForCourseRequiredToBeScheduled.Current);
this.AddCurriculumCoursePreRequesiteCourse(CurrCourseParentObject.CurriculumCourseID, CurrCourseChildObject.CurriculumCourseID);
this.refreshCurriculumCourses();
this.refreshCurriculumCourseListToBePrioritised();
this.refreshCurriculumCourseListOfAvaiableCourseToPrioritise();
this.refreshCurriculumCourseListOfPrioritisedCourses();
}
}
private void tbnRemoveCurriculumCourseParent_Click(object sender, EventArgs e)
{
using (var Dbconnection = new MCDEntities())
{
CurriculumCourse CurrCourse = (from a in Dbconnection.CurriculumCourses
where a.CurriculumCourseID == 0
select a).FirstOrDefault <CurriculumCourse>();
CurrCourse.CurriculumCourseParentID = 0;
Dbconnection.SaveChanges();
};
this.refreshCurriculumCourseListToBePrioritised();
this.refreshCurriculumCourseListOfAvaiableCourseToPrioritise();
this.refreshCurriculumCourseListOfPrioritisedCourses();
}
private void populateCurriculumCourse()
{
using (var Dbconnection = new MCDEntities())
{
CurriculumCourse cc = (from a in Dbconnection.CurriculumCourses
where a.CurriculumCourseID == this.CurriculumCourseID
select a).FirstOrDefault <CurriculumCourse>();
txtCourseCost.Text = Convert.ToInt32(cc.Cost).ToString();
nudCourseDuration.Value = cc.Duration;
nudCourseMaximumAllowed.Value = cc.CurriculumCourseMinimumMaximum.CurriculumCourseMaximum;
nudCourseMinimumAllowed.Value = cc.CurriculumCourseMinimumMaximum.CurriculumCourseMinimum;
txtCourseCourseCode.Text = cc.CurricullumCourseCode.CurricullumCourseCodeValue;
};
}
private void btnUpdateCurriculumCourse_Click(object sender, EventArgs e)
{
using (var Dbconnection = new MCDEntities())
{
using (System.Data.Entity.DbContextTransaction dbTran = Dbconnection.Database.BeginTransaction())
{
try
{
//CRUD Operations
CurriculumCourse courseObj = (from a in Dbconnection.CurriculumCourses
where a.CurriculumCourseID == this.CurriculumCourseID
select a).FirstOrDefault <CurriculumCourse>();
courseObj.Cost = Convert.ToDecimal(txtCourseCost.Text);
courseObj.Duration = Convert.ToInt32(nudCourseDuration.Value);
courseObj.CurriculumCourseMinimumMaximum.CurriculumCourseMaximum = Convert.ToInt32(nudCourseMaximumAllowed.Value);
courseObj.CurriculumCourseMinimumMaximum.CurriculumCourseMinimum = Convert.ToInt32(nudCourseMinimumAllowed.Value);
courseObj.CurricullumCourseCode.CurricullumCourseCodeValue = txtCourseCourseCode.Text;
courseObj.CostCode = txtCurrentCostCode.Text;
////saves all above operations within one transaction
Dbconnection.SaveChanges();
//commit transaction
dbTran.Commit();
}
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);
}
}
}
else
{
MessageBox.Show(ex.Message, "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Rollback transaction if exception occurs
dbTran.Rollback();
}
}
};
}
private void btnLinkSeta_Click(object sender, EventArgs e)
{
using (var DbConnection = new MCDEntities())
{
/*
* this steps follow to both entities
*
* 1 - create instance of entity with relative primary key
*
* 2 - add instance to context
*
* 3 - attach instance to context
*/
LookupSeta s = (LookupSeta)bindingSourceAvailableSeta.Current;
//1
var SetaObj = new LookupSeta
{
SetaID = s.SetaID
};
//2
DbConnection.LookupSetas.Add(SetaObj);
//3
DbConnection.LookupSetas.Attach(SetaObj);
// 1
CurriculumCourse CurriculumCourseObj = new CurriculumCourse
{
CurriculumCourseID = this.CurriculumCourseID
};
//// 2
DbConnection.CurriculumCourses.Add(CurriculumCourseObj);
//// 3
DbConnection.CurriculumCourses.Attach(CurriculumCourseObj);
// like previous method add instance to navigation property
CurriculumCourseObj.LookupSetas.Add(SetaObj);
// call SaveChanges
DbConnection.SaveChanges();
}
this.populateAvailableSeta();
this.populateLinkedSeta();
this.setAddRemoveControls();
}
private void btnRemoveCurriculumCourse_Click(object sender, EventArgs e)
{
DialogResult resl = MessageBox.Show("Note This Will remove the course and all assosiated Modules and Activities!", "Remove Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (resl == DialogResult.Yes)
{
using (var Dbconnection = new MCDEntities())
{
CurriculumCourse CurriculumCourseObj = (CurriculumCourse)(this.curriculumCourseBindingSource.Current);
Dbconnection.CurriculumCourses.Attach(CurriculumCourseObj);
Dbconnection.CurriculumCourses.Remove(CurriculumCourseObj);
Dbconnection.SaveChanges();
this.refreshCurriculumCourses();
this.refreshCurriculumCourseListToBePrioritised();
//this.refreshCurriculumCourseListToBePrioritised();
};
}
}
private void btnUpdateCurriculumCourse_Click(object sender, EventArgs e)
{
using (var Dbconnection = new MCDEntities())
{
CurriculumCourse courseObj = (from a in Dbconnection.CurriculumCourses
where a.CurriculumCourseID == this.CurriculumCourseID
select a).FirstOrDefault <CurriculumCourse>();
courseObj.Cost = Convert.ToDecimal(txtCourseCost.Text);
courseObj.Duration = Convert.ToInt32(nudCourseDuration.Value);
courseObj.CurriculumCourseMinimumMaximum.CurriculumCourseMaximum = Convert.ToInt32(nudCourseMaximumAllowed.Value);
courseObj.CurriculumCourseMinimumMaximum.CurriculumCourseMinimum = Convert.ToInt32(nudCourseMinimumAllowed.Value);
courseObj.CurricullumCourseCode.CurricullumCourseCodeValue = txtCourseCourseCode.Text;
//Dbconnection.CurriculumCourses.Add()
Dbconnection.SaveChanges();
this.Close();
};
}
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 btnUpdateCurriculumCourseOptions_Click(object sender, EventArgs e)
{
if (curriculumCourseBindingSource.Count > 0)
{
CurriculumCourse CurrentSelectedCourse = ((CurriculumCourse)(curriculumCourseBindingSource.Current));
frmUpdateCurriculumCourse frm = new frmUpdateCurriculumCourse();
frm.CurriculumCourseID = ((CurriculumCourse)(curriculumCourseBindingSource.Current)).CurriculumCourseID;
frm.txtCourseCost.Text = CurrentSelectedCourse.Cost.ToString();
frm.nudCourseDuration.Value = CurrentSelectedCourse.Duration;
frm.nudCourseMaximumAllowed.Value = CurrentSelectedCourse.CurriculumCourseMinimumMaximum.CurriculumCourseMaximum;
frm.nudCourseMinimumAllowed.Value = CurrentSelectedCourse.CurriculumCourseMinimumMaximum.CurriculumCourseMinimum;
frm.txtCourseCourseCode.Text = CurrentSelectedCourse.CurricullumCourseCode.CurricullumCourseCodeValue;
frm.ShowDialog();
this.refreshCurriculumCourses();
}
else
{
MessageBox.Show("Add Course First!", "Add Warning", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void prePopulateCurrentlySelectedCourse()
{
using (var Dbconnection = new MCDEntities())
{
CurrentlySelectedCurriculumCourseToSchedule = CurrentSelectedCurriculumCourseEnrollment.CurriculumCourse;
Dbconnection.CurriculumCourses.Attach(CurrentlySelectedCurriculumCourseToSchedule);
//loads the days that can be scheduled.
if (!Dbconnection.Entry(CurrentlySelectedCurriculumCourseToSchedule).Collection(a => a.CurriculumCourseDayCanBeScheduleds).IsLoaded)
{
Dbconnection.Entry(CurrentlySelectedCurriculumCourseToSchedule).Collection(a => a.CurriculumCourseDayCanBeScheduleds).Load();
}
//load the course that associated with the Curriculum Course
if (!Dbconnection.Entry(CurrentlySelectedCurriculumCourseToSchedule).Reference <Course>(a => a.Course).IsLoaded)
{
Dbconnection.Entry(CurrentlySelectedCurriculumCourseToSchedule).Reference <Course>(a => a.Course).Load();
}
//if (!Dbconnection.Entry(CurrentlySelectedCurriculumCourseToSchedule).Collection(a => a.Course.VenueAssociatedCourses).IsLoaded)
//{
// Dbconnection.Entry(CurrentlySelectedCurriculumCourseToSchedule).Collection(a => a.Course.VenueAssociatedCourses).Load();
//}
};
}
private Boolean ValidateStep()
{
Boolean bRtn = true;
switch (CurrentPosition)
{
case 0:
if (courseBindingSource.List.Count == 0)
{
MessageBox.Show("Please Add and Select a Course as you canot proceed if no course is selected.", "Information Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
bRtn = false;
}
break;
case 1:
using (var Dbconnection = new MCDEntities())
{
using (System.Data.Entity.DbContextTransaction dbTran = Dbconnection.Database.BeginTransaction())
{
try
{
//CRUD Operations
Course CourseObj = (Course)courseBindingSource.Current;
string ConfiguredCourseCost = txtCourseCost.Text.Replace("R", "").Replace(".", ",").Trim();
if (ConfiguredCourseCost.Length == 0)
{
ConfiguredCourseCost = "0,0";
}
if (newCourseObj == null)
{
newCourseObj = new CurriculumCourse
{
ObjectState = EntityObjectState.Added,
CourseID = CourseObj.CourseID,
CurriculumID = this.CurriculumID,
EnrollmentTypeID = Convert.ToInt32(cboEnrollmentTypes.SelectedValue),
Cost = Convert.ToDecimal(ConfiguredCourseCost),
Duration = Convert.ToInt32(nudCourseDuration.Value),
CostCode = txtCourseCostCode.Text,
CurricullumCourseCode = new CurricullumCourseCode
{
CurricullumCourseCodeValue = txtCourseCourseCode.Text,
ObjectState = EntityObjectState.Added
},
CurriculumCourseMinimumMaximum = new CurriculumCourseMinimumMaximum
{
CurriculumCourseMaximum = Convert.ToInt32(nudCourseMaximumAllowed.Value),
CurriculumCourseMinimum = Convert.ToInt32(nudCourseMinimumAllowed.Value),
ObjectState = EntityObjectState.Added
}
};
Dbconnection.CurriculumCourses.Add(newCourseObj);
}
else
{
newCourseObj.CourseID = CourseObj.CourseID;
newCourseObj.EnrollmentTypeID = Convert.ToInt32(cboEnrollmentTypes.SelectedValue);
newCourseObj.Cost = Convert.ToDecimal(ConfiguredCourseCost);
newCourseObj.Duration = Convert.ToInt32(nudCourseDuration.Value);
newCourseObj.CurricullumCourseCode.CurricullumCourseCodeValue = txtCourseCourseCode.Text;
newCourseObj.CurriculumCourseMinimumMaximum.CurriculumCourseMaximum = Convert.ToInt32(nudCourseMaximumAllowed.Value);
newCourseObj.CurriculumCourseMinimumMaximum.CurriculumCourseMinimum = Convert.ToInt32(nudCourseMinimumAllowed.Value);
newCourseObj.CostCode = txtCourseCostCode.Text;
Dbconnection.Entry(newCourseObj).State = EntityState.Modified;
}
////saves all above operations within one transaction
Dbconnection.SaveChanges();
//commit transaction
dbTran.Commit();
}
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);
}
}
}
else
{
MessageBox.Show(ex.Message, "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Rollback transaction if exception occurs
dbTran.Rollback();
if (newCourseObj.ObjectState == EntityObjectState.Added)
{
newCourseObj = null;
}
bRtn = false;
}
}
};
break;
case 2:
break;
case 3:
break;
case 4:
break;
case 5:
break;
case 6:
break;
case 7:
break;
default:
bRtn = false;
break;
}
return(bRtn);
}
private void SetPossibleCurriculumCourseDatesWithFacilitatorOnly()
{
List <CurriculumCourseDayCanBeScheduled> CurriculumCourseDayCanBeScheduledDays = new List <CurriculumCourseDayCanBeScheduled>();
CurriculumCourse CC = null;
using (var Dbconnection = new MCDEntities())
{
CC = (from a in Dbconnection.CurriculumCourses
where a.CurriculumCourseID == this.CurriculumCourseID
select a)
.Include(a => a.Course)
.FirstOrDefault <CurriculumCourse>();
CurriculumCourseDayCanBeScheduledDays = (from a in CC.CurriculumCourseDayCanBeScheduleds
select a).ToList <CurriculumCourseDayCanBeScheduled>();
};
List <EnumDayOfWeeks> EnumDayOfWeeksList = new List <EnumDayOfWeeks>();
foreach (CurriculumCourseDayCanBeScheduled CurriculumCourseDayCanBeScheduledDayObj in CurriculumCourseDayCanBeScheduledDays)
{
EnumDayOfWeeksList.Add((EnumDayOfWeeks)CurriculumCourseDayCanBeScheduledDayObj.DayOfWeekID);
}
foreach (FacilitatorAvailableDateSet FADS in FacilitatorAvailableDateSets)
{
DateTime INITIAL_DATE = FADS.StartDate;
//Get First Dat That Scheduling Can Start
DateTime FIRST_DAY_CAN_BE_SCHEDULED_FROM_SET = FADS.StartDate;
while (FIRST_DAY_CAN_BE_SCHEDULED_FROM_SET.Date < FADS.EndDate.Date)
{
Boolean IsFirstDayFound = false;
while (!IsFirstDayFound)
{
if (IsFirstDateCanBeScheduled(FIRST_DAY_CAN_BE_SCHEDULED_FROM_SET, CurriculumCourseDayCanBeScheduledDays))
{
IsFirstDayFound = true;
}
else
{
FIRST_DAY_CAN_BE_SCHEDULED_FROM_SET = FIRST_DAY_CAN_BE_SCHEDULED_FROM_SET.AddDays(1);
}
}
DateTime dd = new DateTime(2017, 07, 13);
dd = dd.AddDays(2);
//DateTime must be inclusive of the initial date so 1 day must be subtracted from the returned possible end date.
DateTime EndDateForCurrentPossibleSchedule = CustomDateTime.getCustomDateTime(FIRST_DAY_CAN_BE_SCHEDULED_FROM_SET, CC.Duration, EnumDayOfWeeksList).AddDays(-1);
if (EndDateForCurrentPossibleSchedule.Date <= FADS.EndDate.Date)
{
//Add Schedule Option To List
CourseByFacilitatorAvailableDateSets.Add(new CourseByFacilitatorAvailableDateSet(
CourseName: CC.Course.CourseName,
FacilitatorID: FADS.FacilitatorID,
CurriculumCourseID: this.CurriculumCourseID,
StartDate: FIRST_DAY_CAN_BE_SCHEDULED_FROM_SET.Date,
EndDate: EndDateForCurrentPossibleSchedule.Date));
FIRST_DAY_CAN_BE_SCHEDULED_FROM_SET = EndDateForCurrentPossibleSchedule.Date.AddDays(1);
}
else
{
FIRST_DAY_CAN_BE_SCHEDULED_FROM_SET = FADS.EndDate.Date;
}
}
}
}
