public void bindLVQuest()
{
QuestAnsBAL QuestBAL = new QuestAnsBAL();
QuestAnsBE Quest = new QuestAnsBE();
DataTable dt = new DataTable();
DateTime FromDate = Convert.ToDateTime("2010/01/01");
DateTime Todate = DateTime.Now;
if (txtFromDate.Text == "")
{
Quest.FromDate = FromDate;
}
else
{
IFormatProvider culture = new CultureInfo("es-Mx", true);
// Quest.FromDate = DateTime.Parse(txtFromDate.Text, culture);
Quest.FromDate = DateTime.ParseExact(txtFromDate.Text + " " + ddlFromHrs.Text + ':' + ddlFromMns.Text, "dd/MM/yyyy HH:mm", culture);
}
if (txtToDate.Text == "")
{
Quest.ToDate = Todate;
}
else
{
IFormatProvider culture = new CultureInfo("es-Mx", true);
//Quest.ToDate = DateTime.Parse(txtToDate.Text, culture);
Quest.ToDate = DateTime.ParseExact(txtToDate.Text + " " + ddlToHrs.Text + ':' + ddlToMns.Text, "dd/MM/yyyy HH:mm", culture);
}
if (txtSubject.Text == "")
{
Quest.Subject = "%";
}
else
{
Quest.Subject = "%" + txtSubject.Text + "%";
}
if (txtTags.Text == "")
{
Quest.Tag = "%";
}
else
{
Quest.Tag = "%" + txtTags.Text + "%";
}
if (txtYrOfStudyExp.Text == "")
{
Quest.YrsOfStudyStream = "%";
}
else
{
Quest.YrsOfStudyStream = "%" + txtYrOfStudyExp.Text + "%";
}
if (txtStudyStream.Text == "") //AM??
{
Quest.StudyStream = "%"; //AM??
}
else
{
Quest.StudyStream = "%" + txtStudyStream.Text + "%"; //AM??
}
// if (txtKeyword.Text == "") //AM????
// {
// Quest.Keyword = "%";
// }
// else
// {
// Quest.Keyword = txtKeyword.Text;
//}
if (QuestBAL.SearchList(ref dt, Quest))
{
lvQuestList.DataSource = dt;
lvQuestList.DataBind();
recalcNoOfPages();
}
else
{
lvQuestList.Items.Clear();
lvQuestList.DataSource = null;
lvQuestList.DataBind();
LoggedIn master = (LoggedIn)this.Master;
master.ShowMessage("Sorry No Records Were found", false);
}
}
