private void btnSave_Click(object sender, RoutedEventArgs e) { Appointment ap = DataContext as Appointment; if (ap == null || ap.Id == 0) { //NEW DATA ap = new Appointment(); ap.Subject = txtSubject.Text; ap.Notes = txtNotes.Text; ap.ApDate = dtAppDate.DisplayDate.Date; ap.Aptime = txtTime.Text; Dentist dent = cbDentist.SelectedItem as Dentist; ap.Dentist = dent; ap.Patient = App.patient; ap.Room = (string)cbRoom.SelectedValue; DB.insertAppointment(ap); } else { ap.Subject = txtSubject.Text; ap.Notes = txtNotes.Text; ap.ApDate = dtAppDate.DisplayDate.Date; ap.Aptime = txtTime.Text; Dentist dent = cbDentist.SelectedItem as Dentist; ap.Dentist = dent; ap.Patient = App.patient; ap.Room = (string)cbRoom.SelectedValue; DB.updateAppointment(ap); } this.Close(); }
private void AptCalendar_DayBoxDoubleClicked(object sender, RoutedEventArgs e) { //MessageBox.Show("AptCalendar_DayBoxDoubleClicked"); //new appointment NewAppointmentEventArgs aea = e as NewAppointmentEventArgs; AppointmentEditForm ef = new AppointmentEditForm(); Appointment ap = new Appointment(); ap.ApDate = aea.StartDate; ef.DataContext = ap; ef.ShowDialog(); Changed(); }
private Appointment toAppointment(IDataReader dataReader) { Appointment p = new Appointment(); p.Id = dataReader.GetInt32(dataReader.GetOrdinal("id")); p.Subject = GetStringSafe(dataReader, "subject"); p.Room = GetStringSafe(dataReader, "room"); p.Notes = GetStringSafe(dataReader, "notes"); p.Aptime = GetStringSafe(dataReader, "appointment_time"); p.ApDate = dataReader.GetDateTime(dataReader.GetOrdinal("appointment_date")); ; p.Patient = findPatientById(GetStringSafe(dataReader,"patient")); p.Dentist = findDentistByUserId(GetStringSafe(dataReader, "dentist")); return p; }
internal bool updateAppointment(Appointment t) { string tableName = "Appointments"; string setColumns = "subject='" + t.Subject + "',patient='" + t.Patient.Id + "', dentist='" + t.Dentist.UserId + "', appointment_date='" + t.ApDate.ToString(Smile.DATE_FORMAT) + "', appointment_time='" + t.Aptime + "', room='" + t.Room + "', notes='" + t.Notes+ "', modified='" + DateTime.Now.ToString(Smile.LONG_DATE_FORMAT) + "', modifiedBy='" + User + "' "; string query = "UPDATE " + tableName + " SET " + setColumns + " WHERE id = "+t.Id+""; if (this.OpenConnection() == true) { IDbCommand cmd = getSqlCommand(query, connection); cmd.ExecuteNonQuery(); return true; } return false; }
internal bool insertAppointment(Appointment t) { string tableName = "Appointments"; string columns = "(subject, patient, dentist, appointment_date, appointment_time, room, notes, created,createdBy)"; string values = "('" + t.Subject + "','" + t.Patient.Id + "','" + t.Dentist.UserId + "','" + t.ApDate.ToString(Smile.DATE_FORMAT) + "'," + t.Aptime + ",'" + t.Room + "','" + t.Notes+ "','" + DateTime.Now.ToString(Smile.LONG_DATE_FORMAT) + "','" + User + "')"; string query = "INSERT INTO " + tableName + " " + columns + " values " + values + " ;"; if (this.OpenConnection() == true) { IDbCommand cmd = getSqlCommand(query, connection); cmd.ExecuteNonQuery(); //t.Id = (int)cmd.LastInsertedId; t.Id = getLastInsertId(cmd, query, connection); this.CloseConnection(); return true; } return false; }