protected void Page_Load(object sender, EventArgs e)
{
Whitfieldcore wc = new Whitfieldcore();
if (!Page.IsPostBack)
{
DataSet ds = new DataSet();
ds = wc.GetSchedule("01/01/2010", "08/01/2010");
Int32 resultCount = 0;
if (ds.Tables.Count > 0)
resultCount = ds.Tables[0].Rows.Count;
DataTable myControls;
myControls = ds.Tables[0];
Int32 iCnt = 1;
if (myControls.Rows.Count > 0)
{
try
{
foreach (DataRow dRow in myControls.Rows)
{
Hashtable hash = wc.GetWeeksHash();
String _yr = dRow["dt2"] != DBNull.Value ? dRow["dt2"].ToString() : "";
String _mnth = dRow["dt1"] != DBNull.Value ? dRow["dt1"].ToString() : "";
foreach (string key in hash.Keys)
{
//+ '(' + [fycd] + ')'
wc.PopulateSchedule(1, _yr, _mnth + "(" + _yr + ")", hash[key].ToString(),iCnt,"0");
//passs
//_yr
//_mnth
//hash[key].ToString()
//ProjectNumber to the Maintainschedule
}
iCnt++;
}
Response.Write("setup Completed.");
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
else
{
Response.Write("No Data");
}
}
}
protected void btnProdSchedule_Click(object sender, EventArgs e)
{
Whitfieldcore wc = new Whitfieldcore();
DataSet ds = new DataSet();
if (!ViewState["Construction_Start_Date"].ToString().Equals("") && !ViewState["Construction_End_Date"].ToString().Equals(""))
{
ds = wc.GetSchedule(ViewState["Construction_Start_Date"].ToString(), ViewState["Construction_End_Date"].ToString());
Int32 resultCount = 0;
if (ds.Tables.Count > 0)
resultCount = ds.Tables[0].Rows.Count;
DataTable myControls;
myControls = ds.Tables[0];
Int32 iCnt = 1;
if (myControls.Rows.Count > 0)
{
try
{
foreach (DataRow dRow in myControls.Rows)
{
Hashtable hash = wc.GetWeeksHash();
String _yr = dRow["dt2"] != DBNull.Value ? dRow["dt2"].ToString() : "";
String _mnth = dRow["dt1"] != DBNull.Value ? dRow["dt1"].ToString() : "";
foreach (string key in hash.Keys)
{
wc.PopulateSchedule(Convert.ToInt32(ViewState["twc_project_number"].ToString()), _yr, _mnth + "(" + _yr + ")", hash[key].ToString(), iCnt, "0");
}
iCnt++;
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
DisplaySchedulingGrid();
}
else
{
Response.Write("No Data");
}
}
else
{
Response.Write("Construction Start date and Construction End date should be Set");
}
}