public DataTable ObtenerInstitucionesBycPerCodigo(BE_Req_UniOrgPerExt Request) { DataTable lista = 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 = "sp_get_Instituciones_BycPerCodigo"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { lista.Load(dr); } } } } catch (Exception) { throw; } return lista; }
public DataTable ObtenerUniOrgBycPerCodigo(BE_Req_UniOrgPerExt Request) { //BE_Res_UniOrgPerExt Item = new BE_Res_UniOrgPerExt(); // var lista = new List<BE_Res_UniOrgPerExt>(); DataTable lista = 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 = "SP_TraDoc_Procesos"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Parameters.AddWithValue("Opcion", 19); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) { lista.Clear(); //while (dr.Read()) //{ // Item = new BE_Res_UniOrgPerExt(); // Item.cIntDescripcion = dr.GetString(dr.GetOrdinal("cIntDescripcion")).Trim(); // Item.nUniOrgCodigo = dr.GetInt32(dr.GetOrdinal("nUniOrgCodigo")); // lista.Add(Item); //} lista.Load(dr); } } } } catch (Exception) { throw; } return lista; }
public DataTable ObtenerUniOrgBycPerCodigo(BE_Req_UniOrgPerExt Request) { DAUniOrgPerExt UniOrgPersona = new DAUniOrgPerExt(); return UniOrgPersona.ObtenerUniOrgBycPerCodigo(Request); }
public DataTable ObtenerAreaByPersonaInstitucion(BE_Req_UniOrgPerExt Request) { DAUniOrgPerExt UniOrgPersona = new DAUniOrgPerExt(); return UniOrgPersona.ObtenerAreaByPersonaInstitucion(Request); }