private void ok_button_Click(object sender, EventArgs e)
{
using (var db = new Session2Entities())
{
var aaaaa = (from ee in db.Employees
where ee.Username == name_box.Text
where ee.Password == password_box.Text
select ee);
if (aaaaa.Any())
{
if (aaaaa.First().isAdmin == true)
{
var form = new EmergencyMaintainenece(aaaaa.First());
this.Hide();
form.Closed += (s, args) => this.Close();
form.Show();
}
}
}
}
public async Task <List <MaintaineneceEmergency> > GetData()
{
var returnlist = new List <MaintaineneceEmergency>();
using (var db = new Session2Entities())
{
var listofassets = (from a in db.Assets
where a.EmployeeID == a.EmployeeID
select a).ToList();
Parallel.ForEach(listofassets, item => {
if ((from e in db.EmergencyMaintenances where e.AssetID == item.ID select e).Any())
{
var me = new MaintaineneceEmergency();
me.AssetName = item.AssetName;
returnlist.Add(new MaintaineneceEmergency()
{
AssetName = item.AssetName,
AssetSN = item.AssetSN,
NumberOfEMs = (from e in db.EmergencyMaintenances where e.ID == item.ID orderby e.EMEndDate descending select e.EMEndDate).Count(),
LastClosedEM = (from e in db.EmergencyMaintenances where e.ID == item.ID orderby e.EMEndDate descending select e.EMEndDate).First().ToString()
}
);
}
else
{
returnlist.Add(new MaintaineneceEmergency()
{
AssetName = item.AssetName,
AssetSN = item.AssetSN,
NumberOfEMs = (from e in db.EmergencyMaintenances where e.ID == item.ID orderby e.EMEndDate descending select e.EMEndDate).Count(),
LastClosedEM = "---"
}
);
}
});
}
return(returnlist);
}