public Utente Register(Utente U) { DataTable dt = new DataTable(); DBEntity db = new DBEntity(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = String.Format(@"INSERT INTO utenti (nome,cognome,telefono,email,password) VALUES('{0}','{1}','{2}','{3}')", U.Nome, U.Cognome, U.Telefono, U.Email, U.Password); int id = db.eseguiInsertIDreturn(cmd); U.ID = id; return(U); }
public Prenotazione AddPrenotazione(Prenotazione P) { DataTable dt = new DataTable(); DBEntity db = new DBEntity(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; Int64 now = Convert.ToInt64(DateTime.UtcNow.Subtract(new DateTime(1970, 1, 1)).TotalSeconds); cmd.CommandText = String.Format(@"INSERT INTO prenotazioni (qta, data, fk_utente, fk_replica) VALUES({0},{1},{2},{3});SELECT SCOPE_IDENTITY()", P.Biglietti, now, P.IDUtente, P.IDReplica); int id = db.eseguiInsertIDreturn(cmd); P.ID = id; P.Replica = new daoReplica().GetByID(P.IDReplica); return(P); }