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