public ItemResult Edit(int resourceId, int updatedBy, InResource editedResource) { ItemResult itemResult = new ItemResult(); using (NpgsqlConnection connection = this.CreateConnection()) { try { connection.Open(); this.CreateFunctionCallQuery(LibraryFunctions.fn_resource_edit, connection); this.Cmd.Parameters.AddWithValue("p_resource_id", resourceId); this.Cmd.Parameters.AddWithValue("p_updated_by", updatedBy); this.Cmd.Parameters.AddWithValue("p_category_id", editedResource.CategoryId); this.Cmd.Parameters.AddWithValue("p_resource_name", editedResource.ResourceName); this.Cmd.Parameters.AddWithValue("p_shelf", editedResource.Shelf); this.Cmd.Parameters.AddWithValue("p_catalogue", editedResource.Catalogue); this.Cmd.Parameters.AddWithValue("p_publish_year", editedResource.PublishYear); this.Cmd.Parameters.AddWithValue("p_card_number", editedResource.CardNumber); this.Cmd.Parameters.AddWithValue("p_rfid", editedResource.Rfid); this.Cmd.Parameters.AddWithValue("p_resource_type_id", editedResource.ResourceTypeId); this.Cmd.Parameters.AddWithValue("p_author_id", editedResource.AuthorId); this.Cmd.Parameters.AddWithValue("p_book_location_id", editedResource.BookLocationId); this.Cmd.Parameters.AddWithValue("p_catalogue_id", editedResource.CatalogId); NpgsqlDataReader dataReader = null; dataReader = this.Cmd.ExecuteReader(); using (dataReader) { while (dataReader.Read()) { itemResult.Item = dataReader[0]; } } connection.Close(); } catch (PostgresException e) { itemResult.Code = e.MessageText; itemResult.Message = LibraryErrorMessages.GetErrorMessage(itemResult.Code); } catch (NpgsqlException e) { itemResult.Code = (e.ErrorCode).ToString(); itemResult.Message = LibraryErrorMessages.GetErrorMessage(itemResult.Code); } } return(itemResult); }
public ItemResult Post([FromForm] InResource inResource) { var resourceFile = inResource.ResourceFile; var filePath = Path.Combine("/app/volume-resources", resourceFile.FileName); if (resourceFile.Length > 0) { using (var fileStream = new FileStream(filePath, FileMode.Create)) { resourceFile.CopyTo(fileStream); } } return(pgResource.Add(inResource)); }
public ItemResult Put(int id, [FromBody] InResource inResource) { return(pgResource.Edit(id, currentUserId, inResource)); }