private void GetOfferProduct(Guid guid)
{
using (IDataReader reader = DBOfferProduct.Get(guid))
{
if (reader.Read())
{
this.guid = new Guid(reader["Guid"].ToString());
this.offerGuid = new Guid(reader["OfferGuid"].ToString());
this.productGuid = new Guid(reader["ProductGuid"].ToString());
this.fullfillType = Convert.ToByte(reader["FullfillType"]);
this.fullFillTermsGuid = new Guid(reader["FullFillTermsGuid"].ToString());
this.quantity = Convert.ToInt32(reader["Quantity"]);
this.sortOrder = Convert.ToInt32(reader["SortOrder"]);
this.isDeleted = Convert.ToBoolean(reader["IsDeleted"]);
this.created = Convert.ToDateTime(reader["Created"]);
this.createdBy = new Guid(reader["CreatedBy"].ToString());
this.createdFromIP = reader["CreatedFromIP"].ToString();
if (reader["DeletedBy"] != DBNull.Value)
{
this.deletedBy = new Guid(reader["DeletedBy"].ToString());
}
this.deletedFromIP = reader["DeletedFromIP"].ToString();
if (reader["DeletedTime"] != DBNull.Value)
{
this.deletedTime = Convert.ToDateTime(reader["DeletedTime"]);
}
this.lastModified = Convert.ToDateTime(reader["LastModified"]);
this.lastModifiedBy = new Guid(reader["LastModifiedBy"].ToString());
this.lastModifiedFromIP = reader["LastModifiedFromIP"].ToString();
}
}
}
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("ProductGuid", typeof(Guid));
dataTable.Columns.Add("FullfillType", typeof(byte));
dataTable.Columns.Add("FullFillTermsGuid", typeof(Guid));
dataTable.Columns.Add("Quantity", typeof(int));
dataTable.Columns.Add("SortOrder", typeof(int));
dataTable.Columns.Add("Name", typeof(string));
using (IDataReader reader = DBOfferProduct.GetByOffer(offerGuid))
{
while (reader.Read())
{
DataRow row = dataTable.NewRow();
row["Guid"] = reader["Guid"];
row["OfferGuid"] = reader["OfferGuid"];
row["ProductGuid"] = reader["ProductGuid"];
row["FullfillType"] = reader["FullfillType"];
row["FullFillTermsGuid"] = reader["FullFillTermsGuid"];
row["Quantity"] = reader["Quantity"];
row["SortOrder"] = reader["SortOrder"];
row["Name"] = reader["Name"];
dataTable.Rows.Add(row);
}
}
return(dataTable);
}
public static bool DeleteByProduct(
Guid productGuid,
Guid deletedBy,
string deletedFromIP)
{
return(DBOfferProduct.DeleteByProduct(
productGuid,
deletedBy,
deletedFromIP,
DateTime.UtcNow));
}
private bool Update()
{
return(DBOfferProduct.Update(
this.guid,
this.fullfillType,
this.fullFillTermsGuid,
this.quantity,
this.sortOrder,
this.lastModified,
this.lastModifiedBy,
this.lastModifiedFromIP));
}
private bool Create()
{
Guid newID = Guid.NewGuid();
this.guid = newID;
int rowsAffected = DBOfferProduct.Add(
this.guid,
this.offerGuid,
this.productGuid,
this.fullfillType,
this.fullFillTermsGuid,
this.quantity,
this.sortOrder,
this.created,
this.createdBy,
this.createdFromIP,
this.lastModified,
this.lastModifiedBy,
this.lastModifiedFromIP);
return(rowsAffected > 0);
}
public static Collection <OfferProduct> GetbyOffer(Guid offerGuid)
{
Collection <OfferProduct> offerProducts = new Collection <OfferProduct>();
using (IDataReader reader = DBOfferProduct.GetByOffer(offerGuid))
{
while (reader.Read())
{
OfferProduct offerProduct = new OfferProduct();
offerProduct.fullFillTermsGuid = new Guid(reader["FullfillTermsGuid"].ToString());
offerProduct.fullfillType = Convert.ToByte(reader["FullfillType"]);
offerProduct.guid = new Guid(reader["Guid"].ToString());
offerProduct.offerGuid = offerGuid;
offerProduct.productGuid = new Guid(reader["ProductGuid"].ToString());
offerProduct.quantity = Convert.ToInt32(reader["Quantity"]);
offerProduct.sortOrder = Convert.ToInt32(reader["SortOrder"]);
offerProducts.Add(offerProduct);
}
}
return(offerProducts);
}
public static int GetCountByOffer(Guid offerGuid)
{
return(DBOfferProduct.GetCountByOffer(offerGuid));
}
public static IDataReader GetReaderByOffer(Guid offerGuid)
{
return(DBOfferProduct.GetByOffer(offerGuid));
}
