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