public BlockTraineeListViewModel(BlockTraineeBussiness bussiness) { _bussiness = bussiness; _bussiness.LoadTraineesEvnet += trainees => { Trainees.Clear(); if (trainees != null) { trainees.ForEach(t => { Trainees.Add(new TraineeViewModel(t, false)); Trainees.Last().OperateTraineeEvent += OnOperateTrainee; }); } }; _bussiness.TraineeChangedEvent += (operation, trainee, newIndex) => { switch (operation) { case OperationType.Add: Trainees.Add(new TraineeViewModel(trainee, false)); Trainees.Last().OperateTraineeEvent += OnOperateTrainee; break; case OperationType.Update: Trainees.Where(t => t.TraineeID == trainee.TraineeIDForShown).First().TraineeName = trainee.TraineeName; break; case OperationType.Delete: Trainees.Remove(Trainees.Where(t => t.TraineeID == trainee.TraineeIDForShown).First()); break; } }; }
public void AddTrainee(ITrainee trainee) { if (!Trainees.Contains(trainee)) { Trainees.Add(trainee); } }
public Trainees GetRegisteredTrainees(string training_id) { Trainees trainees = new Trainees(); try { string query = $"select dsto_questionaire.* from dsto_questionaire inner join dsto_Trainee " + $"on dsto_questionaire.guid = dsto_trainee.yref_questionaire " + $"where dsto_Trainee.yref_training ='{training_id}'"; var table = DbInfo.ExecuteSelectQuery(query); if (table.Rows.Count > 0) { foreach (DataRow row in table.Rows) { Trainee trainee = trainees.Add(); trainee.Questionaire = new Questionaires().Add(); trainee.Questionaire.Key = row["guid"].ToString(); trainee.Questionaire.CreatedBy = row["created_by"].ToString(); trainee.Questionaire.OID = int.Parse(row["OID"].ToString()); trainee.Questionaire.Deleted = bool.Parse(row["deleted"].ToString()); trainee.Questionaire.Name = new SectionProvider(DbInfo).QuestionaireIdentification(row["yref_template"].ToString(), row["guid"].ToString()); } } } catch (Exception ex) { throw ex; } return(trainees); }
public Trainees GetTrainees(string training_id) { Trainees trainees = new Trainees(); try { string query = $"select * from dsto_Trainee where yref_training = '{training_id}' and Deleted=0"; var table = DbInfo.ExecuteSelectQuery(query); if (table.Rows.Count > 0) { foreach (DataRow row in table.Rows) { Trainee trainee = trainees.Add(); trainee.Key = Convert.ToString(row["guid"]); trainee.OID = Convert.ToInt32(row["OID"]); trainee.FarmerKey = Convert.ToString(row["yref_questionaire"]); trainee.Deleted = bool.Parse(row["deleted"].ToString()); trainee.CreatedBy = Convert.ToString(row["created_by"]); trainee.TrainingId = Convert.ToString(row["yref_training"]); } } return(trainees); } catch (Exception ex) { throw ex; } }
public RegularTraineeListViewModel(RegularTraineeBussiness bussiness) : base() { _bussiness = bussiness; _bussiness.LoadTraineesEvent += trainees => { Trainees.Clear(); if (trainees != null) { trainees.ForEach(t => { Trainees.Add(new TraineeViewModel(t, true)); Trainees.Last().OperateTraineeEvent += OnOperateTrainee; }); } }; _bussiness.TraineeChangedEvent += (operation, trainee, newIndex) => { switch (operation) { case OperationType.Add: Trainees.Add(new TraineeViewModel(trainee, true)); Trainees.Last().OperateTraineeEvent += OnOperateTrainee; break; case OperationType.Update: if (newIndex == -1) { //只是更新信息 Trainees.Where(t => t.TraineeID == trainee.TraineeIDForShown).First().TraineeName = trainee.TraineeName; } else { //删除或者恢复 Trainees.Remove(Trainees.Where(t => t.TraineeID == trainee.TraineeIDForShown).First()); Trainees.Insert(newIndex, new TraineeViewModel(trainee, true)); Trainees[newIndex].OperateTraineeEvent += OnOperateTrainee; } break; case OperationType.Delete: Trainees.Remove(Trainees.Where(t => t.TraineeID == trainee.TraineeIDForShown).First()); break; } }; }