public async Task DeleteAsync(int kdBarang)
{
var p = new
{
kdBarang = kdBarang
};
string sql = @"delete barang_m where kdBarang=@kdBarang";
await _db.DeleteData <dynamic>(sql, p);
}
public void DeletePost(int postId)
{
_sql.DeleteData("dbo.spPost_Delete", new { Id = postId }, "SQLData");
}
// Delete a specific ordered food detail with Id = id
public async Task DeleteOrderDetail(int id)
{
await _sql.DeleteData <dynamic>("OrderDetail_Delete", new { id });
}
public void DeleteComment(int commentId)
{
_sql.DeleteData("dbo.spComment_Delete", new { Id = commentId }, "SQLData");
}
public void DeleteRoom(int id)
{
_sql.DeleteData("dbo.spRoom_Remove", new { id }, "OHMData");
}
public async Task DeleteStudent(int studentId)
{
string sql = @"delete from dbo.Student where StudentId = @studentId";
await _db.DeleteData(sql, new { studentId });
}
public void DeleteClient(int id)
{
_sql.DeleteData("dbo.spClient_Remove", new { id }, "OHMData");
}
// Delete Person from database with Id = id
public async Task DeletePerson(int id)
{
await _sql.DeleteData <dynamic>("People_Delete", new { id });
}
// Delete specific DiningTable from database with Id = id
public async Task DeleteTable(int id)
{
await _sql.DeleteData <dynamic>("DiningTable_Delete", new { id });
}
public void DeleteCheckIn(int id)
{
_sql.DeleteData("dbo.spCheckIn_Remove", new { id }, "OHMData");
}
// Delete specific food from database with Id = id
public async Task DeleteFood(int id)
{
await _sql.DeleteData <dynamic>("Food_Delete", new { id });
}