public int Insert(ApproveListLineModel model)
{
string sql =
@"INSERT INTO po_approval_list_lines
(approval_list_header_id
,approver_id
,sequence_num
,comments
,status
,created_by
,creation_date
,last_updated_by
,last_update_date)
VALUES
(@approval_list_header_id
,@approver_id
,@sequence_num
,@comments
,@status
,@created_by
,@creation_date
,@last_updated_by
,@last_update_date)";
return(db.Insert(sql, Take(model)));
}
public void Delete(ApproveListLineModel model)
{
string sql = @"DELETE FROM po_approval_list_lines WHERE approval_list_line_id = @approval_list_line_id";
object[] parms = { "@approval_list_line_id", model.ApprovalListLineId };
db.Update(sql, parms);
}
public void Update(ApproveListLineModel model)
{
string sql =
@"UPDATE po_approval_list_lines
SET approval_list_header_id = @approval_list_header_id
,approver_id = @approver_id
,sequence_num = @sequence_num
,comments = @comments
,status = @status
,last_updated_by = @last_updated_by
,last_update_date = @last_update_date
WHERE approval_list_line_id = @approval_list_line_id";
db.Update(sql, Take(model));
}
private object[] Take(ApproveListLineModel model)
{
return(new object[]
{
"@approval_list_header_id", model.ApprovalListHeaderId,
"@approval_list_line_id", model.ApprovalListLineId,
"@approver_id", model.ApproverId,
"@sequence_num", model.SequenceNum,
"@comments", model.Comments,
"@status", model.Status,
"@last_update_date", model.LastUpdateDate,
"@last_updated_by", model.LastUpdatedBy,
"@creation_date", model.CreationDate,
"@created_by", model.CreatedBy
});
}
