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