/// <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;
}
