private void btn_Submit_Click(object sender, EventArgs e)
{
if (txt_Semester.Text.ToString() != "")
{
aryViewAttendance = new ArrayList();
dbop = new DBOPStudent();
aryViewAttendance = dbop.View_Attendance(txt_Semester.Text.ToString());
if (aryViewAttendance.Count > 0)
{
//this.Size = new Size(537, 350);
ExtendUI();
GenerateAttendanceSheet(aryViewAttendance);
}
else
{
foreach (var item in groupBox)
{
item.Visible = false;
}
ReduceUI();
MessageBox.Show("Semester Doesn't Have Any Attendance Marked.", "Warning Alert", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("Please Fill The Semester Feild.", "Warning Alert", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void txt_Enrollent_TextChanged(object sender, EventArgs e)
{
student = new Student();
dbop = new DBOPStudent();
student = dbop.SearchByID(txt_Enrollent.Text.ToString());
if (student.getenrollment() != "")
{
Student[] arrStudents = new Student[1];
arrStudents[0] = student;
DataTable dt = ConvertArrayToDataTable(arrStudents);
dataGridView1.DataSource = dt;
}
}
private void txt_Semester_TextChanged(object sender, EventArgs e)
{
student = new Student();
dbop = new DBOPStudent();
ArrayList _aryStd = new ArrayList();
_aryStd = dbop.Top3Student(txt_Semester.Text.ToString());
if (_aryStd != null)
{
Student[] arrStudents = new Student[_aryStd.Count];
arrStudents = _aryStd.ToArray(typeof(Student)) as Student[];
DataTable dt = ConvertArrayToDataTable(arrStudents);
dataGridView1.DataSource = dt;
}
}
private void button1_Click(object sender, EventArgs e)
{
if (txt_Semester.Text.ToString() != "")
{
_Semester = txt_Semester.Text.ToString();
pnl_Setup.Visible = false;
try
{
for (int i = 0; i < aryStd.Count; i++)
{
this.Controls.Remove(groupBox[i]);
}
}
catch (Exception)
{
}
aryStd = new ArrayList();
dbop = new DBOPStudent();
aryStd = dbop.SearchBySemester(txt_Semester.Text.ToString());
if (aryStd.Count > 0)
{
ExtendUI();
pnl_Setup.Visible = true;
GenerateAttendanceSheet(aryStd);
}
else
{
ReduceUI();
MessageBox.Show("Doesn't Exist.", "Warning Alert", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("Please Fill the Semester Feild.", "Warning Alert", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
static void Main(string[] args)
{
Console.Clear();
string path = "";
if (args.Count() > 0)
{
if (args[0].Contains(".txt"))
{
path = args[0];
}
else
{
path = args[0] + "file.txt";
}
}
if (path == "")
{
path = "e:/file.txt";
}
DBOPStudent dbop = new DBOPStudent(path);
Student student = new Student();
string choice = "";
Console.WriteLine("\t\t\t\tVisual Programming Assignment # 1\n\n");
Console.WriteLine("\n\n");
Console.WriteLine("\t\t\t\t1 : Create Student Profile");
Console.WriteLine("\t\t\t\t2 : Search Student");
Console.WriteLine("\t\t\t\t3 : Delete Student Record");
Console.WriteLine("\t\t\t\t4 : Top 3 Student");
Console.WriteLine("\t\t\t\t5 : Mark Student Attendance");
Console.WriteLine("\t\t\t\t6 : View Attendance");
Console.WriteLine("\t\t\t\t7 : To Exit");
Console.Write("\n\t\t\t\tYour Choice.....: ");
choice = Console.ReadLine();
Console.Clear();
switch (choice)
{
case "1":
Console.Write("\n\n\t\t\t\tEnter Enrollment : ");
student.setenrollment(Console.ReadLine());
Console.Write("\t\t\t\tEnter Name : ");
student.setname(Console.ReadLine());
Console.Write("\t\t\t\tEnter Semester : ");
student.setsemester(Console.ReadLine());
Console.Write("\t\t\t\tEnter CGPA : ");
student.setcgpa(double.Parse(Console.ReadLine()));
Console.Write("\t\t\t\tEnter Department : ");
student.setdepartment(Console.ReadLine());
Console.Write("\t\t\t\tEnter University : ");
student.setuniversity(Console.ReadLine());
bool result = dbop.Add_Student(student);
if (result.Equals(true))
{
Console.WriteLine("\n\t\t\t\tStudent Has Been Added Successfully");
}
else
{
Console.WriteLine("\n\t\t\t\tStudent Alreay Exist With This Enrollment");
}
Console.ReadLine();
Main(args);
break;
case "2":
#region [Search Student]
Console.WriteLine("\n\t\t\t\tSearch Student");
Console.WriteLine("\n\n");
Console.WriteLine("\t\t\t\t1 : Search By Enrollment");
Console.WriteLine("\t\t\t\t2 : Search By Name");
Console.WriteLine("\t\t\t\t3 : Search By Semester");
Console.Write("\n\t\t\t\tYour Choice : ");
choice = Console.ReadLine();
switch (choice)
{
case "1":
Console.Clear();
Console.WriteLine("\t\t\t\tSearch By Enrollment");
Console.WriteLine("\n\n");
Console.Write("\t\t\t\tEnter Enrollment : ");
choice = Console.ReadLine();
student = dbop.SearchByID(choice);
if (student.getenrollment() != "")
{
Console.WriteLine("\n\n\t\t\t\tStudent Found !");
Program.print_Student(student);
}
else
{
Console.WriteLine("\n\n\t\t\t\tNot Found!");
}
Console.ReadLine();
Main(args);
break;
case "2":
Console.Clear();
Console.WriteLine("\t\t\t\tSearch By Name");
Console.WriteLine("\n\n");
Console.Write("\t\t\t\tEnter Name : ");
choice = Console.ReadLine();
//student = dbop.SearchByName(choice);
//if (student.getenrollment() != "")
//{
// Console.WriteLine("\n\n\t\t\t\tStudent Found !");
// Program.print_Student(student);
//}
//else
// Console.WriteLine("\n\n\t\t\t\tNot Found!");
ArrayList _aryStd = new ArrayList();
_aryStd = dbop._SearchByName(choice);
if (_aryStd != null)
{
for (int i = 0; i < _aryStd.Count; i++)
{
student = (Student)_aryStd[i];
print_Student(student);
}
}
else
{
Console.WriteLine("Not Found !");
}
Console.ReadLine();
Main(args);
break;
case "3":
Console.Clear();
Console.WriteLine("\t\t\t\tSearch By Semester");
Console.WriteLine("\n\n");
Console.Write("\t\t\t\tEnter Semester : ");
choice = Console.ReadLine();
ArrayList std = new ArrayList();
std = dbop.SearchBySemester(choice);
if (std.Count.Equals(0))
{
Console.WriteLine("\n\n\t\t\t\tStudents Not Found!");
}
else
{
Console.WriteLine("\n\n\t\t\t\tStudents Found !");
for (int i = 0; i < std.Count; i++)
{
Program.print_Student((Student)std[i]);
}
}
Console.ReadLine();
Main(args);
break;
default:
break;
}
Console.ReadLine();
Main(args);
break;
#endregion
case "3":
Console.Clear();
Console.WriteLine("\t\t\t\tDelete By Enrollment");
Console.WriteLine("\n\n");
Console.Write("\t\t\t\tEnter Enrollment : ");
choice = Console.ReadLine();
bool isDeleted = dbop.Delete_Student(choice);
if (isDeleted == true)
{
Console.WriteLine("\n\n\t\t\t\tStudent Has Been Deleted Successfully");
}
else
{
Console.WriteLine("\n\n\t\t\t\tStudent Doesnot Exist!");
}
Console.ReadLine();
Main(args);
break;
case "4":
Console.Clear();
Console.WriteLine("\t\t\t\tTop 3 Students");
ArrayList topStudent = new ArrayList();
Console.Write("\n\n\t\t\t\tEnter Semester : ");
choice = Console.ReadLine();
topStudent = dbop.Top3Student(choice);
if (topStudent != null)
{
for (int i = 0; i < topStudent.Count; i++)
{
print_Student((Student)topStudent[i]);
}
}
else
{
Console.WriteLine("\n\n\n\t\t\t\tNot Enough Records !");
}
Console.ReadLine();
Main(args);
break;
case "5":
Console.Clear();
Console.WriteLine("\t\t\t\tMark Attendance");
Console.Write("\n\n\t\t\t\tEnter Semester : ");
choice = Console.ReadLine();
ArrayList aryStd = new ArrayList();
aryStd = dbop.SearchBySemester(choice);
int[] attendance = new int[aryStd.Count];
if (aryStd.Count != 0)
{
Console.WriteLine("\n\n\t\t\tEnter 0 For Absent And 1 For Present");
Console.WriteLine("\n\n");
Console.WriteLine("\t\t\tEnrollment\tName\n\n");
for (int i = 0; i < aryStd.Count; i++)
{
Student std = new Student();
std = (Student)aryStd[i];
Console.Write("\t\t\t" + std.getenrollment());
Console.WriteLine("\t" + std.getname());
//Console.WriteLine("\t\t\t" + std.get);
}
Console.WriteLine("\n\n\t\t\tEnrollment\tStatus\n");
for (int i = 0; i < aryStd.Count; i++)
{
Student std = new Student();
std = (Student)aryStd[i];
Console.Write("\t\t\t" + std.getenrollment() + "\t: ");
attendance[i] = getAttendanceInput();
}
dbop.Mark_Attendance(choice, attendance);
Console.WriteLine("\n\n\t\t\t\tAttendance Has Been Recorded");
}
else
{
Console.WriteLine("No Record Found!");
}
Console.ReadLine();
Main(args);
break;
case "6":
Console.WriteLine("\t\t\t\tView Attendance");
Console.Write("\n\n\t\t\t\tEnter Semester : ");
choice = Console.ReadLine();
ArrayList aryViewAttendance = new ArrayList();
aryViewAttendance = dbop.View_Attendance(choice);
Console.WriteLine("\n\n\t\t\tEnrollment\t\tName\t\tStatus\n\n");
if (aryViewAttendance != null)
{
for (int i = 0; i < aryViewAttendance.Count; i++)
{
Attendance atd = new Attendance();
atd = (Attendance)aryViewAttendance[i];
Console.Write("\t\t\t" + atd.enrollment);
Console.Write("\t\t" + atd.name);
if (atd.status == 0)
{
Console.WriteLine("\t\t" + "Absent");
}
else
{
Console.WriteLine("\t\t" + "Present");
}
}
}
else
{
Console.WriteLine("\n\n\t\t\t\tAttendance Doesn't Exist");
}
Console.ReadLine();
Main(args);
break;
case "7":
return;
default:
Console.ReadLine();
Main(args);
break;
}
Console.ReadLine();
Main(args);
}