public void deleteDeviceCertificate(int id)
{
DBHelper._DeviceCertificate dbhelp = new DBHelper._DeviceCertificate();
DeviceCertificate existingDeviceCertificate = dbhelp.GetByid(id);
dbhelp.Delete(existingDeviceCertificate);
}
public Format_Detail GetById(int id)
{
using (CDStudioEntities dbEntity = new CDStudioEntities())
{
DeviceCertificate existingData = (from c in dbEntity.DeviceCertificate.AsNoTracking()
where c.Id == id
select c).SingleOrDefault <DeviceCertificate>();
if (existingData == null)
{
throw new CDSException(10401);
}
return(new Format_Detail()
{
Id = existingData.Id,
Name = existingData.Name,
CertFile = existingData.CertFile,
KeyFile = existingData.KeyFile,
Thumbprint = existingData.Thumbprint,
Password = existingData.Password,
ExpiredAt = existingData.ExpiredAt
});
}
}
public void updatedeviceCertificate(int id, Edit deviceCertificate)
{
DBHelper._DeviceCertificate dbhelp = new DBHelper._DeviceCertificate();
DeviceCertificate existingDeviceCertificate = dbhelp.GetByid(id);
existingDeviceCertificate.Name = deviceCertificate.Name;
existingDeviceCertificate.CompanyID = deviceCertificate.CompanyId;
existingDeviceCertificate.FileName = deviceCertificate.FileName;
existingDeviceCertificate.Thumbprint = deviceCertificate.Thumbprint;
existingDeviceCertificate.PFXPassword = deviceCertificate.PFXPassword;
existingDeviceCertificate.ExpiredAt = deviceCertificate.ExpiredAt;
dbhelp.Update(existingDeviceCertificate);
}
public void DeleteById(int id)
{
using (CDStudioEntities dbEntity = new CDStudioEntities())
{
DeviceCertificate existingData = dbEntity.DeviceCertificate.Find(id);
if (existingData == null)
{
throw new CDSException(10401);
}
dbEntity.Entry(existingData).State = EntityState.Deleted;
dbEntity.SaveChanges();
}
}
public Detail getDeviceCertificateById(int id)
{
DBHelper._DeviceCertificate dbhelp = new DBHelper._DeviceCertificate();
DeviceCertificate deviceCertificate = dbhelp.GetByid(id);
return(new Detail()
{
Id = deviceCertificate.Id,
Name = deviceCertificate.Name,
FileName = deviceCertificate.FileName,
Thumbprint = deviceCertificate.Thumbprint,
PFXPassword = deviceCertificate.PFXPassword,
ExpiredAt = (DateTime)deviceCertificate.ExpiredAt
});
}
public void addDeviceCertificate(Edit deviceCertificate)
{
DBHelper._DeviceCertificate dbhelp = new DBHelper._DeviceCertificate();
var newDeviceCertificate = new DeviceCertificate()
{
Name = deviceCertificate.Name,
CompanyID = deviceCertificate.CompanyId,
FileName = deviceCertificate.FileName,
Thumbprint = deviceCertificate.Thumbprint,
PFXPassword = deviceCertificate.PFXPassword,
ExpiredAt = (DateTime)deviceCertificate.ExpiredAt,
DeletedFlag = false
};
dbhelp.Add(newDeviceCertificate);
}
public void Update(int id, Format_Update parseData)
{
using (CDStudioEntities dbEntity = new CDStudioEntities())
{
DeviceCertificate existingData = dbEntity.DeviceCertificate.Find(id);
if (existingData == null)
{
throw new CDSException(10401);
}
if (parseData.Name != null)
{
existingData.Name = parseData.Name;
}
if (parseData.KeyFile != null)
{
existingData.KeyFile = parseData.KeyFile;
}
if (parseData.CertFile != null)
{
existingData.CertFile = parseData.CertFile;
}
if (parseData.Thumbprint != null)
{
existingData.Thumbprint = parseData.Thumbprint;
}
if (parseData.Password != null)
{
existingData.Password = parseData.Password;
}
if (parseData.ExpiredAt != null)
{
existingData.ExpiredAt = parseData.ExpiredAt;
}
dbEntity.Entry(existingData).State = EntityState.Modified;
dbEntity.SaveChanges();
}
}
public int Create(int companyId, Format_Create parseData)
{
using (CDStudioEntities dbEntity = new CDStudioEntities())
{
DeviceCertificate newData = new DeviceCertificate()
{
CompanyID = companyId,
Name = parseData.Name,
CertFile = parseData.CertFile ?? "",
KeyFile = parseData.KeyFile ?? "",
Thumbprint = parseData.Thumbprint,
Password = parseData.Password,
ExpiredAt = parseData.ExpiredAt
};
dbEntity.DeviceCertificate.Add(newData);
dbEntity.SaveChanges();
return(newData.Id);
}
}
