internal void Delete(PriorityVO item)
{
string sqlQuery = @"
DELETE FROM
Priority
WHERE
PriorityID = @p0
";
_dbContext.ExecuteSqlCommand(sqlQuery, item.PriorityID);
}
internal void Update(PriorityVO item)
{
string sqlQuery = @"
UPDATE
Priority
SET
PriorityLevel = @p1,
Name = @p2,
Description = @p3
WHERE
PriorityID = @p0
";
_dbContext.ExecuteSqlCommand(
sqlQuery,
item.PriorityID,
item.PriorityLevel,
item.Name,
item.Description
);
}
internal void Create(PriorityVO item)
{
string sqlQuery = @"
INSERT INTO
Priority
(
PriorityLevel,
Name,
Description
) VALUES (
@p0,
@p1,
@p2
)
";
_dbContext.ExecuteSqlCommand(
sqlQuery,
item.PriorityLevel,
item.Name,
item.Description
);
}
public void Delete(PriorityVO item)
{
_priorityDAL.Delete(item);
}
public void Update(PriorityVO item)
{
_priorityDAL.Update(item);
}
public void Create(PriorityVO item)
{
_priorityDAL.Create(item);
}
