public ActionResult DeleteConfirmed(int id) { VolunteerEvent volunteerEvent = db.VolunteerEvent.Find(id); db.VolunteerEvent.Remove(volunteerEvent); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit(VolunteerEvent volunteerEvent) { if (ModelState.IsValid) { db.Entry(volunteerEvent).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("SendMail", "Home", volunteerEvent)); } return(View(volunteerEvent)); }
// GET: VolunteerEvents/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } VolunteerEvent volunteerEvent = db.VolunteerEvent.Find(id); var host = (from a in db.Users join e in db.VolunteerEvent on a.Id equals e.HostID join v in db.User on a.UserID equals v.ID where e.ID == id && e.HostID == a.Id && a.UserID == v.ID select new { FirstName = v.FirstName, LastName = v.LastName, HostID = e.HostID, EndDate = e.EndDate }); foreach (var x in host) { ViewBag.First = x.FirstName; ViewBag.Last = x.LastName; ViewBag.Host = x.HostID; ViewBag.EndDate = x.EndDate; } ViewBag.LoggedUser = User.Identity.GetUserId(); var loggedUser = User.Identity.GetUserName(); var users = db.User.Single(v => v.Email == loggedUser); var userEvents = from u in db.User_Event join e in db.VolunteerEvent on u.VolunteerEventID equals e.ID join v in db.User on u.UserID equals v.ID where u.UserID == users.ID && u.VolunteerEventID == id select v; if (!userEvents.Any()) { ViewBag.Volunteer = "false"; } if (volunteerEvent == null) { return(HttpNotFound()); } return(View(volunteerEvent)); }
/// <summary> /// NAME: Zoey McDonald /// DATE: 2/7/2020 /// CHECKED BY: Ethan Holmes /// /// This is a method for the volunteer event manager to update a volunteer event. /// /// </summary> /// <remarks> /// UPDATED BY: N/A /// UPDATED DATE: N/A /// WHAT WAS CHANGED: N/A /// </remarks> public int UpdateVolunteerEvent(VolunteerEvent oldVolunteerEvent, VolunteerEvent newVolunteerEvent) { int rows = 0; try { rows = _accessor.UpdateVolunteerEvent(oldVolunteerEvent, newVolunteerEvent); } catch (Exception ex) { throw ex; } return(rows); }
// GET: VolunteerEvents/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } VolunteerEvent volunteerEvent = db.VolunteerEvent.Find(id); if (volunteerEvent == null) { return(HttpNotFound()); } return(View(volunteerEvent)); }
public void SendLeaveEventConfirmationEmail(User user, VolunteerEvent volunteerEventObject) { string email = user.Email; //var user1 = _service.GetUserByUsername(email); string subject = "We are sorry to see you leaving this event!"; string eventTitle = volunteerEventObject.EventName; string eventDate = volunteerEventObject.EventStartDateTime.ToShortDateString(); string eventTime = volunteerEventObject.EventStartDateTime.ToShortTimeString(); // string eventTime = volunteerEventObject.EventStartDateTime.TimeOfDay.ToString(); string body = "<h2> Hey " + user.FirstName + "! </h3>" + "<h4>" + "We can confirm that your place at " + eventTitle + " event on " + eventDate + " at " + eventTime + " has been removed" + "</h4>" + "<h4> We can't wait to see you again!"; _mailerService.SendEmailAsync(email, subject, body); }
public void SendJoinedEventConfirmationEmail(User user, VolunteerEvent volunteerEventObject) { string email = user.Email; //var user1 = _service.GetUserByUsername(email); string subject = "Thank you for joining us on this event!"; string eventTitle = volunteerEventObject.EventName; string eventDate = volunteerEventObject.EventStartDateTime.ToShortDateString(); string eventTime = volunteerEventObject.EventStartDateTime.ToShortTimeString(); // string eventTime = volunteerEventObject.EventStartDateTime.TimeOfDay.ToString(); string body = "<h2> Hey " + user.FirstName + "! </h3>" + "<h4>" + "Your place is confirmed for the " + eventTitle + " event " + "</h4>" + "<h4> We can't wait to see you on " + eventDate + " at " + eventTime + "</h4>"; _mailerService.SendEmailAsync(email, subject, body); }
public void LeaveEvent(VolunteerEvent volunteerEventObject) { try { con.Open(); var comm = con.CreateCommand(); comm.CommandText = "DELETE FROM volunteerevent WHERE eventNumber = @eventNumber AND volunteerId = @volunteerId"; comm.Parameters.AddWithValue("?eventNumber", volunteerEventObject.Id); comm.Parameters.AddWithValue("?volunteerId", volunteerEventObject.VolunteerId); comm.ExecuteNonQuery(); } finally { con.Close(); } }
/// <summary> /// Creator: Zoey McDonald /// Created: 2/7/2020 /// Approver: Ethan Holmes /// /// This is an fake accessor method for removing a volunteer event. /// /// </summary> /// <remarks> /// Updater: /// Updated: /// Update: /// </remarks> public int RemoveVolunteerEvent(int volunteerEventID) { int rows = 0; VolunteerEvent eventToRemove = new VolunteerEvent(); foreach (VolunteerEvent volunteerEvent in _volunteerEvents) { if (volunteerEventID == volunteerEvent.VolunteerEventID) { eventToRemove = volunteerEvent; rows++; } } _volunteerEvents.Remove(eventToRemove); return(rows); }
public IActionResult AddVolunterEvent([FromBody] VolunteerEvent volunteerEventObject) { User checkUser = null; if (volunteerEventObject != null) { checkUser = _userService.GetUserById(volunteerEventObject.VolunteerId.GetValueOrDefault()); if (checkUser != null) { _service.AddVolunteerEvent(volunteerEventObject); SendJoinedEventConfirmationEmail(checkUser, volunteerEventObject); return(StatusCode(200)); } return(StatusCode(204)); } return(Ok()); }
/// <summary> /// Creator: Zoey McDonald /// Created: 2/7/2020 /// Approver: Ethan Holmes /// /// This is an fake accessor method for updating a volunteer event. /// /// </summary> /// <remarks> /// Updater: /// Updated: /// Update: /// </remarks> public int UpdateVolunteerEvent(VolunteerEvent oldVolunteerEvent, VolunteerEvent newVolunteerEvent) { int rows = 0; int index = 0; foreach (VolunteerEvent tempEvent in _volunteerEvents) { if (tempEvent.VolunteerEventID == oldVolunteerEvent.VolunteerEventID) { rows = 1; break; } index++; } if (rows == 1) { _volunteerEvents[index] = newVolunteerEvent; } return(rows); }
/// <summary> /// NAME: Zoey McDonald /// DATE: 2/7/2020 /// CHECKED BY: Ethan Holmes /// /// This is an accessor method for updating a volunteer event. /// /// </summary> /// <remarks> /// UPDATED BY: N/A /// UPDATED DATE: N/A /// WHAT WAS CHANGED: N/A /// </remarks> public int UpdateVolunteerEvent(VolunteerEvent oldVolunteerEvent, VolunteerEvent newVolunteerEvent) { int rows = 0; var conn = DBConnection.GetConnection(); var cmd = new SqlCommand("sp_update_volunteer_event"); // Setup cmd object cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; // Add the parameters cmd.Parameters.Add("@VolunteerEventID", SqlDbType.Int); cmd.Parameters.Add("@EventName", SqlDbType.NVarChar, 400); cmd.Parameters.Add("@EventDescription", SqlDbType.NVarChar, 400); cmd.Parameters.Add("@Active", SqlDbType.Bit); // Set parameter values cmd.Parameters["@VolunteerEventID"].Value = oldVolunteerEvent.VolunteerEventID; cmd.Parameters["@EventName"].Value = newVolunteerEvent.EventName; cmd.Parameters["@EventDescription"].Value = newVolunteerEvent.EventDescription; cmd.Parameters["@Active"].Value = newVolunteerEvent.Active; // Try to execute the query try { conn.Open(); rows = Convert.ToInt32(cmd.ExecuteScalar()); } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(rows); }
public ActionResult Create(VolunteerEvent volunteerEvent) { var loggedUser = User.Identity.GetUserName(); var users = db.User.Single(v => v.Email == loggedUser); volunteerEvent.HostID = User.Identity.GetUserId(); User_Event user_event = new User_Event { UserID = users.ID, VolunteerEventID = volunteerEvent.ID }; if (ModelState.IsValid) { db.User_Event.Add(user_event); db.VolunteerEvent.Add(volunteerEvent); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(volunteerEvent)); }
/// <summary> /// NAME: Zoey McDonald /// DATE: 2/7/2020 /// CHECKED BY: Ethan Holmes /// /// This is an accessor method for selecting all volunteer events. /// /// </summary> /// <remarks> /// UPDATED BY: N/A /// UPDATED DATE: N/A /// WHAT WAS CHANGED: N/A /// </remarks> public List <VolunteerEvent> SelectAllEvents() { // Declare the variables List <VolunteerEvent> volunteerEvents = new List <VolunteerEvent>(); var conn = DBConnection.GetConnection(); var cmd = new SqlCommand("sp_select_all_volunteer_events"); // Setup the cmd object cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; // Try to execute the query try { conn.Open(); var reader = cmd.ExecuteReader(); while (reader.Read()) { VolunteerEvent volunteerEvent = new VolunteerEvent(); volunteerEvent.VolunteerEventID = Convert.ToInt32(reader.GetValue(0)); volunteerEvent.EventName = Convert.ToString(reader.GetValue(1)); volunteerEvent.EventDescription = Convert.ToString(reader.GetValue(2)); volunteerEvents.Add(volunteerEvent); } reader.Close(); } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(volunteerEvents); }
public void AddVolunteerEvent(VolunteerEvent volunteerEventObject) { Console.WriteLine(volunteerEventObject.VolunteerId); try { con.Open(); string status = "In Progress"; int count = 0; do { string sql = @"update event set eventStatus = @eventStatus where eventNumber = @id "; MySqlCommand comm1 = new MySqlCommand(sql, con); comm1.Parameters.AddWithValue("?eventStatus", status); comm1.Parameters.AddWithValue("?id", volunteerEventObject.Id); comm1.CommandType = CommandType.Text; comm1.ExecuteNonQuery(); count++; } while (count < 1); var comm = con.CreateCommand(); comm.CommandText = @"INSERT INTO volunteerevent (eventNumber, volunteerId, volunteerEventAttended, volunteerEventNote) VALUES(@eventNumber, @volunteerId, @volunteerEventAttended, @volunteerEventNote) "; comm.Parameters.AddWithValue("?eventNumber", volunteerEventObject.Id); comm.Parameters.AddWithValue("?volunteerId", volunteerEventObject.VolunteerId); comm.Parameters.AddWithValue("?volunteerEventAttended", volunteerEventObject.VolunteerEventAttended); comm.Parameters.AddWithValue("?volunteerEventNote", volunteerEventObject.VolunteerEventNote); comm.ExecuteNonQuery(); } finally { con.Close(); } }