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 }); }