public void SaveActivationLog(Model.ActivationLog activationLog)
{
using (ScutexServiceEntities db1 = new ScutexServiceEntities())
{
ActivationLog al = new ActivationLog();
al.LicenseKey = activationLog.LicenseKey;
al.ActivationResult = (int)activationLog.ActivationResult;
al.IPAddress = activationLog.IpAddress;
al.Timestamp = activationLog.Timestamp;
db1.AddToActivationLogs(al);
db1.SaveChanges();
}
}
public void DeleteLicenseKeyByLicenseSetId(int licenseSetId)
{
using (ScutexServiceEntities db1 = new ScutexServiceEntities())
{
var keys = from lk in db1.LicenseKeys
where lk.LicenseSetId == licenseSetId
select lk;
foreach (var i in keys)
db1.LicenseKeys.DeleteObject(i);
db1.SaveChanges();
}
}
public void DeleteLicenseActivationsByKeyId(int licenseKeyId)
{
using (ScutexServiceEntities db1 = new ScutexServiceEntities())
{
var licenseActivations = from la in db1.LicenseActivations
where la.LicenseKeyId == licenseKeyId
select la;
foreach (var i in licenseActivations)
db1.LicenseActivations.DeleteObject(i);
db1.SaveChanges();
}
}
public void DeleteActivationLogByKey(string key)
{
using (ScutexServiceEntities db1 = new ScutexServiceEntities())
{
var logs = from l in db1.ActivationLogs
where l.LicenseKey == key
select l;
foreach (var l in logs)
{
db1.ActivationLogs.DeleteObject(l);
}
db1.SaveChanges();
}
}
public MasterServiceData SetMasterServiceData(MasterServiceData data)
{
if (GetMasterServiceData() != null)
return null;
using (ScutexServiceEntities db1 = new ScutexServiceEntities())
{
Master m = new Master();
m.ServiceId = data.ServiceId;
m.ClientInboundKey = data.ClientInboundKey;
m.ClientOutboundKey = data.ClientOutboundKey;
m.ManagementInboundKey = data.ManagementInboundKey;
m.ManagementOutboundKey = data.ManagementOutboundKey;
m.Token = data.Token;
db1.AddToMasters(m);
db1.SaveChanges();
}
return GetMasterServiceData();
}
private void InsertServiceLicenseSet(ServiceLicenseSet licenseSet)
{
using (ScutexServiceEntities db1 = new ScutexServiceEntities())
{
LicenseSet ls = new LicenseSet();
ls.LicenseSetId = licenseSet.LicenseSetId;
ls.LicenseId = licenseSet.LicenseId;
ls.Name = licenseSet.LicenseSetName;
ls.LicenseType = (int)licenseSet.LicenseType;
ls.MaxUsers = licenseSet.MaxUsers;
db1.AddToLicenseSets(ls);
db1.SaveChanges();
}
}
private void UpdateServiceLicenseSet(ServiceLicenseSet licenseSet)
{
using (ScutexServiceEntities db1 = new ScutexServiceEntities())
{
var licSet = (from ls in db1.LicenseSets
where ls.LicenseSetId == licenseSet.LicenseSetId
select ls).First();
licSet.LicenseSetId = licenseSet.LicenseSetId;
licSet.LicenseId = licenseSet.LicenseId;
licSet.Name = licenseSet.LicenseSetName;
licSet.LicenseType = (int)licenseSet.LicenseType;
licSet.MaxUsers = licenseSet.MaxUsers;
db1.SaveChanges();
}
}
private void DeleteServiceProductById(int productId)
{
using (ScutexServiceEntities db1 = new ScutexServiceEntities())
{
var prods = from prod in db1.Licenses
where prod.LicenseId == productId
select prod;
foreach (var p in prods)
db1.Licenses.DeleteObject(p);
db1.SaveChanges();
}
}
private void InsertServiceProduct(ServiceProduct product)
{
using (ScutexServiceEntities db1 = new ScutexServiceEntities())
{
License l = new License();
l.LicenseId = product.LicenseId;
l.Name = product.LicenseName;
db1.AddToLicenses(l);
db1.SaveChanges();
}
}
private void UpdateServiceProduct(ServiceProduct product)
{
using (ScutexServiceEntities db1 = new ScutexServiceEntities())
{
var lic = (from l in db1.Licenses
where l.LicenseId == product.LicenseId
select l).First();
lic.Name = product.LicenseName;
db1.SaveChanges();
}
}
public ServiceProductsRepository(ScutexServiceEntities db)
{
this.db = db;
}
public Model.LicenseActivation InsertLicenseActivation(Model.LicenseActivation licenseActivation)
{
int newId;
using (ScutexServiceEntities db1 = new ScutexServiceEntities())
{
LicenseActivation la = new LicenseActivation();
la.LicenseKeyId = licenseActivation.LicenseKeyId;
la.ActivationToken = licenseActivation.ActivationToken;
la.ActivatedOn = licenseActivation.ActivatedOn;
la.OriginalToken = licenseActivation.OriginalToken;
la.ActivationStatus = (int)licenseActivation.ActivationStatus;
la.ActivationStatusUpdatedOn = licenseActivation.ActivationStatusUpdatedOn;
la.HardwareHash = licenseActivation.HardwareHash;
db1.AddToLicenseActivations(la);
db1.SaveChanges();
newId = la.LicenseActivationId;
}
return GetLicenseActivationById(newId);
}
public CommonRepository(ScutexServiceEntities db)
{
this.db = db;
}
public ActivationLogRepoistory(ScutexServiceEntities db)
{
this.db = db;
}
private void UpdateServiceLicenseKey(ServiceLicenseKey serviceLicenseKey)
{
using (ScutexServiceEntities db1 = new ScutexServiceEntities())
{
var licKey = (from lk in db1.LicenseKeys
where lk.Key == serviceLicenseKey.Key
select lk).First();
licKey.Key = serviceLicenseKey.Key;
licKey.CreatedOn = serviceLicenseKey.CreatedOn;
licKey.ActivationCount = serviceLicenseKey.ActivationCount;
licKey.Deactivated = serviceLicenseKey.Deactivated;
licKey.DeactivatedOn = serviceLicenseKey.DeactivatedOn;
licKey.DeactivatedReason = serviceLicenseKey.DeactivatedReason;
licKey.LicenseSetId = serviceLicenseKey.LicenseSetId;
db1.SaveChanges();
}
}
private void InsertServiceLicenseKey(ServiceLicenseKey serviceLicenseKey)
{
using (ScutexServiceEntities db1 = new ScutexServiceEntities())
{
LicenseKey licKey = new LicenseKey();
licKey.Key = serviceLicenseKey.Key;
licKey.ActivationCount = serviceLicenseKey.ActivationCount;
licKey.Deactivated = serviceLicenseKey.Deactivated;
licKey.DeactivatedOn = serviceLicenseKey.DeactivatedOn;
licKey.DeactivatedReason = serviceLicenseKey.DeactivatedReason;
licKey.LicenseSetId = serviceLicenseKey.LicenseSetId;
licKey.CreatedOn = serviceLicenseKey.CreatedOn;
db1.AddToLicenseKeys(licKey);
db1.SaveChanges();
}
}
public ClientRepository(ScutexServiceEntities db)
{
this.db = db;
}
