private void Reset()
{
Request = new VideoAddRequest();
LoadingVisible = false;
ValidationMessage = null;
ValidationResult = null;
SubmitClicked = false;
}
public static void AddCommonParams(VideoAddRequest model, SqlParameterCollection col)
{
col.AddWithValue("@Title", model.Title);
col.AddWithValue("@ReleaseDate", model.ReleaseDate);
col.AddWithValue("@Type", model.Type);
col.AddWithValue("@Synopsis", model.Synopsis);
col.AddWithValue("@CoverPicture", model.CoverPicture);
col.AddWithValue("@UserRating", model.UserRating);
}
[Route, HttpPost] //POST: api/video
public HttpResponseMessage Post(VideoAddRequest model)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
else
{
ItemResponse <int> resp = new ItemResponse <int>();
resp.Item = VideoService.Insert(model);
return(Request.CreateResponse(HttpStatusCode.OK, resp));
}
}
public async Task <IActionResult> Add([FromBody] VideoAddRequest request)
{
try
{
var user = await userManager.GetUserAsync(User);
var url = new Uri(request.Url);
await videoManager.Add(user, url, request.SubscriptionId);
return(Ok(responseFactory.Success()));
}
catch (Exception ex)
{
return(BadRequest(responseFactory.Error(ex.Message)));
}
}
public ActionResult <ItemResponse <int> > Create(VideoAddRequest model)
{
ObjectResult result = null;
try
{
int userId = _authService.GetCurrentUserId();
int id = _service.Add(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(VideoAddRequest model, int userId)
{
int id = 0;
string procName = "[dbo].[Video_Insert]";
_data.ExecuteNonQuery(procName,
inputParamMapper : delegate(SqlParameterCollection col)
{
AddCommonParams(model, col);
col.AddWithValue("@UserId", userId);
SqlParameter idOut = new SqlParameter("@Id", SqlDbType.Int);
idOut.Direction = System.Data.ParameterDirection.Output;
col.Add(idOut);
},
returnParameters : delegate(SqlParameterCollection returnCollection)
{
object oId = returnCollection["@Id"].Value;
int.TryParse(oId.ToString(), out id);
Console.WriteLine("Add request functioning!");
});
return(id);
}
public static int Insert(VideoAddRequest v)
{
int i = 0;
DataProvider.Instance.ExecuteNonQuery(
GetConnection
, "dbo.Video_Insert"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Title", v.Title);
paramCollection.AddWithValue("@Description", v.Description);
paramCollection.AddWithValue("@Url", v.Url);
SqlParameter param = new SqlParameter("@Id", SqlDbType.Int);
param.Direction = ParameterDirection.Output;
paramCollection.Add(param);
},
returnParameters : delegate(SqlParameterCollection paramCollection)
{
int.TryParse(paramCollection["@Id"].Value.ToString(), out i);
});
return(i);
}
