public override List <ProductPackage> GetProductPackageList() { List <ProductPackage> list = new List <ProductPackage>(); using (SqlConnection connection = this.GetSqlConnection()) { string cmdText = "select * from SuCommerce_ProductPackage"; SqlCommand command = new SqlCommand(cmdText, connection) { CommandType = CommandType.Text }; connection.Open(); using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection)) { ProductPackage package = null; while (reader.Read()) { package = new ProductPackage(); CommerceDataProvider.PopulateProductPackageList(reader, package); list.Add(package); } reader.Close(); connection.Close(); } } return(list); }
public static void PopulateProductPackageList(IDataReader dr, ProductPackage _productPackage) { _productPackage.ProductPackageID = (int)dr["productpackageid"]; _productPackage.ProductID = (int)dr["productid"]; _productPackage.PackageTypeID = (int)dr["packagetypeid"]; _productPackage.Version = (decimal)dr["version"]; _productPackage.MajorVersion = dr.GetMajorVersion((decimal)dr["version"]); }
public static bool HasPriorVersionLicense(this SueetieUser _user, ProductPackage _productPackage, ProductLicenseType _productLicenseType) { return(Licenses.GetProductLicenseList().Any <ProductLicense>(l => ((((l.PackageTypeID == _productPackage.PackageTypeID) && (l.LicenseTypeID >= (int)_productLicenseType)) && (l.MajorVersion < _productPackage.MajorVersion)) && (l.UserID == _user.UserID)))); }
public static bool HasFreeLicenseOfCurrentVersion(this SueetieUser _user, ProductPackage _productPackage) { return(Licenses.GetProductLicenseList().Any <ProductLicense>(l => ((((l.PackageTypeID == _productPackage.PackageTypeID) && (l.LicenseTypeID == 1)) && (l.MajorVersion == _productPackage.MajorVersion)) && (l.UserID == _user.UserID)))); }
public static ProductLicense GetProductLicense(ProductPackage _productPackage, int _userID, ProductLicenseType _productLicenseType) { return(GetProductLicenseList().Find(p => (((p.PackageTypeID == _productPackage.PackageTypeID) && (p.LicenseTypeID == (int)_productLicenseType)) && (p.Version == _productPackage.Version)) && (p.UserID == _userID))); }