public void Create(TaskVO item)
{
string sqlQuery = @"
INSERT INTO
Task
(
PriorityID,
StatusID,
Name,
Description,
CreateDate,
Deleted
) VALUES (
@p0,
@p1,
@p2,
@p3,
@p4,
0
)
";
_dbContext.ExecuteSqlCommand(
sqlQuery,
item.PriorityID,
item.StatusID,
item.Name,
item.Description,
item.CreateDate
);
}
public void Delete(TaskVO item)
{
string sqlQuery = @"
UPDATE
Task
SET
Deleted = 1,
DeleteDate = @p1
WHERE
TaskID = @p0
";
_dbContext.ExecuteSqlCommand(
sqlQuery,
item.TaskID,
item.DeleteDate
);
}
public void Update(TaskVO item)
{
string sqlQuery = @"
UPDATE
Task
SET
PriorityID = @p1,
StatusID = @p2,
Name = @p3,
Description = @p4
WHERE
TaskID = @p0
";
_dbContext.ExecuteSqlCommand(
sqlQuery,
item.TaskID,
item.PriorityID,
item.StatusID,
item.Name,
item.Description
);
}
public void Delete(TaskVO item)
{
item.DeleteDate = DateTime.Now;
_taskDAL.Delete(item);
}
public void Update(TaskVO item)
{
_taskDAL.Update(item);
}
public void Create(TaskVO item)
{
item.CreateDate = DateTime.Now;
_taskDAL.Create(item);
}