namespace Seguridad.DataModel
{
	public class Schema
	{
		#region Auditoria
		public struct Auditoria
		{
			public const string SP_SELECT_ALL = "uSp_AuditoriaSelectAll";
			public const string SP_SELECT_BY_PK = "uSp_AuditoriaSelectByPK";
			public const string SP_SELECT_FIND = "uSp_AuditoriaSelectFind";
			public const string SP_INSERT = "uSp_AuditoriaSave";
			public const string SP_UPDATE = "uSp_AuditoriaSave";
			public const string SP_DELETE = "uSp_AuditoriaDelete";

			public struct idAuditoria
			{
				public const string FieldName = "idAuditoria";
				public const string DisplayName = "idAuditoria";
				public const int Length = 4;
			}

			public struct idSistema
			{
				public const string FieldName = "idSistema";
				public const string DisplayName = "idSistema";
				public const int Length = 4;
			}

			public struct idUsuario
			{
				public const string FieldName = "idUsuario";
				public const string DisplayName = "idUsuario";
				public const int Length = 4;
			}

			public struct Fecha
			{
				public const string FieldName = "Fecha";
				public const string DisplayName = "Fecha";
				public const int Length = 8;
			}

			public struct idRegistro
			{
				public const string FieldName = "idRegistro";
				public const string DisplayName = "idRegistro";
				public const int Length = 4;
			}

			public struct Descripcion
			{
				public const string FieldName = "Descripcion";
				public const string DisplayName = "Descripcion";
				public const int Length = 50;
			}

			public struct Accion
			{
				public const string FieldName = "Accion";
				public const string DisplayName = "Accion";
				public const int Length = 1;
			}

			public struct CodigoRegistro
			{
				public const string FieldName = "CodigoRegistro";
				public const string DisplayName = "CodigoRegistro";
				public const int Length = 50;
			}
		}
		#endregion

		#region Permisos
		public struct Permisos
		{
			//Mazars
			public const string SP_SELECT_PERMISOS_BY_USUARIO = "wSp_PermisosByUsuarioAndSistema";
			public const string SP_SELECT_PERMISOS_BY_USUARIO_AND_SUCURSAL = "wSp_PermisosSucursalByUsuarioAndSistema";
		}
		#endregion

		#region Usuarios

		public struct Usuarios
		{
			//Mazars
			public const string SP_USUARIO_BY_EMPRESA_TRABAJADOR = "wSp_UsuarioByEmpresaAndTrabajador";
			public const string SP_USUARIO_BY_TRABAJADOR = "wSp_UsuarioByTrabajador";
			public const string SP_USUARIO_SUCURSAL = "wSp_UsuarioSucursal";
			public const string SP_SELECT_ALL = "wSp_UsuarioWebSelectAll";
			public const string SP_SELECT_BY_PK = "wSp_UsuarioWebSelectByPK";
			public const string SP_INSERT = "wSp_UsuarioWebSave";
			public const string SP_UPDATE = "wSp_UsuarioWebSave";
			public const string SP_DELETE = "wSp_UsuarioWebDelete";
			public const string SP_SELECT_FILTER = "wSp_UsuarioWebFilter";
			public const string SP_CHANGE_PASS = "wSP_UsuarioWebCambiarContrasena";
			public const string SP_USUARIO_EMPRESA_SAVE = "wSp_UsuarioEmpresaSave";
			public const string SP_USUARIO_EMPRESA_DELETE = "wSp_UsuarioEmpresaDeleteByUsuarioAndSistema";
			public const string SP_USUARIO_SUCURSAL_SAVE = "wSp_UsuarioSucursalSave";
			public const string SP_USUARIO_SUCURSAL_DELETE = "wSp_UsuarioSucursalDelete";
			public const string SP_USUARIO_PERMISO_SAVE = "wSp_UsuarioPermisoSave";
			public const string SP_USUARIO_PERMISO_DELETE = "wSp_UsuarioPermisosDelete";
			
			public struct idUsuarioWeb
			{
				public const string FieldName = "idUsuarioWeb";
				public const string DisplayName = "idUsuarioWeb";
				public const int Length = 4;
			}

			public struct Rut
			{
				public const string FieldName = "Rut";
				public const string DisplayName = "Rut";
				public const int Length = 8;
			}

			public struct DV
			{
				public const string FieldName = "DV";
				public const string DisplayName = "DV";
				public const int Length = 1;
			}

			public struct Nombre
			{
				public const string FieldName = "Nombre";
				public const string DisplayName = "Nombre";
				public const int Length = 50;
			}

			public struct Paterno
			{
				public const string FieldName = "Paterno";
				public const string DisplayName = "Paterno";
				public const int Length = 50;
			}

			public struct Materno
			{
				public const string FieldName = "Materno";
				public const string DisplayName = "Materno";
				public const int Length = 50;
			}

			public struct Mail
			{
				public const string FieldName = "Mail";
				public const string DisplayName = "Mail";
				public const int Length = 100;
			}

			public struct Password
			{
				public const string FieldName = "Password";
				public const string DisplayName = "Password";
				public const int Length = 40;
			}

			public struct TipoUsuario
			{
				public const string FieldName = "TipoUsuario";
				public const string DisplayName = "TipoUsuario";
				public const int Length = 4;
			}

			public struct Habilitada
			{
				public const string FieldName = "Habilitada";
				public const string DisplayName = "Habilitada";
				public const int Length = 1;
			}

			public struct CambiarPasswordInicio
			{
				public const string FieldName = "CambiarPasswordInicio";
				public const string DisplayName = "CambiarPasswordInicio";
				public const int Length = 1;
			}

			public struct SaltHash
			{
				public const string FieldName = "SaltHash";
				public const string DisplayName = "SaltHash";
				public const int Length = 40;
			}
		}
		#endregion

		#region ModuloWeb
		
		public struct ModuloWeb
		{
			public const string SP_SELECT_ALL = "wSp_ModuloWebSelectAll";
			public const string SP_SELECT_BY_PK = "wSp_ModuloWebSelectByPK";
			public const string SP_INSERT = "wSp_ModuloWebSave";
			public const string SP_UPDATE = "wSp_ModuloWebSave";
			public const string SP_DELETE = "wSp_ModuloWebDelete";

			public struct idModuloWeb
			{
				public const string FieldName = "idModuloWeb";
				public const string DisplayName = "idModuloWeb";
				public const int Length = 4;
			}

			public struct idSistema
			{
				public const string FieldName = "idSistema";
				public const string DisplayName = "idSistema";
				public const int Length = 4;
			}

			public struct Link
			{
				public const string FieldName = "Link";
				public const string DisplayName = "Link";
				public const int Length = 200;
			}

			public struct NombreDisplay
			{
				public const string FieldName = "NombreDisplay";
				public const string DisplayName = "NombreDisplay";
				public const int Length = 50;
			}

			public struct Nivel
			{
				public const string FieldName = "Nivel";
				public const string DisplayName = "Nivel";
				public const int Length = 4;
			}

			public struct idNivelAnterior
			{
				public const string FieldName = "idNivelAnterior";
				public const string DisplayName = "idNivelAnterior";
				public const int Length = 4;
			}

			public struct EnableInAdmin
			{
				public const string FieldName = "EnableInAdmin";
				public const string DisplayName = "EnableInAdmin";
				public const int Length = 1;
			}

			public struct EnableInUser
			{
				public const string FieldName = "EnableInUser";
				public const string DisplayName = "EnableInUser";
				public const int Length = 1;
			}
		}
		#endregion

		#region Empresa
		public struct Empresa
		{
			public const string SP_SELECT_ALL = "wSp_Empresas";
			public const string SP_SELECT_ALL2 = "wSp_EmpresasAll";
			public const string SP_SELECT_ANO = "uSp_ExisteAnoEmpresa";
		}
		#endregion

		#region Sucursal
		public struct Sucursal
		{
			public const string SP_SELECT_ALL = "wSp_SucursalWebAll";
		}
		#endregion
	}
}