protected void gvOrders_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        try
        {
            gvOrders.PageIndex = e.NewPageIndex;

            if ((!string.IsNullOrEmpty(txtfromDate.Text) && !string.IsNullOrEmpty(txtfromDate.Text)))
            {
                DateTime?       fromDate     = null;
                DateTime?       toDate       = null;
                List <OrderDTO> orderDTOList = new List <OrderDTO>();

                if (!string.IsNullOrEmpty(txtfromDate.Text))
                {
                    fromDate = Convert.ToDateTime(txtfromDate.Text);
                }

                if (!string.IsNullOrEmpty(txttoDate.Text))
                {
                    toDate = Convert.ToDateTime(txttoDate.Text);
                }

                orderDTOList        = OrdersBAL.GetPreviousOrdersByDate(Convert.ToString(Session[enumSessions.User_Id.ToString()]), fromDate, toDate);
                gvOrders.DataSource = orderDTOList;
                gvOrders.DataBind();
            }

            else
            {
                LoadPreviousOrders();
            }
        }
        catch (Exception objException)
        {
            CSLOrderingARCBAL.LinqToSqlDataContext db;
            db = new CSLOrderingARCBAL.LinqToSqlDataContext();
            db.USP_SaveErrorDetails(Request.Url.ToString(), "gvOrders_PageIndexChanging", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()]));
        }
    }
    protected void btnShow_Click(object sender, EventArgs e)
    {
        try
        {
            if ((!string.IsNullOrEmpty(txtfromDate.Text) && !string.IsNullOrEmpty(txtfromDate.Text)))
            {
                DateTime?       fromDate     = null;
                DateTime?       toDate       = null;
                List <OrderDTO> orderDTOList = new List <OrderDTO>();

                if (!string.IsNullOrEmpty(txtfromDate.Text))
                {
                    fromDate = Convert.ToDateTime(txtfromDate.Text);
                    //  order.orderfromdate = fromDate;
                }

                if (!string.IsNullOrEmpty(txttoDate.Text))
                {
                    toDate = Convert.ToDateTime(txttoDate.Text);
                    // order.ordertodate = toDate;
                }


                orderDTOList        = OrdersBAL.GetPreviousOrdersByDate(Convert.ToString(Session[enumSessions.User_Id.ToString()]), fromDate, toDate);
                gvOrders.DataSource = orderDTOList;
                gvOrders.DataBind();
            }
            else
            {
                LoadPreviousOrders();
            }
        }
        catch (Exception)
        {
        }
    }