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