private void btn_UpD_Click(object sender, EventArgs e)
{
if (listViewActivity.SelectedItems.Count == 0)
{
return;
}
Activity activity = (Activity)listViewActivity.SelectedItems[0].Tag;
SomerenLogic.Activities_Service Update_Activity = new SomerenLogic.Activities_Service();
if ((txt_ActName.Text != "") && (txt_NumbStud.Text != "") && (txt_NumbSup.Text != ""))
{
DialogResult dialogBox = MessageBox.Show("Are you sure, you wish to Update this Activity!!!!", "", MessageBoxButtons.YesNo);
if (dialogBox == DialogResult.Yes)
{
Update_Activity.UpdateActivity(activity.ID, txt_ActName.Text, int.Parse(txt_NumbStud.Text), int.Parse(txt_NumbSup.Text));
}
showPanel("Activities"); //to refresh the list.
//after clicking the button clean the text box.
txt_ActName.ResetText();
txt_NumbStud.ResetText();
txt_NumbSup.ResetText();
}
else
{
MessageBox.Show("Please fill in the empty fields..");
}
}
//delete the information selected.
private void btn_Del_Click(object sender, EventArgs e)
{
if (listViewActivity.SelectedItems.Count == 0)
{
return;
}
SomerenLogic.Activities_Service DeleteAct = new SomerenLogic.Activities_Service();
Activity toDelete = (Activity)listViewActivity.SelectedItems[0].Tag;
DialogResult dialogBox = MessageBox.Show("Are you sure, you wish to remove this Activity!!!!", "", MessageBoxButtons.YesNo);// probably need to change this more, but keep it simple right now.
//this is a joke please give me a higher grade??????
//DialogResult dialogBox = MessageBox.Show("What do you want to do with this homework??", "", MessageBoxButtons.AbortRetryIgnore);
if (dialogBox == DialogResult.Yes)
{
DeleteAct.DeleteActivity(toDelete.ID);
}
//else if(dialogBox == DialogResult.No)//dont really need this as it doesnt do anything.
//{
// //it does nothing.
//}
//this has to be last because bae said so.
showPanel("Activities"); //to refresh the list.
//after clicking the button clean the text box.
txt_ActName.ResetText();
txt_NumbStud.ResetText();
txt_NumbSup.ResetText();
}
//add button for the activity panel.
private void btn_Add_Click(object sender, EventArgs e)
{
try
{
ListViewItem item = listViewActivity.FindItemWithText(txt_ActName.Text);
if ((txt_ActName.Text == "") || (txt_NumbStud.Text == "") || (txt_NumbSup.Text == ""))//this is for checking all the text back if they have input
{
MessageBox.Show("Please fill in the empty fields..");
}
else if (item != null)
{
MessageBox.Show("Do not fill in the same activity, fool!");
}
else
{
SomerenLogic.Activities_Service AddAct = new SomerenLogic.Activities_Service();
//passing the informations
//string NameofActivity = txt_ActName.Text;
//int numberStud = int.Parse(txt_NumbStud.Text);
//int numberSupervisor = int.Parse(txt_NumbSup.Text);
AddAct.AddActivity(txt_ActName.Text, int.Parse(txt_NumbStud.Text), int.Parse(txt_NumbSup.Text));
showPanel("Activities"); //to refresh the list.
//after clicking the button clean the text box.
txt_ActName.ResetText();
txt_NumbStud.ResetText();
txt_NumbSup.ResetText();
}
}
catch (Exception a)
{
MessageBox.Show(a.Message);
StreamWriter writer = new StreamWriter($"errorLog.txt", true);
writer.WriteLine($"{ DateTime.Now}, error message: {a.Message}");
writer.Close();
}
}
private void showPanel(string panelName)
{
try
{
if (panelName == "Dashboard")
{
// hide all other panels
pnl_Students.Hide();
//thigns i added
pnl_Teachers.Hide();
pnl_Students.Hide();
pnl_Rooms.Hide();
pnl_Sales.Hide();
pnl_Drinks.Hide();
pnl_Activities.Hide();
panel_TimeTable.Hide();
pnl_Supervisors.Hide();
//this is for the barservice
pnl_BarService.Hide();
// show dashboard
pnl_Dashboard.Show();
img_Dashboard.Show();
}
else if (panelName == "Students")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
//things i added
pnl_Teachers.Hide();
pnl_Rooms.Hide();
pnl_Sales.Hide();
pnl_Drinks.Hide();
pnl_Activities.Hide();
panel_TimeTable.Hide();
pnl_Supervisors.Hide();
// show students
pnl_Students.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
listViewStudents.Clear();
listViewStudents.View = View.Details;
listViewStudents.Columns.Add("Student Id", 100, HorizontalAlignment.Left);
listViewStudents.Columns.Add("First Name", 100, HorizontalAlignment.Left);
listViewStudents.Columns.Add("Last Name", 100, HorizontalAlignment.Left);
listViewStudents.Columns.Add("Class", 100, HorizontalAlignment.Left);
listViewStudents.Columns.Add("Contact Info", 100, HorizontalAlignment.Left);
// clear the listview before filling it again
foreach (SomerenModel.Student s in studentList)
{
ListViewItem li = new ListViewItem(s.Number.ToString());
li.SubItems.Add(s.FirstName);
li.SubItems.Add(s.LastName);
li.SubItems.Add(s.Group);
li.SubItems.Add(s.Contact);
listViewStudents.Items.Add(li);
}
}
else if (panelName == "Teachers")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
//things that i added -stephen
pnl_Students.Hide();
pnl_Rooms.Hide();
pnl_BarService.Hide();
pnl_Sales.Hide();
pnl_Drinks.Hide();
pnl_Activities.Hide();
panel_TimeTable.Hide();
pnl_Supervisors.Hide();
// show Teachers
pnl_Teachers.Show();
// fill the teacher listview within the teacher panel with a list of teachers
SomerenLogic.Teacher_Service teacherService = new SomerenLogic.Teacher_Service();
List <Teacher> teacherList = teacherService.GetTeachers();
// clear the listview before filling it again
listViewTeachers.Clear();
foreach (SomerenModel.Teacher t in teacherList)
{
ListViewItem ListofT = new ListViewItem(t.Number.ToString());
ListofT.SubItems.Add(t.firstName);
ListofT.SubItems.Add(t.lastName);
ListofT.SubItems.Add(t.supervisor);
ListofT.SubItems.Add(t.Department);
ListofT.SubItems.Add(t.Contact.ToString());
listViewTeachers.Items.Add(ListofT);
}
// this is for the display
listViewTeachers.GridLines = true;
listViewTeachers.FullRowSelect = true;
listViewTeachers.View = View.Details;
listViewTeachers.Columns.Add("Teacher ID", 100, HorizontalAlignment.Left);
listViewTeachers.Columns.Add("First Name", 100, HorizontalAlignment.Left);
listViewTeachers.Columns.Add("Last Name", 100, HorizontalAlignment.Left);
listViewTeachers.Columns.Add("Supervisor", 100, HorizontalAlignment.Left);
listViewTeachers.Columns.Add("Department", 100, HorizontalAlignment.Left);
listViewTeachers.Columns.Add("Contact info.", 100, HorizontalAlignment.Left);
}
else if (panelName == "Rooms")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Teachers.Hide();
pnl_BarService.Hide();
pnl_Sales.Hide();
pnl_Drinks.Hide();
pnl_Activities.Hide();
panel_TimeTable.Hide();
pnl_Supervisors.Hide();
//show rooms
pnl_Rooms.Show();
//fill the rooms listview within rooms panel with a list of rooms
SomerenLogic.Room_Service studService = new SomerenLogic.Room_Service();
List <Room> roomList = studService.GetRooms();
// clear the listview before filling it again
listViewRooms.Clear();
listViewRooms.View = View.Details;
listViewRooms.Columns.Add("Room Id", 100, HorizontalAlignment.Left);
listViewRooms.Columns.Add("TypeOfRoom", 100, HorizontalAlignment.Left);
listViewRooms.Columns.Add("Taken/Not-Taken", 100, HorizontalAlignment.Left);
listViewRooms.Columns.Add("Size", 100, HorizontalAlignment.Left);
foreach (SomerenModel.Room r in roomList)
{
ListViewItem li = new ListViewItem(r.Room_Id.ToString());
li.SubItems.Add(r.Type);
li.SubItems.Add(r.Occupied);
li.SubItems.Add(r.Size.ToString());
listViewRooms.Items.Add(li);
}
}
else if (panelName == "Cash Register")
{
pnl_Dashboard.Hide();
pnl_Students.Hide();
pnl_Teachers.Hide();
pnl_Rooms.Hide();
pnl_Sales.Show();
pnl_Drinks.Hide();
panel_TimeTable.Hide();
pnl_Supervisors.Hide();
SomerenLogic.Cash_Service studService = new SomerenLogic.Cash_Service();
//List<CashRegister> drList = studService.GetDrinks();
SomerenLogic.Student_Service ss = new SomerenLogic.Student_Service();
List <Student> stList = ss.GetStudents();
comboBoxStudents.DataSource = stList;
comboBoxStudents.DisplayMember = "Name";
//checkedListBoxDrinks.DataSource = drList;
checkedListBoxDrinks.DisplayMember = "Name";
}
else if (panelName == "Bar Service")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Teachers.Hide();
pnl_Rooms.Hide();
pnl_Sales.Hide();
pnl_Drinks.Hide();
pnl_Activities.Hide();
//show the
//pnl_BarService.Show();
}
else if (panelName == "Drinks")
{
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Teachers.Hide();
pnl_Rooms.Hide();
pnl_Sales.Hide();
pnl_BarService.Hide();
pnl_Activities.Hide();
panel_TimeTable.Hide();
pnl_Supervisors.Hide();
pnl_Drinks.Show();
ShowData();
}
else if (panelName == "Sales Report")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Teachers.Hide();
pnl_Rooms.Hide();
pnl_Sales.Hide();
pnl_Drinks.Hide();
pnl_Activities.Hide();
panel_TimeTable.Hide();
pnl_Supervisors.Hide();
StartCalendar.MaxDate = DateTime.Today;//this is for the calendar to only show the dates til today.
//show the
pnl_BarService.Show();
//this is to show all the transaction.. with no specific date, just all the current transaction in the
//the database.
SomerenLogic.Revenue_Service revenueService = new SomerenLogic.Revenue_Service();
List <Revenue> revenueList = revenueService.GetRevenue();
// clear the listview before filling it again
listViewRevenue.Clear();
foreach (SomerenModel.Revenue r in revenueList)
{
ListViewItem ListofRev = new ListViewItem((r.Students).ToString());//(r.Date.ToString("yyyy-dd-MM"));
//ListViewItem ListofRev = new ListViewItem((r.Date).ToString("dd-MM-yyyy"));
ListofRev.SubItems.Add((r.Price).ToString());
ListofRev.SubItems.Add((r.Prod_Sold).ToString());
ListofRev.SubItems.Add((r.Date).ToString("dd-MM-yyyy"));
ListofRev.SubItems.Add((r.Turnover).ToString());
listViewRevenue.Items.Add(ListofRev);
}
listViewRevenue.GridLines = true;
listViewRevenue.FullRowSelect = true;
listViewRevenue.View = View.Details;
listViewRevenue.Columns.Add("Student", 100, HorizontalAlignment.Left);
listViewRevenue.Columns.Add("Price", 100, HorizontalAlignment.Left);
listViewRevenue.Columns.Add("Amount product Sold", 120, HorizontalAlignment.Left);
listViewRevenue.Columns.Add("Date", 100, HorizontalAlignment.Left);
listViewRevenue.Columns.Add("Turnover", 100, HorizontalAlignment.Left);
//clear the list after for the display when the date is selecteds
lblmsg.Text = "General overview of transaction";
lblStart.Text = "";
lblEnd.Text = "";
}
else if (panelName == "Activities")
{
//hide
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Teachers.Hide();
pnl_Rooms.Hide();
pnl_Sales.Hide();
pnl_Drinks.Hide();
panel_TimeTable.Hide();
pnl_Supervisors.Hide();
//show
pnl_Activities.Show();
SomerenLogic.Activities_Service activityService = new SomerenLogic.Activities_Service();
List <Activity> activityList = activityService.GetActivity();
//clear listview before filling in the informations
listViewActivity.Clear();
//the informations that needs to be shown
foreach (SomerenModel.Activity a in activityList)
{
ListViewItem ListofActivities = new ListViewItem(a.ID.ToString());
ListofActivities.SubItems.Add((a.Description));
ListofActivities.SubItems.Add(a.numbOfStudent.ToString());
ListofActivities.SubItems.Add(a.numbOfTeacher.ToString());
ListofActivities.Tag = a;
listViewActivity.Items.Add(ListofActivities);
}
listViewActivity.GridLines = true;
listViewActivity.FullRowSelect = true;
listViewActivity.View = View.Details;
listViewActivity.Columns.Add("Activity ID", 100, HorizontalAlignment.Left);
listViewActivity.Columns.Add("Description", 100, HorizontalAlignment.Left);
listViewActivity.Columns.Add("Number Of Students", 100, HorizontalAlignment.Left);
listViewActivity.Columns.Add("Number Of Supervisors", 100, HorizontalAlignment.Left);
}
else if (panelName == "Supervisors")
{
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Teachers.Hide();
pnl_Rooms.Hide();
pnl_Sales.Hide();
pnl_Drinks.Hide();
pnl_BarService.Hide();
pnl_Activities.Hide();
panel_TimeTable.Hide();
pnl_Supervisors.Show();
//displaying datagridview in another method
DisplayDataSup();
//to get all the info from teacher's table
SomerenLogic.Teacher_Service teacherdb = new SomerenLogic.Teacher_Service();
List <Teacher> TeacherList = teacherdb.GetTeachers();
combo_Teacher.DataSource = TeacherList;
//only displaying the first name in the combo box
combo_Teacher.DisplayMember = "FirstName";
}
//time table
else if (panelName == "Time Table")
{
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Teachers.Hide();
pnl_Rooms.Hide();
pnl_Sales.Hide();
pnl_Drinks.Hide();
pnl_Activities.Hide();
pnl_BarService.Hide();
pnl_Activities.Hide();
pnl_Supervisors.Hide();
//to show
panel_TimeTable.Show();
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
StreamWriter writer = new StreamWriter($"errorLog.txt", true);
writer.WriteLine($"{ DateTime.Now}, error message: {e.Message}");
writer.Close();
}
}