public static List <CouponInfo> GetAllCoupon()
{
List <CouponInfo> couponList = new List <CouponInfo>();
List <CouponItems> couponItemList = new List <CouponItems>();
using (SqlDataReader reader = AdminDAL.GetCoupon(0))
{
while (reader.Read())
{
CouponItems item = new CouponItems();
item.CouponId = Convert.ToInt32(reader["CouponId"]);
item.SkuId = Convert.ToInt32(reader["SkuId"]);
item.RelatedSkuId = Convert.ToInt32(reader["RelatedSkuId"]);
item.DiscountAmount = Convert.ToDecimal(reader["DiscountAmount"]);
item.DiscountType = (CouponTypeEnum)Convert.ToInt32(reader["DiscountType"]);
couponItemList.Add(item);
}
reader.NextResult();
while (reader.Read())
{
CouponInfo itemInfo = new CouponInfo();
itemInfo.CouponId = Convert.ToInt32(reader["CouponId"]);
itemInfo.Title = reader["Title"].ToString();
itemInfo.Discount = Convert.ToDecimal(reader["Discount"]);
itemInfo.Active = Convert.ToBoolean(reader["active"]);
itemInfo.DiscountType = (CouponTypeEnum)Convert.ToInt32(reader["DiscountType"]);
itemInfo.TotalAmount = Convert.ToDecimal(reader["TotalAmount"]);
if (Convert.ToInt32(reader["DiscountType"]) == (int)CouponTypeEnum.ItemType)
{
itemInfo.ItemsDiscount = couponItemList.FindAll(x => x.CouponId == Convert.ToInt32(reader["CouponId"]));
}
if (reader["includeShipping"] != DBNull.Value)
{
itemInfo.IncludeShipping = Convert.ToBoolean(reader["includeShipping"]);
}
else
{
itemInfo.IncludeShipping = true;
}
couponList.Add(itemInfo);
}
}
return(couponList);
}
public static CouponInfo GetCoupon(int couponId)
{
CouponInfo itemInfo = new CouponInfo();
List <CouponItems> couponItems = new List <CouponItems>();
using (SqlDataReader reader = AdminDAL.GetCoupon(couponId))
{
while (reader.Read())
{
CouponItems couponItemInfo = new CouponItems();
couponItemInfo.CouponId = Convert.ToInt32(reader["CouponId"]);
couponItemInfo.SkuId = Convert.ToInt32(reader["SkuId"]);
couponItemInfo.RelatedSkuId = Convert.ToInt32(reader["RelatedSkuId"]);
couponItemInfo.DiscountAmount = Convert.ToDecimal(reader["DiscountAmount"]);
couponItemInfo.DiscountType = (CouponTypeEnum)Convert.ToInt32(reader["DiscountType"]);
couponItems.Add(couponItemInfo);
}
reader.NextResult();
while (reader.Read())
{
itemInfo.CouponId = Convert.ToInt32(reader["CouponId"]);
itemInfo.Title = reader["Title"].ToString();
itemInfo.Discount = Convert.ToDecimal(reader["Discount"]);
itemInfo.Active = Convert.ToBoolean(reader["active"]);
itemInfo.TotalAmount = Convert.ToDecimal(reader["TotalAmount"]);
itemInfo.DiscountType = (CouponTypeEnum)Convert.ToInt32(reader["DiscountType"]);
if (reader["includeShipping"] != DBNull.Value)
{
itemInfo.IncludeShipping = Convert.ToBoolean(reader["includeShipping"]);
}
else
{
itemInfo.IncludeShipping = true;
}
itemInfo.ItemsDiscount = couponItems;
}
}
return(itemInfo);
}
