using System.Data;
using System.Data.SqlClient;

using Dapper;

using Fab2ApprovalSystem.Misc;
using Fab2ApprovalSystem.Models;

namespace Fab2ApprovalSystem.DMO;

public static class ApprovalLogDMO {

    private static readonly IDbConnection db = new SqlConnection(GlobalVars.DB_CONNECTION_STRING);

    public static void Add(ApprovalLog appLog) {
        DynamicParameters parameters = new();
        parameters.Add("@IssueID", appLog.IssueID);
        parameters.Add("@UserID", appLog.UserID);
        parameters.Add("@OperationType", appLog.OperationType);
        parameters.Add("@SubRoleID", appLog.SubRoleID);
        parameters.Add("@OperationLog", appLog.OperationLog);
        parameters.Add("@DocumentTypeID", appLog.DocumentTypeID);

        db.Execute("InsertApprovalLogByDocument", parameters, commandType: CommandType.StoredProcedure);
    }
}