public static Restriction ToRestriction(this RestrictionModel restriction) { return(new Restriction() { Type = (RestrictionType)restriction.Type, Value = restriction.Value, }); }
protected override RestrictionModel MapRestriction(DataRow row) { var restriction = new RestrictionModel(); restriction.CollectionName = row.GetString("CollectionName"); restriction.RestrictionName = row.GetString("RestrictionName"); restriction.RestrictionNumber = row.GetInt("RestrictionNumber"); return(restriction); }
public void AddEmployeeForm_AddRestriction(object e) { DateTime today = DateTime.Today; var newRestriction = new RestrictionModel(); newRestriction.Name = _selectedRestriction.Name; newRestriction.EndDate = _newRestrictionEndDate; newRestriction.Id = _selectedRestriction.Id; newRestriction.BeginDate = today; Restrictions.Add(newRestriction); }
public static async Task <ObservableCollection <EmployeeModel> > EmployeeQueryAsync() { using (var connection = new System.Data.SqlClient.SqlConnection(CnnString(database))) { var employees = new Dictionary <int, EmployeeModel>(); await connection.QueryAsync <EmployeeModel>("dbo.spGetEmployeeData_All", new[] { typeof(EmployeeModel), typeof(EmailModel), typeof(JobTitleModel), typeof(PhoneModel), typeof(DepartmentModel), typeof(EmployeeStatusModel), typeof(CitationModel), typeof(CertificationModel), typeof(EquipmentAssignmentRecordModel), typeof(RestrictionModel) } , obj => { EmployeeModel employeeModel = obj[0] as EmployeeModel; EmailModel emailModel = obj[1] as EmailModel; JobTitleModel titleModel = obj[2] as JobTitleModel; PhoneModel phoneModel = obj[3] as PhoneModel; DepartmentModel departmentModel = obj[4] as DepartmentModel; EmployeeStatusModel statusModel = obj[5] as EmployeeStatusModel; CitationModel citationModel = obj[6] as CitationModel; CertificationModel certificationModel = obj[7] as CertificationModel; EquipmentAssignmentRecordModel equipmentAssignmentRecord = obj[8] as EquipmentAssignmentRecordModel; RestrictionModel restrictionModel = obj[9] as RestrictionModel; //employeemodel var employeeEntity = new EmployeeModel(); if (!employees.TryGetValue(employeeModel.Id, out employeeEntity)) { employees.Add(employeeModel.Id, employeeEntity = employeeModel); } //list<emailmodel> if (employeeEntity.Emails == null) { employeeEntity.Emails = new ObservableCollection <EmailModel>(); } if (emailModel != null) { if (!employeeEntity.Emails.Any(x => x.Id == emailModel.Id)) { employeeEntity.Emails.Add(emailModel); } } //phonemodel if (employeeEntity.Phones == null) { employeeEntity.Phones = new ObservableCollection <PhoneModel>(); } if (phoneModel != null) { if (!employeeEntity.Phones.Any(x => x.Id == phoneModel.Id)) { employeeEntity.Phones.Add(phoneModel); } } //title if (employeeEntity.JobTitle == null) { if (titleModel != null) { employeeEntity.JobTitle = titleModel; } } //department if (employeeEntity.Department == null) { if (departmentModel != null) { employeeEntity.Department = departmentModel; } } //status if (employeeEntity.Status == null) { if (statusModel != null) { employeeEntity.Status = statusModel; } } //citation if (employeeEntity.Citations == null) { employeeEntity.Citations = new ObservableCollection <CitationModel>(); } if (citationModel != null) { if (!employeeEntity.Citations.Any(x => x.Id == citationModel.Id)) { employeeEntity.Citations.Add(citationModel); } } //certification if (employeeEntity.Certifications == null) { employeeEntity.Certifications = new ObservableCollection <CertificationModel>(); } if (certificationModel != null) { if (!employeeEntity.Certifications.Any(x => x.Id == certificationModel.Id)) { employeeEntity.Certifications.Add(certificationModel); } } //restriction if (employeeEntity.Restrictions == null) { employeeEntity.Restrictions = new ObservableCollection <RestrictionModel>(); } if (restrictionModel != null) { if (!employeeEntity.Restrictions.Any(x => x.Id == restrictionModel.Id)) { employeeEntity.Restrictions.Add(restrictionModel); } } //equipment record if (employeeEntity.EquipmentAssignments == null) { employeeEntity.EquipmentAssignments = new ObservableCollection <EquipmentAssignmentRecordModel>(); } if (equipmentAssignmentRecord != null) { if (!employeeEntity.EquipmentAssignments.Any(x => x.Id == equipmentAssignmentRecord.Id)) { employeeEntity.EquipmentAssignments.Add(equipmentAssignmentRecord); } } return(employeeEntity); });; var result = employees.Values.ToList(); var employeeCollection = new ObservableCollection <EmployeeModel>(result); return(employeeCollection); } }