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