using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;

namespace WX.CRM.DAL.Csvr
{
    public class CSVR_APPLYVIP_DAL
    {
        public void AddBWList(string username, string TelNum, string type, DateTime dateFrom, DateTime dateTo, string memo, int level, string agentId)
        {
            try
            {
                string sql = "insert into BWList([Type],[Level],[TelNum],[UserName],[DateFrom],[DateTo],[DNIS],[AddDate],[AddAgentID],[Memo],[AvailableFlag],[DealAgentID],[DealTime],[DealReason]) " +
                    "values(@Type,@Level,@TelNum,@UserName,@DateFrom,@DateTo,@DNIS,@AddDate,@AddAgentID,@Memo,@AvailableFlag,@DealAgentID,@DealTime,@DealReason)";
                SqlParameter[] parameters = {
                                            new SqlParameter("@Type", SqlDbType.Char){ Value = type},
                                            new SqlParameter("@Level", SqlDbType.Int){ Value = level},
                                            new SqlParameter("@TelNum", SqlDbType.VarChar){ Value = TelNum},
                                            new SqlParameter("@UserName", SqlDbType.VarChar){ Value = username},
                                            new SqlParameter("@DateFrom", SqlDbType.DateTime){ Value = dateFrom},
                                            new SqlParameter("@DateTo", SqlDbType.DateTime){ Value = dateTo},
                                            new SqlParameter("@DNIS", SqlDbType.VarChar){ Value = "!!"},
                                            new SqlParameter("@AddDate", SqlDbType.DateTime){ Value = DateTime.Now},
                                            new SqlParameter("@AddAgentID", SqlDbType.VarChar){ Value = agentId},
                                            new SqlParameter("@Memo", SqlDbType.VarChar){ Value = memo},
                                            new SqlParameter("@AvailableFlag", SqlDbType.Int){ Value = 1},
                                            new SqlParameter("@DealAgentID", SqlDbType.VarChar){ Value = agentId},
                                            new SqlParameter("@DealTime", SqlDbType.DateTime){ Value = DateTime.Now},
                                            new SqlParameter("@DealReason", SqlDbType.VarChar){ Value = ""}
                                        };
                SqlHelper.ExcuteSPOrSql(SqlHelper.DatabaseType.BC, sql, CommandType.Text, parameters);
            }
            catch { throw; }
        }
        public void AddBCHVIP(string TelNum, DateTime dateFrom, DateTime dateTo, string OutNumber)
        {
            string sql = "insert into ext_upchina_vip(Phone,InCallNumber,ValidBegintime,ValidEndtime) values(@Phone,@InCallNumber,@ValidBegintime,@ValidEndtime);";
            var param = new List<SqlParameter>()
            {
                new SqlParameter(){ ParameterName = "Phone",SqlDbType = SqlDbType.VarChar,Value = TelNum},
                new SqlParameter(){ ParameterName = "InCallNumber",SqlDbType = SqlDbType.VarChar,Value = OutNumber},
                new SqlParameter(){ ParameterName = "ValidBegintime",SqlDbType = SqlDbType.DateTime,Value = dateFrom},
                new SqlParameter(){ ParameterName = "ValidEndtime",SqlDbType = SqlDbType.DateTime,Value = dateTo}
            };

            SqlHelper.ExcuteSPOrSql(SqlHelper.DatabaseType.IPSC, sql, CommandType.Text, param.ToArray());
        }
    }
}