//----------------------------------------------------------------------------- // Get Persona con PerJuridica for nPerJurTipInversion and nPerJurSecEconomico //----------------------------------------------------------------------------- public DataTable Get_List_Persona_PerJuridica_for_nPerJurTipInversion_and_nPerJurSecEconomico(int nPerJurTipInversion, int nPerJurSecEconomico) { DataTable dt = new DataTable(); BE_ReqPerJuridica Request = new BE_ReqPerJuridica(); DA_Persona Obj = new DA_Persona(); Request.nPerJurTipInversion = nPerJurTipInversion; Request.nPerJurSecEconomico = nPerJurSecEconomico; return(Obj.Get_List_Persona_PerJuridica_for_nPerJurTipInversion_and_nPerJurSecEconomico(Request)); }
//----------------------------------------------------------------------------- // Get Persona con PerJuridica for nPerJurTipInversion and nPerJurSecEconomico //----------------------------------------------------------------------------- public DataTable Get_List_Persona_PerJuridica_for_nPerJurTipInversion_and_nPerJurSecEconomico(BE_ReqPerJuridica Request) { DataTable dt = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Get_List_Persona_PerJuridica_for_nPerJurTipInversion_and_nPerJurSecEconomico]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("nPerJurTipInversion", Request.nPerJurTipInversion); cm.Parameters.AddWithValue("nPerJurSecEconomico", Request.nPerJurSecEconomico); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return(dt); }