using System.Collections.Generic;
using System.Linq;

namespace BLL
{
    /// <summary>
    /// 专业类别
    /// </summary>
    public class DisciplineCategoryService
    {
        /// <summary>
        /// 根据主键获取专业类别
        /// </summary>
        /// <param name="categoryId"></param>
        /// <returns></returns>
        public static Model.Base_DisciplineCategory GetDisciplineCategoryById(string categoryId)
        {
            return Funs.DB.Base_DisciplineCategory.FirstOrDefault(e => e.CategoryId == categoryId);
        }
        
        /// <summary>
        /// 获取专业类别列表
        /// </summary>
        /// <returns></returns>
        public static List<Model.Base_DisciplineCategory> GetDisciplineCategoryList()
        {
            return (from x in Funs.DB.Base_DisciplineCategory orderby x.Category select x).ToList();
        }

        /// <summary>
        /// 添加专业类别
        /// </summary>
        /// <param name="category"></param>
        public static void AddDisciplineCategory(Model.Base_DisciplineCategory category)
        {
            Model.Base_DisciplineCategory newDisciplineCategory = new Model.Base_DisciplineCategory();
            newDisciplineCategory.CategoryId = category.CategoryId;
            newDisciplineCategory.Category = category.Category;
            newDisciplineCategory.Remarks = category.Remarks;
            Funs.DB.Base_DisciplineCategory.InsertOnSubmit(category);
            Funs.DB.SubmitChanges();
        }

        /// <summary>
        /// 修改专业类别
        /// </summary>
        /// <param name="category"></param>
        public static void UpdateDisciplineCategory(Model.Base_DisciplineCategory category)
        {
            Model.Base_DisciplineCategory newDisciplineCategory = Funs.DB.Base_DisciplineCategory.FirstOrDefault(e => e.CategoryId == category.CategoryId);
            if (newDisciplineCategory != null)
            {
                newDisciplineCategory.Category = category.Category;
                newDisciplineCategory.Remarks = category.Remarks;
                Funs.DB.SubmitChanges();
            }
        }

        /// <summary>
        /// 根据主键删除专业类别
        /// </summary>
        /// <param name="categoryId"></param>
        public static void DeleteDisciplineCategoryById(string categoryId)
        {
            Model.Base_DisciplineCategory category = Funs.DB.Base_DisciplineCategory.FirstOrDefault(e => e.CategoryId == categoryId);
            if (category != null)
            {
                Funs.DB.Base_DisciplineCategory.DeleteOnSubmit(category);
                Funs.DB.SubmitChanges();
            }
        }

        /// <summary>
        /// 验证是否存在相同专业类别
        /// </summary>
        /// <param name="category"></param>
        /// <param name="id"></param>
        /// <returns></returns>
        public static bool IsExitCategory(string category, string id)
        {
            var q = Funs.DB.Base_DisciplineCategory.FirstOrDefault(x => x.Category == category && x.CategoryId != id);
            if (q != null)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        /// <summary>
        /// 常量表下拉框
        /// </summary>
        /// <param name="dropName">下拉框名字</param>
        /// <param name="isShowPlease">是否显示请选择</param>
        public static void InitDropDownList(FineUIPro.DropDownList dropName, bool isShowPlease)
        {
            dropName.DataValueField = "CategoryId";
            dropName.DataTextField = "Category";
            dropName.DataSource = GetDisciplineCategoryList();
            dropName.DataBind();
            if (isShowPlease)
            {
                Funs.FineUIPleaseSelect(dropName);
            }
        }
    }
}