public DataSet FetchReportActivity()
 {
     DataSet dsGrp = new DataSet();
     Whitfield_Project wUser = new Whitfield_Project();
     dsGrp = wUser.GetWorkOrders(ViewState["EstNum"].ToString(), Convert.ToInt32(ViewState["twc_project_number"].ToString()));
     return dsGrp;
 }
    public void BindWorkOrders()
    {
        DataSet dsGrp = new DataSet();
        Whitfield_Project wUser = new Whitfield_Project();
        dsGrp = wUser.GetWorkOrders(ViewState["EstNum"].ToString(), Convert.ToInt32(ViewState["twc_project_number"].ToString()));
        if (dsGrp.Tables[0].Rows.Count > 0)
        {

            ddlworkorders.DataSource = dsGrp;
            ddlworkorders.DataTextField = "WODesc";
            ddlworkorders.DataValueField = "work_order_id";
            ddlworkorders.DataBind();
            ddlworkorders.Items.Insert(0, common.AddItemToList("Select WorkOrder", "0"));

        }
    }
 private void DisplayGrid()
 {
     Whitfield_Project _wc = new Whitfield_Project();
     DataSet _dsWorkOrders = new DataSet();
     _dsWorkOrders = _wc.GetWorkOrders(ViewState["EstNum"].ToString(), Convert.ToInt32(ViewState["twc_project_number"].ToString()));
     this.PopulateDataGrid(_dsWorkOrders);
 }
    public void BindWorkOrders()
    {
        DataSet dsGrp = new DataSet();
        Whitfield_Project wUser = new Whitfield_Project();
        ddlworkorders.Items.Clear();
        dsGrp = wUser.GetWorkOrders(ddlProject.SelectedItem.Value);
        if (dsGrp.Tables[0].Rows.Count > 0)
        {

            ddlworkorders.DataSource = dsGrp;
            ddlworkorders.DataTextField = "woid";
            ddlworkorders.DataValueField = "work_order_id";
            ddlworkorders.DataBind();
            ddlworkorders.Items.Insert(0, common.AddItemToList("Select WorkOrder", "0"));
        }
        else
        {
            ddlworkorders.Items.Insert(0, common.AddItemToList("No workorders available", "0"));
        }
    }