private static string GetRootCertificatePath()
{
//return Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.CommonApplicationData), "test-authority", RootCertificateName);
string RootCerticateName = PlavyConfig.GetString("CaFile");
return(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, RootCerticateName));
}
public static object GetMaxId()
{
string sConn = PlavyConfig.GetConnectionString("db");
SqlDb db = new SQLiteDb(sConn);
var dbFactory = db.DbBuilder.DbFactory;
var dbOperator = dbFactory.GetDbParamOperator();
var dblist = db.ExecuteScalar("select max(id) from tb_certs");
if (dblist == null)
{
return(-1);
}
return(dblist);
}
public static void Insert(string sSerialNo, string sCertData, string sCommonName, string sPwd)
{
string sConn = PlavyConfig.GetConnectionString("db");
SqlDb db = new SQLiteDb(sConn);
var dbFactory = db.DbBuilder.DbFactory;
var dbOperator = dbFactory.GetDbParamOperator();
db.BeginTransaction();
var obj = db.Insert <Certificate>(new Certificate()
{
SerialNo = sSerialNo,
CommonName = sCommonName,
CertData = sCertData,
CertPwd = sPwd,
Udt = DateTime.Now
});
db.CommitTransaction();
}
