public FP()
{
InitializeComponent();
RfidContext db = new RfidContext();
var queryAllCustomers = from cust in db.C_Names
where cust.P_Users.IsUser == true
select new
{
cust.P_Users.ID,
cust.NameFirst,
cust.NameLast,
cust.NameThird,
cust.P_Users.P_Departments.Name,
cust.P_Users.P_InOutValidTimes.Start,
cust.P_Users.P_InOutValidTimes.And,
cust.P_Users.P_InOutValidTimes.Valid
};
GridBasicInformation.EnableColumnVirtualization = true;
GridBasicInformation.ItemsSource = queryAllCustomers.ToList();
GridBasicInformation.EnableColumnVirtualization = true;
GridBasicInformation.Items.Refresh();
var a = GridBasicInformation.CommandBindings;
//this.GridMonthlyReport.Columns[3].ClipboardContentBinding.StringFormat = "HH:mm";
var queryAllDepartamentsNames = from cust in db.C_Departments
select new { cust.Name }
;
List <DepartamentsData> listDepInfo = new List <DepartamentsData>();
foreach (var depName in queryAllDepartamentsNames.ToList())
{
DepartamentsData temp = getDepartamentClientData(depName.Name);
listDepInfo.Add(temp);
}
GridDepartamentReport.ItemsSource = listDepInfo;
this.GridDepartamentReport.Items.Refresh();
var d = GridDepartamentReport.Columns;
//GridDepartamentReport.Columns[0].ClipboardContentBinding.StringFormat = "dd.MM.yyyy";
}
private DepartamentsData getDepartamentClientData(string name)
{
var db = new RfidContext();
var queryAllDepartaments = from cust in db.C_Names
where cust.P_Users.P_Departments.Name.Equals(name)
select new { cust.P_Users.IsUser, cust.P_Users.isInside };
var t1 = queryAllDepartaments.Count();
var t2 = queryAllDepartaments.Count(x => x.isInside);
var t3 = queryAllDepartaments.Count(x => x.isInside == false);
var date = DateTime.Now;
var departParam = new DepartamentsData(date.ToString("dd.MM.yyyy"), name, t1, t2, t3);
return(departParam);
}
