protected void searchclick(object sender, EventArgs e)
{
//if (!Page.IsValid)
//{
// return;
//}
GridViewJournalSearch.Visible = true;
if (DropDownListCategory.SelectedValue != "A")
{
if (TextYear.Text != "")
{
SqlDataSourceJournal.SelectParameters.Clear();
SqlDataSourceJournal.SelectParameters.Add("JournalCategory", DropDownListCategory.SelectedValue);
SqlDataSourceJournal.SelectParameters.Add("Year", TextYear.Text.Trim());
SqlDataSourceJournal.SelectCommand = "select k.Id as ISSN,Title,AbbreviatedTitle,ImpactFactor,fiveImpFact,Comments,Year from Journal_M k LEFT join Journal_IF_Details j on j.id=k.Id WHERE JournalCategory=@JournalCategory and Year= @Year";
}
else
{
SqlDataSourceJournal.SelectParameters.Clear();
SqlDataSourceJournal.SelectParameters.Add("JournalCategory", DropDownListCategory.SelectedValue);
SqlDataSourceJournal.SelectCommand = "select k.Id as ISSN,Title,AbbreviatedTitle,ImpactFactor,fiveImpFact,Comments,Year from Journal_M k LEFT join Journal_IF_Details j on j.id=k.Id WHERE JournalCategory=@JournalCategory";
}
}
else
{
if (TextYear.Text != "")
{
SqlDataSourceJournal.SelectParameters.Clear();
SqlDataSourceJournal.SelectParameters.Add("Year", TextYear.Text.Trim());
SqlDataSourceJournal.SelectCommand = "select k.Id as ISSN,Title,AbbreviatedTitle,ImpactFactor,fiveImpFact,Comments,Year from Journal_M k LEFT join Journal_IF_Details j on j.id=k.Id WHERE Year=@Year";
}
else
{
SqlDataSourceJournal.SelectCommand = "select k.Id as ISSN,Title,AbbreviatedTitle,ImpactFactor,fiveImpFact,Comments,Year from Journal_M k LEFT join Journal_IF_Details j on j.id=k.Id ";
}
}
SqlDataSourceJournal.DataBind();
GridViewJournalSearch.DataBind();
}
protected void GridViewJournalSearchOnPageIndexChanging(object sender, GridViewPageEventArgs e)
{
searchclick(sender, e);
GridViewJournalSearch.PageIndex = e.NewPageIndex;
GridViewJournalSearch.DataBind();
}
protected void searchclick(object sender, EventArgs e)
{
//if (!Page.IsValid)
//{
// return;
//}
try
{
GridViewJournalSearch.Visible = true;
if (dropdownCategory.SelectedValue != " ")
{
if (txtJid.Text != "")
{
SqlDataSourceJournal.SelectParameters.Clear();
SqlDataSourceJournal.SelectParameters.Add("Id", txtJid.Text.Trim());
SqlDataSourceJournal.SelectParameters.Add("JournalCategory", dropdownCategory.SelectedValue);
SqlDataSourceJournal.SelectCommand = "select k.Id as ISSN,Year,Title,AbbreviatedTitle,ImpactFactor,fiveImpFact,JournalCategory,Comments from Journal_M k LEFT join Journal_IF_Details j on j.id=k.Id where j.Id=@Id and JournalCategory=@JournalCategory";
}
//else if (TextYear.Text == "" && txtJid.Text != "")
//{
// SqlDataSourceJournal.SelectCommand = "select j.Id as Id,Year,Title,AbbreviatedTitle,ImpactFactor,fiveImpFact,Comments from Journal_IF_Details j,Journal_M k where j.Id=k.Id and j.Id='" + txtJid.Text.Trim() + "'";
//}
else if (txtJid.Text == "")
{
SqlDataSourceJournal.SelectParameters.Clear();
SqlDataSourceJournal.SelectParameters.Add("JournalCategory", dropdownCategory.SelectedValue);
SqlDataSourceJournal.SelectCommand = "select k.Id as ISSN,Year,Title,AbbreviatedTitle,ImpactFactor,fiveImpFact,JournalCategory,Comments from Journal_M k LEFT join Journal_IF_Details j on j.id=k.Id where JournalCategory=@JournalCategory";
}
}
else
{
if (txtJid.Text != "")
{
SqlDataSourceJournal.SelectParameters.Clear();
SqlDataSourceJournal.SelectParameters.Add("Id", txtJid.Text.Trim());
SqlDataSourceJournal.SelectCommand = "select k.Id as ISSN,Year,Title,AbbreviatedTitle,ImpactFactor,fiveImpFact,JournalCategory,Comments from Journal_M k LEFT join Journal_IF_Details j on j.id=k.Id where j.Id=@Id";
}
//else if (TextYear.Text == "" && txtJid.Text != "")
//{
// SqlDataSourceJournal.SelectCommand = "select j.Id as Id,Year,Title,AbbreviatedTitle,ImpactFactor,fiveImpFact,Comments from Journal_IF_Details j,Journal_M k where j.Id=k.Id and j.Id='" + txtJid.Text.Trim() + "'";
//}
else if (txtJid.Text == "")
{
SqlDataSourceJournal.SelectCommand = " select k.Id as ISSN,Year,Title,AbbreviatedTitle,ImpactFactor,fiveImpFact,JournalCategory,Comments from Journal_M k LEFT join Journal_IF_Details j on j.id=k.Id ";
}
}
//else
//{
// SqlDataSourceJournal.SelectCommand = "select j.Id as Id,Year,Title,AbbreviatedTitle,ImpactFactor,fiveImpFact,Comments from Journal_IF_Details j,Journal_M k where j.Id=k.Id ";
//}
SqlDataSourceJournal.DataBind();
GridViewJournalSearch.DataBind();
}
catch (Exception ex)
{
log.Error(ex.StackTrace);
log.Error(ex.Message);
ClientScript.RegisterStartupScript(Page.GetType(), "validation1", "<script language='javascript'>alert('Error!!!!!!!!!!!!!!!')</script>");
}
}
