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