using System;
using System.Collections;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using Models;
using IDAL;
/************************************
 * 類名：AdminService
 * 創建日期：2007-7-13
 * 功能描述：提供管理員信息操作
 * *********************************/
namespace DAL.SqlServer
{
   public class AdminService:IAdminService
    {
        #region Private Members
        //從配置文件中讀取數據庫連接字符串
        private readonly string connString = ConfigurationManager.ConnectionStrings["MySchoolConnectionString"].ToString();
        private readonly string dboOwner = ConfigurationManager.ConnectionStrings["DataBaseOwner"].ToString();
        #endregion

        #region Public Methods
       /// <summary>
       /// 根據管理員登錄ＩＤ得到登錄密碼
       /// </summary>
       /// <param name="loginID">登錄ＩＤ</param>
       /// <returns>密碼</returns>
       public string GetAdminLoginPwdByLoginID(string loginID)
        {
           string pwd = string.Empty;
            using (SqlConnection conn = new SqlConnection(connString))
            {
                SqlCommand objCommand = new SqlCommand(dboOwner + ".usp_SelectAdminByLoginID", conn);
                objCommand.CommandType = CommandType.StoredProcedure;
                objCommand.Parameters.Add("@LoginId", SqlDbType.NVarChar, 50).Value = loginID;
                conn.Open();
                using (SqlDataReader objReader = objCommand.ExecuteReader(CommandBehavior.CloseConnection))
                {
                    if (objReader.Read())
                        pwd = Convert.ToString(objReader["LoginPwd"]);
                    objReader.Dispose();
                }
                conn.Close();
                conn.Dispose();
            }
            return pwd;
        }
        #endregion
    }
}