private int LoadInfoDB(TokenGitHubInfo inf, bool truncate) { DbOper dbo = new DbOper(); if (truncate) { dbo.TruncateTables(); } dbo.LoadRoot(inf.CoinID, inf.Symbol, inf.GitHubRoot, inf.GitHubLeadPrj, inf.ReposNumber, inf.Followers, inf.CreatedAt, inf.UpdatedAt, inf.ErrNum.ToString(), inf.ErrMes, inf.Url); if (dbo.ErrNum > 0) { intErr = dbo.ErrNum; strErr = dbo.ErrMes; dbo.CloseConn(); return(intErr); } if (inf.ErrNum > 0) { return(intErr); } dbo.LoadHithubInfoTable("RepoInfo", "repoinfo.txt"); if (dbo.ErrNum > 0) { intErr = dbo.ErrNum; strErr = dbo.ErrMes; dbo.CloseConn(); return(intErr); } dbo.LoadHithubInfoTable("ContribInfo", "contribinfo.txt"); if (dbo.ErrNum > 0) { intErr = dbo.ErrNum; strErr = dbo.ErrMes; dbo.CloseConn(); return(intErr); } //dbo.CloseConn(); return(intErr); }
private void cmdRepeatCommit_Click(object sender, EventArgs e) { DbOper dbOper = new DbOper(); DataTable dtRepCommits = dbOper.GetCommitsForRepeat(); string coinid = ""; string symbol = ""; string githubroot = ""; string reponame = ""; string repoid = ""; //** Secret Key string strGAuth = ConfigurationManager.AppSettings["gthauth"]; ContribInfoCompiler ctrbListComp = null; ContribCommit cbcCommits = null; StringBuilder sbContribCommits = null; string DL = "|"; foreach (DataRow dr in dtRepCommits.Rows) { coinid = dr[0].ToString(); symbol = dr[1].ToString(); githubroot = dr[2].ToString(); repoid = dr[3].ToString(); reponame = dr[4].ToString(); Repo rpRepo = new Repo(); rpRepo.RepoID = repoid; rpRepo.RepoName = reponame; sbContribCommits = new StringBuilder(); ctrbListComp = new ContribInfoCompiler(strGAuth); ctrbListComp.GetContribCommits(rpRepo, githubroot); for (int k = 0; k < rpRepo.Contribs.Count; k++) { cbcCommits = rpRepo.Contribs[k]; if (cbcCommits == null) { continue; } sbContribCommits.Append(coinid + DL + symbol + DL + rpRepo.RepoID + DL + rpRepo.RepoName + DL + cbcCommits.LoginName + DL + cbcCommits.Additions + DL + cbcCommits.Deletions + DL + cbcCommits.Commits + DL + cbcCommits.CommTime + DL + cbcCommits.ErrNum.ToString() + DL + cbcCommits.ErrMes + DL + cbcCommits.Cnt.ToString() + DL + cbcCommits.Url + "\n"); } if (sbContribCommits.Length > 0) { dbOper.DeleteRepeatCommits(coinid, symbol, reponame); if (dbOper.ErrNum > 0) { intErr = dbOper.ErrNum; strErr = dbOper.ErrMes; } File.WriteAllText("contribinfo.txt", sbContribCommits.ToString()); dbOper.LoadHithubInfoTable("ContribInfo", "contribinfo.txt"); if (dbOper.ErrNum > 0) { intErr = dbOper.ErrNum; strErr = dbOper.ErrMes; } } Thread.Sleep(3000); } MessageBox.Show("Success!"); }