protected void BindBasePlans()
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("Name", typeof(string)));
dt.Columns.Add(new DataColumn("BasePlanSlotId", typeof(int)));
Hashtable ht = ProjectSpreadSheet.GetFilledSlotHash(int.Parse(Request["ProjectId"]));
if (ht.Keys.Count <= 0)
{
trBasePlanFilter.Visible = false;
}
foreach (BasePlanSlot bps in BasePlanSlot.List())
{
DataRow row = dt.NewRow();
row["BasePlanSlotId"] = bps.BasePlanSlotId;
DateTime d_time = DateTime.MinValue;
if (ht.Contains(bps.BasePlanSlotId))
{
foreach (BasePlan bp in BasePlan.List(int.Parse(Request["ProjectId"])))
{
if (bp.BasePlanSlotId == bps.BasePlanSlotId)
{
d_time = bp.Created;
break;
}
}
}
if (d_time != DateTime.MinValue)
{
row["Name"] = String.Format("{0} ({1}: {2})", bps.Name, LocRM.GetString("LastSaved"), d_time);
}
else
{
continue;
}
dt.Rows.Add(row);
}
ddlBasePlans.DataSource = dt;
ddlBasePlans.DataTextField = "Name";
ddlBasePlans.DataValueField = "BasePlanSlotId";
ddlBasePlans.DataBind();
ddlBasePlans.Items.Insert(0, new ListItem(LocRM.GetString("NotSet"), "-1"));
ddlBasePlans.SelectedValue = BasePlanSlotId.ToString();
}
void BindDropDown()
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("Name", typeof(string)));
dt.Columns.Add(new DataColumn("BasePlanSlotId", typeof(int)));
Hashtable ht = ProjectSpreadSheet.GetFilledSlotHash(int.Parse(Request["ProjectId"]));
int selvalue = -1;
DateTime d_time = DateTime.Now;
foreach (BasePlanSlot bps in BasePlanSlot.List())
{
if (bps.IsDefault)
{
selvalue = bps.BasePlanSlotId;
}
DataRow row = dt.NewRow();
row["BasePlanSlotId"] = bps.BasePlanSlotId;
if (ht.Contains(bps.BasePlanSlotId))
{
foreach (BasePlan bp in BasePlan.List(int.Parse(Request["ProjectId"])))
{
if (bp.BasePlanSlotId == bps.BasePlanSlotId)
{
d_time = bp.Created;
break;
}
}
row["Name"] = String.Format("{0} ({1}: {2})", bps.Name, LocRM.GetString("LastSaved"), d_time);
//row["Created"] = ht[bps.BasePlanSlotId];
}
else
{
row["Name"] = bps.Name;
}
dt.Rows.Add(row);
}
ddBasePlan.DataSource = dt;
ddBasePlan.DataTextField = "Name";
ddBasePlan.DataValueField = "BasePlanSlotId";
ddBasePlan.DataBind();
ddBasePlan.SelectedValue = selvalue.ToString();
}
void BindDropDowns()
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("Id", typeof(int)));
dt.Columns.Add(new DataColumn("Name", typeof(string)));
dt.Rows.Add(new object[] { 1, LocRM.GetString("tWeekYear") });
dt.Rows.Add(new object[] { 2, LocRM.GetString("tMonthQuarterYear") });
dt.Rows.Add(new object[] { 3, LocRM.GetString("tQuarterYear") });
dt.Rows.Add(new object[] { 4, LocRM.GetString("tYear") });
dt.Rows.Add(new object[] { 5, LocRM.GetString("tTotal") });
ArrayList list = new ArrayList(SpreadSheetTemplateInfo.List());
list.Sort(new SortComparer());
ddTemplate.DataSource = list; //SpreadSheetTemplateInfo.List();
ddTemplate.DataTextField = "Name";
ddTemplate.DataValueField = "FileName";
ddTemplate.DataBind();
ddDocType.DataSource = dt;
ddDocType.DataTextField = "Name";
ddDocType.DataValueField = "Id";
ddDocType.DataBind();
ddDocType.SelectedValue = "2";
DataTable dt2 = new DataTable();
dt2.Columns.Add(new DataColumn("Id", typeof(int)));
dt2.Columns.Add(new DataColumn("Name", typeof(string)));
foreach (BasePlan bp in BasePlan.List(ProjectId))
{
DataRow row = dt2.NewRow();
row["Id"] = bp.BasePlanSlotId;
row["Name"] = String.Format("{0} ({1}: {2})", BasePlanSlot.Load(bp.BasePlanSlotId).Name, LocRM.GetString("LastSaved"), bp.Created);
dt2.Rows.Add(row);
}
dt2.Rows.Add(new object[] { -1, LocRM.GetString("Fact") });
dt2.Rows.Add(new object[] { 0, LocRM.GetString("Current") });
DataView dv = dt2.DefaultView;
dv.Sort = "Id ASC";
ddPrimarySheet.DataSource = dv;
ddPrimarySheet.DataTextField = "Name";
ddPrimarySheet.DataValueField = "Id";
ddPrimarySheet.DataBind();
ddPrimarySheet.SelectedValue = "0";
dt2.Rows.Add(new object[] { -2, LocRM.GetString("NotSelected") });
ddSecondarySheet.DataSource = dv;
ddSecondarySheet.DataTextField = "Name";
ddSecondarySheet.DataValueField = "Id";
ddSecondarySheet.DataBind();
ddSecondarySheet.SelectedValue = "-2";
tbFrom.Text = DateTime.Now.Year.ToString();
tbTo.Text = DateTime.Now.Year.ToString();
BindUserValues();
}
