public async Task <Pat> GetPatient(int id)
{
using (var conn = new SqlConnection(_connection))
{
using (var com = new SqlCommand())
{
com.Connection = conn;
com.CommandText = @"SELECT idpatient
FROM Patient WHERE idpatient = @pat";
com.Parameters.AddWithValue("pat", id);
conn.Open();
try
{
var reader = await com.ExecuteReaderAsync();
await reader.ReadAsync();
var pati = new Pat
{
IdPatient = int.Parse(reader["idpatient"].ToString()),
};
return(pati);
}
catch (Exception)
{
return(null);
}
}
}
}
public string FormatAsTableRow(string playerName, string role, decimal pts)
{
string[] pgmArray =
{
playerName,
role,
ProjYDp.ToString(CultureInfo.InvariantCulture),
ProjTDp.ToString(CultureInfo.InvariantCulture),
ProjYDr.ToString(CultureInfo.InvariantCulture),
ProjTDr.ToString(CultureInfo.InvariantCulture),
ProjYDc.ToString(CultureInfo.InvariantCulture),
ProjTDc.ToString(CultureInfo.InvariantCulture),
ProjFG.ToString(CultureInfo.InvariantCulture),
ProjPat.ToString(CultureInfo.InvariantCulture),
YDp.ToString(CultureInfo.InvariantCulture),
TDp.ToString(CultureInfo.InvariantCulture),
YDr.ToString(CultureInfo.InvariantCulture),
TDr.ToString(CultureInfo.InvariantCulture),
YDc.ToString(CultureInfo.InvariantCulture),
TDc.ToString(CultureInfo.InvariantCulture),
FG.ToString(CultureInfo.InvariantCulture),
Pat.ToString(CultureInfo.InvariantCulture),
pts.ToString(CultureInfo.InvariantCulture)
};
var html = HtmlLib.TableRow(pgmArray);
return(html);
}
public static PathologyEntity toPathologyEntity(this Pat pat)
{
return(new PathologyEntity()
{
Id = pat.PatOwnId,
PathologyName = pat.PatNam
});
}
public override MSet <string> FreeVars()
{
var fv1 = Expr.FreeVars().Union(ElseExpr.FreeVars());
var fv2 = Guard.FreeVars().Union(ThenExpr.FreeVars());
var fv3 = fv2.Diff(Pat.FreeVars());
return(fv1.Union(fv3));
}
public static bool IsMatch(this string s, Pat pattern)
{
return(CacheMan.Cache(() =>
new Regex(
DictionaryStringPatternSystemTextRegularExpressionsRegex[pattern]),
false,
pattern).IsMatch(s));
}
public string CopyDisplaying()
{
Pat.BeginModifications();
var ss = Pat.StructureSets.First(e => e.Id == SSId);
var d_copy = ss.AddStructure("CONTROL", Displaying.Id + "cp");
d_copy.SegmentVolume = ss.Structures.First(e => e.Id == Displaying.Id);
Sts.Add(new RepStructure(d_copy.Id, d_copy.Color, Helpers.SolveMeshReference(d_copy.MeshGeometry)));
Logger += $"Copied {d_copy.Id} with success";
return(d_copy.Id);
}
public static Pat ToPat(this PathologyEntity pathology, Pat pat = null)
{
if (pat == null)
{
pat = new Pat();
}
pat.PatOwnId = pathology.Id;
pat.PatNam = pathology.PathologyName;
return(pat);
}
/// <summary>
/// 事前オーダー登録(オーダーID返却)
/// </summary>
/// <param name="order"></param>
/// <param name="orderid"></param>
/// <returns>処理結果クラス</returns>
public ResultData SetOrder_Serv(Order order, out int orderid)
{
var ret = new ResultData();
orderid = 0;
try
{
if (order.Key == 0)
{
Search search = new Search();
search.PatID = order.PatID;
Patient[] tmpList = Pat.GetPatientList(search);
if (tmpList == null || tmpList.Length == 0)
{
order.Key = Pat.SetPatient(order);
}
}
else
{
Pat.SetPatient(order);
}
orderid = Orders.SetOrder_RetId(order);
// 事前オーダー登録メソッド呼び出し（内部関数）
if (orderid == 0)
{
ret.Message = "オーダー登録失敗:" + order.PatID + ":" + order.Modality + ":" + order.Date;
}
else
{
ret.Result = true;
}
}
catch (Exception e)
{
LogControl.WriteLog(LogType.ERR, "SetOrder_Serv", e.Message);
ret.Message = e.Message;
}
return(ret);
}
public string FormatActualsAsTableRow(NFLPlayer player)
{
if (player.IsKicker())
{
string[] pgmArray =
{
string.Empty,
string.Empty,
string.Empty,
string.Empty,
string.Empty,
string.Empty,
string.Empty,
string.Empty,
FG.ToString(CultureInfo.InvariantCulture),
Pat.ToString(CultureInfo.InvariantCulture),
FantasyPoints.ToString(),
VarianceOut()
};
var html = HtmlLib.TableRow(pgmArray);
return(html);
}
else
{
string[] pgmArray =
{
string.Empty,
string.Empty,
YDp.ToString(CultureInfo.InvariantCulture),
TDp.ToString(CultureInfo.InvariantCulture),
YDr.ToString(CultureInfo.InvariantCulture),
TDr.ToString(CultureInfo.InvariantCulture),
YDc.ToString(CultureInfo.InvariantCulture),
TDc.ToString(CultureInfo.InvariantCulture),
string.Empty,
string.Empty,
FantasyPoints.ToString(),
VarianceOut()
};
var html = HtmlLib.TableRow(pgmArray);
return(html);
}
}
public int Delete(PathologyEntity pathology)
{
try
{
using (var db = new CroceRossaEntities())
{
Pat pat = db.Pat.First(x => x.PatOwnId == pathology.Id);
if (pat != null)
{
db.Pat.Remove(pat);
db.SaveChanges();
}
return(0);
}
}
catch (Exception)
{
return(-1);
}
}
public ResultData SetPatient_Serv(Patient patient, out int PatKey)
{
var ret = new ResultData();
PatKey = 0;
try
{
PatKey = Pat.SetPatient(patient);
ret.Result = true;
}
catch (Exception e)
{
LogControl.WriteLog(LogType.ERR, "SetPreOrder_Serv", e.Message);
ret.Message = e.Message;
}
return(ret);
}
public string MoveDisplaying(double x, double y, double z)
{
Pat.BeginModifications();
var mmchange = new VVector(x, y, z);
var ss = Pat.StructureSets.First(e => e.Id == SSId);
var wantMove = ss.Structures.First(e => e.Id == Displaying.Id);
Structure dCopy = null;
if (ss.Structures.Any(e => e.Id == Displaying.Id + "mv"))
{
dCopy = ss.Structures.Single(e => e.Id == Displaying.Id + "mv");
}
else
{
dCopy = ss.AddStructure("CONTROL", Displaying.Id + "mv");
}
dCopy.SegmentVolume = new SegShift(mmchange, ss, wantMove).MoveStructure();
Logger += "Moved with success";
Sts.Add(new RepStructure(dCopy.Id, dCopy.Color, Helpers.SolveMeshReference(dCopy.MeshGeometry)));
return(dCopy.Id);
}
/// <summary>
/// 患者一覧取得
/// </summary>
/// <param name="search">検索項目クラス</param>
/// <param name="patientList">o:患者情報一覧</param>
/// <returns>処理結果クラス</returns>
public ResultData GetPatient_Serv(Search search, out Patient[] patientList)
{
var ret = new ResultData();
patientList = null;
try
{
// 事前登録オーダーリスト取得メソッド呼び出し（内部関数）
patientList = Pat.GetPatientList(search);
ret.Result = true;
}
catch (Exception e)
{
LogControl.WriteLog(LogType.ERR, "GetPatient_Serv", e.Message);
ret.Message = e.Message;
}
return(ret);
}
public override MSet <string> FreeVars()
{
return(Pat.FreeVars().Union(new MSet <string>(Name)));
}
public override MSet <string> FreeVars()
{
return(E1.FreeVars().Union(E2.FreeVars().Diff(Pat.FreeVars())));
}
public override string ToString()
{
return(Pat.GetSurnameAndName() + " - "
+ Doc.GetSurnameAndName() + " - " + Date +
" - " + Reason + " - " + Diagnostic);
}
public override MSet <string> FreeVars()
{
return(Pat.FreeVars());
}
public DTPat PatToDTPat(Pat p)
{
throw new NotImplementedException();
}
/// <summary>
/// Gets a list of all Audit Trail entries for a specific User
/// </summary>
/// <param name="userId">The Id of the user to get the Audit Trail entries for</param>
/// <returns>The audit trail</returns>
public List <AuditTrailEntry> GetAudit(string userId)
{
var query = (from u in this.context.Users
join a in this.context.AuditLogs on u.Id equals
(a.UserId == "<unknown>" && a.ObjectType == typeof(User).Name && a.FieldName == "Id" ? a.RecordId
: a.UserId == "<unknown>" && a.ObjectType == typeof(User).Name && a.FieldName == "UserName" ? (from u2 in this.context.Users where u2.UserName == a.RecordId select u2.Id).FirstOrDefault()
: a.UserId)
join targetU in this.context.Users on
(a.ObjectType == typeof(User).Name && a.FieldName == "Id" ? a.RecordId
: a.ObjectType == typeof(User).Name && a.FieldName == "UserName" ? (from u2 in this.context.Users where u2.UserName == a.RecordId select u2.Id).FirstOrDefault()
: null) equals targetU.Id into targetUser
from targetU2 in targetUser.DefaultIfEmpty()
join p in this.context.Patients on
(a.ObjectType == typeof(Patient).Name ? a.RecordId :
a.ObjectType == typeof(Episode).Name ? (from e in this.context.Episodes where e.Id.ToString() == a.RecordId select e.Patient.Id).FirstOrDefault() :
a.ObjectType == typeof(QuestionnaireUserResponseGroup).Name ? (from q in this.context.QuestionnaireUserResponseGroups where q.Id.ToString() == a.RecordId select q.Patient.Id).FirstOrDefault() :
null) equals p.Id into Pat
from p2 in Pat.DefaultIfEmpty()
join q2 in this.context.Questionnaires on
(a.ObjectType == typeof(QuestionnaireUserResponseGroup).Name ? (from q in this.context.QuestionnaireUserResponseGroups where q.Id.ToString() == a.RecordId select q.Questionnaire.Id).FirstOrDefault() :
0) equals q2.Id into questionnaire
from q3 in questionnaire.DefaultIfEmpty()
join ep in this.context.Episodes on
(a.ObjectType == typeof(Episode).Name ? a.RecordId :
null) equals ep.Id.ToString() into episode
from e2 in episode.DefaultIfEmpty()
where u.Id == userId || a.RecordId == userId
select new AuditTrailEntry()
{
User = u, TargetUser = targetU2, AuditLog = a, Patient = p2, Questionnaire = q3, Episode = e2
}).OrderByDescending(a => a.AuditLog.EventDateUTC);
return(query.ToList());
/* LINQPad query
* from u in Users
* join a in AuditLogs on u.Id equals
* (a.UserId == "<unknown>" && a.ObjectType == typeof(User).Name && a.FieldName == "Id" ? a.RecordId
* : a.UserId == "<unknown>" && a.ObjectType == typeof(User).Name && a.FieldName == "UserName" ? (from u2 in Users where u2.UserName == a.RecordId select u2.Id).FirstOrDefault()
* : a.UserId)
*
* join targetU in Users on
* ( a.ObjectType == typeof(User).Name && a.FieldName == "Id" ? a.RecordId
* : a.ObjectType == typeof(User).Name && a.FieldName == "UserName" ? (from u2 in Users where u2.UserName == a.RecordId select u2.Id).FirstOrDefault()
* : null
* ) equals targetU.Id into targetUser
* from targetU2 in targetUser.DefaultIfEmpty()
*
* join p in Patients on
* (a.ObjectType == typeof(Patient).Name ? a.RecordId :
* a.ObjectType == typeof(Episode).Name ? (from e in Episodes where e.Id.ToString() == a.RecordId select e.Patient.Id).FirstOrDefault() :
* a.ObjectType == typeof(QuestionnaireUserResponseGroup).Name ? (from q in QuestionnaireUserResponseGroups where q.Id.ToString() == a.RecordId select q.Patient.Id).FirstOrDefault() :
* null) equals p.Id into Pat
* from p2 in Pat.DefaultIfEmpty()
*
* join q2 in Questionnaires on
* (a.ObjectType == typeof(QuestionnaireUserResponseGroup).Name ? (from q in QuestionnaireUserResponseGroups where q.Id.ToString() == a.RecordId select q.Questionnaire.Id).FirstOrDefault() :
* 0) equals q2.Id into questionnaire
* from q3 in questionnaire.DefaultIfEmpty()
*
* join ep in Episodes on
* ( a.ObjectType == typeof(Episode).Name ? a.RecordId :
* null) equals ep.Id.ToString() into episode
* from e2 in episode.DefaultIfEmpty()
* select new {User = u, TargetUser = targetU2, AuditLog = a, Patient = p2, Questionnaire = q3, Episode = e2}
*/
}
