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