/// <summary> /// Signals that a request has been completed, therefore it no longer /// has to display on the list /// </summary> private void FoodRequest_Completed(object sender, DataGridViewCellEventArgs e) { // Get the values needed to identify each unique row string date = RequestsList.Rows[e.RowIndex].Cells[8].Value.ToString(); string time = RequestsList.Rows[e.RowIndex].Cells[9].Value.ToString(); string uid = RequestsList.Rows[e.RowIndex].Cells[10].Value.ToString(); // Have to reformat the string to fix Visual studio's stupid crap // Visual studio formats date to: "MM/DD/YYYY HH:MM:SS" When it needs to be "YYYY-MM-DD" date = date.Replace("/", "-"); date = date.Substring(0, date.IndexOf(" ")); // Remove everything after the space string[] _splitdate = date.Split('-'); // Split up d, m, y string[] _reverseddate = new string[3]; _reverseddate[0] = _splitdate[2]; // Map date to correct area _reverseddate[1] = _splitdate[0]; // Map month to correct area _reverseddate[2] = _splitdate[1]; // Map day to correct area date = String.Join("-", _reverseddate); // Combine strings // If it was able to complete the request, reload the list if (Requests_Handler.Complete_Request(uid, date, time)) { Display_Lists(); } }
private void Submit_Button_Click(object sender, EventArgs e) { Requests_Handler.Add_Timed_Request(_type, _hour + ":" + _minute + ":00"); MessageBox.Show("Your request has been acknowledged"); /* * _time = _hour + ":" + _minute; * Parameters = new List<string>(); * Parameters.Add("User_id"); * Parameters.Add("Type_of"); * Parameters.Add("Choice"); * Parameters.Add("First_Name"); * Parameters.Add("Last_Name"); * Parameters.Add("Section"); * Parameters.Add("Room"); * ParameterValues = new List<string>(); * ParameterValues.Add(form1.UserIDProperty); * ParameterValues.Add("Bathing"); * ParameterValues.Add(_type); * ParameterValues.Add(form1.FirstNameProperty); * ParameterValues.Add(form1.LastNameProperty); * ParameterValues.Add(form1.SectionProperty); * ParameterValues.Add(form1.RoomProperty); * _time = _hour + ":" + _minute; * * connect.Insert("INSERT INTO Requests (User_id, Type_of, Choice, First_Name, Last_Name, Section, Room) VALUES (@User_id, @Type_of, @Choice, @First_Name, @Last_Name, @Section, @Room);", Parameters, ParameterValues); * MessageBox.Show("Your request has been acknowledged");*/ }
public void CallRequest() { /* * Parameters = new List<string>(); * Parameters.Add("User_id"); * Parameters.Add("Type_of"); * Parameters.Add("Choice"); * Parameters.Add("First_Name"); * Parameters.Add("Last_Name"); * Parameters.Add("Section"); * Parameters.Add("Room"); * ParameterValues = new List<string>(); * ParameterValues.Add(form1.UserIDProperty); * ParameterValues.Add("Emergency Request"); * ParameterValues.Add("Emergency"); * ParameterValues.Add(form1.FirstNameProperty); * ParameterValues.Add(form1.LastNameProperty); * ParameterValues.Add(form1.SectionProperty); * ParameterValues.Add(form1.RoomProperty); */ time = DateTime.Now.ToLongTimeString(); time = time.Substring(0, time.Length - 3); if (time.Length == 7) { time = "0" + time; } Requests_Handler.Add_Timed_Request("Emergency", time); //connect.Insert("INSERT INTO Requests (Request_id, User_id, Type_of, Choice, First_Name, Last_Name, Section, Room) VALUES (Default, @Type_of, 'Emergency Request', 'Emergency', '@First_Name', '@Last_Name', '@Section', '@Room')", Parameters, ParameterValues); }
// Once user has clicked on submit private void Submit_Button_Click(object sender, EventArgs e) { Requests_Handler.Add_Timed_Request("alarm", Hour + ":" + Minute + ":00"); MessageBox.Show("You have added an alarm"); // Reload the alarms so the datagridview is updated Display_Alarms(); }
private void Add_New_User_Button_CellContentClick(object sender, DataGridViewCellEventArgs e) { rowToDel = Add_New_User_Button.Rows[e.RowIndex].Cells[4].Value.ToString(); Debug.WriteLine(rowToDel); Requests_Handler.Complete_Request(rowToDel, "NEWVisitorSignIn"); Requests_Handler.Show_Visitors(); Add_New_User_Button.DataSource = Requests_Handler.DataTable1; MessageBox.Show("Thanks for visiting!"); }
public void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { timedRowToDel = dataGridView1.Rows[e.RowIndex].Cells[6].Value.ToString(); Debug.WriteLine(timedRowToDel); Requests_Handler.Complete_Request(timedRowToDel, "NEWTimedRequest"); Display_Lists(); }
public Visitor_Signin(List_Of_Requests _list, Mysql_Connect _mysql, Form1 _form1) { InitializeComponent(); list = _list; mysql = _mysql; form1 = _form1; Requests_Handler.Show_Visitors(); Add_New_User_Button.DataSource = Requests_Handler.DataTable1; }
/// <summary> /// Used to display all requests onto a list /// </summary> private void Display_Lists() { // Show requests for food Requests_Handler.Show_Requests(); RequestsList.DataSource = Requests_Handler.DataTable; // Show requests for wake up calls and showers Requests_Handler.Show_Timed_Requests(); TimedRequestsList.DataSource = Requests_Handler.DataTable; }
/// <summary> /// Used to display all requests onto a list /// </summary> public void Display_Lists() { // Show requests for food Requests_Handler.Show_Requests(); Add_New_User_Button.DataSource = Requests_Handler.DataTable1; // Show requests for wake up calls and showers Requests_Handler.Show_Timed_Requests(); dataGridView1.DataSource = Requests_Handler.DataTable2; }
// Remove an alarm once a user has clicked on it private void Remove_Alarm(object sender, DataGridViewCellEventArgs e) { // Get the value of the 1st column for the alarm // that the user wants to delete int TheRow = e.RowIndex; string alarm_time = AlarmsList.Rows[TheRow].Cells[1].Value.ToString(); // If the alarm was deleted refresh the datagridview if (Requests_Handler.Delete_Alarm(alarm_time)) { Display_Alarms(); } }
// Once user has clicked on submit public void Submit_Button_Click(object sender, EventArgs e) { if (Hour_Box.Text == "Hour" || Minute_Box.Text == "Minutes") { MessageBox.Show("You must enter all details"); } else { Requests_Handler.Add_Timed_Request("alarm", Hour + ":" + Minute + ":00"); MessageBox.Show("You have added an alarm"); } // Reload the alarms so the datagridview is updated Display_Alarms(); }
/// <summary> /// Signals that a request has been completed, therefore it no longer /// has to display on the list /// </summary> public void FoodRequest_Completed(object sender, DataGridViewCellEventArgs e) { rowToDel = Add_New_User_Button.Rows[e.RowIndex].Cells[10].Value.ToString(); Debug.WriteLine(rowToDel); Requests_Handler.Complete_Request(rowToDel, "NEWFoodRequest"); // Get the values needed to identify each unique row /* string date = RequestsList.Rows[e.RowIndex].Cells[8].Value.ToString(); * string time = RequestsList.Rows[e.RowIndex].Cells[9].Value.ToString(); * string uid = RequestsList.Rows[e.RowIndex].Cells[10].Value.ToString(); * * // Have to reformat the string to fix Visual studio's stupid crap * // Visual studio formats date to: "MM/DD/YYYY HH:MM:SS" When it needs to be "YYYY-MM-DD" * date = date.Replace("/", "-"); * date = date.Substring(0, date.IndexOf(" ")); // Remove everything after the space * * string[] _splitdate = date.Split('-'); // Split up d, m, y * string[] _reverseddate = new string[3]; * * _reverseddate[0] = _splitdate[2]; // Map date to correct area * _reverseddate[1] = _splitdate[0]; // Map month to correct area * _reverseddate[2] = _splitdate[1]; // Map day to correct area * * date = String.Join("-", _reverseddate); // Combine strings * * * * // If it was able to complete the request, reload the list * if (Requests_Handler.Complete_Request(uid, date, time)) * { * Display_Lists(); * } */ Display_Lists(); }
// Once a user has submitted their request for food public void Submit_Clicked(object sender, EventArgs e) { Requests_Handler.Add_Food(_chosenMealName, _HotOrCold, _mealType); MessageBox.Show("Your request has been recorded"); }
// Load all alarms private void Display_Alarms() { Requests_Handler.Show_Alarms(); AlarmsList.DataSource = Requests_Handler.DataTable; }
// Load all alarms public void Display_Alarms() { Requests_Handler.Show_Alarms(); AlarmsList.DataSource = Requests_Handler.DataTable1; }
public void AlarmsList_CellContentClick(object sender, DataGridViewCellEventArgs e) { Requests_Handler.Show_Alarms(); AlarmsList.DataSource = Requests_Handler.DataTable1; }
private void button2_Click(object sender, EventArgs e) { Requests_Handler.Add_Visitor(_FirstName, _LastName, _PersonVisiting, DateTime.Now.ToString("hh:mm:ss tt")); Requests_Handler.Show_Visitors(); Add_New_User_Button.DataSource = Requests_Handler.DataTable1; }