protected void Page_Load(object sender, EventArgs e)
{
cConexion c = new cConexion();
DataSet ds = new DataSet();
try
{
c.getConexion();
SqlDataAdapter cmd = new SqlDataAdapter("select idCliente as Cliente, Nombre as Nombre, APaterno as Apellido_Paterno, AMaterno as Apellido_Materno, Telefono as Telefono, Direccion as Dirección, Suscripción as Suscripción, Recargos as Recargos from Clientes WHERE Recargos>=1", c.con);
cmd.Fill(ds, "Clientes");
gvAdeudos.DataSource = ds.Tables["Clientes"];
gvAdeudos.DataBind();
c.CerrarConexion();
}
catch (Exception)
{
throw;
}
}
public static bool ConsultarInventario()
{
Models.citas_medicasEntities1 db = new Models.citas_medicasEntities1();
string conectionERP = db.Database.Connection.ConnectionString;
cConexion conexion = new cConexion(conectionERP);
string SQL = @"select Stock from Productos where Id = 3";
DataTable odataTable = conexion.EjecutarConsulta(SQL);
if (odataTable != null)
{
if (odataTable.Rows.Count == 0)
{
return(false);
}
}
else
{
return(true);
}
return(true);
}
public CFicha()
{
oConexion = new cConexion();
}
private void Guia_Load(object sender, EventArgs e)
{
cConexion c = new cConexion();
MostrarGuia();
}
public cUsuario()
{
oConexion = new cConexion();
}
public CLogin()
{
oConexion = new cConexion();
}
public CAlumno()
{
oConexion = new cConexion();
}
private void Alumno_Load(object sender, EventArgs e)
{
cConexion c = new cConexion();
MostrarAlumnos();
}
