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