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