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!");
}