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