public int Insert(EventAddRequest myData) { int id = 0; DataProvider.ExecuteNonQuery("dbo.Event_Insert", inputParamMapper: (SqlParameterCollection inputs) => { inputs.Add(SqlDbParameter.Instance.BuildParameter("@organizationId", myData.OrganizationId, SqlDbType.Int)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@eventTypeId", myData.EventTypeId, SqlDbType.Int)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@title", myData.Title, SqlDbType.NVarChar, 100)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@topicDesc", myData.TopicDesc, SqlDbType.NVarChar, 2000)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@startDate", myData.StartDate, SqlDbType.Date)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@startTime", myData.StartTime, SqlDbType.Time)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@endDate", myData.EndDate, SqlDbType.Date)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@endTime", myData.EndTime, SqlDbType.Time)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@isAllDay", myData.IsAllDay, SqlDbType.Bit)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@venueName", myData.VenueName, SqlDbType.NVarChar, 100)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@addressId", myData.AddressId, SqlDbType.Int)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@scholarshipId", myData.ScholarshipId, SqlDbType.Int)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@imageUrl", myData.ImageUrl, SqlDbType.NVarChar, 128)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@contactInfo", myData.ContactInfo, SqlDbType.NVarChar, 200)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@modifiedById", myData.ModifiedById, SqlDbType.Int)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@createdById", myData.CreatedById, SqlDbType.Int)); SqlParameter idOut = new SqlParameter("@Id", 0); idOut.Direction = ParameterDirection.Output; inputs.Add(idOut); }, returnParameters: (SqlParameterCollection inputs) => { int.TryParse(inputs["@Id"].Value.ToString(), out id); }); return(id); }
public IHttpActionResult Post(EventAddRequest data) { try { data.CreatedById = _userService.GetCurrentUserId(); data.ModifiedById = _userService.GetCurrentUserId(); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } ItemResponse <int> response = new ItemResponse <int> { Item = _Service.Insert(data) }; return(Ok(response)); } catch (Exception ex) { int currentUser = _userService.GetCurrentUserId(); _appLogService.Insert(new AppLogAddRequest { AppLogTypeId = 1, Message = ex.Message, StackTrace = ex.StackTrace, Title = "Error in " + GetType().Name + " " + System.Reflection.MethodBase.GetCurrentMethod().Name, UserBaseId = currentUser }); return(BadRequest(ex.Message)); } }
private static void AddParams(EventAddRequest model, SqlParameterCollection col, int userId) { col.AddWithValue("@EventTypeId", model.EventType); col.AddWithValue("@EventCategoryId", model.EventCategory); col.AddWithValue("@EventName", model.EventName); col.AddWithValue("@Summary", model.Summary); col.AddWithValue("@ShortDescription", model.ShortDescription); col.AddWithValue("@LocationTypeId", model.LocationTypeId); col.AddWithValue("@LineOne", model.LineOne); col.AddWithValue("@LineTwo", model.LineTwo); col.AddWithValue("@City", model.City); col.AddWithValue("@Zip", model.Zip); col.AddWithValue("@StateId", model.StateId); col.AddWithValue("@Latitude", model.Latitude); col.AddWithValue("@Longitude", model.Longitude); col.AddWithValue("@Name", model.Name); col.AddWithValue("@Description", model.Description); col.AddWithValue("@Url", model.Url); col.AddWithValue("@UserId", userId); col.AddWithValue("@ImageUrl", model.ImageUrl); col.AddWithValue("@EventStatusId", model.EventStatusId); col.AddWithValue("@EventImageUrl", model.EventImageUrl); col.AddWithValue("@ExternalSiteUrl", model.ExternalSiteUrl); col.AddWithValue("@ExternalId", model.ExternalId); col.AddWithValue("@IsFree", model.IsFree); col.AddWithValue("@DateStart", model.DateStart); col.AddWithValue("@DateEnd", model.DateEnd); }
public IHttpActionResult Post(EventAddRequest model) { try { model.CreatedById = _authenticationService.GetCurrentUserId(); if (!ModelState.IsValid) { return(new ResponseMessageResult(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState))); } ItemResponse <int> response = new ItemResponse <int> { Item = _eventService.Post(model) }; return(Ok(response)); } catch (Exception ex) { _errorLogService.Post(new Models.Requests.Logs.ErrorLogAddRequest { ErrorSourceTypeId = 1, Message = ex.Message, StackTrace = ex.StackTrace, Title = "Error in " + GetType().Name + " " + System.Reflection.MethodBase.GetCurrentMethod().Name }); return(BadRequest(ex.Message)); } }
private static void AddCommonParams(EventAddRequest model, SqlParameterCollection col) { col.AddWithValue("@EventTypeId", model.EventTypeId); col.AddWithValue("@Name", model.Name); col.AddWithValue("@Summary", model.Summary); col.AddWithValue("@ShortDescription", model.ShortDescription); col.AddWithValue("@VenueId", model.VenueId); col.AddWithValue("@EventStatusId", model.EventStatusId); col.AddWithValue("@ImageUrl", model.ImageUrl); col.AddWithValue("@ExternalSiteUrl", model.ExternalSiteUrl); col.AddWithValue("@IsFree", model.IsFree); col.AddWithValue("@DateStart", model.DateStart); col.AddWithValue("@DateEnd", model.DateEnd); }
public ActionResult <ItemResponse <int> > Insert(EventAddRequest model) { try { int id = _eventService.Insert(model, _authService.GetCurrentUserId()); ItemResponse <int> response = new ItemResponse <int>(); response.Item = id; return(Created201(response)); } catch (Exception ex) { Logger.LogError(ex.ToString()); return(StatusCode(500, new ErrorResponse(ex.Message))); } }
public IHttpActionResult Save(EventAddRequest data) { try { data.CreatedById = _userService.GetCurrentUserId(); data.ModifiedById = _userService.GetCurrentUserId(); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } ItemResponse <int> response = new ItemResponse <int> { Item = _Service.Save(data) }; return(Ok(response)); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
//ADD & DELETE Event public int Add(EventAddRequest model, int userId) { int id = 0; DataTable dataTable = new DataTable(); string procName = "[dbo].[Events_Insert]"; _data.ExecuteNonQuery(procName, inputParamMapper : delegate(SqlParameterCollection col) { EventParamMapper(model, col); SqlParameter idOut = new SqlParameter("@id", SqlDbType.Int); idOut.Direction = ParameterDirection.Output; col.Add(idOut); }, delegate(SqlParameterCollection returnCollection) { object oId = returnCollection["@Id"].Value; int.TryParse(oId.ToString(), out id); }); return(id); }
public ActionResult<ItemResponse<int>> Create(EventAddRequest model) { ObjectResult result = null; try { int userId = _authService.GetCurrentUserId(); int createdBy = _service.Add(model, userId); ItemResponse<int> response = new ItemResponse<int>() { Item = createdBy }; result = Created201(response); } catch (Exception ex) { ErrorResponse response = new ErrorResponse(ex.Message); result = StatusCode(500, response); } return result; }
public ActionResult <ItemResponse <int> > Add(EventAddRequest model) { int code = 201; BaseResponse response = null; try { int userId = _authService.GetCurrentUserId(); int id = _service.Add(model, userId); response = new ItemResponse <int> { Item = id }; } catch (Exception ex) { code = 500; response = new ErrorResponse($"Server Error {ex.Message}"); base.Logger.LogError(ex.ToString()); } return(StatusCode(code, response)); }
public int Insert(EventAddRequest model, int userId) { int returnValue = 0; string procName = "[dbo].[Events_Insert]"; _dataProvider.ExecuteNonQuery(procName, inputParamMapper : delegate(SqlParameterCollection col) { col.AddWithValue("@CreatedBy", userId); col.AddWithValue("@ModifiedBy", userId); AddCommonParams(model, col); SqlParameter idOut = new SqlParameter("@Id", SqlDbType.Int); idOut.Direction = ParameterDirection.Output; col.Add(idOut); }, returnParameters : delegate(SqlParameterCollection returnCollection) { object oId = returnCollection["@Id"].Value; int.TryParse(oId.ToString(), out returnValue); }); return(returnValue); }
public ActionResult <ItemResponse <int> > Insert(EventAddRequest model) { ObjectResult result = null; int userId = _authService.GetCurrentUserId(); try { int id = _service.Insert(model, userId); ItemResponse <int> response = new ItemResponse <int>() { Item = id }; result = Created201(response); } catch (Exception ex) { Logger.LogError(ex.ToString()); ErrorResponse response = new ErrorResponse(ex.Message); result = StatusCode(500, response); } return(result); }
public int Add(EventAddRequest model, int userId) { int id = 0; string procName = "[dbo].[Events_InsertV2]"; _data.ExecuteNonQuery(procName, inputParamMapper : delegate(SqlParameterCollection col) { AddParams(model, col, userId); col.AddWithValue("@CreatedBy", userId); SqlParameter idOut = new SqlParameter("@Id", SqlDbType.Int); idOut.Direction = ParameterDirection.Output; col.Add(idOut); }, returnParameters : delegate(SqlParameterCollection returnCol) { object oId = returnCol["@Id"].Value; Int32.TryParse(returnCol["@Id"].Value.ToString(), out id); } ); return(id); }
// Other co-workers' content public int Insert(EventAddRequest model, int userId) { int id = 0; _dataProvider.ExecuteNonQuery( "dbo.Events_Insert", inputParamMapper : delegate(SqlParameterCollection parameterCollection) { SqlParameter parameter = new SqlParameter(); parameter.ParameterName = "@Id"; parameter.SqlDbType = SqlDbType.Int; parameter.Direction = ParameterDirection.Output; parameterCollection.Add(parameter); parameterCollection.AddWithValue("@OrganizationId", model.OrganizationId); parameterCollection.AddWithValue("@UserId", userId); parameterCollection.AddWithValue("@EventTypeId", model.EventTypeId); parameterCollection.AddWithValue("@Name", model.Name); parameterCollection.AddWithValue("@Summary", model.Summary); parameterCollection.AddWithValue("@Headline", model.Headline ?? SqlString.Null); parameterCollection.AddWithValue("@Description", model.Description); parameterCollection.AddWithValue("@EventStatusId", model.EventStatusId); parameterCollection.AddWithValue("@AllowContributions", model.AllowContributions); // Convert time to UTC DateTime dateStart = TimeZoneInfo.ConvertTimeToUtc(model.DateStart, TimeZoneInfo.Local); DateTime dateEnd = TimeZoneInfo.ConvertTimeToUtc(model.DateEnd, TimeZoneInfo.Local); DateTime setupTime = TimeZoneInfo.ConvertTimeToUtc(model.SetupTime, TimeZoneInfo.Local); parameterCollection.AddWithValue("@DateStart", dateStart); parameterCollection.AddWithValue("@DateEnd", dateEnd); parameterCollection.AddWithValue("@SetupTime", setupTime); // Venue parameterCollection.AddWithValue("@VenueId", model.VenueId); parameterCollection.AddWithValue("@LocationId", model.Venue.LocationId); parameterCollection.AddWithValue("@VenueName", model.Venue.Name); parameterCollection.AddWithValue("@VenueHeadline", model.Venue.Headline); parameterCollection.AddWithValue("@VenueDescription", model.Venue.Description); parameterCollection.AddWithValue("@VenueUrl", model.Venue.Url); parameterCollection.AddWithValue("@VenueIsApproved", model.Venue.IsApproved); // Advertisement Documents DataTable adDocs = null; if (model.AdvertisementDocuments != null) { adDocs = new DataTable(); adDocs.Columns.Add("Name", typeof(string)); adDocs.Columns.Add("DocumentUrl", typeof(string)); foreach (AdvertisementDocumentAddRequest adDoc in model.AdvertisementDocuments) { adDocs.Rows.Add(adDoc.Name, adDoc.DocumentUrl); } } parameterCollection.AddWithValue("@AdvertisementDocuments", adDocs); // Images DataTable images = new DataTable(); images.Columns.Add("EntityTypeId", typeof(int)); images.Columns.Add("Url", typeof(string)); images.Columns.Add("Title", typeof(string)); images.Columns.Add("Description", typeof(string)); foreach (ImageAddRequest image in model.Images) { images.Rows.Add(image.EntityTypeId, image.Url, image.Title, image.Description); } parameterCollection.AddWithValue("@Images", images); // Contributions DataTable contributionTypes = null; if (model.ContributionTypes != null) { contributionTypes = new DataTable(); contributionTypes.Columns.Add("ContributionTypeId", typeof(int)); foreach (int contributionTypeId in model.ContributionTypes) { contributionTypes.Rows.Add(contributionTypeId); } } parameterCollection.AddWithValue("@ContributionTypes", contributionTypes); // Urls DataTable urls = null; if (model.Urls != null) { urls = new DataTable(); urls.Columns.Add("Url", typeof(string)); urls.Columns.Add("UrlTypeId", typeof(int)); urls.Columns.Add("EntityTypeId", typeof(int)); foreach (UrlAddRequest url in model.Urls) { urls.Rows.Add(url.UrlLink, url.UrlTypeId, url.EntityTypeId); } } parameterCollection.AddWithValue("@Urls", urls); }, returnParameters : delegate(System.Data.SqlClient.SqlParameterCollection parameterCollection) { Int32.TryParse(parameterCollection["@Id"].Value.ToString(), out id); } ); return(id); }