// Methods
public bool StartChat(User currentuser, User otheruser)
{
//int chatid;
//if (!CheckIfChatted(currentuser, otheruser, out chatid))
//{
// return DatabaseHandler.StartChat(currentuser, otheruser);
//}
//System.Windows.Forms.MessageBox.Show("Gebruikers hebben al een gesprek");
//return false;
throw new NotImplementedException();
}
/// <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();
}
}
public int GetChatID(User currentuser, User otheruser)
{
throw new NotImplementedException();
}
public bool CheckIfChatted(User currentuser, User otheruser, out int gesprekid)
{
throw new NotImplementedException();
}