/// <summary>
/// The create data source.
/// </summary>
/// <param name="date">
/// The date.
/// </param>
/// <returns>
/// The <see cref="DataTable"/>.
/// </returns>
private DataTable CreateDataSource()
{
var date = (DateTime)(this.Session["Date"] ?? DateTime.Today);
var startOfWeek = date.AddDays(-1 * (int)date.DayOfWeek);
var projectList = projectModule.ProjectList(this.Session["EmpNr"] as string);
var dt = timeLogModule.FetchLog(this.Session["EmpNr"] as string, projectList, startOfWeek, startOfWeek.AddDays(7));
this.Session["GridTable"] = dt;
return(dt);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
this.ProjectDropDown.Items.Clear();
this.ChartViewDropDown.Items.Clear();
var projectList = projectModule.ProjectList(this.Session["EmpNr"] as string);
this.ProjectDropDown.Items.AddRange(projectList.Select(x => new ListItem(x)).ToArray());
foreach (var seriesChartType in Enum.GetNames(typeof(SeriesChartType)))
{
this.ChartViewDropDown.Items.Add(new ListItem(seriesChartType));
}
}
}
/// <summary>
/// The create data source.
/// </summary>
/// <param name="date">
/// The date.
/// </param>
/// <returns>
/// The <see cref="DataTable"/>.
/// </returns>
private DataTable CreateDataSource()
{
var date = (DateTime)(this.Session["Date"] ?? DateTime.Today);
var startOfWeek = date.AddDays(-1 * (int)date.DayOfWeek);
var projectList = projectModule.ProjectList(this.Session["EmpNr"] as string);
var dt = timeLogModule.FetchLog(this.Session["EmpNr"] as string, projectList, startOfWeek, startOfWeek.AddDays(7));
var grid = new DataTable();
grid.Columns.Add("WorkDay");
grid.PrimaryKey = new[] { grid.Columns["WorkDay"] };
grid.Columns.AddRange(projectList.Select(x => new DataColumn($"{x}")).ToArray());
for (var i = startOfWeek; i < startOfWeek.AddDays(7); i = i.AddDays(1))
{
grid.Rows.Add(i.ToShortDateString());
}
grid.BeginLoadData();
foreach (DataRow dtrow in dt.Rows)
{
var itemArray = new string[dtrow.ItemArray.Length];
itemArray[0] = DateTime.Parse(dtrow.ItemArray[0].ToString()).ToShortDateString();
for (var i = 1; i < dtrow.ItemArray.Length; i++)
{
itemArray[i] = dtrow.ItemArray[i].ToString();
}
grid.LoadDataRow(itemArray.Select(x => (object)x).ToArray(), LoadOption.OverwriteChanges);
}
grid.EndLoadData();
this.Session["GridTable"] = grid;
return(grid);
}
public IEnumerable <string> FetchProjectList()
{
var result = projectModule.ProjectList(Thread.CurrentPrincipal.Identity.Name);
return(result);
}
