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(); } }