#pragma warning disable 1591
//------------------------------------------------------------------------------
// <auto-generated>
//     Este código fue generado por una herramienta.
//     Versión de runtime:4.0.30319.1
//
//     Los cambios en este archivo podrían causar un comportamiento incorrecto y se perderán si
//     se vuelve a generar el código.
// </auto-generated>
//------------------------------------------------------------------------------

namespace HCM.DataAccess.Context
{
	using System.Data.Linq;
	using System.Data.Linq.Mapping;
	using System.Data;
	using System.Collections.Generic;
	using System.Reflection;
	using System.Linq;
	using System.Linq.Expressions;
	using System.ComponentModel;
	using System;
	
	
	[global::System.Data.Linq.Mapping.DatabaseAttribute(Name="SIHCEI_SBX")]
	public partial class lnqAvalDataContext : System.Data.Linq.DataContext
	{
		
		private static System.Data.Linq.Mapping.MappingSource mappingSource = new AttributeMappingSource();
		
    #region Definiciones de métodos de extensibilidad
    partial void OnCreated();
    #endregion
		
		public lnqAvalDataContext() : 
				base(global::HCM.DataAccess.Properties.Settings.Default.SIHCEI_SBXConnectionString, mappingSource)
		{
			OnCreated();
		}
		
		public lnqAvalDataContext(string connection) : 
				base(connection, mappingSource)
		{
			OnCreated();
		}
		
		public lnqAvalDataContext(System.Data.IDbConnection connection) : 
				base(connection, mappingSource)
		{
			OnCreated();
		}
		
		public lnqAvalDataContext(string connection, System.Data.Linq.Mapping.MappingSource mappingSource) : 
				base(connection, mappingSource)
		{
			OnCreated();
		}
		
		public lnqAvalDataContext(System.Data.IDbConnection connection, System.Data.Linq.Mapping.MappingSource mappingSource) : 
				base(connection, mappingSource)
		{
			OnCreated();
		}
		
		[global::System.Data.Linq.Mapping.FunctionAttribute(Name="dbo.sp_iAval")]
		public int sp_iAval([global::System.Data.Linq.Mapping.ParameterAttribute(DbType="Int")] System.Nullable<int> iOperacionId, [global::System.Data.Linq.Mapping.ParameterAttribute(DbType="Int")] System.Nullable<int> iPersonaId, [global::System.Data.Linq.Mapping.ParameterAttribute(Name="Consec", DbType="Int")] System.Nullable<int> consec, [global::System.Data.Linq.Mapping.ParameterAttribute(DbType="VarChar(26)")] string sPrimerNombre, [global::System.Data.Linq.Mapping.ParameterAttribute(DbType="VarChar(26)")] string sSegundoNombre, [global::System.Data.Linq.Mapping.ParameterAttribute(DbType="VarChar(26)")] string sApellidoPaterno, [global::System.Data.Linq.Mapping.ParameterAttribute(DbType="VarChar(26)")] string sApellidoMaterno, [global::System.Data.Linq.Mapping.ParameterAttribute(DbType="Int")] System.Nullable<int> iCveRegimenFiscal, [global::System.Data.Linq.Mapping.ParameterAttribute(Name="RFC", DbType="VarChar(50)")] string rFC, [global::System.Data.Linq.Mapping.ParameterAttribute(DbType="TinyInt")] System.Nullable<byte> tintTipoAvalID, [global::System.Data.Linq.Mapping.ParameterAttribute(DbType="SmallInt")] System.Nullable<short> sintActividadINEGIID, [global::System.Data.Linq.Mapping.ParameterAttribute(DbType="TinyInt")] System.Nullable<byte> tintRiesgoIndustriaID, [global::System.Data.Linq.Mapping.ParameterAttribute(DbType="TinyInt")] System.Nullable<byte> tintRiesgoFinancieroID, [global::System.Data.Linq.Mapping.ParameterAttribute(DbType="TinyInt")] System.Nullable<byte> tintRiesgoExperPagoID, [global::System.Data.Linq.Mapping.ParameterAttribute(Name="UAlta", DbType="Int")] System.Nullable<int> uAlta)
		{
			IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), iOperacionId, iPersonaId, consec, sPrimerNombre, sSegundoNombre, sApellidoPaterno, sApellidoMaterno, iCveRegimenFiscal, rFC, tintTipoAvalID, sintActividadINEGIID, tintRiesgoIndustriaID, tintRiesgoFinancieroID, tintRiesgoExperPagoID, uAlta);
			return ((int)(result.ReturnValue));
		}
		
		[global::System.Data.Linq.Mapping.FunctionAttribute(Name="dbo.sp_getAval")]
		public ISingleResult<sp_getAvalResult> sp_getAval([global::System.Data.Linq.Mapping.ParameterAttribute(Name="Consec", DbType="Int")] System.Nullable<int> consec)
		{
			IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), consec);
			return ((ISingleResult<sp_getAvalResult>)(result.ReturnValue));
		}
	}
	
	public partial class sp_getAvalResult
	{
		
		private int _iParticipeId;
		
		private string _sApellidoPaterno;
		
		private string _sApellidoMaterno;
		
		private string _sPrimerNombre;
		
		private string _sSegundoNombre;
		
		private int _iCveRegimenFiscal;
		
		private string _RFC;
		
		private System.Nullable<byte> _tintTipoAvalID;
		
		private System.Nullable<short> _sintActividadINEGIID;
		
		private System.Nullable<byte> _tintRiesgoIndustriaID;
		
		private System.Nullable<byte> _tintRiesgoFinancieroID;
		
		private System.Nullable<byte> _tintRiesgoExperPagoID;
		
		private int _Consec;
		
		public sp_getAvalResult()
		{
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_iParticipeId", DbType="Int NOT NULL")]
		public int iParticipeId
		{
			get
			{
				return this._iParticipeId;
			}
			set
			{
				if ((this._iParticipeId != value))
				{
					this._iParticipeId = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_sApellidoPaterno", DbType="VarChar(26)")]
		public string sApellidoPaterno
		{
			get
			{
				return this._sApellidoPaterno;
			}
			set
			{
				if ((this._sApellidoPaterno != value))
				{
					this._sApellidoPaterno = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_sApellidoMaterno", DbType="VarChar(26)")]
		public string sApellidoMaterno
		{
			get
			{
				return this._sApellidoMaterno;
			}
			set
			{
				if ((this._sApellidoMaterno != value))
				{
					this._sApellidoMaterno = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_sPrimerNombre", DbType="VarChar(26)")]
		public string sPrimerNombre
		{
			get
			{
				return this._sPrimerNombre;
			}
			set
			{
				if ((this._sPrimerNombre != value))
				{
					this._sPrimerNombre = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_sSegundoNombre", DbType="VarChar(26)")]
		public string sSegundoNombre
		{
			get
			{
				return this._sSegundoNombre;
			}
			set
			{
				if ((this._sSegundoNombre != value))
				{
					this._sSegundoNombre = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_iCveRegimenFiscal", DbType="Int NOT NULL")]
		public int iCveRegimenFiscal
		{
			get
			{
				return this._iCveRegimenFiscal;
			}
			set
			{
				if ((this._iCveRegimenFiscal != value))
				{
					this._iCveRegimenFiscal = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_RFC", DbType="VarChar(50)")]
		public string RFC
		{
			get
			{
				return this._RFC;
			}
			set
			{
				if ((this._RFC != value))
				{
					this._RFC = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_tintTipoAvalID", DbType="TinyInt")]
		public System.Nullable<byte> tintTipoAvalID
		{
			get
			{
				return this._tintTipoAvalID;
			}
			set
			{
				if ((this._tintTipoAvalID != value))
				{
					this._tintTipoAvalID = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_sintActividadINEGIID", DbType="SmallInt")]
		public System.Nullable<short> sintActividadINEGIID
		{
			get
			{
				return this._sintActividadINEGIID;
			}
			set
			{
				if ((this._sintActividadINEGIID != value))
				{
					this._sintActividadINEGIID = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_tintRiesgoIndustriaID", DbType="TinyInt")]
		public System.Nullable<byte> tintRiesgoIndustriaID
		{
			get
			{
				return this._tintRiesgoIndustriaID;
			}
			set
			{
				if ((this._tintRiesgoIndustriaID != value))
				{
					this._tintRiesgoIndustriaID = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_tintRiesgoFinancieroID", DbType="TinyInt")]
		public System.Nullable<byte> tintRiesgoFinancieroID
		{
			get
			{
				return this._tintRiesgoFinancieroID;
			}
			set
			{
				if ((this._tintRiesgoFinancieroID != value))
				{
					this._tintRiesgoFinancieroID = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_tintRiesgoExperPagoID", DbType="TinyInt")]
		public System.Nullable<byte> tintRiesgoExperPagoID
		{
			get
			{
				return this._tintRiesgoExperPagoID;
			}
			set
			{
				if ((this._tintRiesgoExperPagoID != value))
				{
					this._tintRiesgoExperPagoID = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Consec", DbType="Int NOT NULL")]
		public int Consec
		{
			get
			{
				return this._Consec;
			}
			set
			{
				if ((this._Consec != value))
				{
					this._Consec = value;
				}
			}
		}
	}
}
#pragma warning restore 1591
