public static int CreateActivation(ActivationParams p)
{
//get data context (license manager database)
using (var dc = new LicenseManagerClassesDataContext())
{
//create activation data object
Activation act = new Activation();
Mapper.Map(p, act);
//add new activation object to new changes
dc.Activations.InsertOnSubmit(act);
//submit changes to database
dc.SubmitChanges();
if (p.IsActivated)
{
act.License.LicenseFeatures[0].ExtendedExpirationDate = p.ExtendedExpirationDate;
act.License.LicenseFeatures[0].ExpirationWarningStartDate = p.ExpirationWarningsBeginDate;
dc.SubmitChanges();
}
return(act.ID);
}
}
public static LicenseManager4Web.Entities.Written.Activation ActivateLicense(int licenseId, string cpuID)
{
using (var dc = new LicenseManagerClassesDataContext())
{
//never activated or has matching cpuid
LicenseManager4Web.Entities.Activation a = (from act in dc.Activations
join l in dc.Licenses on act.LicenseID equals l.ID
join lf in dc.LicenseFeatures on act.LicenseID equals lf.LicenseID
where act.LicenseID == licenseId && act.Enabled == true &&
(act.CPUID == string.Empty && act.IsActivated == false || act.CPUID == cpuID && act.IsActivated == false)
select act).FirstOrDefault();
if (DateTime.Compare(a.License.LicenseFeatures[0].ExtendedExpirationDate.Value, DateTime.Now) <= 0)
{
throw new Exception("Activation has expired.");
}
a.CPUID = cpuID;
a.IsActivated = true;
a.License.LicenseFeatures[0].ExtendedExpirationDate = a.ExpirationDate;
dc.SubmitChanges();
return(MapActivation(a));
}
}
public static List <LicenseManager4Web.Entities.Written.Activation> GetAllActivations()
{
using (var dc = new LicenseManagerClassesDataContext())
{
return((from a in dc.Activations select MapActivation(a)).ToList());
}
}
public static List <License> GetLicensesByClientIdAndSiteId(int clientId, int siteId)
{
using (var dc = new LicenseManagerClassesDataContext())
{
return((from l in dc.Licenses where l.ClientID == clientId && l.SiteID == siteId select MapLicense(l)).ToList());
}
}
public static List <LicenseManager4Web.Entities.Written.Activation> GetActivationsByLicenseId(int id)
{
using (var dc = new LicenseManagerClassesDataContext())
{
return((from a in dc.Activations where a.LicenseID == id select MapActivation(a)).ToList());
}
}
public static List <Site> GetAllSites()
{
using (var dc = new LicenseManagerClassesDataContext())
{
return((from site in dc.Sites select MapSite(site)).ToList());
}
}
public static Site GetSiteById(int siteId)
{
using (var dc = new LicenseManagerClassesDataContext())
{
return(MapSite(dc.Sites.SingleOrDefault(x => x.ID == siteId)));
}
}
public static List <Client> GetAllClients()
{
using (var dc = new LicenseManagerClassesDataContext())
{
return((from client in dc.Clients select MapClient(client)).ToList());
}
}
public static List <Site> GetAllSitesByClientId(int clientId)
{
using (var dc = new LicenseManagerClassesDataContext())
{
return((from site in dc.Sites where site.ClientID == clientId select MapSite(site)).ToList());
}
}
public static LicenseManager4Web.Entities.Written.Activation GetActivationById(int id)
{
using (var dc = new LicenseManagerClassesDataContext())
{
return((from a in dc.Activations where a.ID == id select MapActivation(a)).FirstOrDefault());
}
}
public static License GetLicenseById(int id)
{
using (var dc = new LicenseManagerClassesDataContext())
{
return((from l in dc.Licenses where l.ID == id select MapLicense(l)).FirstOrDefault());
}
}
public static void SaveLicense(LicenseFeaturesParams p)
{
using (var dc = new LicenseManagerClassesDataContext())
{
//save client
ClientService.SaveClient(p.ClientID, p.ClientName);
//save site
SiteService.SaveSite(p.SiteID, p.ClientID, p.SiteName);
//save license
LicenseManager4Web.Entities.License l = dc.Licenses.SingleOrDefault(x => x.ID == p.LicenseID);
l.LicenseType = (int)p.LicenseType;
l.Product = p.Product;
l.LicenseID = p.LicenseKey;
l.GeneratedTime = p.GeneratedDate;
l.GeneratedBy = p.GeneratedBy;
//save license features
LicenseManager4Web.Entities.LicenseFeature f = dc.LicenseFeatures.SingleOrDefault(x => x.LicenseID == p.LicenseID);
Mapper.Map(p, f);
dc.SubmitChanges();
}
}
public static List <License> GetAllLicenses()
{
using (var dc = new LicenseManagerClassesDataContext())
{
return((from l in dc.Licenses select MapLicense(l)).ToList());
}
}
public static Client GetClientById(int clientId)
{
using (var dc = new LicenseManagerClassesDataContext())
{
return(MapClient(dc.Clients.SingleOrDefault(x => x.ID == clientId)));
}
}
public static bool ClientHasActiveLicenses(int clientId)
{
using (var dc = new LicenseManagerClassesDataContext())
{
if (dc.Licenses.Where(x => x.ClientID == clientId).Select(x => x.ID).Count() > 0)
{
return(true);
}
return(false);
}
}
public static void SaveClient(int clientId, string clientName, string salesForceId)
{
using (var dc = new LicenseManagerClassesDataContext())
{
Entities.Client c = dc.Clients.SingleOrDefault(x => x.ID == clientId);
c.ClientName = clientName;
c.SalesForceId = salesForceId;
dc.SubmitChanges();
}
}
public static int SaveActivationCode(int activationId, string activationCode)
{
using (var dc = new LicenseManagerClassesDataContext())
{
Activation adbo = dc.Activations.SingleOrDefault(x => x.ID == activationId);
adbo.ActivationCode = activationCode;
dc.SubmitChanges();
return(adbo.ID);
}
}
public static int CreateClient(string ClientName, string SalesForceId)
{
using (var dc = new LicenseManagerClassesDataContext())
{
Entities.Client c = new Entities.Client();
c.ClientName = ClientName;
c.SalesForceId = SalesForceId;
dc.Clients.InsertOnSubmit(c);
dc.SubmitChanges();
return(c.ID);
}
}
public static Site GetSite(int siteId)
{
using (var dc = new LicenseManagerClassesDataContext())
{
Site c = (from site in dc.Sites where site.ID == siteId select MapSite(site)).FirstOrDefault();
if (c == null)
{
c = new Site();
}
return(c);
}
}
public static Client GetClient(int clientId)
{
using (var dc = new LicenseManagerClassesDataContext())
{
Client c = (from client in dc.Clients where client.ID == clientId select MapClient(client)).FirstOrDefault();
if (c == null)
{
c = new Client();
}
return(c);
}
}
public static int SaveActivation(ActivationParams p)
{
using (var dc = new LicenseManagerClassesDataContext())
{
Activation a = dc.Activations.SingleOrDefault(x => x.ID == p.ID);
Mapper.Map(p, a);
a.License.LicenseFeatures[0].ExtendedExpirationDate = p.ExtendedExpirationDate;
a.License.LicenseFeatures[0].ExpirationWarningStartDate = p.ExpirationWarningsBeginDate;
dc.SubmitChanges();
return(a.ID);
}
}
public static int CreateSite(int clientId, string siteName, string salesForceId)
{
using (var dc = new LicenseManagerClassesDataContext())
{
Entities.Site s = new Entities.Site();
s.SiteName = siteName;
s.ClientID = clientId;
s.SalesForceId = salesForceId;
dc.Sites.InsertOnSubmit(s);
dc.SubmitChanges();
return(s.ID);
}
}
public static int CreateLicense(LicenseFeaturesParams p)
{
using (var dc = new LicenseManagerClassesDataContext())
{
//create site if it doesn't exist
if (p.ClientID == -1)
{
p.ClientID = ClientService.CreateClient(p.ClientName);
}
//create site if it doesn't exist
if (p.SiteID == -1)
{
p.SiteID = SiteService.CreateSite(p.ClientID, p.SiteName);
}
//create new or save license
LicenseManager4Web.Entities.License l = new LicenseManager4Web.Entities.License();
l.LicenseType = (int)p.LicenseType;
l.Product = p.Product;
l.LicenseID = p.LicenseKey;
l.ClientID = p.ClientID;
l.SiteID = p.SiteID;
l.GeneratedTime = p.GeneratedDate;
l.GeneratedBy = p.GeneratedBy;
//insert new license
dc.Licenses.InsertOnSubmit(l);
dc.SubmitChanges();
//create new features list and map params to it
LicenseManager4Web.Entities.LicenseFeature f = new LicenseManager4Web.Entities.LicenseFeature();
Mapper.Map(p, f);
//insert new license features
f.LicenseID = l.ID;
dc.LicenseFeatures.InsertOnSubmit(f);
dc.SubmitChanges();
return(l.ID);
}
}
public static LicenseFeaturesParams GetLicenseFeatureParams(int licenseId)
{
using (var dc = new LicenseManagerClassesDataContext())
{
LicenseManager4Web.Entities.LicenseFeature f = dc.LicenseFeatures.SingleOrDefault(x => x.LicenseID == licenseId);
LicenseFeaturesParams p = new LicenseFeaturesParams();
Mapper.Map(f, p);
p.ClientID = f.License.ClientID;
p.SiteID = f.License.SiteID;
p.ClientName = f.License.Client.ClientName;
p.SiteName = f.License.Site.SiteName;
p.GeneratedBy = f.License.GeneratedBy;
p.GeneratedDate = f.License.GeneratedTime;
p.Product = f.License.Product;
p.LicenseType = (LicenseType)Enum.ToObject(typeof(LicenseType), f.License.LicenseType);
return(p);
}
}
