public static List <Appointment> GetApptConsult(string epi, CacheADOConnection con) { var apps = new List <Appointment>(); var query = QueryString.GetApptConsult(epi); try { using (var cmd = new CacheCommand(query.Item1, con)) { foreach (var pair in query.Item2) { cmd.AddInputParameters(new { key = pair.Value }); } using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { var appDatetime = string.IsNullOrEmpty(reader["AS_Date"].ToString()) ? new Tuple <string, string>("", "") : new Tuple <string, string>(reader["AS_Date"].ToString(), reader["AS_SessStartTime"].ToString()); var appDate = string.IsNullOrEmpty(appDatetime.Item1) ? "" : DateTime.Parse(appDatetime.Item1).ToString("dd/MM/yyyy"); var appTime = string.IsNullOrEmpty(appDatetime.Item2) ? "" : DateTime.Parse(appDatetime.Item2).ToString("HH:mm"); var app = new Appointment() { AS_Date = appDate, AS_SessStartTime = appTime, APPT_Status = reader["APPT_Status"].ToString(), PAADM_VisitStatus = reader["PAADM_VisitStatus"].ToString(), CTLOC_Code = reader["CTLOC_Code"].ToString(), CTLOC_Desc = reader["CTLOC_Desc"].ToString(), CTPCP_Desc = reader["CTPCP_Desc"].ToString(), SER_Desc = reader["SER_Desc"].ToString() }; apps.Add(app); } } } apps = apps.OrderBy(a => string.IsNullOrEmpty(a.AS_Date) ? (DateTime?)null : DateTime.ParseExact(a.AS_Date, "dd/MM/yyyy", null)) .ThenBy(a => string.IsNullOrEmpty(a.AS_SessStartTime) ? (DateTime?)null : DateTime.ParseExact(a.AS_SessStartTime, "HH:mm", null)).ToList(); } catch (Exception) { return(apps); } return(apps); }
public static Tuple <User, string> GetUser(string username, string password) { var model = new User(); string message = string.Empty; var query = TrakCareQuery.GetUser(username); using (CacheConnection con = new CacheConnection(Constants.Cache)) { con.Open(); using (CacheCommand cmd = new CacheCommand(query.Item1, con)) { foreach (KeyValuePair <string, string> pair in query.Item2) { var key = pair.Key; cmd.AddInputParameters(new { key = pair.Value }); } using (var reader = cmd.ExecuteReader()) { if (reader.Read()) { User user = new User() { SSUSR_Initials = reader["SSUSR_Initials"].ToString(), SSUSR_Name = reader["SSUSR_Name"].ToString(), SSUSR_Password = reader["SSUSR_Password"].ToString() }; if (Helper.CheckPassword(user, password)) { model = user; message = "Login Success."; } else { message = "Login fail."; } } } } } return(new Tuple <User, string>(model, message)); }
public static IEnumerable <AlertMsg> GetAlertMsg(string hn, CacheConnection con) { List <AlertMsg> alertMsgs = new List <AlertMsg>(); var query = QueryString.GetAlertMsg(hn); try { using (var cmd = new CacheCommand(query.Item1, con)) { foreach (KeyValuePair <string, string> pair in query.Item2) { cmd.AddInputParameters(new { key = pair.Value }); } using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { AlertMsg result = new AlertMsg() { ALERTCAT_Code = reader["ALERTCAT_Code"].ToString(), ALERTCAT_Desc = reader["ALERTCAT_Desc"].ToString(), ALM_Message = reader["ALM_Message"].ToString(), ALM_Status = reader["ALM_Status"].ToString() }; alertMsgs.Add(result); } } } } catch (Exception e) { Console.WriteLine(e); throw; } return(alertMsgs); }
public static PatientCategory GetPatientCategory(string hn, CacheConnection con) { var result = new PatientCategory(); var query = QueryString.GetPatientCategory(hn); try { using (var cmd = new CacheCommand(query.Item1, con)) { foreach (var pair in query.Item2) { cmd.AddInputParameters(new { key = pair.Value }); } using (var reader = cmd.ExecuteReader()) { if (reader.Read()) { result = new PatientCategory() { PCAT_CODE = reader["PCAT_CODE"].ToString(), PCAT_Desc = reader["PCAT_Desc"].ToString() }; return(result); } } } } catch (Exception e) { Console.WriteLine(e); throw; } return(result); }
/// <summary> /// Execute command string /// Close database connection /// </summary> /// <param name="cmdString"></param> /// <param name="conString"></param> /// <param name="hn"></param> /// <returns>Datatable</returns> public static DataTable DtBindDataCommandWithValuesMultiple(string cmdString, CacheConnection con, string hn) { var dt = new DataTable(); try { using (var cmd = new CacheCommand(cmdString, con)) { cmd.AddInputParameters(new { PAPMI_No = hn, PAPMI_No1 = hn }); using (var reader = cmd.ExecuteReader()) { dt.Load(reader); } } } catch (Exception e) { Console.WriteLine(e); throw; } return(dt); }
/// <summary> /// Execute command string /// Close database connection /// </summary> /// <param name="cmdString"></param> /// <param name="conString"></param> /// <param name="dics"></param> /// <returns>DataTable</returns> public static DataTable DtBindDataCommandWihDictionary(string cmdString, string conString, Dictionary <string, string> dics) { var dt = new DataTable(); using (var con = ConnectCache.DBUtils.GetDBConnection()) { try { con.Open(); using (var cmd = new CacheCommand(cmdString, con)) { foreach (KeyValuePair <string, string> pair in dics) { var key = pair.Key; cmd.AddInputParameters(new { key = pair.Value }); } using (var reader = cmd.ExecuteReader()) { dt.Load(reader); } } } catch (Exception e) { Console.WriteLine(e); throw; } finally { con.Close(); con.Dispose(); } } return(dt); }
public static PatientRegisLoc GetRegisConsultLocation(string hn) { var regisLocList = GetPatientRegisLoc(hn).Item2; var loclist = new List <string>(); var locs = ""; if (!hn.Contains("-")) { hn = Regex.Replace(hn, @"^(.{2})(.{2})(.{6})$", "$1-$2-$3"); } var query = QueryString.GetRegisConsultLocation(hn); var con = ConnectCache.DBUtils.GetDBConnection(); try { con.Open(); using (var cmd = new CacheCommand(query.Item1, con)) { foreach (var pair in query.Item2) { cmd.AddInputParameters(new { key = pair.Value }); } using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { var loc = string.Equals(reader["LocRegis"].ToString(), reader["LocConsult"].ToString(), StringComparison.CurrentCultureIgnoreCase) ? new Tuple <bool, string, string>(true, reader["LocRegis"].ToString(), "") : new Tuple <bool, string, string>(false, reader["LocRegis"].ToString(), reader["LocConsult"].ToString()); if (loc.Item1) { loclist.Add(loc.Item2); } else { loclist.Add(loc.Item2); loclist.Add(loc.Item3); } } } } } catch (Exception) { throw; } foreach (var regisLoc in regisLocList) { loclist.Add(regisLoc.CTLOC_Code); } loclist = loclist.Distinct().ToList(); locs = string.Join(",", loclist); var locRegisConsult = new PatientRegisLoc() { Papmi_No = hn, RegisLoc = locs }; return(locRegisConsult); }
public static Tuple <PatientRegisLoc, List <LocRegis> > GetPatientRegisLoc(string hn, string loc = "") { var lstLocRegis = new List <LocRegis>(); var locs = Empty; if (!hn.Contains("-")) { hn = Regex.Replace(hn, @"^(.{2})(.{2})(.{6})$", "$1-$2-$3"); } var query = QueryString.GetPatientRegisLoc(hn); var con = ConnectCache.DBUtils.GetDBConnection(); try { con.Open(); using (var cmd = new CacheCommand(query.Item1, con)) { foreach (var pair in query.Item2) { cmd.AddInputParameters(new { key = pair.Value }); } using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { var newRegis = string.Equals(reader["CTLOC_Code"].ToString(), loc, StringComparison.CurrentCultureIgnoreCase); locs += IsNullOrEmpty(locs) ? reader["CTLOC_Code"].ToString() : $"|{reader["CTLOC_Code"].ToString()}"; var locRegis = new LocRegis() { CTLOC_Code = reader["CTLOC_Code"].ToString(), NewRegis = newRegis }; lstLocRegis.Add(locRegis); } } } } catch (Exception e) { Console.WriteLine(e); throw; } finally { con.Close(); con.Dispose(); } var patientRegisLoc = new PatientRegisLoc() { Papmi_No = hn, RegisLoc = locs }; return(new Tuple <PatientRegisLoc, List <LocRegis> >(patientRegisLoc, lstLocRegis)); }