private void FetchSehedule()
{
txtSchhours.Text = "";
txtWeeklyComments.Text = "";
Whitfieldcore wc = new Whitfieldcore();
DataSet ds = new DataSet();
ds = wc.GetScheduleData(Convert.ToInt32(ViewState["twc_project_number"].ToString()), ddlYear.SelectedItem.Value.ToString(), ddlMonth.SelectedItem.Value.ToString() + "(" + ddlYear.SelectedItem.Value.ToString() + ")", ddlWeek.SelectedItem.Value.ToString());
Int32 resultCount = 0;
if (ds.Tables.Count > 0)
resultCount = ds.Tables[0].Rows.Count;
DataTable myControls;
myControls = ds.Tables[0];
if (myControls.Rows.Count > 0)
{
try
{
foreach (DataRow dRow in myControls.Rows)
{
String _hr = dRow["Hours"] != DBNull.Value ? dRow["Hours"].ToString() : "";
String _comments = dRow["weeklyNotes"] != DBNull.Value ? dRow["weeklyNotes"].ToString() : "";
//String project_amount = dRow["project_amount"] != DBNull.Value ? dRow["project_amount"].ToString() : "";
txtSchhours.Text = _hr;
txtWeeklyComments.Text = _comments;
//txtProjectedAmt.Text = project_amount;
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
DisplaySchedulingGrid();
}
else
{
txtSchhours.Text = "0";
txtWeeklyComments.Text = "";
}
}
