searchcvs.aspx.cs

electronic CURRICULUM VITAE

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class SearchCVs : System.Web.UI.Page
{
    //declare sqldatasource variable for search options.
    SqlDataSource sql = new SqlDataSource();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            GridView1.DataSource = SqlDataSource2;
            GridView1.DataBind();
        }
    }

    protected void Button1_Click(object sender, EventArgs e)
    {


        // get the connection string from web.config file
        sql.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;


    //    check if both text boxes have any value then search by two parameters
     if ((EmiTextBox2.Text != null || EmiTextBox2.Text != "") && (MajorTextBox1.Text != null || MajorTextBox1.Text != ""))
         sql.SelectCommand = "SELECT  cvTable1.CVId, cvTable1.FirstName, cvTable1.LastName,cvTable1.Emirate ,Education.Major, Education.University, Education.College, Experience.InstitutionName, Experience.JobTitle, Files.FileName, [References].ReferenceName, Skills.SkillName, Rewards.RewardTitle FROM CareerObjInterestOther INNER JOIN cvTable1 ON CareerObjInterestOther.CVId = cvTable1.CVId INNER JOIN Education ON cvTable1.CVId = Education.CVId INNER JOIN Experience ON cvTable1.CVId = Experience.CVId INNER JOIN Files ON cvTable1.CVId = Files.CVId INNER JOIN [References] ON cvTable1.CVId = [References].CVId INNER JOIN Rewards ON cvTable1.CVId = Rewards.CVId INNER JOIN Skills ON cvTable1.CVId = Skills.CVId WHERE (Emirate LIKE '%" + EmiTextBox2.Text + "%') AND (Major LIKE '%" + MajorTextBox1.Text + "%')";


         //check if only Emitextbox has value then search by that.
        if ((EmiTextBox2.Text != null || EmiTextBox2.Text != "") && (MajorTextBox1.Text == null || MajorTextBox1.Text == ""))
            sql.SelectCommand = "SELECT  cvTable1.CVId, cvTable1.FirstName, cvTable1.LastName,cvTable1.Emirate, Education.Major, Education.University, Education.College, Experience.InstitutionName, Experience.JobTitle, Files.FileName, [References].ReferenceName, Skills.SkillName, Rewards.RewardTitle FROM CareerObjInterestOther INNER JOIN cvTable1 ON CareerObjInterestOther.CVId = cvTable1.CVId INNER JOIN Education ON cvTable1.CVId = Education.CVId INNER JOIN Experience ON cvTable1.CVId = Experience.CVId INNER JOIN Files ON cvTable1.CVId = Files.CVId INNER JOIN [References] ON cvTable1.CVId = [References].CVId INNER JOIN Rewards ON cvTable1.CVId = Rewards.CVId INNER JOIN Skills ON cvTable1.CVId = Skills.CVId WHERE (Emirate LIKE '%" + EmiTextBox2.Text + "%')";


       
        /////////////////////////////////////////////

       //check if only Majortextbox has value then search by that.
        else if ((EmiTextBox2.Text == null || EmiTextBox2.Text == "") && (MajorTextBox1.Text != null || MajorTextBox1.Text != ""))
            sql.SelectCommand = "SELECT  cvTable1.CVId, cvTable1.FirstName, cvTable1.LastName,cvTable1.Emirate ,Education.Major, Education.University, Education.College, Experience.InstitutionName, Experience.JobTitle, Files.FileName, [References].ReferenceName, Skills.SkillName, Rewards.RewardTitle FROM CareerObjInterestOther INNER JOIN cvTable1 ON CareerObjInterestOther.CVId = cvTable1.CVId INNER JOIN Education ON cvTable1.CVId = Education.CVId INNER JOIN Experience ON cvTable1.CVId = Experience.CVId INNER JOIN Files ON cvTable1.CVId = Files.CVId INNER JOIN [References] ON cvTable1.CVId = [References].CVId INNER JOIN Rewards ON cvTable1.CVId = Rewards.CVId INNER JOIN Skills ON cvTable1.CVId = Skills.CVId WHERE (Major LIKE '%" + MajorTextBox1.Text + "%')";

        //bind source according to conditions
        GridView1.DataSource = sql;
        GridView1.DataBind();

    }

}