public async Task <IActionResult> CreateEbook(EBookModel model)
{
var username = ApplicationUtility.GetTokenAttribute(Request.Headers["Authorization"], "sub");
var service = new PublisherRepositoryService(connString);
var pubId = await service.CreateEBook(model, username);
var response = new GenericResponse <int>()
{
IsSuccess = true,
Message = "Ebook created successfully.",
ResponseCode = 200,
Result = pubId
};
return(Ok(response));
}
public async Task <int> CreateEBook(EBookModel model, string actor)
{
var result = 0;
try
{
await _connection.OpenAsync();
var cmd = new MySqlCommand("Create_EBook", _connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("PublisherIdVal", model.PublisherId);
cmd.Parameters.AddWithValue("Actor", actor);
cmd.Parameters.AddWithValue("TitleVal", model.Title);
cmd.Parameters.AddWithValue("HeightVal", model.Height);
cmd.Parameters.AddWithValue("WidthVal", model.Width);
cmd.Parameters.AddWithValue("BreadthVal", model.Breadth);
cmd.Parameters.AddWithValue("DotInInchVal", model.DotInInch);
cmd.Parameters.AddWithValue("AuthorVal", model.Author);
cmd.Parameters.AddWithValue("ISDNval", model.ISDN);
cmd.Parameters.AddWithValue("EditionVal", model.Edition);
cmd.Parameters.AddWithValue("YearVal", model.Year);
cmd.Parameters.AddWithValue("FreeOfCost", model.FreeOfCost);
cmd.Parameters.AddWithValue("SubjectIdVal", model.SubjectIdVal);
cmd.Parameters.AddWithValue("ClassIdVal", model.ClassIdVal);
var dr = cmd.ExecuteReader();
while (dr.Read())
{
result = Convert.ToInt32(dr["EbookId"]);
}
return(result);
}
catch
{
throw;
}
finally
{
await _connection.CloseAsync();
}
}
