public bool UpdateOfferById(SpecialOffer o) { try { SqlConnection cnn = ReturnSQLConnection(); string query = "UPDATE dbo.[SpecialOffer] SET Startdate=@Start, Enddate=@End, OfferPrice=@OfferPrice WHERE ProductID = @ProductId"; SqlCommand newCmd = CreateSQLCommandText(query, cnn); newCmd.Parameters.AddWithValue("@Start", o.StartTime); newCmd.Parameters.AddWithValue("@End", o.EndTime); newCmd.Parameters.AddWithValue("@OfferPrice", o.RetrieveOfferPrice()); newCmd.Parameters.AddWithValue("@ProductId", o.RetrieveProductId()); newCmd.ExecuteNonQuery(); cnn.Close(); return(true); } catch (Exception e) { Console.WriteLine(e.Message); } return(false); }
public bool CreateNewSpecialOffer(SpecialOffer s) { try { SqlConnection cnn = ReturnSQLConnection(); string query = "INSERT INTO dbo.[SpecialOffer] (Startdate, Enddate, OfferPrice, ProductID) VALUES (@Startdate, @Enddate, @OfferPrice, @ProductId)"; SqlCommand newCmd = CreateSQLCommandText(query, cnn); newCmd.Parameters.AddWithValue("@Startdate", s.StartTime); newCmd.Parameters.AddWithValue("@Enddate", s.EndTime); newCmd.Parameters.AddWithValue("@OfferPrice", s.RetrieveOfferPrice()); newCmd.Parameters.AddWithValue("@ProductId", s.RetrieveProductId()); newCmd.ExecuteNonQuery(); cnn.Close(); return(true); } catch (Exception e) { Console.WriteLine(e.Message); } return(false); }
public bool UpdateOfferById(SpecialOffer o) { string sqlUserInsert = "UPDATE dbo.[SpecialOffer] SET Startdate=@Start, Enddate=@End, OfferPrice=@OfferPrice WHERE ProductID = @ProductId"; using (SqlConnection connection = ReturnSQLConnection()) { int affectedRows = connection.Execute(sqlUserInsert, new { Start = o.StartTime, End = o.EndTime, OfferPrice = o.RetrieveOfferPrice(), ProductId = o.RetrieveProductId() }); return(true); } }