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