private static Coupon[] TransFerToCouponArray(string sqlCommand1, Coupon[] cpArray, DataTable table) { int n = table.Rows.Count; cpArray = new Coupon[n]; for (int i = 0; i < n; i++) { cpArray[i] = new Coupon(); DataRow row = table.Rows[i]; cpArray[i].DieuKienSuDung = row["DIEUKIENSD"].ToString(); cpArray[i].DonViTien = row["DVTIENTE"].ToString(); cpArray[i].GiaHangKhiChuaGiam = row["GIAGOC"].ToString(); cpArray[i].GiaHangSauKhiGiam = row["GIASGIAM"].ToString(); cpArray[i].LinkHinhAnh = new string[1]; // cpArray[i].LinkHinhAnh[0] = "http://www.beatifulhouse.somee.com/Content/images/products/" + row["HINHANH"].ToString(); cpArray[i].LinkHinhAnh[0] = ConfigurationManager.AppSettings.GetValues("image")[0].ToString() + row["HINHANH"].ToString(); cpArray[i].MaCoupon = row["MACP"].ToString(); cpArray[i].MaMatHang = row["MASP"].ToString(); cpArray[i].MaNhaCungCap = "BIZ"; cpArray[i].NgayBatDau = DateTime.Parse(row["THOIGIANBD"].ToString()); cpArray[i].NgayCouponBatDauDuocSuDung = cpArray[i].NgayBatDau; cpArray[i].NgayKetThuc = DateTime.Parse(row["THOIGIANKT"].ToString()); cpArray[i].NgayCouponHetHan = cpArray[i].NgayKetThuc; List<SqlParameter> sql = new List<SqlParameter>(); sql.Add(new SqlParameter("@macp", cpArray[i].MaCoupon)); SqlParameter output = new SqlParameter("@count", SqlDbType.Int); output.Direction = ParameterDirection.Output; sql.Add(output); provider.executeNonQueryProcedure(sqlCommand1, sql); cpArray[i].SoLuongDaDat = (int)output.Value; float slcl=float.Parse(row["SLCONLAI"].ToString()); int slspmin = int.Parse(row["SLSPMIN"].ToString()); cpArray[i].SoLuongMuaLonNhat =(int)slcl/slspmin; cpArray[i].SoLuongThoaCoupon = int.Parse(row["SLCPMINGIAMGIA"].ToString()); cpArray[i].TenMatHang = row["TENSP"].ToString(); cpArray[i].TenNhaCungCap = "BeatifulhouseGroup"; cpArray[i].ThongTinMoTa = row["MOTA"].ToString(); cpArray[i].ThongTinMoTa += " .Mỗi coupon gồm " + slspmin.ToString()+" "+row["DVTINH"].ToString()+" sản phẩm"; } return cpArray; }
public static Coupon FindCouponInfo(string couponId) { provider.connect(); string sqlCommand = "sp_FindCouponInfo"; string sqlCommand1 = "sp_CountOrderCoupon"; List<SqlParameter> list = new List<SqlParameter>(); list.Add(new SqlParameter("@couponId", couponId)); Coupon[] cpArray = new Coupon[0]; try { DataTable table = provider.executeQueryDataTableProcedure(sqlCommand, list); if (table != null && table.Rows.Count > 0) { cpArray = TransFerToCouponArray(sqlCommand1, cpArray, table); return cpArray[0]; } } catch (Exception e) { } finally { provider.disconnect(); } return new Coupon(); }
public static Coupon[] FindCoupons(string productName,DateTime startDate,DateTime endDate,int minPrice,int maxPrice) { provider.connect(); string sqlCommand = "sp_FindCoupons"; string sqlCommand1 = "sp_CountOrderCoupon"; productName = "%" + productName + "%"; List<SqlParameter> list = new List<SqlParameter>(); list.Add(new SqlParameter("@productName", productName)); list.Add(new SqlParameter("@startDate", startDate)); list.Add(new SqlParameter("@endDate", endDate)); list.Add(new SqlParameter("@minPrice", minPrice)); list.Add(new SqlParameter("@maxPrice", maxPrice)); Coupon[] cpArray = new Coupon[0]; try { DataTable table = provider.executeQueryDataTableProcedure(sqlCommand, list); if (table != null && table.Rows.Count > 0) { cpArray = TransFerToCouponArray(sqlCommand1, cpArray, table); } } catch (Exception e) { } finally { provider.disconnect(); } return cpArray; }
public static Coupon[] FindAllCoupons() { provider.connect(); string sqlCommand = "sp_FindAllCoupons"; string sqlCommand1="sp_CountOrderCoupon"; List<SqlParameter> list = new List<SqlParameter>(); Coupon[] cpArray=new Coupon[0]; try { DataTable table = provider.executeQueryDataTableProcedure(sqlCommand, list); if (table != null && table.Rows.Count > 0) { cpArray = TransFerToCouponArray(sqlCommand1, cpArray, table); } } catch (Exception e) { throw e; } finally { provider.disconnect(); } return cpArray; }