//------------------------------ // Listar Asignaciones por promotor //------------------------------ public DataTable Android_Get_Asignaciones_By_Promotor(BE_Req_Medico Object) { DataTable dt = new DataTable(); try { clsConection Obj = new clsConection(); //string Cadena = Obj.GetConexionString("Naylamp"); string Cadena = "Server=10.0.0.10\\SRVDATOSMED; DataBase = BDDatos; Uid = android; Pwd =C2879442C28147B;Integrated Security=False; Pooling = False"; using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[Android].[usp_Get_Asignaciones_By_Promotor]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerPromCodigo", Object.cPerPromCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return(dt); }
public Medico[] ListaMedicoByPromotor(String cPerPromCodigo) { //BE_Req_Medico Object) { try { List <Medico> lista = new List <Medico>(); if (VerificarPermisos(CredencialAutenticacion)) { BE_Req_Medico Object = new BE_Req_Medico(); Object.cPerPromCodigo = cPerPromCodigo; BL_Medico Servicio = new BL_Medico(); DataTable dt = new DataTable(); dt = Servicio.Android_Get_Medico_By_Promotor(Object); foreach (DataRow row in dt.Rows) { lista.Add(new Medico( Convert.ToString(row[0]), Convert.ToString(row[1]), Convert.ToString(row[2]), Convert.ToString(row[3]) )); } } else { //return null; lista.Add(new Medico("", "Credenciales no válidas.")); } return(lista.ToArray()); } catch (Exception ex) { throw new SoapException("Credenciales no válidas.", SoapException.ServerFaultCode, "Error:", ex); } }
//------------------------------ // Listar Asignaciones By Promotor //------------------------------ public DataTable Android_Get_Asignaciones_By_Promotor(BE_Req_Medico Object) { DA_Promotor Obj = new DA_Promotor(); return(Obj.Android_Get_Asignaciones_By_Promotor(Object)); }