//Insert a certificate program with links to specific entrance requirements
public void InsertCertificateProgram(DiplomaCertificate certProgram, List <EntranceRequirementList> entReqList)
{
using (Pathway_Model context = new Pathway_Model())
{
DiplomaCertificate added = null;
EntranceRequirement addedEntReq = null;
added = context.DiplomaCertificates.Add(certProgram);
if (entReqList != null)
{
// create entrance requirement entry for each row entered
foreach (EntranceRequirementList entry in entReqList)
{
EntranceRequirement entReq = new EntranceRequirement()
{
ProgramID = added.ProgramID,
CourseID = entry.CourseID,
Marks = entry.Mark
};
addedEntReq = context.EntranceRequirements.Add(entReq);
}
}
// commits the add to the databas
context.SaveChanges();
}
}
public void DegreeRel_Delete(DegreeRelationshipInfo item)
{
using (Pathway_Model context = new Pathway_Model())
{
Degree selectedDegree = context.Degrees.SingleOrDefault(d => d.DegreeID == item.DegreeID);
DiplomaCertificate selectedDiploma = context.DiplomaCertificates.SingleOrDefault(d => d.ProgramID == item.ProgramID);
//selectedDegree.DiplomaCertificates.Add(selectedDiploma);
// EntranceRequirement existing = context.EntranceRequirements.Find(item.ProgramID, item.CourseID);
selectedDegree.DiplomaCertificates.Remove(selectedDiploma);
context.SaveChanges();
}
}
public void DegreeRel_Add(DegreeRelationshipInfo item)
{
using (Pathway_Model context = new Pathway_Model())
{
//create degree diploma entry for row entered
Degree selectedDegree = context.Degrees.SingleOrDefault(d => d.DegreeID == item.DegreeID);
DiplomaCertificate selectedDiploma = context.DiplomaCertificates.SingleOrDefault(d => d.ProgramID == item.ProgramID);
selectedDegree.DiplomaCertificates.Add(selectedDiploma);
context.SaveChanges();
}
}
//Insert a degree program with links to diploma programs
public void InsertDegreeProgram(Degree degreeProgram, List <int> diplomaIDs)
{
using (Pathway_Model context = new Pathway_Model())
{
Degree added = null;
added = context.Degrees.Add(degreeProgram);
// commits the add to the databas
if (diplomaIDs != null)
{
//create degree diploma entry for each row entered
foreach (int entry in diplomaIDs)
{
DiplomaCertificate selectedDiploma = context.DiplomaCertificates.SingleOrDefault(d => d.ProgramID == entry);
added.DiplomaCertificates.Add(selectedDiploma);
}
}
context.SaveChanges();
}
}
//Insert a diploma program with entrance requirements for specific courses, and links to degree programs
public void InsertDiplomaProgram(DiplomaCertificate diplomaProgram, List <EntranceRequirementList> entReqList, List <int> degreeIDs)
{
using (Pathway_Model context = new Pathway_Model())
{
DiplomaCertificate added = null;
EntranceRequirement addedEntReq = null;
added = context.DiplomaCertificates.Add(diplomaProgram);
if (entReqList.Count != 0)
{
// create entrance requirement entry for each row entered
foreach (EntranceRequirementList entry in entReqList)
{
EntranceRequirement entReq = new EntranceRequirement()
{
ProgramID = added.ProgramID,
CourseID = entry.CourseID,
Marks = entry.Mark
};
addedEntReq = context.EntranceRequirements.Add(entReq);
}
}
if (degreeIDs.Count != 0)
{
//create degree diploma entry for each row entered
foreach (int entry in degreeIDs)
{
Degree selectedDegree = context.Degrees.SingleOrDefault(d => d.DegreeID == entry);
selectedDegree.DiplomaCertificates.Add(diplomaProgram);
}
}
// commits the add to the databas
context.SaveChanges();
}
}
public void CertDiploma_Update(DiplomaCertificate item)
{
using (Pathway_Model context = new Pathway_Model())
{
DiplomaCertificate entReq = new DiplomaCertificate()
{
ProgramID = item.ProgramID,
ProgramName = item.ProgramName,
ProgramLength = item.ProgramLength,
EntranceRequirementDetail = item.EntranceRequirementDetail,
CompetitveAdvantage = item.CompetitveAdvantage,
ProgramLink = item.ProgramLink,
Activated = item.Activated,
WorkOutdoors = item.WorkOutdoors,
ShiftWork = item.ShiftWork,
WorkTravel = item.WorkTravel,
CredentialType = item.CredentialType,
CategoryID = item.CategoryID
};
context.Entry <DiplomaCertificate>(context.DiplomaCertificates.Attach(entReq)).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
protected void SubmitProgram_Click(object sender, EventArgs e)
{
MessageUserControl.TryRun(() =>
{
// Variables
string programName, credentialType, programLink, programLength;
string errorList = "";
int categoryID, temp;
Uri tempUrl;
bool workOutdoors, shiftWork, travel, activated, checkURL;
//Validate non-string variables
//Po
bool result = int.TryParse(ProgramLength.Text.Trim(), out temp);
if (!result)
{
errorList += "- Please enter a numeric value into the program length field (whole number only).\\n";
}
if (temp != 0)
{
if ((int.Parse(ProgramLength.Text)) < 0 || (int.Parse(ProgramLength.Text)) > 100)
{
errorList += "- Program length must be a whole number between 1 - 99.\\n";
}
}
//Validate URL
result = Uri.TryCreate(ProgramLink.Text, UriKind.Absolute, out tempUrl) && tempUrl.Scheme == Uri.UriSchemeHttp;
if (!result)
{
errorList += "- Please enter a properly formatted URL (ex. http://www.example.com).\\n";
}
PathwaysController controller = new PathwaysController();
//Validate field lengths
if (ProgramName.Text.Trim().Length > 100)
{
errorList += "- Program Name cannot exceed 100 characters. \\n";
}
if (ProgramLink.Text.Trim().Length > 150)
{
errorList += "- Program Link cannot exceed 150 characters. \\n";
}
//check to see if program name exists
//Po
result = controller.CheckProgramName(ProgramName.Text.Trim());
//verify the name does not exist
if (result == false)
{
errorList += "- The Program Name selected currently exists in the system, and cannot be repeated.\\n";
}
// Get values from page
//Po
programName = ProgramName.Text.Trim();
credentialType = CredentialType.SelectedValue;
programLink = ProgramLink.Text.Trim();
programLength = ProgramLength.Text.Trim() + " " + ProgramLengthDDL.SelectedValue;
workOutdoors = WorkOutdoors.Checked;
shiftWork = ShiftWork.Checked;
travel = Travel.Checked;
activated = Activated.Checked;
categoryID = int.Parse(CategoryList.SelectedValue);
if (credentialType == "Degree")
{
//verify the URL does not exist
checkURL = controller.CheckDegUrl(programLink);
if (checkURL == false)
{
errorList += "- The url selected currently exists in the system, and cannot be repeated.\\n";
}
// Make a list for entering degree pathway information
List <int> diplomaIDs = new List <int>();
Degree degreeProgram = new Degree();
// Populate a new degree
degreeProgram.DegreeName = programName;
degreeProgram.DegreeLink = programLink;
degreeProgram.DegreeLength = programLength;
degreeProgram.Activated = activated;
degreeProgram.WorkOutdoors = workOutdoors;
degreeProgram.WorkTravel = travel;
degreeProgram.ShiftWork = shiftWork;
degreeProgram.CategoryID = categoryID;
int numOfRows = Program_GridView.Rows.Count;
if (numOfRows != 0)
{
//gather data from the degree pathway gridview for processing
foreach (GridViewRow row in Program_GridView.Rows)
{
// Find controls in the Gridview
int diplomaID = int.Parse((row.FindControl("ProgramList") as DropDownList).SelectedValue);
diplomaIDs.Add(diplomaID);
}
}
int index = 0;
diplomaIDs.Sort();
bool flagDip = true;
while (index < diplomaIDs.Count - 1 && flagDip == true)
{
if (diplomaIDs[index] == diplomaIDs[index + 1])
{
errorList += "- Diploma pathways cannot appear more than once.\\n";
flagDip = false;
}
else
{
index++;
}
}
if (errorList != "")
{
throw new Exception(errorList);
}
//Insert the entry
controller.InsertDegreeProgram(degreeProgram, diplomaIDs);
ClearFields();
Response.Write("<script type=\"text/javascript\">alert('Entry has been inserted.');</script>");
//Hide panels
ShowCoursesView.Checked = false;
ShowDipPathView.Checked = false;
ShowDegPathView.Checked = false;
entrance_req.Visible = false;
degree_link.Visible = false;
degree_pathways.Visible = false;
}
if (credentialType == "Diploma")
{
//verify the URL does not exist
checkURL = controller.CheckDipCertUrl(programLink);
if (checkURL == false)
{
errorList += "- The url selected currently exists in the system, and cannot be repeated.\\n";
}
//validate field length
if (EntReqDetail.Text.Length > 150)
{
errorList += "- Entrance Requirement Details cannot exceed 150 characters. \\n";
}
//check coompetitive advantage
//Po
result = int.TryParse(CompetitiveAdv.Text.Trim(), out temp);
if (!result)
{
errorList += "- Please enter a numeric value into the competitive advantage field (whole number only).\\n";
}
if (temp != 0)
{
if ((int.Parse(CompetitiveAdv.Text)) < 0 || (int.Parse(CompetitiveAdv.Text)) > 100)
{
errorList += "- Competitive advantage must be a whole number between 1 - 99.\\n";
}
}
// get other required data
byte competitiveAdvantage = byte.Parse(CompetitiveAdv.Text);
string entReqDetail = EntReqDetail.Text;
DiplomaCertificate diploma = new DiplomaCertificate();
// Populate a new diploma
diploma.ProgramName = programName;
diploma.ProgramLink = programLink;
diploma.ProgramLength = programLength;
diploma.Activated = activated;
diploma.WorkOutdoors = workOutdoors;
diploma.WorkTravel = travel;
diploma.ShiftWork = shiftWork;
diploma.CategoryID = categoryID;
diploma.CredentialType = true;
diploma.CompetitveAdvantage = competitiveAdvantage;
diploma.EntranceRequirementDetail = entReqDetail;
// Make a list for entering entrance requirement information
List <EntranceRequirementList> entranceReqList = new List <EntranceRequirementList>();
if (ShowCoursesView.Checked)
{
// Gather data from course gridview for processing items
foreach (GridViewRow row in Course_Gridview.Rows)
{
// Find controls in the Gridview
//Po
int courseID = int.Parse((row.FindControl("CourseList") as DropDownList).SelectedValue);
byte mark;
result = byte.TryParse(((row.FindControl("EnterMark") as TextBox).Text.Trim()), out mark);
if (!result)
{
errorList += "- Marks entered must be numeric values (whole numbers greater than 0). \\n";
}
if (mark > 100 || mark < 0)
{
errorList += "- Marks entered must whole numbers between 1 - 99. \\n";
}
entranceReqList.Add(new EntranceRequirementList()
{
CourseID = courseID,
Mark = mark
});
}
}
List <int> courseIds = new List <int>();
foreach (EntranceRequirementList item in entranceReqList)
{
courseIds.Add(item.CourseID);
}
courseIds.Sort();
int index = 0;
bool flag = true;
while (index < entranceReqList.Count - 1 && flag == true)
{
if (courseIds[index] == courseIds[index + 1])
{
errorList += "- Courses in entrance requirements cannot appear more than once.\\n";
flag = false;
}
else
{
index++;
}
}
int numOfRows = DegreeList_GridView.Rows.Count;
List <int> degreeIDs = new List <int>();
if (numOfRows != 0)
{
//gather data from the degree pathway gridview for processing
foreach (GridViewRow row in DegreeList_GridView.Rows)
{
// Find controls in the Gridview
int degreeID = int.Parse((row.FindControl("DegreeList") as DropDownList).SelectedValue);
if (degreeID != 0)
{
degreeIDs.Add(degreeID);
}
}
}
degreeIDs.Sort();
bool flagDeg = true;
while (index < degreeIDs.Count - 1 && flagDeg == true)
{
if (degreeIDs[index] == degreeIDs[index + 1])
{
errorList += "- Degree pathways cannot appear more than once.\\n";
flagDeg = false;
}
else
{
index++;
}
}
if (errorList != "")
{
throw new Exception(errorList);
}
//Insert the entry
controller.InsertDiplomaProgram(diploma, entranceReqList, degreeIDs);
ClearFields();
Response.Write("<script type=\"text/javascript\">alert('Entry has been inserted.');</script>");
//Hide panels
ShowCoursesView.Checked = false;
ShowDipPathView.Checked = false;
ShowDegPathView.Checked = false;
entrance_req.Visible = false;
degree_link.Visible = false;
degree_pathways.Visible = false;
}
if (credentialType == "Certificate")
{
//verify the URL does not exist
checkURL = controller.CheckDipCertUrl(programLink);
if (checkURL == false)
{
errorList += "- The url selected currently exists in the system, and cannot be repeated.\\n";
}
//validate field length
if (EntReqDetail.Text.Length > 150)
{
errorList += "- Entrance Requirement Details cannot exceed 150 characters. \\n";
}
byte competitiveAdvantage;
//Po
result = byte.TryParse(CompetitiveAdv.Text.Trim(), out competitiveAdvantage);
if (!result)
{
errorList += "- Please enter a numeric value into the competitive advantage field (whole numbers greater than zero only).\\n";
}
if (competitiveAdvantage < 0 || competitiveAdvantage > 100)
{
errorList += "- Please enter a numeric value between 1 - 99. \\n";
}
//check coompetitive advantage
//po
result = int.TryParse(CompetitiveAdv.Text.Trim(), out temp);
if (!result)
{
errorList += "- Please enter a numeric value into the competitive advantage field (whole number only).\\n";
}
if (temp != 0)
{
if ((int.Parse(CompetitiveAdv.Text)) < 0 || (int.Parse(CompetitiveAdv.Text)) > 100)
{
errorList += "- Competitive advantage must be a whole number between 1 - 99.\\n";
}
}
string entReqDetail = EntReqDetail.Text;
DiplomaCertificate certificate = new DiplomaCertificate();
// Populate a new certificate
certificate.ProgramName = programName;
certificate.ProgramLink = programLink;
certificate.ProgramLength = programLength;
certificate.Activated = activated;
certificate.WorkOutdoors = workOutdoors;
certificate.WorkTravel = travel;
certificate.ShiftWork = shiftWork;
certificate.CategoryID = categoryID;
certificate.CredentialType = false;
certificate.CompetitveAdvantage = competitiveAdvantage;
certificate.EntranceRequirementDetail = entReqDetail;
// Make a list for entering entrance requirement information
List <EntranceRequirementList> entranceReqList = new List <EntranceRequirementList>();
if (ShowCoursesView.Checked)
{
// Gather data from course gridview for processing items
foreach (GridViewRow row in Course_Gridview.Rows)
{
// Find controls in the Gridview
int courseID = int.Parse((row.FindControl("CourseList") as DropDownList).SelectedValue);
byte mark;
result = byte.TryParse(((row.FindControl("EnterMark") as TextBox).Text.Trim()), out mark);
if (!result)
{
errorList += "- Marks entered must be numeric values (whole numbers greater than 0). \\n";
}
if (mark > 100 || mark < 0)
{
errorList += "- Marks entered must whole numbers between 1 - 99. \\n";
}
entranceReqList.Add(new EntranceRequirementList()
{
CourseID = courseID,
Mark = mark
});
}
List <int> courseIds = new List <int>();
foreach (EntranceRequirementList item in entranceReqList)
{
courseIds.Add(item.CourseID);
}
courseIds.Sort();
int index = 0;
bool flag = true;
while (index < entranceReqList.Count - 1 && flag == true)
{
if (courseIds[index] == courseIds[index + 1])
{
errorList += "- Courses in entrance requirements cannot appear more than once.\\n";
flag = false;
}
else
{
index++;
}
}
}
if (errorList != "")
{
throw new Exception(errorList);
}
//Insert the entry
controller.InsertCertificateProgram(certificate, entranceReqList);
ClearFields();
Response.Write("<script type=\"text/javascript\">alert('Entry has been inserted.');</script>");
//Hide panels
ShowCoursesView.Checked = false;
ShowDipPathView.Checked = false;
ShowDegPathView.Checked = false;
entrance_req.Visible = false;
degree_link.Visible = false;
degree_pathways.Visible = false;
}
});
}
protected void Page_Load(object sender, EventArgs e)
{
CourseMarks_Gridview.DataBind();
MarksNotQualified.Visible = false;
string programID = Request.QueryString["programID"];
//Course-Marks query string
string allEnteredCourseMarks = Request.QueryString["allEnteredCourseMarks"];
if (!string.IsNullOrEmpty(allEnteredCourseMarks))
{
allEnteredCourseMarks = allEnteredCourseMarks.Remove(allEnteredCourseMarks.Length - 1);
//test data transfer
List <string> firstSplit = allEnteredCourseMarks.Split(';').ToList();
string[] secondSplit = new string[2];
List <string> courses = new List <string>();
List <string> marks = new List <string>();
foreach (string item in firstSplit)
{
secondSplit = item.Split(',');
//if (allEnteredCourseMarks.Split(',').Length > 2)
//{
courses.Add(secondSplit[0]);
marks.Add(secondSplit[1]);
//}
}
PathwaysController controller = new PathwaysController();
List <CourseMarks> marksEntered = controller.ProcessStudentMarks(courses, marks);
CourseMarks_Gridview.DataSource = marksEntered;
CourseMarks_Gridview.DataBind();
//Compare the certain course-marks
int countGVRow = 0;
foreach (GridViewRow theRow in EntReq_GridView.Rows)
{
var myCourseReqName = theRow.FindControl("LB_CourseName") as Label;
var mycourseReqMarks = theRow.FindControl("LB_Marks") as Label;
int countCourse = 0;
foreach (string myCourseId in courses)
{
PathwaysController myCourseController = new PathwaysController();
string myCourseName = myCourseController.GetCourseNameByID(int.Parse(myCourseId));
//Check the same course for comparison marks
if (myCourseName.Equals(myCourseReqName.Text))
{
//for the same column/record check
int countMarks = 0;
//get marks
foreach (string myCourseMarks in marks)
{
//if they are in the same associated row/data
if (countCourse == countMarks)
{
//compare marks at the certain course
if (int.Parse(myCourseMarks) < int.Parse(mycourseReqMarks.Text))
{
//show prompt messages
MarksNotQualified.Visible = true;
//Check the same row.data as the one associated with the compared data
int enteredCourseMarksCount = 0;
//for change row color if marks comparison failed
foreach (GridViewRow myEnterCoureMarks in CourseMarks_Gridview.Rows)
{
//check the it is at the same row as the accosicated row
if (countCourse == enteredCourseMarksCount)
{
//change color if marks comparison failed
myEnterCoureMarks.ForeColor = ColorTranslator.FromHtml("#ff3300");
myEnterCoureMarks.Font.Bold = true;
}
//for count the row, which row it is now.
enteredCourseMarksCount += 1;
}
}
}
countMarks += 1;
}
}
countCourse += 1;
}
countGVRow += 1;
}
}
if (String.IsNullOrEmpty(programID))
{
Response.Redirect("~/Default.aspx");
}
else
{
PathwaysController controller = new PathwaysController();
// find out the type of program
bool programType = controller.GetProgramType(int.Parse(programID));
if (programType) //if its diploma/certificate
{
DiplomaCertificate dipCert = new DiplomaCertificate();
dipCert = controller.GetSingleProgram(int.Parse(programID));
//Populate page fields
//Program Name:
ProgramName.Text = dipCert.ProgramName;
//Credential Type:
if (dipCert.CredentialType == true)
{
CredentialType.Text = "Diploma Program - " + dipCert.ProgramLength;
//Po's future path data bind
RP_FuturePathWay.DataSourceID = "ODS_FuturePath";
RP_FuturePathWay.DataBind();
foreach (RepeaterItem myFuturePath in RP_FuturePathWay.Items)
{
var myFuturePathID = myFuturePath.FindControl("LB_MyFuturePathDegreeID") as Label;
if (!string.IsNullOrEmpty(myFuturePathID.Text))
{
Div_FuturePathway.Visible = true;
}
}
}
else
{
CredentialType.Text = "Certificate Program - " + dipCert.ProgramLength;
}
//Competitive Advantage
CompetitiveAdvantage.Text = dipCert.CompetitveAdvantage + "%";
//Working outdoors
if (dipCert.WorkOutdoors == true)
{
WorkOutdoors.Text = "Yes";
}
else
{
WorkOutdoors.Text = "No";
}
//Travel
if (dipCert.WorkTravel == true)
{
Travel.Text = "Yes";
}
else
{
Travel.Text = "No";
}
//Shift Work
if (dipCert.ShiftWork == true)
{
Schedule.Text = "Rotational";
}
else
{
Schedule.Text = "Regular Hours";
}
//Program Link
ProgramLink.Text = dipCert.ProgramLink;
ProgramLink.NavigateUrl = dipCert.ProgramLink;
//Entrance Req Details
EntranceDetails.Text = dipCert.EntranceRequirementDetail;
}
else
{
ProgramEnvironment.Visible = false;
ProgramGradeInfo.Visible = false;
MarkInfo.Visible = false;
DegreeWorkInfo.Visible = true;
Degree degree = new Degree();
degree = controller.DegreeProgram_byID(int.Parse(programID));
//Populate page fields
//Program Name:
ProgramName.Text = degree.DegreeName;
//Credential Type:
CredentialType.Text = "Degree Program - " + degree.DegreeLength;
//Working outdoors
if (degree.WorkOutdoors == true)
{
DegOutDoors.Text = "Yes";
}
else
{
DegOutDoors.Text = "No";
}
//Travel
if (degree.WorkTravel == true)
{
DegTravel.Text = "Yes";
}
else
{
DegTravel.Text = "No";
}
//Shift Work
if (degree.ShiftWork == true)
{
DegSchedule.Text = "Rotational";
}
else
{
DegSchedule.Text = "Regular Hours";
}
//Program Link
ProgramLink.Text = degree.DegreeLink;
ProgramLink.NavigateUrl = degree.DegreeLink;
}
}
}
protected void ShowUpdateFields_Click(object sender, EventArgs e)
{
MessageUserControl.TryRun(() =>
{
//POPULATE FIELDS BASED ON SELECTION
if (InitialCredential.SelectedValue == "Certificate")
{
// Use a string to capture Program Length for spliting into two fields.
string programLength;
string[] programSplit = new string[2];
char[] splitChar = { ' ' };
show_update_form.Visible = true;
SubmitProgram.Visible = true;
DiplomaCertificate certificate = new DiplomaCertificate();
PathwaysController controller = new PathwaysController();
certificate = controller.CertificateProgram_byID(int.Parse(CertificateList.SelectedValue));
//Split string before populating form
programLength = certificate.ProgramLength;
programSplit = programLength.Split(splitChar);
ProgramID.Text = certificate.ProgramID.ToString();
ProgramName.Text = certificate.ProgramName;
CategoryList.SelectedValue = certificate.CategoryID.ToString();
CredentialType.Text = "Certificate";
ProgramLength.Text = programSplit[0];
ProgramLengthDDL.SelectedValue = programSplit[1];
ProgramLink.Text = certificate.ProgramLink;
Activated.Checked = certificate.Activated;
WorkOutdoors.Checked = certificate.WorkOutdoors;
ShiftWork.Checked = certificate.ShiftWork;
Travel.Checked = certificate.WorkTravel;
CompetitiveAdv.Text = certificate.CompetitveAdvantage.ToString();
EntReqDetail.Text = certificate.EntranceRequirementDetail;
DegreePathListView.Visible = false;
pathwaysheading_toggle.Visible = false;
entrance_req.Visible = true;
EntReqListView.Visible = true;
DiplomaEntReqList.Visible = false;
//ProgramLink Holder for comparison later on
ProgramLinkCompare.Value = certificate.ProgramLink;
//ProgramName Holder for comparison later on
ProgramNameCompare.Value = certificate.ProgramName;
}
else if (InitialCredential.SelectedValue == "Diploma")
{
// Use a string to capture Program Length for spliting into two fields.
string programLength;
string[] programSplit = new string[2];
char[] splitChar = { ' ' };
show_update_form.Visible = true;
SubmitProgram.Visible = true;
DiplomaCertificate diploma = new DiplomaCertificate();
PathwaysController controller = new PathwaysController();
diploma = controller.DiplomaProgram_byID(int.Parse(DiplomaList.SelectedValue));
//Split string before populating form
programLength = diploma.ProgramLength;
programSplit = programLength.Split(splitChar);
ProgramID.Text = diploma.ProgramID.ToString();
ProgramName.Text = diploma.ProgramName;
CategoryList.SelectedValue = diploma.CategoryID.ToString();
CredentialType.Text = "Diploma";
ProgramLength.Text = programSplit[0];
ProgramLengthDDL.SelectedValue = programSplit[1];
ProgramLink.Text = diploma.ProgramLink;
Activated.Checked = diploma.Activated;
WorkOutdoors.Checked = diploma.WorkOutdoors;
ShiftWork.Checked = diploma.ShiftWork;
Travel.Checked = diploma.WorkTravel;
CompetitiveAdv.Text = diploma.CompetitveAdvantage.ToString();
EntReqDetail.Text = diploma.EntranceRequirementDetail;
entrance_req.Visible = true;
EntReqListView.Visible = false;
DiplomaEntReqList.Visible = true;
DiplomaPathListView.Visible = true;
pathwaysheading_toggle.Visible = true;
DegreePathListView.Visible = false;
//ProgramLink Holder for comparison later on
ProgramLinkCompare.Value = diploma.ProgramLink;
//ProgramName Holder for comparison later on
ProgramNameCompare.Value = diploma.ProgramName;
}
else if (InitialCredential.SelectedValue == "Degree")
{
// Use a string to capture Program Length for spliting into two fields.
string programLength;
string[] programSplit = new string[2];
char[] splitChar = { ' ' };
show_update_form.Visible = true;
SubmitProgram.Visible = true;
Degree degree = new Degree();
PathwaysController controller = new PathwaysController();
degree = controller.DegreeProgram_byID(int.Parse(DegreeList.SelectedValue));
//Split string before populating form
programLength = degree.DegreeLength;
programSplit = programLength.Split(splitChar);
ProgramID.Text = degree.DegreeID.ToString();
ProgramName.Text = degree.DegreeName;
CategoryList.SelectedValue = degree.CategoryID.ToString();
CredentialType.Text = "Degree";
ProgramLength.Text = programSplit[0];
ProgramLengthDDL.SelectedValue = programSplit[1];
ProgramLink.Text = degree.DegreeLink;
Activated.Checked = degree.Activated;
WorkOutdoors.Checked = degree.WorkOutdoors;
ShiftWork.Checked = degree.ShiftWork;
Travel.Checked = degree.WorkTravel;
pathwaysheading_toggle.Visible = true;
EntReqListView.Visible = false;
DegreePathListView.Visible = true;
DiplomaEntReqList.Visible = false;
DiplomaPathListView.Visible = false;
entrance_req.Visible = false;
//ProgramLink Holder for comparison later on
ProgramLinkCompare.Value = degree.DegreeLink;
//ProgramName Holder for comparison later on
ProgramNameCompare.Value = degree.DegreeName;
DegreePathListView.DataSource = DipRelDB_ODS;
DegreePathListView.DataBind();
}
else
{
DegreePathListView.Visible = false;
DiplomaEntReqList.Visible = false;
DiplomaPathListView.Visible = false;
pathwaysheading_toggle.Visible = false;
EntReqListView.Visible = false;
entrance_req.Visible = false;
}
});
}
protected void SubmitProgram_Click(object sender, EventArgs e)
{
MessageUserControl.TryRun(() =>
{
// BUILD OBJECTS AND UPDATE BASED ON PROGRAM TYPE
//Declare variables for error handling
Uri tempUrl;
int temp;
string errorList = "";
if (InitialCredential.SelectedValue == "Certificate")
{
//Validate non-string variables
//Po
bool result = int.TryParse(ProgramLength.Text.Trim(), out temp);
if (!result)
{
errorList += "- Please enter a numeric value into the program length field (whole number only). \\n";
}
if (temp != 0)
{
//Po
if ((int.Parse(ProgramLength.Text.Trim())) < 0 || (int.Parse(ProgramLength.Text.Trim())) > 100)
{
errorList += "- Program length must be a whole number between 1 - 99. \\n";
}
}
//Validate URL
//Po
result = Uri.TryCreate(ProgramLink.Text.Trim(), UriKind.Absolute, out tempUrl) && tempUrl.Scheme == Uri.UriSchemeHttp;
if (!result)
{
errorList += "- Please enter a properly formatted URL (ex. http://www.example.com). \\n";
}
PathwaysController controller = new PathwaysController();
//verify the URL does not exist
if (ProgramLinkCompare.Value != ProgramLink.Text.Trim())
{
//Po
bool checkURL = controller.CheckDipCertUrl(ProgramLink.Text.Trim());
if (checkURL == false)
{
errorList += "- The url selected currently exists in the system, and cannot be repeated.\\n";
}
}
//verify the name does not exist
//Po
if (ProgramNameCompare.Value != ProgramName.Text.Trim())
{
//Po
bool checkName = controller.CheckProgramName(ProgramName.Text.Trim());
if (checkName == false)
{
errorList += "- The Program Name selected currently exists in the system, and cannot be repeated.\\n";
}
}
//Validate field lengths
if (ProgramName.Text.Trim().Length > 100)
{
errorList += "- Program Name cannot exceed 100 characters. \\n";
}
if (ProgramLink.Text.Trim().Length > 150)
{
errorList += "- Program Link cannot exceed 150 characters. \\n";
}
//validate field length
if (EntReqDetail.Text.Trim().Length > 150)
{
errorList += "- Entrance Requirement Details cannot exceed 150 characters. \\n";
}
byte competitiveAdvantage;
result = byte.TryParse(CompetitiveAdv.Text.Trim(), out competitiveAdvantage);
if (!result)
{
errorList += "- Please enter a numeric value into the competitive advantage field (whole numbers greater than zero only). \\n";
}
if (competitiveAdvantage < 0 || competitiveAdvantage > 100)
{
errorList += "- Please enter a numeric value between 1 - 99. \\n";
}
//populate certificate
DiplomaCertificate certificate = new DiplomaCertificate()
{
ProgramID = int.Parse(ProgramID.Text),
ProgramName = ProgramName.Text.Trim(),
ProgramLength = ProgramLength.Text.Trim() + " " + ProgramLengthDDL.SelectedValue,
EntranceRequirementDetail = EntReqDetail.Text,
CompetitveAdvantage = competitiveAdvantage,
ProgramLink = ProgramLink.Text.Trim(),
Activated = Activated.Checked,
WorkOutdoors = WorkOutdoors.Checked,
ShiftWork = ShiftWork.Checked,
WorkTravel = Travel.Checked,
CredentialType = false,
CategoryID = int.Parse(CategoryList.SelectedValue)
};
if (errorList != "")
{
throw new Exception(errorList);
}
//process update
// PathwaysController controller = new PathwaysController();
controller.CertDiploma_Update(certificate);
Clear_Click();
Response.Write("<script type=\"text/javascript\">alert('The selected Certificate program has been updated.');</script>");
}
else if (InitialCredential.SelectedValue == "Diploma")
{
//Validate non-string variables
bool result = int.TryParse(ProgramLength.Text.Trim(), out temp);
if (!result)
{
errorList += "- Please enter a numeric value into the program length field (whole number only). \\n";
}
if (temp != 0)
{
if ((int.Parse(ProgramLength.Text)) < 0 || (int.Parse(ProgramLength.Text)) > 100)
{
errorList += "- Program length must be a whole number between 1 - 99. \\n";
}
}
//Validate URL
result = Uri.TryCreate(ProgramLink.Text.Trim(), UriKind.Absolute, out tempUrl) && tempUrl.Scheme == Uri.UriSchemeHttp;
if (!result)
{
errorList += "- Please enter a properly formatted URL (ex. http://www.example.com). \\n";
}
PathwaysController controller = new PathwaysController();
//verify the URL does not exist
if (ProgramLinkCompare.Value != ProgramLink.Text.Trim())
{
bool checkURL = controller.CheckDipCertUrl(ProgramLink.Text.Trim());
if (checkURL == false)
{
errorList += "- The url selected currently exists in the system, and cannot be repeated.\\n";
}
}
//verify the name does not exist
if (ProgramNameCompare.Value != ProgramName.Text.Trim())
{
bool checkName = controller.CheckProgramName(ProgramName.Text.Trim());
if (checkName == false)
{
errorList += "- The Program Name selected currently exists in the system, and cannot be repeated.\\n";
}
}
//Validate field lengths
if (ProgramName.Text.Trim().Length > 100)
{
errorList += "- Program Name cannot exceed 100 characters. \\n";
}
if (ProgramLink.Text.Trim().Length > 150)
{
errorList += "- Program Link cannot exceed 150 characters. \\n";
}
//validate field length
if (EntReqDetail.Text.Trim().Length > 150)
{
errorList += "- Entrance Requirement Details cannot exceed 150 characters. \\n";
}
byte competitiveAdvantage;
result = byte.TryParse(CompetitiveAdv.Text.Trim(), out competitiveAdvantage);
if (!result)
{
errorList += "- Please enter a numeric value into the competitive advantage field (whole numbers greater than zero only). \\n";
}
if (competitiveAdvantage < 0 || competitiveAdvantage > 100)
{
errorList += "- Please enter a numeric value between 1 - 99. \\n";
}
//populate diploma
DiplomaCertificate diploma = new DiplomaCertificate()
{
ProgramID = int.Parse(ProgramID.Text),
ProgramName = ProgramName.Text.Trim(),
ProgramLength = ProgramLength.Text.Trim() + " " + ProgramLengthDDL.SelectedValue,
EntranceRequirementDetail = EntReqDetail.Text.Trim(),
CompetitveAdvantage = competitiveAdvantage,
ProgramLink = ProgramLink.Text.Trim(),
Activated = Activated.Checked,
WorkOutdoors = WorkOutdoors.Checked,
ShiftWork = ShiftWork.Checked,
WorkTravel = Travel.Checked,
CredentialType = true,
CategoryID = int.Parse(CategoryList.SelectedValue)
};
if (errorList != "")
{
throw new Exception(errorList);
}
//process update
//PathwaysController controller = new PathwaysController();
controller.CertDiploma_Update(diploma);
Clear_Click();
Response.Write("<script type=\"text/javascript\">alert('The selected Diploma program has been updated.');</script>");
}
else if (InitialCredential.SelectedValue == "Degree")
{
//Validate non-string variables
bool result = int.TryParse(ProgramLength.Text.Trim(), out temp);
if (!result)
{
errorList += "- Please enter a numeric value into the program length field (whole number only). \\n";
}
if (temp != 0)
{
if ((int.Parse(ProgramLength.Text.Trim())) < 0 || (int.Parse(ProgramLength.Text)) > 100)
{
errorList += "- Program length must be a whole number between 1 - 99. \\n";
}
}
//Validate URL
result = Uri.TryCreate(ProgramLink.Text.Trim(), UriKind.Absolute, out tempUrl) && tempUrl.Scheme == Uri.UriSchemeHttp;
if (!result)
{
errorList += "- Please enter a properly formatted URL (ex. http://www.example.com). \\n";
}
PathwaysController controller = new PathwaysController();
if (ProgramLinkCompare.Value != ProgramLink.Text.Trim())
{
//verify the URL does not exist
bool checkURL = controller.CheckDegUrl(ProgramLink.Text.Trim());
if (checkURL == false)
{
errorList += "- The url selected currently exists in the system, and cannot be repeated.\\n";
}
}
//verify the name does not exist
if (ProgramNameCompare.Value != ProgramName.Text.Trim())
{
bool checkName = controller.CheckProgramName(ProgramName.Text.Trim());
if (checkName == false)
{
errorList += "- The Program Name selected currently exists in the system, and cannot be repeated.\\n";
}
}
//Validate field lengths
if (ProgramName.Text.Trim().Length > 100)
{
errorList += "- Program Name cannot exceed 100 characters. \\n";
}
if (ProgramLink.Text.Trim().Length > 150)
{
errorList += "- Program Link cannot exceed 150 characters. \\n";
}
//populate degree
Degree degree = new Degree()
{
DegreeID = int.Parse(ProgramID.Text),
DegreeName = ProgramName.Text.Trim(),
DegreeLength = ProgramLength.Text.Trim() + " " + ProgramLengthDDL.SelectedValue,
DegreeLink = ProgramLink.Text.Trim(),
Activated = Activated.Checked,
WorkOutdoors = WorkOutdoors.Checked,
ShiftWork = ShiftWork.Checked,
WorkTravel = Travel.Checked,
CategoryID = int.Parse(CategoryList.SelectedValue)
};
if (errorList != "")
{
throw new Exception(errorList);
}
//process update
//PathwaysController controller = new PathwaysController();
controller.Degree_Update(degree);
Clear_Click();
Response.Write("<script type=\"text/javascript\">alert('The selected Degree program has been updated.');</script>");
}
else
{
}
});
}
