public void Then_Expected_Results_Are_Returned() { Result.Should().NotBeNull(); (Result as ViewResult).Model.Should().NotBeNull(); var model = (Result as ViewResult).Model as ChangeComponentAchievementsViewModel; model.ProfileId.Should().Be(ProfileId); // Back link model.BackLink.Should().NotBeNull(); model.BackLink.RouteName.Should().Be(RouteConstants.RequestSoaCheckAndSubmit); model.BackLink.RouteAttributes.Count.Should().Be(1); model.BackLink.RouteAttributes.TryGetValue(Constants.ProfileId, out string routeValue); routeValue.Should().Be(ProfileId.ToString()); }
public void Then_Returns_Expected_Results() { Result.Should().NotBeNull(); (Result as ViewResult).Model.Should().NotBeNull(); var model = (Result as ViewResult).Model as QueryEnglishAndMathsViewModel; model.ProfileId.Should().Be(mockresult.ProfileId); model.Name.Should().Be(mockresult.Name); model.BackLink.Should().NotBeNull(); model.BackLink.RouteName.Should().Be(RouteConstants.LearnerRecordDetails); model.BackLink.RouteAttributes.Count.Should().Be(1); model.BackLink.RouteAttributes.TryGetValue(Constants.ProfileId, out string routeValue); routeValue.Should().Be(ProfileId.ToString()); }
public string GetProperty(string propertyName, string format, System.Globalization.CultureInfo formatProvider, Entities.Users.UserInfo accessingUser, Scope accessLevel, ref bool propertyNotFound) { string OutputFormat = string.Empty; if (format == string.Empty) { OutputFormat = "g"; } else { OutputFormat = format; } propertyName = propertyName.ToLowerInvariant(); switch (propertyName) { case "journalid": return(PropertyAccess.FormatString(JournalId.ToString(), format)); case "journaltypeid": return(PropertyAccess.FormatString(JournalTypeId.ToString(), format)); case "profileid": return(PropertyAccess.FormatString(ProfileId.ToString(), format)); case "socialgroupid": return(PropertyAccess.FormatString(SocialGroupId.ToString(), format)); case "datecreated": return(PropertyAccess.FormatString(DateCreated.ToString(), format)); case "title": return(PropertyAccess.FormatString(Title, format)); case "summary": return(PropertyAccess.FormatString(Summary, format)); case "body": return(PropertyAccess.FormatString(Body, format)); case "timeframe": return(PropertyAccess.FormatString(TimeFrame, format)); } propertyNotFound = true; return(string.Empty); }
/// <summary> /// Escreve os dados no XML. /// </summary> /// <param name="writer"></param> void IXmlSerializable.WriteXml(System.Xml.XmlWriter writer) { writer.WriteElementString("ProfileId", ProfileId.ToString()); writer.WriteElementString("UserName", this.UserName); writer.WriteElementString("FullName", this.FullName); writer.WriteElementString("SearchMode", this.SearchMode.ToString()); writer.WriteDateTimeOffset(LastActivityDate, "LastActivityDate"); writer.WriteDateTimeOffset(LastUpdatedDate, "LastUpdatedDate"); writer.WriteStartElement("Source", null); if (Source != null) { ((IXmlSerializable)Source).WriteXml(writer); } writer.WriteEndElement(); writer.WriteStartElement("IsAnonymous", null); writer.WriteValue(IsAnonymous); writer.WriteEndElement(); writer.WriteStartElement("MarkGroupId"); if (MarkGroupId.HasValue) { writer.WriteValue(MarkGroupId.Value); } writer.WriteEndElement(); writer.WriteStartElement("SellerTreeId"); if (SellerTreeId.HasValue) { writer.WriteValue(SellerTreeId.Value); } writer.WriteEndElement(); writer.WriteStartElement("IntermediateId"); if (IntermediateId.HasValue) { writer.WriteValue(IntermediateId.Value); } writer.WriteEndElement(); }
/// <summary> /// Escreve os dados da instancia no xml. /// </summary> /// <param name="writer"></param> void IXmlSerializable.WriteXml(System.Xml.XmlWriter writer) { writer.WriteElementString("DefaultValueGroupId", DefaultValueGroupId.ToString()); writer.WriteElementString("FullName", FullName); writer.WriteElementString("GroupRoleId", GroupRoleId.ToString()); writer.WriteStartElement("IsAnonymous"); writer.WriteValue(IsAnonymous); writer.WriteEndElement(); writer.WriteElementString("SearchMode", SearchMode.ToString()); writer.WriteDateTimeOffset(LastActivityDate, "LastActivityDate"); writer.WriteDateTimeOffset(LastUpdatedDate, "LastUpdatedDate"); writer.WriteElementString("ProfileId", ProfileId.ToString()); writer.WriteStartElement("Properties"); if (Properties != null) { var serializer = new XmlSerializer(typeof(ProfileProperty), new XmlRootAttribute("ProfileProperty")); foreach (IXmlSerializable i in Properties) { serializer.Serialize(writer, i); } } writer.WriteEndElement(); writer.WriteStartElement("RoleSet"); if (RoleSet != null) { ((IXmlSerializable)RoleSet).WriteXml(writer); } writer.WriteEndElement(); writer.WriteStartElement("Source"); if (Source != null) { ((IXmlSerializable)Source).WriteXml(writer); } writer.WriteEndElement(); writer.WriteElementString("SourceId", SourceId.ToString()); writer.WriteElementString("UserId", UserId.ToString()); writer.WriteElementString("UserName", UserName); writer.WriteStartElement("MarkGroupId"); if (MarkGroupId.HasValue) { writer.WriteValue(MarkGroupId.Value); } writer.WriteEndElement(); writer.WriteStartElement("SellerTreeId"); if (SellerTreeId.HasValue) { writer.WriteValue(SellerTreeId.Value); } writer.WriteEndElement(); writer.WriteStartElement("IntermediateId"); if (IntermediateId.HasValue) { writer.WriteValue(IntermediateId.Value); } writer.WriteEndElement(); }
/// <summary> /// Saves the current profile, existing or newly created. /// </summary> /// <param name="caller"></param> private void SaveCurrentProfile(string caller) { SecurityController sc = new SecurityController(); string user = sc.GetUserName(); if (!String.IsNullOrEmpty(this._ptProfileId.Value)) { ProfileId = Int32.Parse(this._ptProfileId.Value); } if (this._visitTypeStage.Value != "0") { VisitTypeId = Int32.Parse(this._visitTypeStage.Value); } PatientEducationDa da = new PatientEducationDa(); List <string> checkedPartsList = new List <string>(); foreach (TreeNode sectionNode in contentTV.Nodes) { foreach (TreeNode topicNode in sectionNode.ChildNodes) { foreach (TreeNode subTopicNode in topicNode.ChildNodes) { if (subTopicNode.Checked) { checkedPartsList.Add(subTopicNode.Value); } } } } if (ProfileId > 0) { DataTable dbProfilePartsDt = da.GetProfileDocPartsByProfileId(ProfileId); // Delete existing profile parts that have been deselected, // and update the list of actual new parts to be saved later on. foreach (DataRow dr in dbProfilePartsDt.Rows) { string stId = dr[PatientEdProfileDocPart.SubTopicId].ToString(); if (!checkedPartsList.Contains(stId)) { //delete this profile doc part from the db da.DeleteProfileDocPartByProfileIdAndSubTopicId(ProfileId, Int32.Parse(stId)); } else { //remove it from the list of checked parts, as we have confirmed it is already in the db checkedPartsList.Remove(stId); } } PatientEdProfile profileBiz = new PatientEdProfile(); profileBiz.Get(ProfileId); profileBiz[PatientEdProfile.UpdatedBy] = user; profileBiz[PatientEdProfile.UpdatedTime] = DateTime.Now.ToString(); if (caller == "print") { profileBiz[PatientEdProfile.LastPrintedBy] = user; profileBiz[PatientEdProfile.LastPrintedTime] = DateTime.Now.ToString(); } profileBiz.Save(); } else { // Saving a brand new profile. SessionHandler sh = new SessionHandler(Session); int ptId = sh.GetPatientId(); PatientEdProfile profile = new PatientEdProfile(); profile[PatientEdProfile.PatientId] = ptId.ToString(); if (this._visitTypeStage.Value != "0") { profile[PatientEdProfile.ProfileVisitTypeId] = VisitTypeId; } if (this.ddlDiseaseProfile.SelectedIndex > 0) { profile[PatientEdProfile.ProfileDiseaseId] = DiseaseId; } string profileDate = DateTime.Now.ToString(); profile[PatientEdProfile.ProfileCreateDate] = profileDate; profile[PatientEdProfile.EnteredBy] = user; profile[PatientEdProfile.EnteredTime] = profileDate; profile[PatientEdProfile.UpdatedBy] = user; profile[PatientEdProfile.UpdatedTime] = profileDate; if (caller == "print") { profile[PatientEdProfile.LastPrintedBy] = user; profile[PatientEdProfile.LastPrintedTime] = DateTime.Now.ToString(); } profile.Save(); ProfileId = Int32.Parse(profile[PatientEdProfile.ProfileId].ToString()); LoadListOfProfilesTable(ptId); ShowProfileLog(true); } // Add the new profile parts to this profile document foreach (string profilePart in checkedPartsList) { PatientEdProfileDocPart dp = new PatientEdProfileDocPart(); dp[PatientEdProfileDocPart.ProfileId] = ProfileId.ToString(); dp[PatientEdProfileDocPart.SubTopicId] = Int32.Parse(profilePart); dp[PatientEdProfileDocPart.ProfileDocPartVersionNumber] = "1.0"; dp[PatientEdProfileDocPart.ProfileDocPartOrderNumber] = "1"; dp.Save(); } LoadExistingProfile(); GetRootNodes(); this._callbackType.Value = String.Empty; }
private void FillGrid() { using (PriemEntities context = new PriemEntities()) { //стартовый микро-запрос количества людей по фильтру string query = @"SELECT COUNT(DISTINCT extAbit.PersonId) FROM ed.extAbit WHERE extAbit.StudyLevelGroupId=1 AND FacultyId=" + FacultyId.ToString() + " "; string where = ""; if (LicenseProgramId != null) { where += " AND extAbit.LicenseProgramId=" + LicenseProgramId.ToString(); } if (ObrazProgramId != null) { where += " AND extAbit.ObrazProgramId=" + ObrazProgramId.ToString(); } if (ProfileId != null) { where += " AND extAbit.ProfileId='" + ProfileId.ToString() + "'"; } if (StudyFormId != null) { where += " AND extAbit.StudyFormId=" + StudyFormId.ToString(); } if (StudyBasisId != null) { where += " AND extAbit.StudyBasisId=" + StudyBasisId.ToString(); } int cnt = (int)MainClass.Bdc.GetValue(query + where); Watch wc; if (cnt > 0) { wc = new Watch(cnt); wc.Show(); } else { wc = null; return; } query = @" SELECT DISTINCT extAbit.PersonId, extAbit.FIO, EgeExamName.Name, hlpStatMaxApprovedEgeMarks.Value, (CASE WHEN hlpStatMaxApprovedEgeMarks.EgeExamNameId IN (11, 12, 13, 14) THEN 1 ELSE 0 END) AS ForeignLang FROM ed.extAbit INNER JOIN ed.extExamInEntry ON extExamInEntry.EntryId = extAbit.EntryId INNER JOIN ed.EgeToExam ON EgeToExam.ExamId = extExamInEntry.ExamId INNER JOIN ed.EgeExamName ON EgeExamName.Id = EgeToExam.EgeExamNameId INNER JOIN ed.hlpStatMaxApprovedEgeMarks ON hlpStatMaxApprovedEgeMarks.PersonId = extAbit.PersonId AND hlpStatMaxApprovedEgeMarks.EgeExamNameId = EgeExamName.Id WHERE extAbit.StudyLevelGroupId=1 AND extAbit.FacultyId=" + FacultyId.ToString() + " "; where = ""; if (LicenseProgramId != null) { where += " AND extAbit.LicenseProgramId=" + LicenseProgramId.ToString(); } if (ObrazProgramId != null) { where += " AND extAbit.ObrazProgramId=" + ObrazProgramId.ToString(); } if (ProfileId != null) { where += " AND extAbit.ProfileId='" + ProfileId.ToString() + "'"; } if (StudyFormId != null) { where += " AND extAbit.StudyFormId=" + StudyFormId.ToString(); } if (StudyBasisId != null) { where += " AND extAbit.StudyBasisId=" + StudyBasisId.ToString(); } DataTable tblPersons = MainClass.Bdc.GetDataSet(query + where + " ORDER BY hlpStatMaxApprovedEgeMarks.Value ").Tables[0]; var p_RAW = (from DataRow rw in tblPersons.Rows select new { PersonId = rw.Field <Guid>("PersonId"), FIO = rw.Field <string>("FIO"), ExamName = rw.Field <string>("Name"), IsForeign = rw.Field <int>("ForeignLang") == 1 ? true : false, Value = rw.Field <int>("Value") }); query = @" SELECT PersonId, (case when extAbit.CompetitionId IN (1,2,7,8) then 1 else 0 end) AS VK FROM ed.extAbit WHERE extAbit.StudyLevelGroupId=1 AND extAbit.BackDoc=0 AND extAbit.FacultyId=" + FacultyId.ToString() + " "; where = ""; if (LicenseProgramId != null) { where += " AND extAbit.LicenseProgramId=" + LicenseProgramId.ToString(); } if (ObrazProgramId != null) { where += " AND extAbit.ObrazProgramId=" + ObrazProgramId.ToString(); } if (ProfileId != null) { where += " AND extAbit.ProfileId='" + ProfileId.ToString() + "'"; } if (StudyFormId != null) { where += " AND extAbit.StudyFormId=" + StudyFormId.ToString(); } if (StudyBasisId != null) { where += " AND extAbit.StudyBasisId=" + StudyBasisId.ToString(); } DataTable tblVKs = MainClass.Bdc.GetDataSet(query + where).Tables[0]; var VKs = from DataRow rw in tblVKs.Rows select new { PersonId = rw.Field <Guid>("PersonId"), VK = rw.Field <int>("VK") == 1 ? true : false }; List <Guid> persons = p_RAW.Select(x => x.PersonId).Distinct().ToList(); query = @"SELECT DISTINCT EgeExamName.Name FROM ed.extExamInEntry INNER JOIN ed.EgeToExam ON EgeToExam.ExamId = extExamInEntry.ExamId INNER JOIN ed.EgeExamName ON EgeExamName.Id = EgeToExam.EgeExamNameId"; where = " WHERE extExamInEntry.FacultyId=" + FacultyId.ToString() + " "; if (LicenseProgramId != null) { where += " AND extExamInEntry.LicenseProgramId=" + LicenseProgramId.ToString(); } if (ObrazProgramId != null) { where += " AND extExamInEntry.ObrazProgramId=" + ObrazProgramId.ToString(); } if (ProfileId != null) { where += " AND extExamInEntry.ProfileId='" + ProfileId.ToString(); } if (StudyFormId != null) { where += " AND extExamInEntry.StudyFormId=" + StudyFormId.ToString(); } if (StudyBasisId != null) { where += " AND extExamInEntry.StudyBasisId=" + StudyBasisId.ToString(); } DataTable tblExams = MainClass.Bdc.GetDataSet(query + where).Tables[0]; dgv.DataSource = null; DataTable tblSource = new DataTable(); tblSource.Columns.Add("Id", typeof(Guid)); tblSource.Columns.Add("ФИО", typeof(string)); foreach (DataRow rw in tblExams.Rows) { tblSource.Columns.Add(rw.Field <string>("Name"), typeof(int)); } tblSource.Columns.Add("Сумма", typeof(int)); tblSource.Columns.Add("Green", typeof(bool)); Guid PersonId; foreach (Guid pId in persons) { var rwData = from x in p_RAW where x.PersonId == pId select new { x.PersonId, x.FIO, x.ExamName, x.Value, x.IsForeign }; DataRow rw = tblSource.NewRow(); PersonId = rwData.First().PersonId; rw["Id"] = PersonId; rw["ФИО"] = rwData.First().FIO; foreach (var ex in rwData.Select(x => new { x.ExamName, x.Value })) { rw[ex.ExamName] = ex.Value; } rw["Сумма"] = rwData.Where(x => x.IsForeign == false).Select(x => x.Value).DefaultIfEmpty(0).Sum() + rwData.Where(x => x.IsForeign == true).Select(x => x.Value).DefaultIfEmpty(0).Max(); rw["Green"] = VKs.Where(x => x.PersonId == PersonId && x.VK == true).Select(x => x.VK).DefaultIfEmpty(false).First(); tblSource.Rows.Add(rw); wc.PerformStep(); } query = "SELECT SUM(KCP) FROM ed.qEntry WHERE StudyLevelGroupId=1 AND FacultyId=" + FacultyId.ToString() + " "; where = ""; if (LicenseProgramId != null) { where += " AND LicenseProgramId=" + LicenseProgramId.ToString(); } if (ObrazProgramId != null) { where += " AND ObrazProgramId=" + ObrazProgramId.ToString(); } if (ProfileId != null) { where += " AND ProfileId='" + ProfileId.ToString(); } if (StudyFormId != null) { where += " AND StudyFormId=" + StudyFormId.ToString(); } if (StudyBasisId != null) { where += " AND StudyBasisId=" + StudyBasisId.ToString(); } int kcp = (int)MainClass.Bdc.GetValue(query + where); tbKCP.Text = kcp.ToString(); var p_sums = (from DataRow rw in tblSource.Rows select new { Id = rw.Field <Guid>("Id"), Sum = rw.Field <int>("Сумма") }).OrderByDescending(x => x.Sum); int i = VKs.Where(x => x.VK == true).Select(x => x.PersonId).Distinct().Count(); foreach (var p in p_sums) { if (++i > kcp) { break; } for (int j = 0; j < tblSource.Rows.Count; j++) { if (tblSource.Rows[j].Field <Guid>("Id") == p.Id) { tblSource.Rows[j].SetField <bool>("Green", true); break; } } } dgv.DataSource = tblSource; dgv.Columns["Id"].Visible = false; dgv.Columns["Green"].Visible = false; dgv.Sort(dgv.Columns["Сумма"], ListSortDirection.Ascending); dgv.Columns["ФИО"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; wc.Close(); wc = null; } }
public override string ToString() { return("SimpleDescriptor [endpoint=" + Endpoint + ", profileId=" + ProfileId.ToString("X4") + ", deviceId=" + DeviceId + ", deviceVersion=" + DeviceVersion + ", inputClusterList=" + string.Join(", ", InputClusterList) + ", outputClusterList=" + string.Join(", ", OutputClusterList) + "]"); }
public OLB(ProfileId Position) { this.Position = Position; this.Pos = Position.ToString(); }