protected void btnProdSchedule_Click(object sender, EventArgs e)
{
Whitfieldcore wc = new Whitfieldcore();
DataSet ds = new DataSet();
if (!txtInitialPaymentDate.Text.ToString().Equals("") && !txtFinalPaymentDate.Text.ToString().Equals(""))
{
wc.RemoveCashFlowScheduledata(Convert.ToInt32(ViewState["twc_project_number"].ToString()));
ds = wc.GetSchedule(txtInitialPaymentDate.Text.ToString(), txtFinalPaymentDate.Text.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.PopulateCashFlowSchedule(Convert.ToInt32(ViewState["twc_project_number"].ToString()), _yr, _mnth + "(" + _yr + ")", hash[key].ToString(), iCnt);
}
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");
}
}