///<summary>Updates one Patientm in the database.</summary> internal static void Update(Patientm patientm) { string command = "UPDATE patientm SET " + "LName = '" + POut.String(patientm.LName) + "', " + "FName = '" + POut.String(patientm.FName) + "', " + "MiddleI = '" + POut.String(patientm.MiddleI) + "', " + "Preferred = '" + POut.String(patientm.Preferred) + "', " + "PatStatus = " + POut.Int((int)patientm.PatStatus) + ", " + "Gender = " + POut.Int((int)patientm.Gender) + ", " + "Position = " + POut.Int((int)patientm.Position) + ", " + "Birthdate = " + POut.Date(patientm.Birthdate) + ", " + "Address = '" + POut.String(patientm.Address) + "', " + "Address2 = '" + POut.String(patientm.Address2) + "', " + "City = '" + POut.String(patientm.City) + "', " + "State = '" + POut.String(patientm.State) + "', " + "Zip = '" + POut.String(patientm.Zip) + "', " + "HmPhone = '" + POut.String(patientm.HmPhone) + "', " + "WkPhone = '" + POut.String(patientm.WkPhone) + "', " + "WirelessPhone = '" + POut.String(patientm.WirelessPhone) + "', " + "Guarantor = " + POut.Long(patientm.Guarantor) + ", " + "Email = '" + POut.String(patientm.Email) + "', " + "AddrNote = '" + POut.String(patientm.AddrNote) + "', " + "ClinicNum = " + POut.Long(patientm.ClinicNum) + ", " + "InsEst = '" + POut.Double(patientm.InsEst) + "', " + "BalTotal = '" + POut.Double(patientm.BalTotal) + "', " + "PreferContactMethod= " + POut.Int((int)patientm.PreferContactMethod) + ", " + "OnlinePassword = '******' " + "WHERE CustomerNum = " + POut.Long(patientm.CustomerNum) + " AND PatNum = " + POut.Long(patientm.PatNum); Db.NonQ(command); }
///<summary>Converts a DataTable to a list of objects.</summary> internal static List<Patientm> TableToList(DataTable table){ List<Patientm> retVal=new List<Patientm>(); Patientm patientm; for(int i=0;i<table.Rows.Count;i++) { patientm=new Patientm(); patientm.CustomerNum = PIn.Long (table.Rows[i]["CustomerNum"].ToString()); patientm.PatNum = PIn.Long (table.Rows[i]["PatNum"].ToString()); patientm.LName = PIn.String(table.Rows[i]["LName"].ToString()); patientm.FName = PIn.String(table.Rows[i]["FName"].ToString()); patientm.MiddleI = PIn.String(table.Rows[i]["MiddleI"].ToString()); patientm.Preferred = PIn.String(table.Rows[i]["Preferred"].ToString()); patientm.PatStatus = (PatientStatus)PIn.Int(table.Rows[i]["PatStatus"].ToString()); patientm.Gender = (PatientGender)PIn.Int(table.Rows[i]["Gender"].ToString()); patientm.Position = (PatientPosition)PIn.Int(table.Rows[i]["Position"].ToString()); patientm.Birthdate = PIn.Date (table.Rows[i]["Birthdate"].ToString()); patientm.Address = PIn.String(table.Rows[i]["Address"].ToString()); patientm.Address2 = PIn.String(table.Rows[i]["Address2"].ToString()); patientm.City = PIn.String(table.Rows[i]["City"].ToString()); patientm.State = PIn.String(table.Rows[i]["State"].ToString()); patientm.Zip = PIn.String(table.Rows[i]["Zip"].ToString()); patientm.HmPhone = PIn.String(table.Rows[i]["HmPhone"].ToString()); patientm.WkPhone = PIn.String(table.Rows[i]["WkPhone"].ToString()); patientm.WirelessPhone = PIn.String(table.Rows[i]["WirelessPhone"].ToString()); patientm.Guarantor = PIn.Long (table.Rows[i]["Guarantor"].ToString()); patientm.Email = PIn.String(table.Rows[i]["Email"].ToString()); patientm.AddrNote = PIn.String(table.Rows[i]["AddrNote"].ToString()); patientm.ClinicNum = PIn.Long (table.Rows[i]["ClinicNum"].ToString()); patientm.InsEst = PIn.Double(table.Rows[i]["InsEst"].ToString()); patientm.BalTotal = PIn.Double(table.Rows[i]["BalTotal"].ToString()); patientm.PreferContactMethod= (ContactMethod)PIn.Int(table.Rows[i]["PreferContactMethod"].ToString()); patientm.OnlinePassword = PIn.String(table.Rows[i]["OnlinePassword"].ToString()); retVal.Add(patientm); } return retVal; }
///<summary>Converts one Patient object to its mobile equivalent. Warning! CustomerNum will always be 0.</summary> internal static Patientm ConvertToM(Patient patient) { Patientm patientm = new Patientm(); //CustomerNum cannot be set. Remains 0. patientm.PatNum = patient.PatNum; patientm.LName = patient.LName; patientm.FName = patient.FName; patientm.MiddleI = patient.MiddleI; patientm.Preferred = patient.Preferred; patientm.PatStatus = patient.PatStatus; patientm.Gender = patient.Gender; patientm.Position = patient.Position; patientm.Birthdate = patient.Birthdate; patientm.Address = patient.Address; patientm.Address2 = patient.Address2; patientm.City = patient.City; patientm.State = patient.State; patientm.Zip = patient.Zip; patientm.HmPhone = patient.HmPhone; patientm.WkPhone = patient.WkPhone; patientm.WirelessPhone = patient.WirelessPhone; patientm.Guarantor = patient.Guarantor; patientm.Email = patient.Email; patientm.AddrNote = patient.AddrNote; patientm.ClinicNum = patient.ClinicNum; patientm.InsEst = patient.InsEst; patientm.BalTotal = patient.BalTotal; patientm.PreferContactMethod = patient.PreferContactMethod; patientm.OnlinePassword = ""; //patient.OnlinePassword was removed and this column isn't used anymore. return(patientm); }
public AccountModel(Patientm patm) { String formatstring = "{0:0.00}"; BalTotal = "$" + String.Format(formatstring, Math.Abs(patm.BalTotal)); InsEst = "$" + String.Format(formatstring, Math.Abs(patm.InsEst)); AfterIns = "$" + String.Format(formatstring, Math.Abs(patm.BalTotal - patm.InsEst)); if (patm.BalTotal < 0) { BalTotal = "-" + BalTotal; } else { BalTotal = " " + BalTotal; } if (patm.InsEst < 0) { InsEst = "-" + InsEst; } else { InsEst = " " + InsEst; } if ((patm.BalTotal - patm.InsEst) < 0) { AfterIns = "-" + AfterIns; } else { AfterIns = " " + AfterIns; } statementmList = Statementms.GetStatementms(patm.CustomerNum, patm.PatNum); }
public FamilyModel(Patientm patm) { this.patm = patm; patList = Patientms.GetPatientmsOfFamily(patm.CustomerNum, patm.PatNum); foreach (Patientm pm in patList) { pm.Age = Patientms.DateToAge(pm.Birthdate); } }
public string GetPatientName(long PatNum, long CustomerNum) { try{ String PatName = ""; Patientm pat = Patientms.GetOne(CustomerNum, PatNum); PatName = GetPatientName(pat); return(PatName); } catch (Exception ex) { Logger.LogError(ex); return(""); } }
protected void Page_Load(object sender, EventArgs e) { try { CustomerNum = util.GetCustomerNum(Message); if (CustomerNum == 0) { return; } if (Request["PatNum"] != null) { Int64.TryParse(Request["PatNum"].ToString().Trim(), out PatNum); } Int64.TryParse(Session["CustomerNum"].ToString(), out CustomerNum); pat = Patientms.GetOne(CustomerNum, PatNum); pat.Age = Patientms.DateToAge(pat.Birthdate); PatName = util.GetPatientName(pat); String DialString1 = @" <a href=""tel:"; String DialString2 = @""" class=""style2"">dial</a>"; if (!String.IsNullOrEmpty(pat.HmPhone)) { DialLinkHmPhone = DialString1 + pat.HmPhone + DialString2; } if (!String.IsNullOrEmpty(pat.WkPhone)) { DialLinkWkPhone = DialString1 + pat.WkPhone + DialString2; } if (!String.IsNullOrEmpty(pat.WirelessPhone)) { DialLinkWirelessPhone = DialString1 + pat.WirelessPhone + DialString2; } if (!String.IsNullOrEmpty(pat.Email)) { EmailString = @"<a href=""mailto:" + pat.Email + @""" class=""style2"">" + pat.Email + "</a>"; } List <Appointmentm> appointmentmList = Appointmentms.GetAppointmentms(CustomerNum, PatNum); appointmentmList = appointmentmList.Where(a => a.AptStatus != ApptStatus.UnschedList && a.AptStatus != ApptStatus.Planned).ToList(); //exclude unscheduled and planned appointments. Repeater1.DataSource = appointmentmList; Repeater1.DataBind(); List <RxPatm> rxList = RxPatms.GetRxPatms(CustomerNum, PatNum); Repeater2.DataSource = rxList; Repeater2.DataBind(); List <Allergym> allergyList = Allergyms.GetAllergyms(CustomerNum, PatNum); Repeater3.DataSource = allergyList; Repeater3.DataBind(); } catch (Exception ex) { LabelError.Text = Util.ErrorMessage; Logger.LogError(ex); } }
protected void Page_Load(object sender, EventArgs e) { try { CustomerNum = util.GetCustomerNum(Message); if (CustomerNum == 0) { return; } if (Request["AptNum"] != null) { Int64.TryParse(Request["AptNum"].ToString().Trim(), out AptNum); } apt = Appointmentms.GetOne(CustomerNum, AptNum); pat = Patientms.GetOne(CustomerNum, apt.PatNum); PatName = util.GetPatientName(pat); } catch (Exception ex) { LabelError.Text = Util.ErrorMessage; Logger.LogError(ex); } }
public string GetPatientName(Patientm pat) { try { String PatName = ""; PatName += pat.LName + ", "; if (!String.IsNullOrEmpty(pat.Preferred)) { PatName += "'" + pat.Preferred + "'"; } PatName += " " + pat.FName + " "; if (!String.IsNullOrEmpty(pat.MiddleI)) { PatName += pat.MiddleI + "."; } return(PatName); } catch (Exception ex) { Logger.LogError(ex); return(""); } }
///<summary>Usually set useExistingPK=true. Inserts one Patientm into the database.</summary> internal static long Insert(Patientm patientm, bool useExistingPK) { if (!useExistingPK) { patientm.PatNum = ReplicationServers.GetKey("patientm", "PatNum"); } string command = "INSERT INTO patientm ("; command += "PatNum,"; command += "CustomerNum,LName,FName,MiddleI,Preferred,PatStatus,Gender,Position,Birthdate,Address,Address2,City,State,Zip,HmPhone,WkPhone,WirelessPhone,Guarantor,Email,AddrNote,ClinicNum,InsEst,BalTotal,PreferContactMethod,OnlinePassword) VALUES("; command += POut.Long(patientm.PatNum) + ","; command += POut.Long(patientm.CustomerNum) + "," + "'" + POut.String(patientm.LName) + "'," + "'" + POut.String(patientm.FName) + "'," + "'" + POut.String(patientm.MiddleI) + "'," + "'" + POut.String(patientm.Preferred) + "'," + POut.Int((int)patientm.PatStatus) + "," + POut.Int((int)patientm.Gender) + "," + POut.Int((int)patientm.Position) + "," + POut.Date(patientm.Birthdate) + "," + "'" + POut.String(patientm.Address) + "'," + "'" + POut.String(patientm.Address2) + "'," + "'" + POut.String(patientm.City) + "'," + "'" + POut.String(patientm.State) + "'," + "'" + POut.String(patientm.Zip) + "'," + "'" + POut.String(patientm.HmPhone) + "'," + "'" + POut.String(patientm.WkPhone) + "'," + "'" + POut.String(patientm.WirelessPhone) + "'," + POut.Long(patientm.Guarantor) + "," + "'" + POut.String(patientm.Email) + "'," + "'" + POut.String(patientm.AddrNote) + "'," + POut.Long(patientm.ClinicNum) + "," + "'" + POut.Double(patientm.InsEst) + "'," + "'" + POut.Double(patientm.BalTotal) + "'," + POut.Int((int)patientm.PreferContactMethod) + "," + "'" + POut.String(patientm.OnlinePassword) + "')"; Db.NonQ(command); //There is no autoincrement in the mobile server. return(patientm.PatNum); }
///<summary>Converts a DataTable to a list of objects.</summary> internal static List <Patientm> TableToList(DataTable table) { List <Patientm> retVal = new List <Patientm>(); Patientm patientm; for (int i = 0; i < table.Rows.Count; i++) { patientm = new Patientm(); patientm.CustomerNum = PIn.Long(table.Rows[i]["CustomerNum"].ToString()); patientm.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString()); patientm.LName = PIn.String(table.Rows[i]["LName"].ToString()); patientm.FName = PIn.String(table.Rows[i]["FName"].ToString()); patientm.MiddleI = PIn.String(table.Rows[i]["MiddleI"].ToString()); patientm.Preferred = PIn.String(table.Rows[i]["Preferred"].ToString()); patientm.PatStatus = (PatientStatus)PIn.Int(table.Rows[i]["PatStatus"].ToString()); patientm.Gender = (PatientGender)PIn.Int(table.Rows[i]["Gender"].ToString()); patientm.Position = (PatientPosition)PIn.Int(table.Rows[i]["Position"].ToString()); patientm.Birthdate = PIn.Date(table.Rows[i]["Birthdate"].ToString()); patientm.Address = PIn.String(table.Rows[i]["Address"].ToString()); patientm.Address2 = PIn.String(table.Rows[i]["Address2"].ToString()); patientm.City = PIn.String(table.Rows[i]["City"].ToString()); patientm.State = PIn.String(table.Rows[i]["State"].ToString()); patientm.Zip = PIn.String(table.Rows[i]["Zip"].ToString()); patientm.HmPhone = PIn.String(table.Rows[i]["HmPhone"].ToString()); patientm.WkPhone = PIn.String(table.Rows[i]["WkPhone"].ToString()); patientm.WirelessPhone = PIn.String(table.Rows[i]["WirelessPhone"].ToString()); patientm.Guarantor = PIn.Long(table.Rows[i]["Guarantor"].ToString()); patientm.Email = PIn.String(table.Rows[i]["Email"].ToString()); patientm.AddrNote = PIn.String(table.Rows[i]["AddrNote"].ToString()); patientm.ClinicNum = PIn.Long(table.Rows[i]["ClinicNum"].ToString()); patientm.InsEst = PIn.Double(table.Rows[i]["InsEst"].ToString()); patientm.BalTotal = PIn.Double(table.Rows[i]["BalTotal"].ToString()); patientm.PreferContactMethod = (ContactMethod)PIn.Int(table.Rows[i]["PreferContactMethod"].ToString()); patientm.OnlinePassword = PIn.String(table.Rows[i]["OnlinePassword"].ToString()); retVal.Add(patientm); } return(retVal); }
public ActionResult Login(LoginModel model, string returnUrl) { if (ModelState.IsValid) { HttpCookie DentalOfficeIDCookie = Request.Cookies["DentalOfficeIDCookie"]; if (DentalOfficeIDCookie != null) { Int64.TryParse(DentalOfficeIDCookie.Value, out DentalOfficeID); } Patientm patm = Patientms.GetOne(DentalOfficeID, model.UserName, model.Password); if (patm == null) { ModelState.AddModelError("", "Login Failed, Please Try Again"); } else { Session["Patient"] = patm; Prefms.LoadPreferences(); return(RedirectToAction("EHRInformation", "Medical")); } } return(View()); }
///<summary>Usually set useExistingPK=true. Inserts one Patientm into the database.</summary> internal static long Insert(Patientm patientm,bool useExistingPK){ if(!useExistingPK) { patientm.PatNum=ReplicationServers.GetKey("patientm","PatNum"); } string command="INSERT INTO patientm ("; command+="PatNum,"; command+="CustomerNum,LName,FName,MiddleI,Preferred,PatStatus,Gender,Position,Birthdate,Address,Address2,City,State,Zip,HmPhone,WkPhone,WirelessPhone,Guarantor,Email,AddrNote,ClinicNum,InsEst,BalTotal,PreferContactMethod,OnlinePassword) VALUES("; command+=POut.Long(patientm.PatNum)+","; command+= POut.Long (patientm.CustomerNum)+"," +"'"+POut.String(patientm.LName)+"'," +"'"+POut.String(patientm.FName)+"'," +"'"+POut.String(patientm.MiddleI)+"'," +"'"+POut.String(patientm.Preferred)+"'," + POut.Int ((int)patientm.PatStatus)+"," + POut.Int ((int)patientm.Gender)+"," + POut.Int ((int)patientm.Position)+"," + POut.Date (patientm.Birthdate)+"," +"'"+POut.String(patientm.Address)+"'," +"'"+POut.String(patientm.Address2)+"'," +"'"+POut.String(patientm.City)+"'," +"'"+POut.String(patientm.State)+"'," +"'"+POut.String(patientm.Zip)+"'," +"'"+POut.String(patientm.HmPhone)+"'," +"'"+POut.String(patientm.WkPhone)+"'," +"'"+POut.String(patientm.WirelessPhone)+"'," + POut.Long (patientm.Guarantor)+"," +"'"+POut.String(patientm.Email)+"'," +"'"+POut.String(patientm.AddrNote)+"'," + POut.Long (patientm.ClinicNum)+"," +"'"+POut.Double(patientm.InsEst)+"'," +"'"+POut.Double(patientm.BalTotal)+"'," + POut.Int ((int)patientm.PreferContactMethod)+"," +"'"+POut.String(patientm.OnlinePassword)+"')"; Db.NonQ(command);//There is no autoincrement in the mobile server. return patientm.PatNum; }
public MedicalModel(Patientm patm) //constructor { this.patm = patm; FillData(); }
public AppointmentModel(Patientm patm) { appointmentmList = Appointmentms.GetAppointmentms(patm.CustomerNum, patm.PatNum); }
///<summary>Updates one Patientm in the database.</summary> internal static void Update(Patientm patientm){ string command="UPDATE patientm SET " +"LName = '"+POut.String(patientm.LName)+"', " +"FName = '"+POut.String(patientm.FName)+"', " +"MiddleI = '"+POut.String(patientm.MiddleI)+"', " +"Preferred = '"+POut.String(patientm.Preferred)+"', " +"PatStatus = "+POut.Int ((int)patientm.PatStatus)+", " +"Gender = "+POut.Int ((int)patientm.Gender)+", " +"Position = "+POut.Int ((int)patientm.Position)+", " +"Birthdate = "+POut.Date (patientm.Birthdate)+", " +"Address = '"+POut.String(patientm.Address)+"', " +"Address2 = '"+POut.String(patientm.Address2)+"', " +"City = '"+POut.String(patientm.City)+"', " +"State = '"+POut.String(patientm.State)+"', " +"Zip = '"+POut.String(patientm.Zip)+"', " +"HmPhone = '"+POut.String(patientm.HmPhone)+"', " +"WkPhone = '"+POut.String(patientm.WkPhone)+"', " +"WirelessPhone = '"+POut.String(patientm.WirelessPhone)+"', " +"Guarantor = "+POut.Long (patientm.Guarantor)+", " +"Email = '"+POut.String(patientm.Email)+"', " +"AddrNote = '"+POut.String(patientm.AddrNote)+"', " +"ClinicNum = "+POut.Long (patientm.ClinicNum)+", " +"InsEst = '"+POut.Double(patientm.InsEst)+"', " +"BalTotal = '"+POut.Double(patientm.BalTotal)+"', " +"PreferContactMethod= "+POut.Int ((int)patientm.PreferContactMethod)+", " +"OnlinePassword = '******' " +"WHERE CustomerNum = "+POut.Long(patientm.CustomerNum)+" AND PatNum = "+POut.Long(patientm.PatNum); Db.NonQ(command); }
///<summary>Converts one Patient object to its mobile equivalent. Warning! CustomerNum will always be 0.</summary> internal static Patientm ConvertToM(Patient patient){ Patientm patientm=new Patientm(); //CustomerNum cannot be set. Remains 0. patientm.PatNum =patient.PatNum; patientm.LName =patient.LName; patientm.FName =patient.FName; patientm.MiddleI =patient.MiddleI; patientm.Preferred =patient.Preferred; patientm.PatStatus =patient.PatStatus; patientm.Gender =patient.Gender; patientm.Position =patient.Position; patientm.Birthdate =patient.Birthdate; patientm.Address =patient.Address; patientm.Address2 =patient.Address2; patientm.City =patient.City; patientm.State =patient.State; patientm.Zip =patient.Zip; patientm.HmPhone =patient.HmPhone; patientm.WkPhone =patient.WkPhone; patientm.WirelessPhone =patient.WirelessPhone; patientm.Guarantor =patient.Guarantor; patientm.Email =patient.Email; patientm.AddrNote =patient.AddrNote; patientm.ClinicNum =patient.ClinicNum; patientm.InsEst =patient.InsEst; patientm.BalTotal =patient.BalTotal; patientm.PreferContactMethod=patient.PreferContactMethod; patientm.OnlinePassword =patient.OnlinePassword; return patientm; }