/// <summary>
/// Template provider class used for implementing specific queries here
/// Use the DatabaseProvider class to execute queries
/// It uses by default the table with the same name as the Entity
/// </summary>
public Entity Delete(int id)
{
/// <summary>
/// Creates the query for deleting an item by EntityId and executing it with DatabaseProvider
/// </summary>
var deletedEntity = GetById(id);
string query = @"
DELETE
FROM dbo.Entity
WHERE EntityId = @id
";
/// <summary>
/// parameters variable initializes all the variables used by the query
/// </summary>
var parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@id", id));
DatabaseProvider.ExecuteQuery(query, parameters);
return(deletedEntity);
}
public int Update(Entity updatedEntity)
{
/// <summary>
/// Query for updating an Entity
/// Returns the id of the Entity
/// </summary>
string query = @"
UPDATE dbo.Entity
SET Name = @Name
WHERE EntityId = @Id
";
/// <summary>
/// parameters variable initializes all the variables used by the query
/// </summary>
var parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@Name", updatedEntity.Name));
parameters.Add(new SqlParameter("@Id", updatedEntity.EntityId));
var result = DatabaseProvider.ExecuteQuery(query, parameters);
return(updatedEntity.EntityId);
}