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} */ }