public manager()
{
InitializeComponent();
laboratory = new LaboratoryContext();
listmember = laboratory.MemberInfo.FromSqlRaw("SELECT * FROM dbo.MemberInfo").ToList();
table_member.ItemsSource = listmember;
listeq = laboratory.Equipment.FromSqlRaw("SELECT * FROM dbo.Equipment").ToList();
ListEquipment.ItemsSource = listeq;
laboratory.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
}
public listequipment(int id)
{
InitializeComponent();
Laboratory = new LaboratoryContext();
List <Supply> supply = Laboratory.Supply.Where(x => x.ExpId == id).ToList();
List <Equipment> equipment = Laboratory.Equipment.ToList();
for (int i = 0; i < supply.Count; i++)
{
for (int j = 0; i < equipment.Count; j++)
{
if (supply[i].EqmId == equipment[j].Id)
{
supply[i].Eqm = equipment[j];
equipment[j].Quantity -= supply[i].Quantity;
break;
}
}
}
ListEquipment.ItemsSource = supply;
}
public MemberGUI(string id)
{
InitializeComponent();
laboratory = new LaboratoryContext();
member = new MemberInfo();
member = laboratory.MemberInfo.FromSqlRaw("EXECUTE dbo.sp_ShowPersonalInfo {0}", id).ToList()[0];
member.LoginInfo = laboratory.LoginInfo.First(x => x.MemId == member.Id);
position = laboratory.Position.ToList();
//Ldepartments = new List<Department>();//laboratory.Department.ToList();
//lab = laboratory.LabInfo.ToList()[0];
member.Pos = position.First(x => x.Id == member.PosId);
tabinfo.DataContext = member;
memberpicture.DataContext = member;
image_login.DataContext = member;
membernamebox.DataContext = member;
var labinfo = laboratory.LabInfo.FromSqlRaw("EXECUTE dbo.sp_ShowLabInfo").ToList();
tablab.DataContext = labinfo;
//participations = laboratory.Participation.ToList();
//for (int i = 0; i < Ldepartments.Count(); i++)
//{
// Ldepartments[i].MemberInfo = laboratory.MemberInfo.Where(x => x.Id == Ldepartments[i].LeaderId).ToList();
//}
var deptinfo = laboratory.Department.FromSqlRaw("EXECUTE dbo.sp_ShowDepInfo").ToList();
labdepartment.ItemsSource = deptinfo;
//participations = laboratory.Participation.ToList();
//if (participations.Exists(x => x.MemId == member.Id))
// {
//Participation = participations.Where(x => x.MemId == member.Id).ToList();
Lexperiments = new List <Experiment>();
//for (int i = 0; i < Participation.Count; i++)
//{
// Experiment a = laboratory.Experiment.First(x => x.Id == Participation[i].ExpId);
// Lexperiments.Add(a);
//}
Lexperiments = laboratory.Experiment.FromSqlRaw("EXECUTE dbo.sp_ShowExpInfo {0}", member.Id).ToList();
project_experiments.ItemsSource = Lexperiments;
var abc = laboratory.MemberInfo.FromSqlRaw("EXECUTE dbo.sp_ShowParticipantsInExp {0}", member.Id).ToList();
//for (int i = 0; i < Lexperiments.Count(); i++)
//{
// Lexperiments[i].Leader = laboratory.MemberInfo.First(x => x.Id == Lexperiments[i].LeaderId);
// Lexperiments[i].Participation = abc.Where(x => x.ExpId == Lexperiments[i].Id).ToList();
// Lexperiments[i].Finished = laboratory.Finished.First(x => x.ExpId == Lexperiments[i].Id);
// //Lexperiments[i].progress_time();
// for (int j = 0; j < Lexperiments[i].Participation.Count; j++)
// {
// Lexperiments[i].Participation.ElementAt(j).Mem = laboratory.MemberInfo.First(x => x.Id == Lexperiments[i].Participation.ElementAt(j).MemId);
// }
//}
int m = 0;
for (int i = 0; i < Lexperiments.Count(); i++)
{
Lexperiments[i].Leader = laboratory.MemberInfo.First(x => x.Id == Lexperiments[i].LeaderId);
Lexperiments[i].Finished = laboratory.Finished.First(x => x.ExpId == Lexperiments[i].Id);
for (int j = 0; j < Lexperiments[i].Participants; j++)
{
Lexperiments[i].Participation.Add(new Models.Participation());
Lexperiments[i].Participation.ElementAt(j).Mem = abc[m++];
}
}
if (member.Id == "LM01")
{
manager manager = new manager();
manager.Show();
}
}
