//------------------------------
// 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));
}
