// update more info For The Certificate public int UpdateCertificateInfo(string Cert, int reqid) { StreamWriter objFile = null; try { objFile = File.CreateText("c:\\" + reqid + ".cer"); objFile.Write(Cert); objFile.Close(); X509Certificate2 cert = new X509Certificate2("c:\\" + reqid + ".cer"); File.Delete("c:\\" + reqid + ".cer"); using (caProjectEntities context = new caProjectEntities()) { cert cetificate = context.certs.FirstOrDefault(r => r.RequestId == reqid); cetificate.ExpiredDate = Convert.ToDateTime(cert.NotAfter.ToString("yyyy/MM/dd hh:mm:ss tt")); cetificate.Issuedby = cert.Issuer.ToString(); cetificate.serialnumber = cert.GetSerialNumberString(); context.SaveChanges(); } return(0); } catch (Exception ex) { if (objFile != null) { objFile.Close(); } Console.Write(ex.Message); return(-1); } }
//delete cert record for expired certificate public void DeleteCertificateRecordFromDb(int reqid) { using (caProjectEntities context = new caProjectEntities()) { cert cetificate = context.certs.FirstOrDefault(r => r.RequestId == reqid); context.certs.Remove(cetificate); context.SaveChanges(); } }
//update certFlag for unlock public void UnlockCetificate(string hostname) { using (caProjectEntities context = new caProjectEntities()) { cert cetificate = context.certs.FirstOrDefault(r => r.HostName == hostname); cetificate.CertFlag = null; context.SaveChanges(); } }
//update Certification Status and cert Flag public void UpdateUnlockFlagAndStatus(int status, int reqid) { using (caProjectEntities context = new caProjectEntities()) { cert cetificate = context.certs.FirstOrDefault(r => r.RequestId == reqid); cetificate.status = status; if (status == 3) //issued { cetificate.CertFlag = "true"; } context.SaveChanges(); } }
// Inserts First info For The Certificate public void InsertToCertificateTable(string hostname, int status, int reqid) { using (caProjectEntities context = new caProjectEntities()) { cert cetificate = new cert() { CreationDate = DateTime.Now.ToString("yyyyMMdd", System.Globalization.CultureInfo.GetCultureInfo("en-US")), RequestId = reqid, HostName = hostname, status = status }; context.certs.Add(cetificate); context.SaveChanges(); } }
// Inserts Error Message public void InsertToErrorMessageTable(string hostname, int requestid, string errorMessage, string functionName) { using (caProjectEntities context = new caProjectEntities()) { Error_Log erroLog = new Error_Log() { ErrorMessage = errorMessage, Request = requestid, CreateDate = DateTime.Now.ToString(), HostName = hostname, functionName = functionName }; context.Error_Logs.Add(erroLog); context.SaveChanges(); } }
// Inserts First info For The Certificate public void InsertToSigntureTable(string ClientId, string Hash, string Username) { using (caProjectEntities context = new caProjectEntities()) { DateTime dt = DateTime.Now; signature signature = new signature() { hash = Hash, uuid = ClientId, username = Username, timestamp = BitConverter.GetBytes(dt.Ticks), ldtdisk = "N" }; context.signatures.Add(signature); context.SaveChanges(); } }