protected void btnsearch_Click(object sender, EventArgs e)
{
int userid = 0;
string fname = "";
string lname = "";
string usename = "";
string email = "";
string phone = "";
string answer = "";
string type = "";
string status = "";
DateTime datestemp;
if (DropDownListuserid.SelectedValue == "%")
{
userid = 0;
}
else
{
userid = Convert.ToInt32(DropDownListuserid.SelectedValue);
}
if (DropDownListfirstname.SelectedValue == "%")
{
fname = "";
}
else
{
fname = DropDownListfirstname.SelectedValue;
}
if (DropDownListlastname.SelectedValue == "%")
{
lname = "";
}
else
{
lname = DropDownListlastname.SelectedValue;
}
if (DropDownListusername.SelectedValue == "%")
{
usename = "";
}
else
{
usename = DropDownListusername.SelectedValue;
}
if (DropDownListrecoveryemail.SelectedValue == "%")
{
email = "";
}
else
{
email = DropDownListrecoveryemail.SelectedValue;
}
if (DropDownListphoneno.SelectedValue == "%")
{
phone = "";
}
else
{
phone = DropDownListphoneno.SelectedValue;
}
if (DropDownListSecurityAns.SelectedValue == "%")
{
answer = "";
}
else
{
answer = DropDownListSecurityAns.SelectedValue;
}
if (DropDownListusertype.SelectedValue == "%")
{
type = "";
}
else
{
type = DropDownListusertype.SelectedValue;
}
if (DropDownListuserstatus.SelectedValue == "%")
{
status = "";
}
else
{
status = DropDownListuserstatus.SelectedValue.Trim();
}
//string MYNEWDate = string.Empty;
//if (DropDownListdatestamp.SelectedValue != "%")
//{
// datestemp = Convert.ToDateTime(DropDownListdatestamp.SelectedValue);
// //DateTime myDateTime = DateTime.Now;
// MYNEWDate = datestemp.ToString("yyyy-MM-dd HH:mm:ss:fff");
//}
//else
//{
// datestemp = DateTime.Now;
// MYNEWDate = datestemp.ToString("yyyy-MM-dd HH:mm:ss:fff");
//}
// dsfilter = loginDA.fetchreportsbyfilter(userid, DropDownListfirstname.SelectedValue, DropDownListlastname.SelectedValue,DropDownListusername.SelectedValue,DropDownListphoneno.SelectedValue,DropDownListrecoveryemail.SelectedValue,DropDownListSecurityAns.SelectedValue,DropDownListusertype.SelectedValue,DropDownListuserstatus.SelectedValue);
dsfilter = loginDA.fetchreportsbyfilter(userid, fname, lname, usename, phone, email, answer, type, status);
if (dsfilter.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = dsfilter;
GridView1.DataBind();
}
else
{
BindGridviewdata();
}
}
