BusinessMgr-2019/SaBusMgrStandardBase/Base/Bus/Control/SbmcRepository.cs

using Sarand.Net.Standard.Base.Bus;
using Sarand.Net.Standard.Base.Core;
using Sarand.Net.Standard.Base.Utils;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Sarand.BusinessMgr.Net.Standard.Base.Bus.Control
{
	//=======================================================================
	public class SbmcRepository : SbmcHierarchyItem
	{
		//-------------------------------------------------------------------
		// Columns.
		public enum Column
		{
			Hidden,
			Pos,
			// Repository.
			Id,
			Context,
			ServerName,
			InstanceName,
			DatabaseName,
			UserName,
			// Owner.
			OwnerId,
			OwnerName,
			ContactName,
			ContactEmailAddress,
			ContactPhoneMain,
			ContactPhoneAlt,
			// Common properties.
			Notes,
			Flag,
			Status,
			Status_Ind,
			Status_Desc,
			CreateOn_Date,
			UpdateOn_Date,
		}

		//-------------------------------------------------------------------
		/// <summary>Properties other than common.</summary>
		public class DataProperties
		{
			public SysId OwnerId { get; set; }
			public String Context { get; set; } = "";
			public String ServerName { get; set; } = "";
			public String InstanceName { get; set; } = "";
			public String DatabaseName { get; set; }
			public String UserName { get; set; } = "";
			public String Password { get; set; } = "";
		}

		//-------------------------------------------------------------------
		// Data.
		public new class Data : SacsHierarchyItem.Data
		{
			// Data members.
			private readonly DataProperties data = new DataProperties();
			// Construction.
			public Data()
			{
				Status = SbmcRepository.DefaultStatus;
			}
			public SysId OwnerId
			{
				get { return data.OwnerId; }
				set { CheckChanged(data.OwnerId, value); data.OwnerId = value; }
			}
			public String Context
			{
				get { return data.Context; }
				set { CheckChanged(data.Context, value); data.Context = value; }
			}
			public String ServerName
			{
				get { return data.ServerName; }
				set { CheckChanged(data.ServerName, value); data.ServerName = value; }
			}
			public String InstanceName
			{
				get { return data.InstanceName; }
				set { CheckChanged(data.InstanceName, value); data.InstanceName = value; }
			}
			public String DatabaseName
			{
				get { return data.DatabaseName; }
				set { CheckChanged(data.DatabaseName, value); data.DatabaseName = value; }
			}
			public String UserName
			{
				get { return data.UserName; }
				set { CheckChanged(data.UserName, value); data.UserName = value; }
			}
			public String Password
			{
				get { return data.Password; }
				set { CheckChanged(data.Password, value); data.Password = value; }
			}

			internal void PopulateFrom(Data data)
			{
				OwnerId = data.OwnerId;
				Context = data.Context;
				ServerName = data.ServerName;
				InstanceName = data.InstanceName;
				DatabaseName = data.DatabaseName;
				UserName = data.UserName;
				Password = data.Password;
				base.PopulateFrom(data);
			}
			public Data Clone()
			{
				Data data = new Data();
				data.PopulateFrom(this);
				return data;
			}
		}
		public new class ErrField : SacsHierarchyItem.ErrField
		{
			// Identifies the field that has invalid data.
			public ValidValue OwnerId { get; set; } = ValidValue.Valid;
			public ValidValue Context { get; set; } = ValidValue.Valid;
			public ValidValue ServerName { get; set; } = ValidValue.Valid;
			public ValidValue InstanceName { get; set; } = ValidValue.Valid;
			public ValidValue DatabaseName { get; set; } = ValidValue.Valid;
			public ValidValue UserName { get; set; } = ValidValue.Valid;
			public ValidValue Password { get; set; } = ValidValue.Valid;
		}

		//-------------------------------------------------------------------
		// Data members.
		private readonly Data data = new Data();

		//-------------------------------------------------------------------
		// Construction.
		protected SbmcRepository(SysId id) : base(id)
		{
			base.SetData(data);
		}

		//-------------------------------------------------------------------
		// Repository status.
		private static readonly List<SaStatus> repositoryStatuses = new List<SaStatus>()
		{
			SaStatus.Active,
			SaStatus.OnHold,
			SaStatus.Inactive,
			SaStatus.Deleted,
		};
		public static SaStatus DefaultStatus { get { return SaStatus.Active; } }
		public static List<SaStatus> ValidStatuses { get { return new List<SaStatus>(repositoryStatuses); } }
		public static DataValue.TriStateType GetStatusTriState(SaStatus status)
		{
			switch (status)
			{
				case SaStatus.Active:
					return DataValue.TriStateType.Green;
				case SaStatus.OnHold:
					return DataValue.TriStateType.Amber;
				case SaStatus.Inactive:
					return DataValue.TriStateType.Red;
				case SaStatus.Deleted:
					return DataValue.TriStateType.Purple;
			}
			return DataValue.TriStateType.Unknown;
		}

		//-------------------------------------------------------------------
		// Utilities.

		//-------------------------------------------------------------------
		// Properties.
		public Data GetData() { return data.Clone(); }
		public void SetData(Data data)
		{
			// Properties that cannot be changed if previously specified.
			if (SysId.IsValid(Id) && SysId.ToInt(Id) != SysId.ToInt(data.Id))
				throw new NotSupportedException($"{SysUtil.Fn} Id cannot be changed");
			// Populate individual properties to ensure that 'Changed' indicator is kept up to date.
			this.data.PopulateFrom(data);
		}

		//-------------------------------------------------------------------
		// Properties.

		// Owner.

		public SysId OwnerId
		{
			get { return data.OwnerId; }
			set { data.OwnerId = value; }
		}

		// Repository.

		public String Context
		{
			get { return data.Context; }
			set { data.Context = value; }
		}
		public String ServerName
		{
			get { return data.ServerName; }
			set { data.ServerName = value; }
		}
		public String InstanceName
		{
			get { return data.InstanceName; }
			set { data.InstanceName = value; }
		}
		public String DatabaseName
		{
			get { return data.DatabaseName; }
			set { data.DatabaseName = value; }
		}

		// Credentials.

		public String UserName
		{
			get { return data.UserName; }
			set { data.UserName = value; }
		}
		public String Password
		{
			get { return data.Password; }
			set { data.Password = value; }
		}

		//-------------------------------------------------------------------
		// Flags.

		//-------------------------------------------------------------------
		// Associated data.

		//-------------------------------------------------------------------
		// List parameters.

		/// <summary> Status filter options.</summary>
		public enum StatusCat
		{
			Any,
			ActiveOnly,
			OnHoldOnly,
			InactiveOnly,
			NotDeleted,
			DeletedOnly,
		}

		/// <summary>Parameters - used to define the filters that should be applied to a list of items.</summary>
		public new class Params : SacsHierarchyItem.Params
		{
			// List filtering.
			public HashSet<SysId> IdsIncluded { get; } = new HashSet<SysId>();
			public HashSet<SysId> IdsExcluded { get; } = new HashSet<SysId>();
			/// <summary>Repository owners.</summary>
			public HashSet<SysId> OwnerIdsIncluded { get; } = new HashSet<SysId>();
			/// <summary>Repository contexts.</summary>
			public HashSet<String> ContextsIncluded { get; set; } = new HashSet<String>();
			/// <summary>Generic search value - context, server, instance, database etc.</summary>
			public String Search { get; set; }
			public String NotesPartial { get; set; }
			/// <summary>Contact status.</summary>
			public StatusCat StatusCat { get; set; } = StatusCat.NotDeleted;
			// Table alises.
			public String Alias_Owner { get; set; }
		}
	}
	//=======================================================================
	// Item list.
	public static class SbmcRepositoryList
	{
	}
	//=======================================================================
}