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