protected void ProcessAllInfoForOnePub(int publicationId)
{
ProcessPub.ProcessAllInfoForOnePubId(publicationId, false);
int confirmId = ProcessPub.ConfirmOnePubByAuthorInitial(publicationId);
ProcessPub.UpdateNameConfirm(publicationId, confirmId);
}
protected void TreatInfoForOnePubId(int publicationId)
{
//string pmidStr = pmid.ToString();
string connectionStr = ConfigurationManager.ConnectionStrings["UcccPubMedDB"].ConnectionString;
SqlConnection myConnection = new SqlConnection(connectionStr);
string sqlStatement;
sqlStatement = "select count(*) as cnt from publication_processing where publication_id = " + publicationId.ToString();
SqlCommand commandFromProcessing = new SqlCommand(sqlStatement, myConnection);
myConnection.Open();
int cnt = (int)commandFromProcessing.ExecuteScalar();
myConnection.Close();
if (cnt == 0)
{
ProcessPub.ProcessAllInfoForOnePubId(publicationId, false);
int confirmId = ProcessPub.ConfirmOnePubByAuthorInitial(publicationId);
ProcessPub.UpdateNameConfirm(publicationId, confirmId);
}
else if (cnt == 1)
{
ProcessPub.UpdateAllProcessInfoForOnePubId(publicationId);
int confirmId = ProcessPub.ConfirmOnePubByAuthorInitial(publicationId);
ProcessPub.UpdateNameConfirm(publicationId, confirmId);
}
else
{
//error
}
}
protected void btnProcessPmid_Click(object sender, EventArgs e)
{
string msg = "";
string connectionStr = ConfigurationManager.ConnectionStrings["UcccPubMedDB"].ConnectionString;
SqlConnection conn = new SqlConnection(connectionStr);
string sqlStatement = "select publication_id from publication where pmid = " + txtPmid.Text;
SqlCommand command = new SqlCommand(sqlStatement, conn);
conn.Open();
int pubId = 0;
object pubIdObj = (object)command.ExecuteScalar();
if (pubIdObj != null)
{
pubId = Convert.ToInt32(pubIdObj);
}
else
{
conn.Close();
msg = "Not found publication in database.";
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + msg + "');", true);
return;
}
conn.Close();
ProcessPub.ProcessAllInfoForOnePubId(pubId, true);
msg = "processed.";
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + msg + "');", true);
}
protected void btnProcess_Click(object sender, EventArgs e)
{
//List<int> pubIdList = GetPubIdList(lastPubId).ToList();
List <int> pubIdList = GetNotProcessedPubIdList().ToList();
//ProcessPubList(pubIdList);
//ConfirmByName(pubIdList);
int totalConfirmedCnt = 0;
int totalConflictCnt = 0;
int totalUnknownCnt = 0;
int confirmId = 0;
foreach (int publicationId in pubIdList)
{
ProcessPub.ProcessAllInfoForOnePubId(publicationId, false);
confirmId = ProcessPub.ConfirmOnePubByAuthorInitial(publicationId);
ProcessPub.UpdateNameConfirm(publicationId, confirmId);
if (confirmId == 1)
{
totalConfirmedCnt++;
}
else if (confirmId == 2)
{
totalConflictCnt++;
}
else
{
totalUnknownCnt++;
}
}
int pubCnt = pubIdList.Count;
string msg = "Among " + pubCnt.ToString() + " pubs, " + totalConfirmedCnt +
" are name (initial) confirmed, " +
totalConflictCnt.ToString() +
" are name (initial) conflict, and " +
totalUnknownCnt.ToString() +
" are unknown.";
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + msg + "');", true);
}
