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); }