public async Task UpdateEbook(EbookUpdateModel model, string actor)
{
try
{
await _connection.OpenAsync();
var cmd = new MySqlCommand("Update_Ebook", _connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("EbookId", model.EbookId);
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("EbookDescription", model.EbookDescription);
cmd.Parameters.AddWithValue("EditionVal", model.Edition);
cmd.Parameters.AddWithValue("YearVal", model.Year);
cmd.Parameters.AddWithValue("FreeOfCost", model.FreeOfCost);
cmd.Parameters.AddWithValue("SubjectIdVal", model.SubjectId);
cmd.Parameters.AddWithValue("ClassIdVal", model.ClassId);
cmd.ExecuteNonQuery();
}
catch
{
throw;
}
finally
{
await _connection.CloseAsync();
}
}
public async Task <IActionResult> UpdateEbook(EbookUpdateModel model)
{
var username = ApplicationUtility.GetTokenAttribute(Request.Headers["Authorization"], "sub");
var service = new PublisherRepositoryService(connString);
await service.UpdateEbook(model, username);
var response = new GenericResponse <string>()
{
IsSuccess = true,
Message = "Ebook updated successfully.",
ResponseCode = 200,
Result = "Success"
};
return(Ok(response));
}
