public static bool CheckConn(ref string numPazienti) { bool bRes; try { var sb = new StringBuilder(); sb.Append("SELECT "); sb.Append("count(ID)"); sb.Append(" FROM "); sb.Append("paziente"); var res = SqlLiteHelper.ExecuteScalar(sb.ToString()); numPazienti = res.ToString(); bRes = true; } catch (Exception exc) { bRes = false; numPazienti = exc.Message; } return(bRes); }
public static bool IsNuovo(string nome, string cognome) { var sb = new StringBuilder(); sb.Append("SELECT "); sb.Append("count(*)"); sb.Append(" FROM "); sb.Append("paziente"); sb.Append(" WHERE "); //sb.Append(" LCase(cognome) ='"+ cognome.ToLower() +"'"); sb.Append("cognome LIKE '%" + cognome + "%'"); if (nome.Length > 0) { sb.Append(" AND "); sb.Append(" lower(nome) ='" + nome.ToLower() + "'"); } //Object res = OleDbHelper.ExecuteScalar(ConfigurationSettings.AppSettings["strConn"], CommandType.Text, sb.ToString(), null); var res = SqlLiteHelper.ExecuteScalar(sb.ToString()); return((Convert.ToInt32(res) == 0) ? true : false); }