#pragma warning disable 1591
//------------------------------------------------------------------------------
// <auto-generated>
//     Este código fue generado por una herramienta.
//     Versión de runtime:4.0.30319.269
//
//     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_tmp")]
	public partial class lnqCreditoHipotecarioDataContext : 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 lnqCreditoHipotecarioDataContext() : 
				base(global::HCM.DataAccess.Properties.Settings.Default.SIHCEI_SBXConnectionString, mappingSource)
		{
			OnCreated();
		}
		
		public lnqCreditoHipotecarioDataContext(string connection) : 
				base(connection, mappingSource)
		{
			OnCreated();
		}
		
		public lnqCreditoHipotecarioDataContext(System.Data.IDbConnection connection) : 
				base(connection, mappingSource)
		{
			OnCreated();
		}
		
		public lnqCreditoHipotecarioDataContext(string connection, System.Data.Linq.Mapping.MappingSource mappingSource) : 
				base(connection, mappingSource)
		{
			OnCreated();
		}
		
		public lnqCreditoHipotecarioDataContext(System.Data.IDbConnection connection, System.Data.Linq.Mapping.MappingSource mappingSource) : 
				base(connection, mappingSource)
		{
			OnCreated();
		}
		
		[global::System.Data.Linq.Mapping.FunctionAttribute(Name="dbo.sp_getCreditoHipotecario")]
		public ISingleResult<sp_getCreditoHipotecarioResult> sp_getCreditoHipotecario([global::System.Data.Linq.Mapping.ParameterAttribute(DbType="Int")] System.Nullable<int> iOperacionId)
		{
			IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), iOperacionId);
			return ((ISingleResult<sp_getCreditoHipotecarioResult>)(result.ReturnValue));
		}
		
		[global::System.Data.Linq.Mapping.FunctionAttribute(Name="dbo.sp_uCreditoHipotecario")]
		public int sp_uCreditoHipotecario(
					[global::System.Data.Linq.Mapping.ParameterAttribute(DbType="Int")] System.Nullable<int> iOpcion, 
					[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(DbType="SmallInt")] System.Nullable<short> sintDestinoCredID, 
					[global::System.Data.Linq.Mapping.ParameterAttribute(DbType="SmallInt")] System.Nullable<short> sintTasaRefID, 
					[global::System.Data.Linq.Mapping.ParameterAttribute(DbType="TinyInt")] System.Nullable<byte> tintTipoAltaID, 
					[global::System.Data.Linq.Mapping.ParameterAttribute(DbType="TinyInt")] System.Nullable<byte> tintTipoBajaID, 
					[global::System.Data.Linq.Mapping.ParameterAttribute(DbType="SmallInt")] System.Nullable<short> sintTipoCreditoID, 
					[global::System.Data.Linq.Mapping.ParameterAttribute(DbType="Decimal(8,2)")] System.Nullable<decimal> dMProyecto, 
					[global::System.Data.Linq.Mapping.ParameterAttribute(DbType="SmallInt")] System.Nullable<short> sintEntAsegID, 
					[global::System.Data.Linq.Mapping.ParameterAttribute(DbType="SmallInt")] System.Nullable<short> sintEntidadCofinanID, 
					[global::System.Data.Linq.Mapping.ParameterAttribute(DbType="TinyInt")] System.Nullable<byte> tintTipoSeguroID, 
					[global::System.Data.Linq.Mapping.ParameterAttribute(DbType="Bit")] System.Nullable<bool> bitSeguroCargoCli, 
					[global::System.Data.Linq.Mapping.ParameterAttribute(DbType="TinyInt")] System.Nullable<byte> tintTipoTasaIntID, 
					[global::System.Data.Linq.Mapping.ParameterAttribute(Name="GastosOriginacion", DbType="Decimal(18,0)")] System.Nullable<decimal> gastosOriginacion, 
					[global::System.Data.Linq.Mapping.ParameterAttribute(Name="TasaComisiones", DbType="Decimal(18,0)")] System.Nullable<decimal> tasaComisiones, 
					[global::System.Data.Linq.Mapping.ParameterAttribute(Name="TasaInteres", DbType="Decimal(18,0)")] System.Nullable<decimal> tasaInteres, 
					[global::System.Data.Linq.Mapping.ParameterAttribute(DbType="TinyInt")] System.Nullable<byte> tintSectorLabID, 
					[global::System.Data.Linq.Mapping.ParameterAttribute(DbType="Int")] System.Nullable<int> iComprobanteEmpleoId, 
					[global::System.Data.Linq.Mapping.ParameterAttribute(DbType="VarChar(5)")] string sCodigoPostal, 
					[global::System.Data.Linq.Mapping.ParameterAttribute(DbType="Int")] System.Nullable<int> iEstadoId, 
					[global::System.Data.Linq.Mapping.ParameterAttribute(DbType="Int")] System.Nullable<int> iMunicipioDelegacionId, 
					[global::System.Data.Linq.Mapping.ParameterAttribute(DbType="Decimal(15,2)")] System.Nullable<decimal> decImporteIngreso, 
					[global::System.Data.Linq.Mapping.ParameterAttribute(DbType="Bit")] System.Nullable<bool> bitConvenio)
		{
			IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), iOpcion, iOperacionId, iPersonaId, sintDestinoCredID, sintTasaRefID, tintTipoAltaID, tintTipoBajaID, sintTipoCreditoID, dMProyecto, sintEntAsegID, sintEntidadCofinanID, tintTipoSeguroID, bitSeguroCargoCli, tintTipoTasaIntID, gastosOriginacion, tasaComisiones, tasaInteres, tintSectorLabID, iComprobanteEmpleoId, sCodigoPostal, iEstadoId, iMunicipioDelegacionId, decImporteIngreso, bitConvenio);
			return ((int)(result.ReturnValue));
		}
	}
	
	public partial class sp_getCreditoHipotecarioResult
	{
		
		private System.Nullable<int> _iOperacionId;
		
		private System.Nullable<int> _iPersonaId;
		
		private System.Nullable<short> _sintDestinoCredID;
		
		private System.Nullable<short> _sintTasaRefID;
		
		private System.Nullable<byte> _tintTipoAltaID;
		
		private System.Nullable<byte> _tintTipoBajaID;
		
		private System.Nullable<short> _sintTipoCreditoID;
		
		private System.Nullable<decimal> _dpConcedido;
		
		private System.Nullable<decimal> _dMProyecto;
		
		private System.Nullable<short> _sintEntAsegID;
		
		private System.Nullable<short> _sintEntidadCofinanID;
		
		private System.Nullable<byte> _tintTipoSeguroID;
		
		private System.Nullable<bool> _bitSeguroCargoCli;
		
		private System.Nullable<byte> _tintTipoTasaIntID;
		
		private System.Nullable<bool> _bitConvenio;
		
		private System.Nullable<decimal> _GastosOriginacion;
		
		private System.Nullable<decimal> _TasaComisiones;
		
		private System.Nullable<decimal> _TasaInteres;
		
		private System.Nullable<byte> _tintSectorLabID;
		
		private System.Nullable<int> _iComprobanteEmpleoId;
		
		private System.Nullable<int> _iEstadoId;
		
		private System.Nullable<int> _iMunicipioDelegacionId;
		
		private string _sCodigoPostal;
		
		private System.Nullable<decimal> _decImporteIngreso;
		
		public sp_getCreditoHipotecarioResult()
		{
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_iOperacionId", DbType="Int")]
		public System.Nullable<int> iOperacionId
		{
			get
			{
				return this._iOperacionId;
			}
			set
			{
				if ((this._iOperacionId != value))
				{
					this._iOperacionId = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_iPersonaId", DbType="Int")]
		public System.Nullable<int> iPersonaId
		{
			get
			{
				return this._iPersonaId;
			}
			set
			{
				if ((this._iPersonaId != value))
				{
					this._iPersonaId = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_sintDestinoCredID", DbType="SmallInt")]
		public System.Nullable<short> sintDestinoCredID
		{
			get
			{
				return this._sintDestinoCredID;
			}
			set
			{
				if ((this._sintDestinoCredID != value))
				{
					this._sintDestinoCredID = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_sintTasaRefID", DbType="SmallInt")]
		public System.Nullable<short> sintTasaRefID
		{
			get
			{
				return this._sintTasaRefID;
			}
			set
			{
				if ((this._sintTasaRefID != value))
				{
					this._sintTasaRefID = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_tintTipoAltaID", DbType="TinyInt")]
		public System.Nullable<byte> tintTipoAltaID
		{
			get
			{
				return this._tintTipoAltaID;
			}
			set
			{
				if ((this._tintTipoAltaID != value))
				{
					this._tintTipoAltaID = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_tintTipoBajaID", DbType="TinyInt")]
		public System.Nullable<byte> tintTipoBajaID
		{
			get
			{
				return this._tintTipoBajaID;
			}
			set
			{
				if ((this._tintTipoBajaID != value))
				{
					this._tintTipoBajaID = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_sintTipoCreditoID", DbType="SmallInt")]
		public System.Nullable<short> sintTipoCreditoID
		{
			get
			{
				return this._sintTipoCreditoID;
			}
			set
			{
				if ((this._sintTipoCreditoID != value))
				{
					this._sintTipoCreditoID = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_dpConcedido", DbType="Decimal(15,4)")]
		public System.Nullable<decimal> dpConcedido
		{
			get
			{
				return this._dpConcedido;
			}
			set
			{
				if ((this._dpConcedido != value))
				{
					this._dpConcedido = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_dMProyecto", DbType="Decimal(15,2)")]
		public System.Nullable<decimal> dMProyecto
		{
			get
			{
				return this._dMProyecto;
			}
			set
			{
				if ((this._dMProyecto != value))
				{
					this._dMProyecto = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_sintEntAsegID", DbType="SmallInt")]
		public System.Nullable<short> sintEntAsegID
		{
			get
			{
				return this._sintEntAsegID;
			}
			set
			{
				if ((this._sintEntAsegID != value))
				{
					this._sintEntAsegID = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_sintEntidadCofinanID", DbType="SmallInt")]
		public System.Nullable<short> sintEntidadCofinanID
		{
			get
			{
				return this._sintEntidadCofinanID;
			}
			set
			{
				if ((this._sintEntidadCofinanID != value))
				{
					this._sintEntidadCofinanID = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_tintTipoSeguroID", DbType="TinyInt")]
		public System.Nullable<byte> tintTipoSeguroID
		{
			get
			{
				return this._tintTipoSeguroID;
			}
			set
			{
				if ((this._tintTipoSeguroID != value))
				{
					this._tintTipoSeguroID = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_bitSeguroCargoCli", DbType="Bit")]
		public System.Nullable<bool> bitSeguroCargoCli
		{
			get
			{
				return this._bitSeguroCargoCli;
			}
			set
			{
				if ((this._bitSeguroCargoCli != value))
				{
					this._bitSeguroCargoCli = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_tintTipoTasaIntID", DbType="TinyInt")]
		public System.Nullable<byte> tintTipoTasaIntID
		{
			get
			{
				return this._tintTipoTasaIntID;
			}
			set
			{
				if ((this._tintTipoTasaIntID != value))
				{
					this._tintTipoTasaIntID = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_bitConvenio", DbType="Bit")]
		public System.Nullable<bool> bitConvenio
		{
			get
			{
				return this._bitConvenio;
			}
			set
			{
				if ((this._bitConvenio != value))
				{
					this._bitConvenio = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_GastosOriginacion", DbType="Decimal(38,2)")]
		public System.Nullable<decimal> GastosOriginacion
		{
			get
			{
				return this._GastosOriginacion;
			}
			set
			{
				if ((this._GastosOriginacion != value))
				{
					this._GastosOriginacion = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_TasaComisiones", DbType="Decimal(38,2)")]
		public System.Nullable<decimal> TasaComisiones
		{
			get
			{
				return this._TasaComisiones;
			}
			set
			{
				if ((this._TasaComisiones != value))
				{
					this._TasaComisiones = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_TasaInteres", DbType="Decimal(38,2)")]
		public System.Nullable<decimal> TasaInteres
		{
			get
			{
				return this._TasaInteres;
			}
			set
			{
				if ((this._TasaInteres != value))
				{
					this._TasaInteres = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_tintSectorLabID", DbType="TinyInt")]
		public System.Nullable<byte> tintSectorLabID
		{
			get
			{
				return this._tintSectorLabID;
			}
			set
			{
				if ((this._tintSectorLabID != value))
				{
					this._tintSectorLabID = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_iComprobanteEmpleoId", DbType="Int")]
		public System.Nullable<int> iComprobanteEmpleoId
		{
			get
			{
				return this._iComprobanteEmpleoId;
			}
			set
			{
				if ((this._iComprobanteEmpleoId != value))
				{
					this._iComprobanteEmpleoId = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_iEstadoId", DbType="Int")]
		public System.Nullable<int> iEstadoId
		{
			get
			{
				return this._iEstadoId;
			}
			set
			{
				if ((this._iEstadoId != value))
				{
					this._iEstadoId = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_iMunicipioDelegacionId", DbType="Int")]
		public System.Nullable<int> iMunicipioDelegacionId
		{
			get
			{
				return this._iMunicipioDelegacionId;
			}
			set
			{
				if ((this._iMunicipioDelegacionId != value))
				{
					this._iMunicipioDelegacionId = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_sCodigoPostal", DbType="VarChar(5)")]
		public string sCodigoPostal
		{
			get
			{
				return this._sCodigoPostal;
			}
			set
			{
				if ((this._sCodigoPostal != value))
				{
					this._sCodigoPostal = value;
				}
			}
		}
		
		[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_decImporteIngreso", DbType="Decimal(15,2)")]
		public System.Nullable<decimal> decImporteIngreso
		{
			get
			{
				return this._decImporteIngreso;
			}
			set
			{
				if ((this._decImporteIngreso != value))
				{
					this._decImporteIngreso = value;
				}
			}
		}
	}
}
#pragma warning restore 1591
