private void CreateAccountButton_Click(object sender, RoutedEventArgs e) { if (CheckDupli() == true) { MsgDupli(); } else { dbman = new DBConnectionManager(); pmsutil = new PMSUtil(); using (conn = new MySqlConnection(dbman.GetConnStr())) { conn.Open(); if (conn.State == ConnectionState.Open) { string uid = Application.Current.Resources["uid"].ToString(); string[] dt = pmsutil.GetServerDateTime().Split(null); DateTime cDate = Convert.ToDateTime(dt[0]); DateTime cTime = DateTime.Parse(dt[1] + " " + dt[2]); string curDate = cDate.ToString("yyyy-MM-dd"); string curTime = cTime.ToString("HH:mm:ss"); string selTime = HourPicker.Text + ":" + MinutePicker.Text + " " + ModePicker.Text; string tid = pmsutil.GenTimeSlotID(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "INSERT INTO timeslots(timeslot_id, timeslot, status)" + "VALUES(@timeslot_id, @timeslot, @status)"; cmd.Prepare(); cmd.Parameters.AddWithValue("@timeslot_id", tid); cmd.Parameters.AddWithValue("@timeslot", DateTime.Parse(selTime).ToString("HH:mm:ss")); cmd.Parameters.AddWithValue("@status", Status.Text); int stat_code = cmd.ExecuteNonQuery(); conn.Close(); if (stat_code > 0) { _caller.SyncTimeSlots(); pmsutil.LogAccount("Added Timeslot: " + DateTime.Parse(selTime).ToString("HH:mm:ss")); MsgSuccess(); this.Close(); } else { MsgFail(); } } else { } } } }