protected void btn_makeappointment_Click(object sender, EventArgs e)
{
if (lbox_getquestion.SelectedItem != null)
{
Question question = (Question)Session["Question"];
Client currentuser = (Client)Session["currentUser"];
Volunteer volun = volunteerhandler.GetVolunteer(Convert.ToInt32(lbox_getquestion.SelectedItem.Value));
if (tb_location.Text != "")
{
DateTime testdate = CalenderTest.SelectedDate;
Meeting meeting = new Meeting(currentuser, volun, testdate, tb_location.Text);
meetinghandler.addmeeting(meeting);
tb_location.Text = "";
locationdiv.Visible = false;
lbox_getquestion.ClearSelection();
errormsgmeeting.ForeColor = System.Drawing.Color.Green;
errormsgmeeting.Text = "Afspraak aangemaakt";
errormsgmeeting.Visible = true;
}
else
{
errormsgmeeting.ForeColor = System.Drawing.Color.Red;
errormsgmeeting.Text = "Geen geldige locatie ingevuld";
errormsgmeeting.Visible = true;
}
}
}
public void addmeeting(Meeting meeting)
{
try
{
dbm.AddMeeting(meeting);
}
catch
{
}
}
public bool AddAppointment(Meeting 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.Date;
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 bool AddMeeting(Meeting meeting)
{
try
{
Connect();
cmd = new OracleCommand();
cmd.Connection = con;
cmd.CommandText =
"Insert into TAFSPRAAK(hulpbehoevendeid, vrijwilligerid, datum, locatie) VALUES (:Newhulpbehoevendeid, :Newvrijwilligerid, :Newdatum, :Newlocatie)";
cmd.Parameters.Add("Newhulpbehoevendeid", OracleDbType.Int32).Value = meeting.Client.ClientID;
cmd.Parameters.Add("Newvrijwilligerid", OracleDbType.Int32).Value = meeting.Volunteer.VolunteerID;
cmd.Parameters.Add("Newdatum", OracleDbType.Date).Value = meeting.Date;
cmd.Parameters.Add("Newlocatie", OracleDbType.Varchar2).Value = meeting.Location;
cmd.ExecuteNonQuery();
return true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return false;
}
finally
{
Disconnect();
}
}
/// <summary>
/// Gets the meetings of the given user.
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public List<Meeting> GetMeetings(User user)
{
try
{
List<Meeting> meetings = new List<Meeting>();
Connect();
if (user is Client)
{
Client actualuser = user as Client;
using (cmd = new OracleCommand())
{
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from tafspraak a left join tvrijwilliger v on a.VRIJWILLIGERID = v.ID left join tgebruiker g on v.GEBRUIKERID = g.id left join taccount acc on g.ACCOUNTID = acc.ID where hulpbehoevendeid = :clientid";
cmd.Parameters.Add("clientid", actualuser.ClientID);
dr = cmd.ExecuteReader();
while (dr.Read())
{
var meetingid = SafeReadInt(dr, 0);
var clientid = SafeReadInt(dr, 1);
var volunteerid = SafeReadInt(dr, 2);
var date = SafeReadDateTime(dr, 3);
var location = SafeReadString(dr, 4);
var trash = SafeReadInt(dr, 5);
var dateofbirth = SafeReadDateTime(dr, 6);
var profilephoto = SafeReadString(dr, 7);
var vogpath = SafeReadString(dr, 8);
var userid = SafeReadInt(dr, 9);
var trash2 = SafeReadInt(dr, 10);
var givenname = SafeReadString(dr, 11);
var address = SafeReadString(dr, 12);
var city = SafeReadString(dr, 13);
var phonenumber = SafeReadString(dr, 14);
var haslicense = SafeReadString(dr, 15);
var hascar = SafeReadString(dr, 16);
var unsubscribedate = SafeReadDateTime(dr, 17);
var accountid = SafeReadInt(dr, 18);
var thrash3 = SafeReadInt(dr, 19);
var username = SafeReadString(dr, 20);
var password = SafeReadString(dr, 21);
var email = SafeReadString(dr, 22);
Volunteer helper = new Volunteer(accountid, username, password, email, userid, givenname, address, city, phonenumber, haslicense, hascar, unsubscribedate, volunteerid, dateofbirth, profilephoto, vogpath);
Meeting toadd = new Meeting(meetingid, actualuser, helper, date , location);
meetings.Add(toadd);
}
return meetings;
}
}
else
{
Volunteer actualuser = user as Volunteer;
using (cmd = new OracleCommand())
{
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from tafspraak a left join thulpbehoevende h on a.HULPBEHOEVENDEID = h.ID left join tgebruiker g on h.GEBRUIKERID = g.id left join taccount acc on g.ACCOUNTID = acc.ID where a.hulpbehoevendeid = :volunteerid";
cmd.Parameters.Add("volunteerid", actualuser.VolunteerID);
dr = cmd.ExecuteReader();
while (dr.Read())
{
var meetingid = SafeReadInt(dr, 0);
var clientid = SafeReadInt(dr, 1);
var volunteerid = SafeReadInt(dr, 2);
var date = SafeReadDateTime(dr, 3);
var location = SafeReadString(dr, 4);
var trash = SafeReadInt(dr, 5);
var ovpossible = SafeReadString(dr, 6);
var userid = SafeReadInt(dr, 7);
var trash2 = SafeReadInt(dr, 8);
var givenname = SafeReadString(dr, 9);
var address = SafeReadString(dr, 10);
var city = SafeReadString(dr, 11);
var phonenumber = SafeReadString(dr, 12);
var haslicense = SafeReadString(dr, 13);
var hascar = SafeReadString(dr, 14);
var unsubscribedate = SafeReadDateTime(dr, 15);
var accountid = SafeReadInt(dr, 16);
var thrash3 = SafeReadInt(dr, 17);
var username = SafeReadString(dr, 18);
var password = SafeReadString(dr, 19);
var email = SafeReadString(dr, 20);
Client helper = new Client(accountid, username, password, email, userid, givenname, address, city, phonenumber, haslicense, hascar, clientid, ovpossible, unsubscribedate);
Meeting toadd = new Meeting(meetingid, helper, actualuser, date, location);
meetings.Add(toadd);
}
return meetings;
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
return null;
}
finally
{
Disconnect();
}
}