public static DataTable GetByOffer(Guid offerGuid)
{
DataTable dataTable = new DataTable();
dataTable.Columns.Add("Guid", typeof(Guid));
dataTable.Columns.Add("OfferGuid", typeof(Guid));
dataTable.Columns.Add("BeginUTC", typeof(DateTime));
dataTable.Columns.Add("EndUTC", typeof(DateTime));
dataTable.Columns.Add("RequiresOfferCode", typeof(bool));
dataTable.Columns.Add("OfferCode", typeof(string));
dataTable.Columns.Add("MaxAllowedPerCustomer", typeof(int));
using (IDataReader reader = DBOfferAvailability.GetByOffer(offerGuid))
{
while (reader.Read())
{
DataRow row = dataTable.NewRow();
row["Guid"] = reader["Guid"];
row["OfferGuid"] = reader["OfferGuid"];
row["BeginUTC"] = reader["BeginUTC"];
row["EndUTC"] = reader["EndUTC"];
row["RequiresOfferCode"] = reader["RequiresOfferCode"];
row["OfferCode"] = reader["OfferCode"];
row["MaxAllowedPerCustomer"] = reader["MaxAllowedPerCustomer"];
dataTable.Rows.Add(row);
}
}
return dataTable;
}
public static bool Delete(
Guid guid,
Guid deletedBy,
DateTime deletedTime,
string deletedFromIP)
{
OfferAvailability availability = new OfferAvailability(guid);
DBOfferAvailability.AddHistory(
Guid.NewGuid(),
availability.Guid,
availability.OfferGuid,
availability.BeginUtc,
availability.EndUtc,
availability.RequiresOfferCode,
availability.OfferCode,
availability.MaxAllowedPerCustomer,
availability.Created,
availability.CreatedBy,
availability.CreatedFromIP,
availability.IsDeleted,
Guid.Empty,
Convert.ToDateTime("1/1/1753 12:00:00 AM"),
string.Empty,
availability.LastModified,
availability.LastModifedBy,
availability.LastModifedFromIP,
DateTime.UtcNow);
return DBOfferAvailability.Delete(
guid,
deletedBy,
deletedTime,
deletedFromIP);
}
private void GetOfferAvailability(Guid guid)
{
using (IDataReader reader = DBOfferAvailability.Get(guid))
{
if (reader.Read())
{
this.guid = new Guid(reader["Guid"].ToString());
this.offerGuid = new Guid(reader["OfferGuid"].ToString());
this.beginUTC = Convert.ToDateTime(reader["BeginUTC"]);
this.endUTC = Convert.ToDateTime(reader["EndUTC"]);
this.requiresOfferCode = Convert.ToBoolean(reader["RequiresOfferCode"]);
this.offerCode = reader["OfferCode"].ToString();
this.maxAllowedPerCustomer = Convert.ToInt32(reader["MaxAllowedPerCustomer"]);
this.created = Convert.ToDateTime(reader["Created"]);
this.createdBy = new Guid(reader["CreatedBy"].ToString());
this.createdFromIP = reader["CreatedFromIP"].ToString();
this.isDeleted = Convert.ToBoolean(reader["IsDeleted"]);
if (reader["DeletedBy"] != DBNull.Value)
{
this.deletedBy = new Guid(reader["DeletedBy"].ToString());
}
if (reader["DeletedTime"] != DBNull.Value)
{
this.deletedTime = Convert.ToDateTime(reader["DeletedTime"]);
}
this.deletedFromIP = reader["DeletedFromIP"].ToString();
this.lastModified = Convert.ToDateTime(reader["LastModified"]);
this.lastModifedBy = new Guid(reader["LastModifedBy"].ToString());
this.lastModifedFromIP = reader["LastModifedFromIP"].ToString();
}
}
}
private bool Update()
{
OfferAvailability availability = new OfferAvailability(this.guid);
//log.Info($"offer availability update: BeginUtc ({availability.BeginUtc}), EndUtc ({availability.EndUtc}), Created ({availability.Created}), DeletedTime ({availability.DeletedTime}), LastModified ({availability.LastModified})");
DBOfferAvailability.AddHistory(
Guid.NewGuid(),
availability.Guid,
availability.OfferGuid,
availability.BeginUtc,
availability.EndUtc,
availability.RequiresOfferCode,
availability.OfferCode,
availability.MaxAllowedPerCustomer,
availability.Created,
availability.CreatedBy,
availability.CreatedFromIP,
availability.IsDeleted,
Guid.Empty,
Convert.ToDateTime("1/1/1753 12:00:00 AM"),
string.Empty,
availability.LastModified,
availability.LastModifedBy,
availability.LastModifedFromIP,
DateTime.UtcNow);
return DBOfferAvailability.Update(
this.guid,
this.beginUTC,
this.endUTC,
this.requiresOfferCode,
this.offerCode,
this.maxAllowedPerCustomer,
this.lastModified,
this.lastModifedBy,
this.lastModifedFromIP);
}
private bool Create()
{
Guid newID = Guid.NewGuid();
this.guid = newID;
int rowsAffected = DBOfferAvailability.Add(
this.guid,
this.offerGuid,
this.beginUTC,
this.endUTC,
this.requiresOfferCode,
this.offerCode,
this.maxAllowedPerCustomer,
this.created,
this.createdBy,
this.createdFromIP,
this.lastModified,
this.lastModifedBy,
this.lastModifedFromIP);
return(rowsAffected > 0);
}
private bool Update()
{
OfferAvailability availability = new OfferAvailability(this.guid);
DBOfferAvailability.AddHistory(
Guid.NewGuid(),
availability.Guid,
availability.OfferGuid,
availability.BeginUtc,
availability.EndUtc,
availability.RequiresOfferCode,
availability.OfferCode,
availability.MaxAllowedPerCustomer,
availability.Created,
availability.CreatedBy,
availability.CreatedFromIP,
availability.IsDeleted,
availability.DeletedBy,
availability.DeletedTime,
availability.DeletedFromIP,
availability.LastModified,
availability.LastModifedBy,
availability.LastModifedFromIP,
DateTime.UtcNow);
return(DBOfferAvailability.Update(
this.guid,
this.beginUTC,
this.endUTC,
this.requiresOfferCode,
this.offerCode,
this.maxAllowedPerCustomer,
this.lastModified,
this.lastModifedBy,
this.lastModifedFromIP));
}
