using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using SqlSugar;

namespace IStation.DAL
{
    /// <summary>
    /// 用户角色映射
    /// </summary>
    public class UserRoleMapping : BaseDAL<Entity.UserRoleMapping> 
    {
		/// <summary>
		/// 
		/// </summary>
		public override ConnectionConfig ConnectionConfig
		{
			get { return ConfigHelper.DefaultConnectionConfig; }
		}

		/// <summary>
		///  通过 RoleID 获取 
		/// </summary>
		public List<Entity.UserRoleMapping> GetByRoleID(long RoleID)
		{
			using (var db = new SqlSugarClient(ConnectionConfig))
			{
				return db.Queryable<Entity.UserRoleMapping>()
					.Where(x => x.RoleID == RoleID).ToList();
			}
		}

		/// <summary>
		///  通过 RoleIds 获取 
		/// </summary>
		public List<Entity.UserRoleMapping> GetByRoleIds(List<long> RoleIds)
		{
			if (RoleIds == null || RoleIds.Count() < 1)
				return default;
			using (var db = new SqlSugarClient(ConnectionConfig))
			{
				return db.Queryable<Entity.UserRoleMapping>()
					.Where(x => RoleIds.Contains(x.RoleID)).ToList();
			}
		}

		/// <summary>
		///  通过 UserID 获取 
		/// </summary>
		public List<Entity.UserRoleMapping> GetByUserID(long UserID)
		{
			using (var db = new SqlSugarClient(ConnectionConfig))
			{
				return db.Queryable<Entity.UserRoleMapping>()
					.Where(x => x.UserID == UserID).ToList();
			}
		}

		/// <summary>
		///  通过 UserIds 获取 
		/// </summary>
		public List<Entity.UserRoleMapping> GetByUserIds(List<long> UserIds)
		{
			if (UserIds == null || UserIds.Count() < 1)
				return default;
			using (var db = new SqlSugarClient(ConnectionConfig))
			{
				return db.Queryable<Entity.UserRoleMapping>()
					.Where(x => UserIds.Contains(x.UserID)).ToList();
			}
		}

		/// <summary>
		/// 通过 UserID 和 RoleID 获取 
		/// </summary>
		public Entity.UserRoleMapping GetByUserIDAndRoleID(long UserID, long RoleID)
		{
			using (var db = new SqlSugarClient(ConnectionConfig))
			{
				return db.Queryable<Entity.UserRoleMapping>()
					.First(x => x.UserID == UserID&&x.RoleID==RoleID);
			}
		}

		/// <summary>
		/// 设置
		/// </summary>
		public bool Set(List<Entity.UserRoleSelected> list)
		{
			if (list == null || list.Count() < 1)
				return default;
			using (var db = new SqlSugarClient(ConnectionConfig))
			{
				try
				{
					db.BeginTran();
					foreach (var item in list)
					{
						var bol = db.Queryable<Entity.UserRoleMapping>()
							.Where(x => x.UserID == item.UserID && x.RoleID == item.RoleID).Count() > 0;
						if (bol)//已存在
						{
							if (!item.Selected)//未选择
							{
								var result = db.Deleteable<Entity.UserRoleMapping>()
									.Where(x => x.UserID == item.UserID && x.RoleID == item.RoleID).ExecuteCommandHasChange();
								if (!result)
								{
									db.RollbackTran();
									return false;
								}
							}
						}
						else//不存在
						{
							if (item.Selected)//选择
							{
								var entity = new Entity.UserRoleMapping();
								entity.UserID = item.UserID;
								entity.RoleID = item.RoleID;
								var id = db.Insertable(entity).ExecuteReturnSnowflakeId();
								if (id < 1)
								{
									db.RollbackTran();
									return false;
								}
							}
						}
					}
					db.CommitTran();
					return true;
				}
				catch
				{
					db.RollbackTran();
					throw;
				}
			}
		}



















	}
}