public void BindData(ReportFilter filter)
{
try
{
var control = new ReportController();
xrTableCellDepartment.Text = control.GetCompanyName(filter.SessionDepartment);
//var toDate = new DateTime(filter.Year, filter.StartMonth, DateTime.DaysInMonth(filter.Year, filter.StartMonth));
var toDate = filter.ReportedDate;
lblReportDate.Text = string.Format(lblReportDate.Text, toDate.Day, toDate.Month, toDate.Year);
var location = new ReportController().GetCityName(filter.SessionDepartment);
lblInformationFooter.Text = string.Format(lblInformationFooter.Text, location, DateTime.Now.Day,
DateTime.Now.Month, DateTime.Now.Year);
// get organization
var organization = cat_DepartmentServices.GetByDepartments(filter.SessionDepartment);
if (organization == null)
{
return;
}
var departments = filter.SelectedDepartment;
var arrDepartment = departments.Split(new[] { ',' }, StringSplitOptions.None);
for (var i = 0; i < arrDepartment.Length; i++)
{
arrDepartment[i] = "'{0}'".FormatWith(arrDepartment[i]);
}
var table = SQLHelper.ExecuteTable(
SQLManagementAdapter.GetStore_ListEmployeeHavePersonalTaxCode(string.Join(",", arrDepartment),
filter.WhereClause));
DataSource = table;
//binding data
GroupHeader1.GroupFields.AddRange(new[]
{
new GroupField("DepartmentId", XRColumnSortOrder.Ascending)
});
xrTableCellDepartment.DataBindings.Add("Text", DataSource, "DepartmentName");
xrTableCellEmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode");
xrTableCellFullName.DataBindings.Add("Text", DataSource, "FullName");
xrTableCellGender.DataBindings.Add("Text", DataSource, "Gender");
xrTableCellBirthDate.DataBindings.Add("Text", DataSource, "BirthDate", "{0:dd/MM/yyyy}");
xrTableCellPositionName.DataBindings.Add("Text", DataSource, "PositionName");
xrTableCellPersonalTax.DataBindings.Add("Text", DataSource, "PersonalTaxCode");
}
catch
{
}
}
