public int Delete(ModelOfProductionModel model)
{
string sqlDelete = "DELETE FROM ModelOfProduction WHERE Id = @Id";
using (_connection)
{
return(_connection.Execute(sqlDelete, model));
}
}
public int Update(ModelOfProductionModel model)
{
string sqlUpdate = "UPDATE ModelOfProduction SET Name = @Name," +
" ManufacturerId = @ManufacturerId WHERE Id = @Id";
using (_connection)
{
return(_connection.Execute(sqlUpdate, model));
}
}
public int Insert(ModelOfProductionModel model)
{
string sqlInsert = "INSERT INTO ModelOfProduction (Id, Name, ManufacturerId)" +
" Values (@Id, @Name, @ManufacturerId)";
using (_connection)
{
return(_connection.Execute(sqlInsert, model));
}
}
/// <summary>
/// Method whose purpose is to update
/// an existing ModelOfProduction record.
/// </summary>
/// <param name="modelOfProduction">
/// Existing ModelOfProductionModel object.
/// </param>
/// <returns>
/// Returns true if the query is successfully executed
/// otherwise returns false.
/// </returns>
public bool Update(ModelOfProductionModel modelOfProduction)
{
return(_modelOfProductionRepository.Update(modelOfProduction) > 0 ? true : false);
}
/// <summary>
/// Method whose purpose is to insert
/// a new ModelOfProduction record.
/// </summary>
/// <param name="modelOfProduction">
/// Newly created ModelOfProductionModel object.
/// </param>
/// <returns>
/// Returns true if the query is successfully executed
/// otherwise returns false.
/// </returns>
public bool Insert(ModelOfProductionModel modelOfProduction)
{
return(_modelOfProductionRepository.Insert(modelOfProduction) > 0 ? true : false);
}
