public void onClickApprove(object sender, EventArgs e) { DataButton b = (DataButton)sender; b.BackgroundColor = ClientData.getGridColorCC(true); string sql; if (b.GetInt2() == 1) { b.BackgroundColor = ClientData.rotatingConfirmationColors[0]; b.Text = "Approve"; b.Integer2 = 0; sql = "UPDATE punchclock SET Approved='0' WHERE IDKey='" + b.GetInt() + "'"; } else { b.Text = "Disapprove"; b.BackgroundColor = ClientData.rotatingNegativeColors[0]; b.Integer2 = 1; sql = "UPDATE punchclock SET Approved='1' WHERE IDKey='" + b.GetInt() + "'"; } DatabaseFunctions.SendToPhp(sql); }
public void onClickANote(object sender, EventArgs e) { DataButton b = (DataButton)sender; string sql = "UPDATE punchclock SET AdminNote='" + AdminNote.Text + "' WHERE IDKey='" + b.GetInt() + "'"; DatabaseFunctions.SendToPhp(sql); b.BackgroundColor = Color.FromRgb(213, 213, 213); }
public void onClickOverrideTime(object sender, RoutedEventArgs e) { DataButton b = (DataButton)sender; string sql = "UPDATE punchclock SET TimeStamp='" + FormatFunctions.CleanDateNew(Timepick.Text) + "' WHERE IDKey='" + b.GetInt() + "'"; DatabaseFunctions.SendToPhp(sql); b.Background = new SolidColorBrush(Color.FromRgb(213, 213, 213)); }