public static int InsertNewToode(Toode toode)
{
using (OleDbConnection conn = ConnectDB.GetConnection())
{
OleDbCommand cmd = new OleDbCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "INSERT INTO toode(Nimi, kategoriaFK, Kogus, KoodTood, Hind) VALUES (?,?,?,?,?)";
cmd.Parameters.AddWithValue("@nimi", toode.Nimi);
cmd.Parameters.AddWithValue("@kategoriafk", toode.KategoriaFK);
cmd.Parameters.AddWithValue("@kogus", toode.Kogus);
cmd.Parameters.AddWithValue("@koodtood", toode.KoodToode);
cmd.Parameters.AddWithValue("@hind", toode.Hind);
cmd.Connection = conn;
conn.Open();
try
{
cmd.ExecuteNonQuery();
}
catch
{
return(0);
}
}
return(1);
}
public static int UpdateToode(Toode toode, Klient id)
{
using (OleDbConnection conn = ConnectDB.GetConnection())
{
OleDbCommand cmd = new OleDbCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "UPDATE toode SET Nimi = @nimi, kategooriaFK = @kategooriaFK, Kogus = @kogus, KoodToode = @koodtoode, Hind = @hind WHERE ID = @id";
cmd.Parameters.AddWithValue("@nimi", toode.Nimi);
cmd.Parameters.AddWithValue("@kategooriaFK", toode.KategoriaFK);
cmd.Parameters.AddWithValue("@kogus", toode.Kogus);
cmd.Parameters.AddWithValue("@koodtoode", toode.KoodToode);
cmd.Parameters.AddWithValue("@hind", toode.Hind);
cmd.Parameters.AddWithValue("@id", id);
cmd.Connection = conn;
conn.Open();
try
{
cmd.ExecuteNonQuery();
}
catch
{
return(0);
}
}
return(1);
}
