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"));
}
}