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())
{
}
}
}
