public void bindLVQuest()
{
QuestAnsBAL QuestBAL = new QuestAnsBAL();
QuestAnsBE Quest = new QuestAnsBE();
DataTable dt = new DataTable();
DateTime FromDate = Convert.ToDateTime("2013/01/01");
DateTime Todate = Convert.ToDateTime("9999/01/01");
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 (txtShortDesc.Text == "")
{
Quest.ShortDesc = "%";
}
else
{
Quest.ShortDesc = "%" + txtShortDesc.Text + "%";
}
// if (txtKeyword.Text == "")
//{
// Quest.Keyword = "%";
//}
//else
//{
// Quest.Keyword = "%" + txtKeyword.Text + "%";
//}
if (QuestBAL.SearchKO(ref dt, Quest))
{
KOList.DataSource = dt;
KOList.DataBind();
recalcNoOfPages();
}
else
{
KOList.Items.Clear();
KOList.DataSource = null;
KOList.DataBind();
LoggedIn master = (LoggedIn)this.Master;
master.ShowMessage("There is no data to show.", false);
}
}
