public ActionResult AddEvent(CreateEventModel model) { SaveEventRequest request = PrepareSaveEventRequest(model); EventConnection conn = new EventConnection(); conn.SaveEvent(request); return(RedirectToAction("Home")); }
public void SaveEvent(SaveEventRequest request) { ConnectionHelper conn = new ConnectionHelper(); SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("@Name", request.Name), new SqlParameter("@Type", request.Type), new SqlParameter("@Category", request.Category), new SqlParameter("@Description", request.Description), new SqlParameter("@Date", request.Date), new SqlParameter("@Location", request.Location), new SqlParameter("@ContactPhone", request.ContactPhone), new SqlParameter("@ContactEmail", request.ContactEmail), new SqlParameter("@EventAdmin", request.EventAdmin), new SqlParameter("@HostUniversity", request.HostUniversity) }; conn.ExecuteNonQuery("SaveEvent", sqlParams); }
private SaveEventRequest PrepareSaveEventRequest(CreateEventModel model) { string date = model.Date + " " + model.StartTime; int userId = Convert.ToInt32(Session["UserId"]); SaveEventRequest request = new SaveEventRequest() { Category = model.SelectedCategory, ContactEmail = model.ContactEmail, ContactPhone = model.ContactPhone, Date = date, Description = model.Description, EventAdmin = userId, HostUniversity = model.SelectedUniversity, Location = 1, Name = model.Name, Type = model.SelectedEventType }; return(request); }