using System;
using System.Collections.Generic;
using System.Text;
using MyCRM.IDAL;
using MyCRM.Models;
using System.Data;
using System.Data.SqlClient;
using MyCRM.DBUtility;

namespace MyCRM.DAL
{
    /// <summary>
    /// 用戶角色數據層
    /// </summary>
   public class RoleService:IRole
    {
        /// <summary>
        /// 查詢所有用戶角色
        /// </summary>
        /// <returns>返回集合</returns>
       public List<Sys_role> GetAllRoles()
        {
            string sql = "select * from Sys_role";
            return GetRolesBySql(sql);
        }
        /// <summary>
        /// 根據角色id獲得角色信息
        /// </summary>
        /// <param name="roleId">角色id</param>
        /// <returns>角色對象</returns>
       public Sys_role GetRoleInfoById(int roleId)
        {
            string sql = "select * from Sys_role where Role_id = @roleId";
            try
            {
                SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@roleId", roleId));
                if (reader.Read())
                {
                    Sys_role role = new Sys_role();
                    role.Role_id = (int)reader["Role_id"];
                    role.Role_name = (string)reader["Role_name"];
                    role.Role_desc = (string)reader["Role_desc"];
                    role.Role_flag = (int)reader["Role_flag"];
                    reader.Close();
                    reader.Dispose();
                    return role;                   
                }
                else
                {
                    reader.Close();
                    return null;
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                return null;
            }
        }

        /// <summary>
        /// 根據sql查詢角色信息
        /// </summary>
        /// <param name="safeSql">sql語句</param>
        /// <returns>返回集合</returns>
       private List<Sys_role> GetRolesBySql(string safeSql)
        {
            List<Sys_role> list = new List<Sys_role>();

            using (DataTable table = DBHelper.GetDataSet(safeSql))
            {
                foreach (DataRow row in table.Rows)
                {
                    Sys_role role = new Sys_role();

                    role.Role_id = (int)row["Role_id"];
                    role.Role_name = (string)row["Role_name"];
                    role.Role_desc = (string)row["Role_desc"];
                    role.Role_flag=(int)row["Role_flag"];

                    list.Add(role);
                }

                return list;
            }
        }
    }
    }