public bool AggiornaUtente_pri(UtenteProgramma u)
{
var s = "";
var i = 0;
var n = 0;
try
{
var p = System.IO.Path.Combine(Server.MapPath("public"), "/files/files.mdb");
using (var c = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + p))
{
try
{
c.Open();
try
{
s = "SELECT count(*) Num FROM Utenti where Programma=:Programma and Nome=:Nome";
var pr = new System.Data.OleDb.OleDbParameter[] {
new System.Data.OleDb.OleDbParameter("Programma", u.Programma),
new System.Data.OleDb.OleDbParameter("Nome", u.Utente)
};
using (var m = new System.Data.OleDb.OleDbCommand(s, c))
{
m.Parameters.AddRange(pr);
using (var dr = m.ExecuteReader())
{
while (dr.HasRows && dr.Read())
{
try
{
n = Convert.ToInt32(dr["Num"]);
}
catch
{
//error
n = 0;
}
}
dr.Close();
}
}
}
catch
{
//error
}
try
{
if (n > 0)
{
s = "update Utenti set Versione=:Versione where Nome=:Nome and Programma=:Programma";
}
else
{
s = "insert into Utenti (Versione,Nome,Programma) values (:Versione,:Nome,:Programma)";
}
var pr = new System.Data.OleDb.OleDbParameter[] {
new System.Data.OleDb.OleDbParameter("Versione", u.Versione),
new System.Data.OleDb.OleDbParameter("Nome", u.Utente),
new System.Data.OleDb.OleDbParameter("Programma", u.Programma)
};
using (var m = new System.Data.OleDb.OleDbCommand(s, c))
{
m.Parameters.AddRange(pr);
i = m.ExecuteNonQuery();
}
}
catch
{
//error
}
c.Close();
}
catch
{
//error
}
}
}
catch
{
//error
}
return(i > 0);
}
public bool AggiornaUtente(UtenteProgramma u)
{
return(AggiornaUtente_pri(u));
}
