private void SaveButton_Click(object sender, EventArgs e)
{
string timestamp = SqlUpdater.CreateTimestamp();
int userId = SqlUpdater.GetCurrentUserID();
string username = SqlUpdater.GetCurrentUserName();
int appointmentId = Convert.ToInt32(SearchBar.Text);
int customerId = Convert.ToInt32(TeamIdBox.Text);
string type = TypeBox.Text;
DateTime startTime = DateTime.Parse(StartTimeBox.Text).ToUniversalTime();
DateTime endTime = DateTime.Parse(EndTimeBox.Text).ToUniversalTime();
//String st = DateTime.Parse(StartTimeBox.Text).ToUniversalTime().ToString("u");
//String et = DateTime.Parse(EndTimeBox.Text).ToUniversalTime().ToString("u");
String st = DateTime.Parse(StartTimeBox.Text).ToUniversalTime().ToString("yyyy-MM-dd hh:mm:ss");
String et = DateTime.Parse(EndTimeBox.Text).ToUniversalTime().ToString("yyyy-MM-dd hh:mm:ss");
bool pass = Validator();
if (pass)
{
try
{
if (AppHasConflict(startTime, endTime))
{
throw new ScheduleException();
}
else
{
try
{
if (OutsideBusinessHours(startTime, endTime))
{
throw new ScheduleException();
}
else
{
SqlUpdater.UpdateAppt(customerId, userId, st, et, type, timestamp, username, appointmentId);
mainScheduleObject.UpdateCalendar();
MessageBox.Show("Update Sucessfull.");
Close();
}
}
catch (ScheduleException ex) { ex.BusinessHours(); }
}
}
catch (ScheduleException ex) { ex.AppOverlap(); }
}
else
{
MessageBox.Show("Add Schedule Error.");
}
}
private void AddButton_Click(object sender, EventArgs e)
{
string timestamp = SqlUpdater.CreateTimestamp();
int userId = SqlUpdater.GetCurrentUserID();
string userName = SqlUpdater.GetCurrentUserName();
DateTime startTime = DateTime.Parse(StartTimeBox.Text).ToUniversalTime();
DateTime endTime = DateTime.Parse(EndTimeBox.Text).ToUniversalTime();
string type = TypeBox.Text;
int teamId = Convert.ToInt32(TeamIdBox.Text);
string st = DateTime.Parse(StartTimeBox.Text).ToUniversalTime().ToString("yyyy-MM-dd hh:mm:ss");
string et = DateTime.Parse(EndTimeBox.Text).ToUniversalTime().ToString("yyyy-MM-dd hh:mm:ss");
string title = " ";
string description = " ";
string location = " ";
string url = " ";
string contact = " ";
bool pass = Validator();
if (pass)
{
try
{
if (AppHasConflict(startTime, endTime))
{
throw new ScheduleException();
}
else
{
try
{
if (OutsideBusinessHours(startTime, endTime))
{
throw new ScheduleException();
}
else
{
SqlUpdater.CreateSchedule("appointment", teamId, st, et, type, title, description, location, url, contact, timestamp, userName, userId);
mainScheduleObject.UpdateCalendar();
Close();
}
}
catch (ScheduleException ex) { ex.BusinessHours(); }
}
}
catch (ScheduleException ex) { ex.AppOverlap(); }
}
static public int FindUser(string userName, string password)
{
MySqlConnection C = new MySqlConnection(SqlUpdater.conString);
C.Open();
MySqlCommand cmd = new MySqlCommand($"SELECT userId FROM user WHERE userName = '******' AND password = '******'", C);
MySqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
rdr.Read();
SqlUpdater.SetCurrentUserID(Convert.ToInt32(rdr[0]));
SqlUpdater.SetCurrentUserName(userName);
rdr.Close();
return(SqlUpdater.GetCurrentUserID());
}
return(0);
}
