public void ShowRequestGrid()
{
try
{
lblmsg.Text = "";
string datefltr = "";
string reqtypefltr = "";
string FromDate = "", Todate = "";
if (txtdatefrom.Text != "" && txttodate.Text != "")
{
FromDate = objfun.ConvertMyDateFormat(txtdatefrom.Text);
Todate = objfun.ConvertMyDateFormat(txttodate.Text);
}
if (FromDate != "" && Todate != "")
{
datefltr = " and ReqDate between convert(smalldatetime,'" + FromDate + " 00:01:01') and convert(smalldatetime,'" + Todate + " 23:59:59') ";
}
if (ddlreqtype.SelectedValue == "--Select--" || ddlreqtype.SelectedValue == "-1")
{
reqtypefltr = " ";
}
else
{
reqtypefltr = " and ReqTypeMasterID=" + objdb.ExecuteScaler("select ReqIypeId from ReqTypeMaster where ReqType = '" + ddlreqtype.SelectedItem.Value + "'");
}
DataSet dsReq = new DataSet();
string str = "Select ReqID, ReqType , convert(varchar, ReqDate,106) as [Request Date],ReqStatus as [Status],Request from RequestMaster, ReqTypeMaster where reqstatus='Open' and ReqTypeMasterID=ReqIypeId " + datefltr + " " + reqtypefltr + " order by ReqID";
dsReq = objdb.GetDataset(str, "Req_Mst");
grvRequest.DataSource = dsReq;
grvRequest.DataBind();
}
catch (Exception ex) { lblmsg.Text = "Error in Display request : " + ex.Message.ToString(); }
}
