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