public static bool AddAppointment(Appointment meeting) { try { Connect(); cmd = new OracleCommand(); cmd.Connection = con; cmd.CommandText = "Insert into TAFSPRAAK(CLIENT, VOLUNTEER, DATUMTIJD, LOCATIE) VALUES (:NewCLIENT, :NewVOLUNTEER, :NewDATUMTIJD, :NewLOCATIE)"; cmd.Parameters.Add("NewCLIENT", OracleDbType.Int32).Value = meeting.Client.UserID; cmd.Parameters.Add("NewVOLUNTEER", OracleDbType.Int32).Value = meeting.Volunteer.UserID; cmd.Parameters.Add("NewDATUMTIJD", OracleDbType.Varchar2).Value = meeting.DateString; cmd.Parameters.Add("NewLOCATIE", OracleDbType.Varchar2).Value = meeting.Location; cmd.ExecuteNonQuery(); return true; } catch (Exception ex) { MessageBox.Show(ex.Message); return false; } finally { Disconnect(); } }
public Form_Meeting(Appointment meeting) { InitializeComponent(); label1.Text = meeting.Client.Name; lbl_VolunName.Text = "Geholpen door: " + meeting.Volunteer.Name; dtp_Date.Value = meeting.Date; tbox_Location.Text = meeting.Location; dtp_Date.Enabled = false; tbox_Location.Enabled = false; btn_AddMeeting.Visible = false; }
// TODO: NOT CORRECT public bool AddMeeting(Client client, Volunteer volunteer, DateTime date, string location) { Appointment meeting = new Appointment(client, volunteer, date, location); return false; ; }
// TODO: NOT CORRECT public bool AddMeeting(Client client, Volunteer volunteer, DateTime date, string location) { Appointment meeting = new Appointment(client, volunteer, date, location); return(false);; }