using CRM.Core.Model;
using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.Data;

namespace CRM.Core.DAL.Exam
{
    public class Exam_DAL
    {
        public int GenerateExam(int paperType, string appid, string appuserid)
        {
            var param = new List<MySqlParameter>
            {
                new MySqlParameter { ParameterName = "p_paperType",  DbType = DbType.Int32, Value = paperType },
                new MySqlParameter { ParameterName = "p_appid", DbType = DbType.String, Value = appid },
                new MySqlParameter { ParameterName = "p_appuserid",  DbType = DbType.String, Value = appuserid }
            };
            return Convert.ToInt32(MySqlDbHelper.ExecuteScalar(ConStringHelper.ZxdCRMConn, CommandType.StoredProcedure, "GenerateExam", param.ToArray()));
        }
    }
}