protected void btnReprocess_Click(object sender, EventArgs e) { List <int> pubIdList = GetAllPubIdList().ToList(); int totalConfirmedCnt = 0; int totalConflictCnt = 0; int totalUnknownCnt = 0; int confirmId = 0; foreach (int publicationId in pubIdList) { ProcessPub.UpdateAllProcessInfoForOnePubId(publicationId); confirmId = ProcessPub.ConfirmOnePubByAuthorInitial(publicationId); ProcessPub.UpdateNameConfirm(publicationId, confirmId); } 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); }
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 btnProcessSelectedPubs_Click(object sender, EventArgs e) { List <int> pubIdList = new List <int>(); for (int i = 0; i < gvPublication.Rows.Count; i++) { CheckBox chxSelectTemp = (CheckBox)gvPublication.Rows[i].FindControl("chxSelect"); if (chxSelectTemp == null) { return; } int id; Label lblIdTemp = null; lblIdTemp = (Label)gvPublication.Rows[i].FindControl("lblId"); if (lblIdTemp != null) { if (chxSelectTemp.Checked) { id = Convert.ToInt32(lblIdTemp.Text); pubIdList.Add(id); } } else { return; } } foreach (int id in pubIdList) { //bool isRE = ProcessPub.IsReviewEditorial(id); ProcessPub.UpdateAllProcessInfoForOnePubId(id); int confirmId = ProcessPub.ConfirmOnePubByAuthorInitial(id); ProcessPub.UpdateNameConfirm(id, confirmId); } string msg = pubIdList.Count.ToString() + " publication are processed."; ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + msg + "');", true); }
protected void gvAuthor_RowUpdating(object sender, GridViewUpdateEventArgs e) { ErrorMessage.Text = ""; string idStr; Label lblIdTemp = null; lblIdTemp = (Label)gvAuthor.Rows[e.RowIndex].FindControl("lblId"); if (lblIdTemp != null) { idStr = lblIdTemp.Text; } else { return; } TextBox txtClientIdTemp = null; txtClientIdTemp = (TextBox)gvAuthor.Rows[e.RowIndex].FindControl("txtClientId"); if (txtClientIdTemp == null) { return; } string sqlStatement; if (txtClientIdTemp.Text != "") { sqlStatement = "Update author" + " SET client_id=@client_id" + ", confirm_id = 1" + " WHERE (author_id = @author_id)"; } else { sqlStatement = "Update author" + " SET client_id=@client_id" + ", confirm_id = 2" + " WHERE (author_id = @author_id)"; } //string connectionStr = ConfigurationManager.AppSettings.Get("ConnectionString"); string connectionStr = ConfigurationManager.ConnectionStrings["UcccPubMedDB"].ConnectionString; SqlConnection myConnection = new SqlConnection(connectionStr); SqlCommand command = new SqlCommand(sqlStatement, myConnection); SqlParameter client_idParameter = new SqlParameter(); client_idParameter.ParameterName = "@client_id"; client_idParameter.SqlDbType = SqlDbType.Int; if (txtClientIdTemp.Text == "") { client_idParameter.Value = DBNull.Value;; } else { client_idParameter.Value = Convert.ToInt32(txtClientIdTemp.Text); } command.Parameters.Add(client_idParameter); SqlParameter author_idParameter = new SqlParameter(); author_idParameter.ParameterName = "@author_id"; author_idParameter.SqlDbType = SqlDbType.Int; author_idParameter.Value = System.Convert.ToInt32(lblIdTemp.Text); command.Parameters.Add(author_idParameter); myConnection.Open(); command.ExecuteNonQuery(); myConnection.Close(); List <int> pubIdList = GetPubIdListByAuthorId(idStr).ToList(); foreach (int pubId in pubIdList) { ProcessPub.UpdateAllProcessInfoForOnePubId(pubId); } gvAuthor.EditIndex = -1; FillAuthorGrid(txtLastName.Text, txtFirstName.Text); }