public void RazduziKnjigu(Posudba oUser) { string connectionString = ConfigurationManager.ConnectionStrings["DbConnection"].ConnectionString; using (DbConnection oConnection = new SqlConnection(connectionString)) using (DbCommand oCommand = oConnection.CreateCommand()) { oCommand.CommandText = "DELETE FROM Dakovic_Posudba WHERE Id ='" + oUser.IDPosudba + "'"; oConnection.Open(); using (DbDataReader oReader = oCommand.ExecuteReader()) { } } }
public void PousdiKnjigu(Posudba oUser) { string connectionString = ConfigurationManager.ConnectionStrings["DbConnection"].ConnectionString; using (DbConnection oConnection = new SqlConnection(connectionString)) using (DbCommand oCommand = oConnection.CreateCommand()) { oCommand.CommandText = "INSERT INTO Dakovic_Posudba (NazivKnjige, NazivKorisnika, DatumPosudjivanja, DatumVracanja) VALUES ('" + oUser.NazivKnjige + "','" + oUser.NazivKorisnika + "','" + oUser.DatumPosudjivanja + "','" + oUser.DatumVracanja + "');"; oConnection.Open(); using (DbDataReader oReader = oCommand.ExecuteReader()) { } } }