/// <summary>
/// Add a new entry to the DeliveryRestriction table
/// </summary>
public static DeliveryRestriction Add(int deliveryAreaId, int customerId, TimeSpan?startTime, TimeSpan?endTime,
bool onlyLimitAmount, double amountLimit)
{
DeliveryRestriction result = null;
DateTime purchaseTime = DateTime.Now;
SqlConnection cn = GetConnection();
string cmd = "AddDeliveryRestriction";
using (SqlCommand sqlCmd = new SqlCommand(cmd, cn))
{
sqlCmd.CommandType = CommandType.StoredProcedure;
BuildSqlParameter(sqlCmd, "@DeliveryRestrictionDeliveryAreaId", SqlDbType.Int, deliveryAreaId);
BuildSqlParameter(sqlCmd, "@DeliveryRestrictionCustomerId", SqlDbType.Int, customerId);
BuildSqlParameter(sqlCmd, "@DeliveryRestrictionStartTime", SqlDbType.Time, startTime);
BuildSqlParameter(sqlCmd, "@DeliveryRestrictionEndTime", SqlDbType.Time, endTime);
BuildSqlParameter(sqlCmd, "@DeliveryRestrictionOnlyLimitAmount", SqlDbType.Bit, onlyLimitAmount);
BuildSqlParameter(sqlCmd, "@DeliveryRestrictionAmountLimit", SqlDbType.Float, amountLimit);
BuildSqlParameter(sqlCmd, "@DeliveryRestrictionId", SqlDbType.Int, ParameterDirection.ReturnValue);
if (sqlCmd.ExecuteNonQuery() > 0)
{
result = new DeliveryRestriction(Convert.ToInt32(sqlCmd.Parameters["@DeliveryRestrictionId"].Value),
deliveryAreaId, customerId, startTime, endTime, onlyLimitAmount, amountLimit);
}
}
FinishedWithConnection(cn);
return(result);
}
/// <summary>
/// Update an entry in the DeliveryRestriction table
/// </summary>
public static bool Update(DeliveryRestriction deliveryRestriction)
{
bool result = false;
SqlConnection cn = GetConnection();
result = Update(cn, deliveryRestriction);
FinishedWithConnection(cn);
return(result);
}
/// <summary>
/// Get an entry from the DeliveryRestriction table
/// </summary>
public static DeliveryRestriction Get(int id)
{
DeliveryRestriction result = null;
SqlConnection cn = GetConnection();
result = Get(cn, id);
FinishedWithConnection(cn);
return(result);
}
private static DeliveryRestriction Get(SqlConnection cn, int id)
{
DeliveryRestriction result = null;
using (SqlCommand cmd = new SqlCommand("SELECT * FROM DeliveryRestriction WHERE DeliveryRestrictionId=" + id, cn))
{
using (SqlDataReader rdr = cmd.ExecuteReader())
{
if (rdr.Read())
{
result = BuildDeliveryRestriction(rdr);
}
}
}
return(result);
}
/// <summary>
/// Delete an entry from the DeliveryRestriction table
/// </summary>
public static bool Delete(int id)
{
Int32 rowsAffected = 0;
SqlConnection cn = GetConnection();
DeliveryRestriction deliveryRestriction = Get(cn, id);
if (deliveryRestriction != null)
{
using (SqlCommand sqlCmd = cn.CreateCommand())
{
sqlCmd.CommandText = "DELETE FROM DeliveryRestriction WHERE DeliveryRestrictionId=" + id;
rowsAffected = sqlCmd.ExecuteNonQuery();
}
}
FinishedWithConnection(cn);
return(rowsAffected != 0);
}
private static bool Update(SqlConnection cn, DeliveryRestriction deliveryRestriction)
{
Int32 rowsAffected = 0;
using (SqlCommand sqlCmd = cn.CreateCommand())
{
sqlCmd.CommandText = "UPDATE DeliveryRestriction SET DeliveryRestrictionDeliveryAreaId=@DeliveryRestrictionDeliveryAreaId,DeliveryRestrictionCustomerId=@DeliveryRestrictionCustomerId,DeliveryRestrictionStartTime=@DeliveryRestrictionStartTime,DeliveryRestrictionEndTime=@DeliveryRestrictionEndTime,DeliveryRestrictionOnlyLimitAmount=@DeliveryRestrictionOnlyLimitAmount,DeliveryRestrictionAmountLimit=@DeliveryRestrictionAmountLimit WHERE DeliveryRestrictionId=@DeliveryRestrictionId";
BuildSqlParameter(sqlCmd, "@DeliveryRestrictionId", SqlDbType.Int, deliveryRestriction.Id);
BuildSqlParameter(sqlCmd, "@DeliveryRestrictionDeliveryAreaId", SqlDbType.Int, deliveryRestriction.DeliveryAreaId);
BuildSqlParameter(sqlCmd, "@DeliveryRestrictionCustomerId", SqlDbType.Int, deliveryRestriction.CustomerId);
BuildSqlParameter(sqlCmd, "@DeliveryRestrictionStartTime", SqlDbType.Time, deliveryRestriction.StartTime);
BuildSqlParameter(sqlCmd, "@DeliveryRestrictionEndTime", SqlDbType.Time, deliveryRestriction.EndTime);
BuildSqlParameter(sqlCmd, "@DeliveryRestrictionOnlyLimitAmount", SqlDbType.Bit, deliveryRestriction.OnlyLimitAmount);
BuildSqlParameter(sqlCmd, "@DeliveryRestrictionAmountLimit", SqlDbType.Float, deliveryRestriction.AmountLimit);
rowsAffected = sqlCmd.ExecuteNonQuery();
}
return(rowsAffected != 0);
}
