public bool[] cargaCheck(string sqlQry)
{
string[] val = new string[8];
bool[] retVal = new bool[8];
DataTable tabla = new DataTable();
tabla = ConexionCall.SqlDTable(sqlQry);
val[0] = tabla.Rows[0]["yema"].ToString();
val[1] = tabla.Rows[0]["boton"].ToString();
val[2] = tabla.Rows[0]["florA"].ToString();
val[3] = tabla.Rows[0]["cuajado"].ToString();
val[4] = tabla.Rows[0]["pinton"].ToString();
val[5] = tabla.Rows[0]["cosecha"].ToString();
val[6] = tabla.Rows[0]["poscosecha"].ToString();
val[7] = tabla.Rows[0]["receso"].ToString();
for (int i = 0; i < 9; i++)
{
if (val[i] == "True")
{
retVal[i] = true;
}
else
{
retVal[i] = false;
}
}
return(retVal);
}
public static DataTable GeneraTablaValidacion(string login, string password)
{
try
{
string strQuery = (@"SELECT * FROM tb_acounts WHERE cuenta ='" + login + "' and password = '******' and estado = 'True'");
DataTable datos = ConexionCall.SqlDTable(strQuery);
return(datos);
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable BuscarAntecedentes(string rut)
{
try
{
string query = (@"SELECT rut_usuario,nombres,a_paterno,a_materno,direccion,telefono,mail,foto From usuario WHERE rut_usuario='" + rut + "'");
DataTable datos = ConexionCall.SqlDTable(query);
return(datos);
}
catch (Exception ex)
{
throw ex;
}
}
public static int devuelveValorINT(string strQuery)// solo de vuelve un solo valor entero
{
int val = 0;
DataTable tabla = new DataTable();
tabla = ConexionCall.SqlDTable(strQuery);
try
{
return(val = Convert.ToInt32(tabla.Rows[0][0]));
}
catch (Exception)
{
return(val = 0);
}
}
public static string devuelveValor2(string strQuery)// solo de vuelve un solo valor
{
string val = string.Empty;
DataTable tabla = new DataTable();
tabla = ConexionCall.SqlDTable(strQuery);
try
{
return(val = tabla.Rows[0][0].ToString());
}
catch (Exception)
{
return("--");
}
}
public int plagoenf(string Qry) //REVISA SI ES ENFERMADAD O PLAGA
{
int EoP = 0;
string val = string.Empty;
DataTable tabla = new DataTable();
tabla = ConexionCall.SqlDTable(Qry);
try
{
val = tabla.Rows[0][0].ToString();
return(EoP = int.Parse(val));
}
catch (Exception)
{
return(EoP = 0);
}
}
public bool Verificador(string strQuery)//BUSCA SI DATOS SE ENCUENTRAN EN LA BD
{
DataTable tabla = new DataTable();
try
{
tabla = ConexionCall.SqlDTable(strQuery);
if (tabla.Rows.Count > 0)
{
tabla.Dispose();
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
return(false);
}
}
