private void btnSave_Click(object sender, EventArgs e)
{
try
{
StudentSections studentSections = new StudentSections();
studentSections.SectionID = Convert.ToInt32(txtSectionName.Tag);
studentSections.SectionName = txtSectionName.Text;
studentSections.SessionID = Convert.ToInt64(cmbStudentSession.SelectedValue);
studentSections.CreatedDateTime = System.DateTime.Now;
studentSections.CreatedByID = Convert.ToInt32(this.Tag);
studentSections.LastUpdateByID = Convert.ToInt32(this.Tag);
studentSections.LastUpdateDateTime = System.DateTime.Now;
studentSections.IsEnabled = chkIsEnabled.Checked;
studentSections.Remarks = txtSectionRemarks.Text;
long section_id = StudentSectionsController.InsertUpdateStudentSections(studentSections);
txtSectionName.Tag = section_id;
if (section_id > 0)
{
SuccessMessage.SHowDialog("Record Entered Successfully ");
StudentSectionDataGridView.DataSource = sections;
}
else
{
WarningMessage.SHowDialog("Error: Section Not Added");
}
}
catch (Exception ex)
{
MessageBox.Show(Convert.ToString(ex));
}
}
private void BindingDataToComboBox()
{
try
{
List <StudentDegree> student_degrees = StudentDegreeController.StudentDegreeSelectAll();
cmbStudentAdmissionDegree.DataSource = student_degrees;
cmbStudentAdmissionDegree.DisplayMember = "DegreeName";
cmbStudentAdmissionDegree.ValueMember = "DegreeID";
cmbStudentAdmissionDegree.Tag = "DegreeID";
cmbStudentAdmissionDegree.SelectedIndex = 0;
List <StudentProgram> selected_programs = StudentProgramController.StudentProgramSelectAll();
cmbStudentAdmissionProgram.DataSource = selected_programs;
cmbStudentAdmissionProgram.DisplayMember = "ProgramName";
cmbStudentAdmissionProgram.ValueMember = "ProgramID";
cmbStudentAdmissionProgram.Tag = "ProgramID";
cmbStudentAdmissionProgram.SelectedIndex = 0;
List <StudentSession> student_Sessions = StudentSessionController.StudentSessionSelectAll();
cmbStudentSession.DataSource = student_Sessions;
cmbStudentSession.DisplayMember = "SessionName";
cmbStudentSession.ValueMember = "SessionID";
cmbStudentSession.Tag = "SessionID";
cmbStudentSession.SelectedIndex = 0;
List <StudentSections> Student_section = StudentSectionsController.StudentSectionsSelectAll();
cmbStudentSession.DataSource = Student_section;
cmbStudentSession.DisplayMember = "SectionName";
cmbStudentSession.ValueMember = "SectionID";
cmbStudentSession.Tag = "SectionID";
cmbStudentSession.SelectedIndex = 0;
List <StudentSubject> student_Subject = StudentSubjectController.StudentSubjectSelectAll();
cmbMasterMajor.DataSource = student_Subject;
cmbMasterMajor.DisplayMember = "SubjectName";
cmbMasterMajor.ValueMember = "SubjectID";
cmbMasterMajor.Tag = "SubjectID";
cmbMasterMajor.SelectedIndex = 0;
List <DAEStudentMajor> student_DAEMajor = DAEStudentMajorController.DAEStudentMajorSelectAll();
cmbInterStudentDEAMajor.DataSource = student_DAEMajor;
cmbDAE.DisplayMember = "DAEName";
cmbInterStudentDEAMajor.ValueMember = "DAEMajorID";
cmbInterStudentDEAMajor.Tag = "DAEMajorID";
cmbInterStudentDEAMajor.SelectedIndex = 0;
List <AllReligion> religion = AllReligionController.AllReligionSelectAll();
cmbRligion.DataSource = religion;
cmbRligion.DisplayMember = "ReligionName";
cmbRligion.ValueMember = "ReligionID";
cmbRligion.Tag = "ReligionID";
cmbRligion.SelectedIndex = 0;
}
catch (Exception) { }
}
public static List <StudentSections> StudentSectionsSelectBySessionID(Int64 session_id)
{
List <StudentSections> student_programs = StudentSectionsController.StudentSectionsSelectAll();
List <StudentSections> selected_Sections = new List <StudentSections>();
foreach (StudentSections sections in student_programs)
{
if (sections.SectionID == session_id)
{
selected_Sections.Add(sections);
}
}
return(selected_Sections);
}
private void cmbStudentSession_SelectedIndexChanged(object sender, EventArgs e)
{
int session_id = 0;
try
{
session_id = Convert.ToInt32(cmbSession.SelectedValue);
List <StudentSections> selected_Sections = new List <StudentSections>();
selected_Sections = StudentSectionsController.StudentSectionsSelectBySessionID(session_id);
cmbSection.DataSource = selected_Sections;
cmbSection.DisplayMember = "SectioName";
cmbSection.ValueMember = "SectionID";
cmbSection.Tag = "SectionID";
cmbSection.SelectedIndex = 0;
}
catch (Exception) { }
}
private void Daly_Tick(object sender, EventArgs e)
{
Daly.Stop();
List <StudentDegree> studentDegrees = new List <StudentDegree>();
studentDegrees = StudentDegreeController.StudentDegreeSelectAll();
lblTotalDegree.Text = studentDegrees.Count.ToString();
StudentDegree studentDegree = new StudentDegree();
studentDegrees = studentDegree.StudentDegreeSelectAll();
List <StudentProgram> studentPrograms = new List <StudentProgram>();
StudentProgram studentProgram = new StudentProgram();
studentPrograms = studentProgram.StudentProgramSelectAll();
lblProgramTotal.Text = studentPrograms.Count.ToString();
List <CollageAdmin> collageAdmins = CollageAdminController.CollageAdminSelectAll();
lblTotalAdmin.Text = collageAdmins.Count.ToString();
List <StudentPersonalInfo> studentPersonalInfos = StudentPersonalInfoController.StudentPersonalInfoSelectAll();
lblTotalStudent.Text = studentPersonalInfos.Count.ToString();
List <StudentSections> studentSections = StudentSectionsController.StudentSectionsSelectAll();
lblTotalSection.Text = studentSections.Count.ToString();
Bunifu.DataViz.Data data = new Bunifu.DataViz.Data();
Bunifu.DataViz.DataPoint dataPoint = new Bunifu.DataViz.DataPoint(Bunifu.DataViz.BunifuCharts._type.column);
Random r = new Random();
dataPoint.addLabely("Degrees", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString());
dataPoint.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString());
dataPoint.addLabely("Users", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString());
dataPoint.addLabely("Program", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString());
dataPoint.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString());
dataPoint.addLabely("Degrees", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString());
dataPoint.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString());
dataPoint.addLabely("Users", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString());
dataPoint.addLabely("Program", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString());
dataPoint.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString());
data.addData(dataPoint);
CollumChart.Render(data);
Bunifu.DataViz.Data data1 = new Bunifu.DataViz.Data();
Bunifu.DataViz.DataPoint dataPoint2 = new Bunifu.DataViz.DataPoint(Bunifu.DataViz.BunifuCharts._type.pie);
dataPoint2.addLabely("Degrees", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString());
dataPoint2.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString());
dataPoint2.addLabely("Users", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString());
dataPoint2.addLabely("Program", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString());
dataPoint2.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString());
dataPoint2.addLabely("Degrees", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString());
dataPoint2.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString());
dataPoint2.addLabely("Users", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString());
dataPoint2.addLabely("Program", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString());
dataPoint2.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString());
data1.addData(dataPoint2);
bunifuCharts1.Render(data1);
Bunifu.DataViz.Data data2 = new Bunifu.DataViz.Data();
Bunifu.DataViz.DataPoint dataPoint3 = new Bunifu.DataViz.DataPoint(Bunifu.DataViz.BunifuCharts._type.spline);
dataPoint3.addLabely("Degrees", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString());
dataPoint3.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString());
dataPoint3.addLabely("Users", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString());
dataPoint3.addLabely("Program", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString());
dataPoint3.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString());
dataPoint3.addLabely("Degrees", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString());
dataPoint3.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString());
dataPoint3.addLabely("Program", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString());
dataPoint3.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString());
data2.addData(dataPoint3);
bunifuCharts2.Render(data2);
Bunifu.DataViz.Data data3 = new Bunifu.DataViz.Data();
Bunifu.DataViz.DataPoint dataPoint4 = new Bunifu.DataViz.DataPoint(Bunifu.DataViz.BunifuCharts._type.area);
dataPoint4.addLabely("Degrees", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString());
dataPoint4.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString());
dataPoint4.addLabely("Users", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString());
dataPoint4.addLabely("Program", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString());
dataPoint4.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString());
dataPoint4.addLabely("Degrees", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString());
dataPoint4.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString());
dataPoint4.addLabely("Program", r.Next(0, Convert.ToInt32(studentDegrees.Count.ToString())).ToString());
dataPoint4.addLabely("Program", r.Next(0, Convert.ToInt32(studentPrograms.Count.ToString())).ToString());
data3.addData(dataPoint4);
bunifuCharts3.Render(data3);
}
