public int brisiNarudzbu(NarudzbaHrane a)
{
try
{
String query = "DELETE FROM NarudzbaHrane WHERE id = @id;";
DBConnectionString s = new DBConnectionString();
using (SqlConnection con = new SqlConnection(s.GetString()))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = query;
SqlParameter id = new SqlParameter();
id.Value = Convert.ToString(a.idNarudzbe);
id.ParameterName = "id";
cmd.Parameters.Add(id);
con.Open();
int r = 0;
if (con.State == System.Data.ConnectionState.Open)
{
r = cmd.ExecuteNonQuery();
}
con.Close();
return(r);
}
}
catch (Exception e)
{
Debug.WriteLine("Exception: " + e.Message);
return(0);
}
}
public int unesiNarudzbu(NarudzbaHrane a)
{
try
{
String query = "insert into NarudzbaHrane " +
"values (@id,@idKupca)";
DBConnectionString s = new DBConnectionString();
using (SqlConnection con = new SqlConnection(s.GetString()))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = query;
SqlParameter id = new SqlParameter();
id.Value = Convert.ToString(a.idNarudzbe);
id.ParameterName = "id";
SqlParameter idKupca = new SqlParameter();
idKupca.Value = a.idKupca;
idKupca.ParameterName = "idKupca";
cmd.Parameters.Add(id);
cmd.Parameters.Add(idKupca);
int k = cmd.ExecuteNonQuery();
cmd.Dispose();
return(k);
}
}
catch (Exception e)
{
Debug.WriteLine("Exception: " + e.Message);
return(0);
}
}
public void ucitajNarudzbe()
{
try
{
Narudzbe = new List <NarudzbaHrane>();
String query = "SELECT * FROM NarudzbaHrane;";
DBConnectionString s = new DBConnectionString();
using (SqlConnection con = new SqlConnection(s.GetString()))
{
con.Open();
if (con.State == System.Data.ConnectionState.Open)
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = query;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
NarudzbaHrane a = new NarudzbaHrane(Convert.ToInt32(reader.GetString(0)), reader.GetInt32(1));
Narudzbe.Add(a);
}
}
con.Close();
}
}
catch (Exception e)
{
Debug.WriteLine("Exception: " + e.Message);
}
}
public void prikazdetaljaNarudzbe(NarudzbaHrane narudzba)
{
}
