protected DataTable eventInfo(Int64 eventId, int userId)
{
DataTable dt = new DataTable();
Classes.Events e = new Classes.Events();
return(e.eventInfo(eventId, userId));
}
private void btnAdd_Click(object sender, EventArgs e)
{
/*string sportsmen = comboBox1.Text;
* string ev = txtEv.Text;
* DateTime date = dateTimePicker1.Value;
* Classes.Events a = new Classes.Events(sportsmen, ev, date);
* if(Elist==null)
* {
* Elist = new Classes.EventsList();
* }
* Elist.Add(a);
* CleanAllTextBoxesIn(this);
* update(Elist);*/
try
{
if (comboBox1.Text != "" && dateTimePicker1.Value != null && txtEv.Text != "")
{
string sportsmen = comboBox1.Text;
string ev = txtEv.Text;
DateTime date = dateTimePicker1.Value;
Classes.Events a = new Classes.Events(sportsmen, ev, date);
Elist.Add(a);
CleanAllTextBoxesIn(this);
update(Elist);
}
else
{
MessageBox.Show("Усі поля мають бути заповнені");
}
}
catch
{
MessageBox.Show("Виникла помилка");
}
}
public int removeParticipant(int ownerId, int userId, Int64 eventId)
{
int status = 0; //0 user not owner 1 participants cancelled 2 user was not participant
Classes.Events ev = new Classes.Events();
if (!ev.isUserOwner(ownerId, eventId))
{
status = 0;
}
else
{
bool participantStatus = ev.isUserParticipant(userId, eventId);
if (!participantStatus)
{
status = 2;
}
else
{
status = 1;
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
SqlCommand sqlCmd = new SqlCommand("sp_eventRemoveParticipant", sqlConn);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add("@EventId", SqlDbType.BigInt).Value = eventId;
sqlCmd.Parameters.Add("@UserId", SqlDbType.Int).Value = userId;
try
{
sqlConn.Open();
sqlCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
sqlConn.Close();
sqlCmd.Dispose();
sqlConn.Dispose();
}
Classes.Notifications n = new Classes.Notifications();
n.notificationAdd(userId, 8, eventId);
}
}
return(status);
}
public int checkRequest(int userId, Int64 eventId)
{
int status = 0; //0 user has no request 1 user has requested before 2 user is a participant
DataTable dt = new DataTable();
DataSet ds = new DataSet();
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
SqlDataAdapter sda = new SqlDataAdapter("sp_requestCheck", sqlConn);
sda.SelectCommand.CommandType = CommandType.StoredProcedure;
sda.SelectCommand.Parameters.Add("@UserId", SqlDbType.Int).Value = userId;
sda.SelectCommand.Parameters.Add("@EventId", SqlDbType.BigInt).Value = eventId;
try
{
sda.Fill(ds);
dt = ds.Tables[0];
}
catch (Exception ex)
{
}
finally
{
sqlConn.Close();
sda.Dispose();
sqlConn.Dispose();
}
if (dt.Rows.Count == 0)// request exists
{
Classes.Events ev = new Classes.Events();
bool participantStatus = ev.isUserParticipant(userId, eventId);
if (participantStatus)// user is a participant
{
status = 2;
}
}
else
{
status = 1;
}
return(status);
}
public int requestSend(int userId, Int64 eventId, string message)
{
int totalStatus = 0;
Classes.Events ev = new Classes.Events();
if (ev.isUserOwner(userId, eventId))
{
totalStatus = -1;
}
else if (ev.isUserParticipant(userId, eventId))
{
//cancel participation
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
SqlCommand sqlCmd = new SqlCommand("sp_eventCancelParticipation", sqlConn);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add("@EventId", SqlDbType.BigInt).Value = eventId;
sqlCmd.Parameters.Add("@UserId", SqlDbType.Int).Value = userId;
try
{
sqlConn.Open();
sqlCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
sqlConn.Close();
sqlCmd.Dispose();
sqlConn.Dispose();
}
Classes.Events e = new Classes.Events();
int ownerId = e.getOwnerIdByEventId(eventId);
Classes.Notifications n = new Classes.Notifications();
n.notificationAdd(ownerId, 7, Convert.ToInt64(userId));
totalStatus = 1;
}
else
{
int status = checkRequest(userId, eventId);
if (status == 0)
{
//send request
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
SqlCommand sqlCmd = new SqlCommand("sp_eventRequestAdd", sqlConn);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add("@EventId", SqlDbType.BigInt).Value = eventId;
sqlCmd.Parameters.Add("@UserId", SqlDbType.Int).Value = userId;
sqlCmd.Parameters.Add("@Message", SqlDbType.NVarChar).Value = message;
try
{
sqlConn.Open();
sqlCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
sqlConn.Close();
sqlCmd.Dispose();
sqlConn.Dispose();
}
Classes.Events e1 = new Classes.Events();
int personId = e1.getOwnerIdByEventId(eventId);
Classes.Signal s = new Classes.Signal();
s.usernotificationsNumber(personId);
totalStatus = 3;
}
else if (status == 1)
{
//cancel request
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
SqlCommand sqlCmd = new SqlCommand("sp_eventRequestDelete", sqlConn);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add("@EventId", SqlDbType.BigInt).Value = eventId;
sqlCmd.Parameters.Add("@UserId", SqlDbType.Int).Value = userId;
try
{
sqlConn.Open();
sqlCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
sqlConn.Close();
sqlCmd.Dispose();
sqlConn.Dispose();
}
Classes.Events e1 = new Classes.Events();
int personId = e1.getOwnerIdByEventId(eventId);
Classes.Signal s = new Classes.Signal();
s.usernotificationsNumber(personId);
totalStatus = 2;
}
}
return(totalStatus);
}
public int requestAccept(int userId, Int64 requestId)
{
int status = 0;
DataTable dt = new DataTable();
DataSet ds = new DataSet();
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
SqlDataAdapter sda = new SqlDataAdapter("sp_requestInfo", sqlConn);
sda.SelectCommand.CommandType = CommandType.StoredProcedure;
sda.SelectCommand.Parameters.Add("@OwnerId", SqlDbType.Int).Value = userId;
sda.SelectCommand.Parameters.Add("@RequestId", SqlDbType.BigInt).Value = requestId;
try
{
sda.Fill(ds);
dt = ds.Tables[0];
}
catch (Exception ex)
{
}
finally
{
sqlConn.Close();
sda.Dispose();
sqlConn.Dispose();
}
if (dt.Rows.Count != 0)// request exists
{
int userId1 = Convert.ToInt32(dt.Rows[0]["UserId"].ToString());
Int64 eventId = Convert.ToInt64(dt.Rows[0]["EventId"].ToString());
SqlConnection sqlConn1 = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
SqlCommand sqlCmd1 = new SqlCommand("sp_requestAccept", sqlConn1);
sqlCmd1.CommandType = CommandType.StoredProcedure;
sqlCmd1.Parameters.Add("@OwnerId", SqlDbType.Int).Value = userId;
sqlCmd1.Parameters.Add("@RequestId", SqlDbType.BigInt).Value = requestId;
sqlCmd1.Parameters.Add("@EventId", SqlDbType.BigInt).Value = eventId;
sqlCmd1.Parameters.Add("@UserId", SqlDbType.Int).Value = userId1;
try
{
sqlConn1.Open();
sqlCmd1.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
sqlConn1.Close();
sqlCmd1.Dispose();
sqlConn1.Dispose();
}
// add notification
Classes.Notifications n = new Classes.Notifications();
n.notificationAdd(userId1, 2, eventId);
Classes.Events ev = new Classes.Events();
int remained = ev.eventParticipantsRemained(eventId);
if (remained == 0)
{
n.notificationAdd(userId, 3, eventId);
}
status = 1;
}
else
{
status = -1;
}
return(status);
}
public int checkRequest(int userId, Int64 eventId)
{
int status = 0; //0 user has no request 1 user has requested before 2 user is a participant
DataTable dt = new DataTable();
DataSet ds = new DataSet();
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
SqlDataAdapter sda = new SqlDataAdapter("sp_requestCheck", sqlConn);
sda.SelectCommand.CommandType = CommandType.StoredProcedure;
sda.SelectCommand.Parameters.Add("@UserId", SqlDbType.Int).Value = userId;
sda.SelectCommand.Parameters.Add("@EventId", SqlDbType.BigInt).Value = eventId;
try
{
sda.Fill(ds);
dt = ds.Tables[0];
}
catch (Exception ex)
{
}
finally
{
sqlConn.Close();
sda.Dispose();
sqlConn.Dispose();
}
if (dt.Rows.Count == 0)// request exists
{
Classes.Events ev = new Classes.Events();
bool participantStatus = ev.isUserParticipant(userId, eventId);
if (participantStatus)// user is a participant
{
status = 2;
}
}
else
{
status = 1;
}
return status;
}
public int removeParticipant(int ownerId, int userId, Int64 eventId)
{
int status = 0; //0 user not owner 1 participants cancelled 2 user was not participant
Classes.Events ev = new Classes.Events();
if (!ev.isUserOwner(ownerId, eventId))
{
status = 0;
}
else
{
bool participantStatus = ev.isUserParticipant(userId, eventId);
if(!participantStatus)
{
status = 2;
}
else
{
status = 1;
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
SqlCommand sqlCmd = new SqlCommand("sp_eventRemoveParticipant", sqlConn);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add("@EventId", SqlDbType.BigInt).Value = eventId;
sqlCmd.Parameters.Add("@UserId", SqlDbType.Int).Value = userId;
try
{
sqlConn.Open();
sqlCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
sqlConn.Close();
sqlCmd.Dispose();
sqlConn.Dispose();
}
Classes.Notifications n = new Classes.Notifications();
n.notificationAdd(userId, 8, eventId);
}
}
return status;
}
public int requestAccept(int userId, Int64 requestId)
{
int status = 0;
DataTable dt = new DataTable();
DataSet ds = new DataSet();
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
SqlDataAdapter sda = new SqlDataAdapter("sp_requestInfo", sqlConn);
sda.SelectCommand.CommandType = CommandType.StoredProcedure;
sda.SelectCommand.Parameters.Add("@OwnerId", SqlDbType.Int).Value = userId;
sda.SelectCommand.Parameters.Add("@RequestId", SqlDbType.BigInt).Value = requestId;
try
{
sda.Fill(ds);
dt = ds.Tables[0];
}
catch (Exception ex)
{
}
finally
{
sqlConn.Close();
sda.Dispose();
sqlConn.Dispose();
}
if (dt.Rows.Count != 0)// request exists
{
int userId1 = Convert.ToInt32(dt.Rows[0]["UserId"].ToString());
Int64 eventId = Convert.ToInt64(dt.Rows[0]["EventId"].ToString());
SqlConnection sqlConn1 = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
SqlCommand sqlCmd1 = new SqlCommand("sp_requestAccept", sqlConn1);
sqlCmd1.CommandType = CommandType.StoredProcedure;
sqlCmd1.Parameters.Add("@OwnerId", SqlDbType.Int).Value = userId;
sqlCmd1.Parameters.Add("@RequestId", SqlDbType.BigInt).Value = requestId;
sqlCmd1.Parameters.Add("@EventId", SqlDbType.BigInt).Value = eventId;
sqlCmd1.Parameters.Add("@UserId", SqlDbType.Int).Value = userId1;
try
{
sqlConn1.Open();
sqlCmd1.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
sqlConn1.Close();
sqlCmd1.Dispose();
sqlConn1.Dispose();
}
// add notification
Classes.Notifications n = new Classes.Notifications();
n.notificationAdd(userId1, 2, eventId);
Classes.Events ev = new Classes.Events();
int remained = ev.eventParticipantsRemained(eventId);
if (remained == 0)
{
n.notificationAdd(userId, 3, eventId);
}
status = 1;
}
else
{
status = -1;
}
return status;
}
public int requestSend(int userId, Int64 eventId, string message)
{
int totalStatus = 0;
Classes.Events ev = new Classes.Events();
if (ev.isUserOwner(userId, eventId))
{
totalStatus = -1;
}
else if (ev.isUserParticipant(userId, eventId))
{
//cancel participation
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
SqlCommand sqlCmd = new SqlCommand("sp_eventCancelParticipation", sqlConn);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add("@EventId", SqlDbType.BigInt).Value = eventId;
sqlCmd.Parameters.Add("@UserId", SqlDbType.Int).Value = userId;
try
{
sqlConn.Open();
sqlCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
sqlConn.Close();
sqlCmd.Dispose();
sqlConn.Dispose();
}
Classes.Events e = new Classes.Events();
int ownerId = e.getOwnerIdByEventId(eventId);
Classes.Notifications n = new Classes.Notifications();
n.notificationAdd(ownerId, 7, Convert.ToInt64(userId));
totalStatus = 1;
}
else
{
int status = checkRequest(userId, eventId);
if (status == 0)
{
//send request
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
SqlCommand sqlCmd = new SqlCommand("sp_eventRequestAdd", sqlConn);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add("@EventId", SqlDbType.BigInt).Value = eventId;
sqlCmd.Parameters.Add("@UserId", SqlDbType.Int).Value = userId;
sqlCmd.Parameters.Add("@Message", SqlDbType.NVarChar).Value = message;
try
{
sqlConn.Open();
sqlCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
sqlConn.Close();
sqlCmd.Dispose();
sqlConn.Dispose();
}
Classes.Events e1 = new Classes.Events();
int personId = e1.getOwnerIdByEventId(eventId);
Classes.Signal s = new Classes.Signal();
s.usernotificationsNumber(personId);
totalStatus = 3;
}
else if (status == 1)
{
//cancel request
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["AppConnectionString"].ConnectionString);
SqlCommand sqlCmd = new SqlCommand("sp_eventRequestDelete", sqlConn);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add("@EventId", SqlDbType.BigInt).Value = eventId;
sqlCmd.Parameters.Add("@UserId", SqlDbType.Int).Value = userId;
try
{
sqlConn.Open();
sqlCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
sqlConn.Close();
sqlCmd.Dispose();
sqlConn.Dispose();
}
Classes.Events e1 = new Classes.Events();
int personId = e1.getOwnerIdByEventId(eventId);
Classes.Signal s = new Classes.Signal();
s.usernotificationsNumber(personId);
totalStatus = 2;
}
}
return totalStatus;
}
protected DataTable eventInfo(Int64 eventId, int userId)
{
DataTable dt = new DataTable();
Classes.Events e = new Classes.Events();
return e.eventInfo(eventId, userId);
}
public string notificationText(int NotificationType, Int64 itemId)
{
switch (NotificationType)
{
case 1:
{
return("Congratulations! You have successfully registered!");
break;
}
case 2:
{
Classes.Events e = new Classes.Events();
string eventName = e.getEventNameByEventId(itemId);
return("Guess what?! You have been accepted to participate in this event: " + eventName);
break;
}
case 3:
{
Classes.Events e = new Classes.Events();
string eventName = e.getEventNameByEventId(itemId);
return("Your event, " + eventName + " is full now!");
break;
}
case 4:
{
Classes.UserInfo ui = new Classes.UserInfo();
string userFullName = ui.getUserFullNameByUserId(Convert.ToInt32(itemId));
return(userFullName + " started following you.");
break;
}
case 5:
{
Classes.UserInfo ui = new Classes.UserInfo();
string userFullName = ui.getUserFullNameByUserId(Convert.ToInt32(itemId));
return(userFullName + " registered in the app with your invitation.");
break;
}
case 6:
{
Classes.UserInfo ui = new Classes.UserInfo();
string userFullName = ui.getUserFullNameByUserId(Convert.ToInt32(itemId));
return(userFullName + " just reviewed you!");
break;
}
case 7:
{
Classes.UserInfo ui = new Classes.UserInfo();
string userFullName = ui.getUserFullNameByUserId(Convert.ToInt32(itemId));
return(userFullName + " canceled participation in your event.");
break;
}
case 8:
{
Classes.Events e = new Classes.Events();
string eventName = e.getEventNameByEventId(itemId);
return("You just got removed from " + eventName + ".");
break;
}
case 9:
{
Classes.UserInfo ui = new Classes.UserInfo();
string userFullName = ui.getUserFullNameByUserId(Convert.ToInt32(itemId));
return(userFullName + " removed an event that you were a participant in it.");
break;
}
case 10:
{
Classes.UserInfo ui = new Classes.UserInfo();
string userFullName = ui.getUserFullNameByUserId(Convert.ToInt32(itemId));
return(userFullName + " is waiting for your review.");
break;
}
case 11:
{
return("You have successfully verified your email address.");
break;
}
case 12:
{
Classes.UserInfo ui = new Classes.UserInfo();
string userFullName = ui.getUserFullNameByUserId(Convert.ToInt32(itemId));
return(userFullName + " from your Facebook friends just became a CityCrowder.");
break;
}
case 13:
{
Classes.UserInfo ui = new Classes.UserInfo();
string userFullName = ui.getUserFullNameByUserId(Convert.ToInt32(itemId));
return(userFullName + " became a CityCrowder with your invitation.");
break;
}
case 14:
{
Classes.Locations l = new Classes.Locations();
string locationName = l.getLocationInfoById(Convert.ToInt32(itemId));
return("Good news! The location you requested to be added is now available! Locaion: " + locationName);
break;
}
default:
{
return("");
break;
}
}
}
public string notificationText(int NotificationType, Int64 itemId)
{
switch (NotificationType)
{
case 1:
{
return "Congratulations! You have successfully registered!";
break;
}
case 2:
{
Classes.Events e = new Classes.Events();
string eventName = e.getEventNameByEventId(itemId);
return "Guess what?! You have been accepted to participate in this event: " + eventName;
break;
}
case 3:
{
Classes.Events e = new Classes.Events();
string eventName = e.getEventNameByEventId(itemId);
return "Your event, " + eventName + " is full now!";
break;
}
case 4:
{
Classes.UserInfo ui = new Classes.UserInfo();
string userFullName = ui.getUserFullNameByUserId(Convert.ToInt32(itemId));
return userFullName + " started following you.";
break;
}
case 5:
{
Classes.UserInfo ui = new Classes.UserInfo();
string userFullName = ui.getUserFullNameByUserId(Convert.ToInt32(itemId));
return userFullName + " registered in the app with your invitation.";
break;
}
case 6:
{
Classes.UserInfo ui = new Classes.UserInfo();
string userFullName = ui.getUserFullNameByUserId(Convert.ToInt32(itemId));
return userFullName + " just reviewed you!";
break;
}
case 7:
{
Classes.UserInfo ui = new Classes.UserInfo();
string userFullName = ui.getUserFullNameByUserId(Convert.ToInt32(itemId));
return userFullName + " canceled participation in your event.";
break;
}
case 8:
{
Classes.Events e = new Classes.Events();
string eventName = e.getEventNameByEventId(itemId);
return "You just got removed from " + eventName + ".";
break;
}
case 9:
{
Classes.UserInfo ui = new Classes.UserInfo();
string userFullName = ui.getUserFullNameByUserId(Convert.ToInt32(itemId));
return userFullName + " removed an event that you were a participant in it.";
break;
}
case 10:
{
Classes.UserInfo ui = new Classes.UserInfo();
string userFullName = ui.getUserFullNameByUserId(Convert.ToInt32(itemId));
return userFullName + " is waiting for your review.";
break;
}
case 11:
{
return "You have successfully verified your email address.";
break;
}
case 12:
{
Classes.UserInfo ui = new Classes.UserInfo();
string userFullName = ui.getUserFullNameByUserId(Convert.ToInt32(itemId));
return userFullName + " from your Facebook friends just became a CityCrowder.";
break;
}
case 13:
{
Classes.UserInfo ui = new Classes.UserInfo();
string userFullName = ui.getUserFullNameByUserId(Convert.ToInt32(itemId));
return userFullName + " became a CityCrowder with your invitation.";
break;
}
case 14:
{
Classes.Locations l = new Classes.Locations();
string locationName = l.getLocationInfoById(Convert.ToInt32(itemId));
return "Good news! The location you requested to be added is now available! Locaion: " + locationName;
break;
}
default:
{
return "";
break;
}
}
}
