// 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);
}
}
public cert ReturnCertificateInformation(string hostname)
{
using (caProjectEntities context = new caProjectEntities())
{
cert cetificate = context.certs.FirstOrDefault(r => r.HostName == hostname);
return(cetificate);
}
}
//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();
}
}
//checking if there is allready Request for the hostname
public int CheckIfCertificateExists(string hostname)
{
using (caProjectEntities context = new caProjectEntities())
{
cert cetificate = context.certs.FirstOrDefault(r => r.HostName == hostname);
if (cetificate != null)
{
if (cetificate.Issuedby == null)
{
return(1);
}
return(2);
}
return(0);
}
}
//check if the hostnameand redid belong to each other
public bool CheckIfReqIDBelongToHost(int reqid, string hostname)
{
try
{
using (caProjectEntities context = new caProjectEntities())
{
cert cetificate = context.certs.FirstOrDefault(r => r.RequestId == reqid);
if (cetificate != null && cetificate.HostName == hostname)
{
return(false);
}
return(true);
}
}
catch (Exception ex)
{
Console.Write(ex.Message);
return(true);
}
}
//check if the cerrtficate allready consumed
public bool CheckIfCertificateConsumed(int reqid)
{
try
{
using (caProjectEntities context = new caProjectEntities())
{
cert cetificate = context.certs.FirstOrDefault(r => r.RequestId == reqid);
if (cetificate.CertFlag == null)
{
return(false);
}
return(true);
}
}
catch (Exception ex)
{
Console.Write(ex.Message);
return(false);
}
}
