public static ItemPricing Add(int itemId, Days day, TimeSpan?startTime, TimeSpan?endTime, double price, int?additionalDiscountMin, int?additionalDiscountMax, double?additionalDiscountPrice, bool isEnabled) { ItemPricing result = null; SqlConnection cn = GetConnection(); using (SqlCommand sqlCmd = new SqlCommand("AddItemPricing", cn)) { sqlCmd.CommandType = CommandType.StoredProcedure; BuildSqlParameter(sqlCmd, "@ItemPricingItemId", SqlDbType.Int, itemId); BuildSqlParameter(sqlCmd, "@ItemPricingDayOfWeek", SqlDbType.TinyInt, day); BuildSqlParameter(sqlCmd, "@ItemPricingStartDate", SqlDbType.Time, startTime); BuildSqlParameter(sqlCmd, "@ItemPricingEndDate", SqlDbType.Time, endTime); BuildSqlParameter(sqlCmd, "@ItemPricingPrice", SqlDbType.Float, price); BuildSqlParameter(sqlCmd, "@ItemPricingAdditionalDiscountMin", SqlDbType.Float, additionalDiscountMin); BuildSqlParameter(sqlCmd, "@ItemPricingAdditionalDiscountMax", SqlDbType.Float, additionalDiscountMax); BuildSqlParameter(sqlCmd, "@ItemPricingAdditionalDiscountPrice", SqlDbType.Float, additionalDiscountPrice); BuildSqlParameter(sqlCmd, "@ItemPricingIsEnabled", SqlDbType.Bit, isEnabled); BuildSqlParameter(sqlCmd, "@ItemPricingId", SqlDbType.Int, ParameterDirection.ReturnValue); if (sqlCmd.ExecuteNonQuery() > 0) { result = new ItemPricing(Convert.ToInt32(sqlCmd.Parameters["@ItemPricingId"].Value), itemId, day, startTime, endTime, price, additionalDiscountMin, additionalDiscountMax, additionalDiscountPrice, isEnabled); } } FinishedWithConnection(cn); return(result); }
/// <summary> /// Update an entry in the ItemPricing table /// </summary> public static bool Update(ItemPricing itemPricing) { bool result = false; SqlConnection cn = GetConnection(); result = Update(cn, itemPricing); FinishedWithConnection(cn); return(result); }
/// <summary> /// Get an entry from the ItemPricing table /// </summary> public static ItemPricing Get(int id) { ItemPricing result = null; SqlConnection cn = GetConnection(); result = Get(cn, id); FinishedWithConnection(cn); return(result); }
private static ItemPricing Get(SqlConnection cn, int id) { ItemPricing result = null; using (SqlCommand cmd = new SqlCommand("SELECT * FROM ItemPricing WHERE ItemPricingId=" + id, cn)) { using (SqlDataReader rdr = cmd.ExecuteReader()) { if (rdr.Read()) { result = BuildItemPricing(rdr); } } } return(result); }
/// <summary> /// Delete an entry from the ItemPricing table /// </summary> public static bool Delete(int id) { Int32 rowsAffected = 0; SqlConnection cn = GetConnection(); ItemPricing itemPricing = Get(cn, id); if (itemPricing != null) { using (SqlCommand sqlCmd = cn.CreateCommand()) { sqlCmd.CommandText = "DELETE FROM ItemPricing WHERE ItemPricingId=" + id; rowsAffected = sqlCmd.ExecuteNonQuery(); } } FinishedWithConnection(cn); return(rowsAffected != 0); }
private static bool Update(SqlConnection cn, ItemPricing itemPricing) { Int32 rowsAffected = 0; using (SqlCommand sqlCmd = cn.CreateCommand()) { sqlCmd.CommandText = "UPDATE ItemPricing SET ItemPricingItemId=@ItemPricingItemId,ItemPricingDayOfWeek=@ItemPricingDayOfWeek,ItemPricingStartDate=@ItemPricingStartDate,ItemPricingEndDate=@ItemPricingEndDate,ItemPricingPrice=@ItemPricingPrice,ItemPricingAdditionalDiscountMin=@ItemPricingAdditionalDiscountMin,ItemPricingAdditionalDiscountMax=@ItemPricingAdditionalDiscountMax,ItemPricingAdditionalDiscountPrice=@ItemPricingAdditionalDiscountPrice,ItemPricingIsEnabled=@ItemPricingIsEnabled WHERE ItemPricingId=@ItemPricingId"; BuildSqlParameter(sqlCmd, "@ItemPricingId", SqlDbType.Int, itemPricing.Id); BuildSqlParameter(sqlCmd, "@ItemPricingItemId", SqlDbType.Int, itemPricing.ItemId); BuildSqlParameter(sqlCmd, "@ItemPricingDayOfWeek", SqlDbType.TinyInt, itemPricing.DayOfWeek); BuildSqlParameter(sqlCmd, "@ItemPricingStartDate", SqlDbType.Time, itemPricing.StartTime); BuildSqlParameter(sqlCmd, "@ItemPricingEndDate", SqlDbType.Time, itemPricing.EndTime); BuildSqlParameter(sqlCmd, "@ItemPricingPrice", SqlDbType.Float, itemPricing.Price); BuildSqlParameter(sqlCmd, "@ItemPricingAdditionalDiscountMin", SqlDbType.Float, itemPricing.AdditionalDiscountMin); BuildSqlParameter(sqlCmd, "@ItemPricingAdditionalDiscountMax", SqlDbType.Float, itemPricing.AdditionalDiscountMax); BuildSqlParameter(sqlCmd, "@ItemPricingAdditionalDiscountPrice", SqlDbType.Float, itemPricing.AdditionalDiscountPrice); BuildSqlParameter(sqlCmd, "@ItemPricingIsEnabled", SqlDbType.Bit, itemPricing.IsEnabled); rowsAffected = sqlCmd.ExecuteNonQuery(); } return(rowsAffected != 0); }
public bool Update() { return(ItemPricing.Update(this)); }