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