public void Delete(ApproveListHeadModel model)
{
string sql = @"DELETE FROM po_approval_list_headers WHERE approval_list_header_id = @approval_list_header_id";
object[] parms = { "@approval_list_header_id", model.ApprovalListHeaderId };
db.Update(sql, parms);
}
public int Insert(ApproveListHeadModel model)
{
string sql =
@"INSERT INTO po_approval_list_headers
(document_id
,document_type
,revision
,latest_revision
,first_approver_id
,approval_path_id
,created_by
,creation_date
,last_updated_by
,last_update_date
,final_flag)
VALUES
(@document_id
,@document_type
,@revision
,@latest_revision
,@first_approver_id
,@approval_path_id
,@created_by
,@creation_date
,@last_updated_by
,@last_update_date
,@final_flag)";
return(db.Insert(sql, Take(model)));
}
private object[] Take(ApproveListHeadModel model)
{
return(new object[]
{
"@approval_list_header_id", model.ApprovalListHeaderId,
"@document_id", model.DocumentId,
"@document_type", model.DocumentType,
"@revision", model.Revision,
"@latest_revision", model.LatestRevision,
"@first_approver_id", model.FirstApproverId,
"@approval_path_id", model.ApprovalPathId,
"@last_update_date", model.LastUpdateDate,
"@last_updated_by", model.LastUpdatedBy,
"@creation_date", model.CreationDate,
"@created_by", model.CreatedBy
});
}
public void Update(ApproveListHeadModel model)
{
string sql =
@"UPDATE po_approval_list_headers
SET document_id = @document_id
,document_type = @document_type
,revision = @revision
,latest_revision = @latest_revision
,first_approver_id = @first_approver_id
,approval_path_id = @approval_path_id
,last_updated_by = @last_updated_by
,last_update_date = @last_update_date
,final_flag = @final_flag
WHERE approval_list_header_id = @approval_list_header_id";
db.Update(sql, Take(model));
}
