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