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