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; } } }