protected void DelectPubs(List <int> pubIdList) { string pubIdListStr = string.Join(",", pubIdList.Select(n => n.ToString()).ToArray()); string connectionStr = ConfigurationManager.ConnectionStrings["UcccPubMedDB"].ConnectionString; SqlConnection myConnection = new SqlConnection(connectionStr); string sqlStatement; foreach (int pubId in pubIdList) { ProcessPub.SaveRejectOnPubId(pubId); } sqlStatement = "delete from publication_author where publication_id in (" + pubIdListStr + ")" + "; delete from publication_processing where publication_id in (" + pubIdListStr + ")" + "; delete from publication_program where publication_id in (" + pubIdListStr + ")" + "; delete from publication_programmatic where publication_id in (" + pubIdListStr + ")" + "; delete from publication_pubtype where publication_id in (" + pubIdListStr + ")" + "; delete from publication_resource where publication_id in (" + pubIdListStr + ")" + "; delete from publication where publication_id in (" + pubIdListStr + ")" + "; delete from author where author_id not in (select author_id from publication_author)"; SqlCommand command = new SqlCommand(sqlStatement, myConnection); myConnection.Open(); command.ExecuteNonQuery(); myConnection.Close(); FillPublicationGrid(); int cnt = pubIdList.Count; ErrorMessage.Text = cnt.ToString() + " publications are deleted."; }
protected void ProcessAllInfoForOnePub(int publicationId) { ProcessPub.ProcessAllInfoForOnePubId(publicationId, false); int confirmId = ProcessPub.ConfirmOnePubByAuthorInitial(publicationId); ProcessPub.UpdateNameConfirm(publicationId, confirmId); }
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 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 ProcessSelectedAuthors_Click(object sender, EventArgs e) { List <int> authorIdList = new List <int>(); for (int i = 0; i < gvAuthor.Rows.Count; i++) { CheckBox chxSelectTemp = (CheckBox)gvAuthor.Rows[i].FindControl("chxSelect"); if (chxSelectTemp == null) { return; } int id; Label lblIdTemp = null; lblIdTemp = (Label)gvAuthor.Rows[i].FindControl("lblId"); if (lblIdTemp != null) { if (chxSelectTemp.Checked) { id = Convert.ToInt32(lblIdTemp.Text); authorIdList.Add(id); } } else { return; } } ProcessPub.ProcessAuthorList(authorIdList); }
protected void btnPutEpubDate_Click(object sender, EventArgs e) { List <int> pubIdList = GetNoEPubDatePubIdList().ToList(); foreach (int publicationId in pubIdList) { ProcessPub.UpdateEPubDateForOnePubId(publicationId); } }
protected void btnReprocess_ClickTitle(object sender, EventArgs e) { List <int> pubIdList = GetAllPubIdList().ToList(); foreach (int publicationId in pubIdList) { ProcessPub.UpdateTitleForOnePubId(publicationId); } }
protected void gvAuthor_RowDeleting(object sender, GridViewDeleteEventArgs e) { string idStr; Label lblIdTemp = null; lblIdTemp = (Label)gvAuthor.Rows[e.RowIndex].FindControl("lblId"); if (lblIdTemp != null) { idStr = lblIdTemp.Text; } else { return; } List <int> pubIdList = GetPubIdListByAuthorId(idStr).ToList(); //string connectionStr = ConfigurationManager.AppSettings.Get("ConnectionString"); string connectionStr = ConfigurationManager.ConnectionStrings["UcccPubMedDB"].ConnectionString; SqlConnection myConnection = new SqlConnection(connectionStr); string sqlStatement; foreach (int pubId in pubIdList) { ProcessPub.SaveRejectOnPubId(pubId); sqlStatement = "delete from publication_author where publication_id = " + pubId + "; delete from publication_processing where publication_id = " + pubId + "; delete from publication_program where publication_id = " + pubId + "; delete from publication_programmatic where publication_id = " + pubId + "; delete from publication_pubtype where publication_id = " + pubId + "; delete from publication_resource where publication_id = " + pubId + "; delete from publication where publication_id = " + pubId; SqlCommand myCommand = new SqlCommand(sqlStatement, myConnection); myConnection.Open(); myCommand.ExecuteNonQuery(); myConnection.Close(); } sqlStatement = "delete from author where author_id = " + idStr; SqlCommand command = new SqlCommand(sqlStatement, myConnection); myConnection.Open(); command.ExecuteNonQuery(); myConnection.Close(); FillAuthorGrid(txtLastName.Text, txtFirstName.Text); }
protected void gvPublication_RowDeleting(object sender, GridViewDeleteEventArgs e) { string idStr; Label lblIdTemp = null; lblIdTemp = (Label)gvPublication.Rows[e.RowIndex].FindControl("lblId"); if (lblIdTemp != null) { idStr = lblIdTemp.Text; } else { return; } string connectionStr = ConfigurationManager.ConnectionStrings["UcccPubMedDB"].ConnectionString; SqlConnection myConnection = new SqlConnection(connectionStr); string sqlStatement; ProcessPub.SaveRejectOnPubId(Convert.ToInt32(idStr)); sqlStatement = "delete from publication_author where publication_id = " + idStr + "; delete from publication_processing where publication_id = " + idStr + "; delete from publication_program where publication_id = " + idStr + "; delete from publication_programmatic where publication_id = " + idStr + "; delete from publication_pubtype where publication_id = " + idStr + "; delete from publication_resource where publication_id = " + idStr + "; delete from publication where publication_id = " + idStr + "; delete from author where author_id not in (select author_id from publication_author)"; SqlCommand command = new SqlCommand(sqlStatement, myConnection); SqlParameter publication_program_idParameter = new SqlParameter(); publication_program_idParameter.ParameterName = "@publication_program_id"; publication_program_idParameter.SqlDbType = SqlDbType.Int; publication_program_idParameter.Value = Convert.ToInt32(idStr); command.Parameters.Add(publication_program_idParameter); myConnection.Open(); command.ExecuteNonQuery(); myConnection.Close(); gvPublication.EditIndex = -1; FillPublicationGrid(); }
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); }
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 SaveYesNoSelection(pubid_ours mp) { int publicationId = mp.pubId; int yesNoId = mp.yesNoId; string sqlStatement; if (yesNoId == 2) { string connectionStr = ConfigurationManager.ConnectionStrings["UcccPubMedDB"].ConnectionString; SqlConnection myConnection = new SqlConnection(connectionStr); ProcessPub.SaveRejectOnPubId(publicationId); sqlStatement = "delete from publication_processing where publication_id = @publication_id" + "; delete from publication_author where publication_id = @publication_id" + "; delete from publication_program where publication_id = @publication_id" + "; delete from publication_programmatic where publication_id = @publication_id" + "; delete from publication_pubtype where publication_id = @publication_id" + "; delete from publication_resource where publication_id = @publication_id" + "; delete from publication where publication_id = @publication_id" + "; delete from author where author_id not in (select author_id from publication_author)"; SqlCommand command = new SqlCommand(sqlStatement, myConnection); SqlParameter publication_idParameter = new SqlParameter(); publication_idParameter.ParameterName = "@publication_id"; publication_idParameter.SqlDbType = SqlDbType.Int; publication_idParameter.Value = publicationId; command.Parameters.Add(publication_idParameter); myConnection.Open(); command.ExecuteNonQuery(); myConnection.Close(); } else { sqlStatement = "Update publication_processing" + " SET final_confirm_id=@final_confirm_id" + " WHERE (publication_id = @publication_id)"; string connectionStr = ConfigurationManager.ConnectionStrings["UcccPubMedDB"].ConnectionString; SqlConnection myConnection = new SqlConnection(connectionStr); SqlCommand command = new SqlCommand(sqlStatement, myConnection); SqlParameter final_confirm_idParameter = new SqlParameter(); final_confirm_idParameter.ParameterName = "@final_confirm_id"; final_confirm_idParameter.SqlDbType = SqlDbType.Int; final_confirm_idParameter.Value = yesNoId; command.Parameters.Add(final_confirm_idParameter); SqlParameter publication_idParameter = new SqlParameter(); publication_idParameter.ParameterName = "@publication_id"; publication_idParameter.SqlDbType = SqlDbType.Int; publication_idParameter.Value = publicationId; command.Parameters.Add(publication_idParameter); myConnection.Open(); command.ExecuteNonQuery(); myConnection.Close(); } gvPublication.EditIndex = -1; FillPublicationGrid(); }
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); }
protected void btnProcessAuthorList_Click(object sender, EventArgs e) { List <int> authorIdList = GetUnconfirmedAuthorList(); ProcessPub.ProcessAuthorList(authorIdList); }