private static void FillFieldsForPatientLetter(Sheet sheet,Patient pat)
{
foreach(SheetField field in sheet.SheetFields) {
switch(field.FieldName) {
case "PracticeTitle":
field.FieldValue=PrefC.GetString(PrefName.PracticeTitle);
break;
case "PracticeAddress":
field.FieldValue=PrefC.GetString(PrefName.PracticeAddress);
if(PrefC.GetString(PrefName.PracticeAddress2) != ""){
field.FieldValue+="\r\n"+PrefC.GetString(PrefName.PracticeAddress2);
}
break;
case "practiceCityStateZip":
field.FieldValue=PrefC.GetString(PrefName.PracticeCity)+", "
+PrefC.GetString(PrefName.PracticeST)+" "
+PrefC.GetString(PrefName.PracticeZip);
break;
case "patient.nameFL":
field.FieldValue=pat.GetNameFLFormal();
break;
case "patient.address":
field.FieldValue=pat.Address;
if(pat.Address2!="") {
field.FieldValue+="\r\n"+pat.Address2;
}
break;
case "patient.cityStateZip":
field.FieldValue=pat.City+", "+pat.State+" "+pat.Zip;
break;
case "today.DayDate":
field.FieldValue=DateTime.Today.ToString("dddd")+", "+DateTime.Today.ToShortDateString();
break;
case "patient.salutation":
field.FieldValue="Dear "+pat.GetSalutation()+":";
break;
case "patient.priProvNameFL":
field.FieldValue=Providers.GetFormalName(pat.PriProv);
break;
}
}
}
///<summary>Pat can be null sometimes. For example, in deposit slip.</summary>
private static void FillFieldsInStaticText(Sheet sheet,Patient pat)
{
string fldval="";
string address="";
string apptsAllFuture="";
string birthdate="";
string carrierName="";
string carrierAddress="";
string carrierCityStZip="";
string subscriberId="";
string subscriberNameFL="";
string insAnnualMax="";
string insDeductible="";
string insDeductibleUsed="";
string insPending="";
string insPercentages="";
string insPlanGroupNumber="";
string insPlanGroupName="";
string insPlanNote="";
string insSubNote="";
string insRemaining="";
string insUsed="";
string carrier2Name="";
string subscriber2NameFL="";
string ins2AnnualMax="";
string ins2Deductible="";
string ins2DeductibleUsed="";
string ins2Pending="";
string ins2Percentages="";
string ins2Remaining="";
string ins2Used="";
string clinicDescription="";
string clinicAddress="";
string clinicCityStZip="";
string phone="";
string clinicPhone="";
string plannedAppointmentInfo="";
string dateFirstVisit="";
string treatmentPlanProcs="";
string dateOfLastSavedTP="";
string tpResponsPartyAddress="";
string tpResponsPartyCityStZip="";
string tpResponsPartyNameFL="";
string dateRecallDue="";
string recallInterval="";
string nextSchedApptDateT="";
string dateTimeLastAppt="";
string nextSchedApptsFam="";
string serviceNote="";
string insFreqBW="";
string insFreqExams="";
string insFreqPanoFMX="";
string insType=""; //(ppo, etc)
string referredFrom=""; //(just one)
string referredTo=""; //(typically Drs. could be multiline. Include date)
string dateLastBW="";
string dateLastExam="";
string dateLastPanoFMX="";
string dateLastProphy="";
string genderHeShe="";
string genderheshe="";
string genderHimHer="";
string genderhimher="";
string genderHimselfHerself="";
string genderhimselfherself="";
string genderHisHer="";
string genderhisher="";
string genderHisHers="";
string genderhishers="";
string guarantorNameF="";
string guarantorNameFL="";
string guarantorNameL="";
string guarantorNamePref="";
string guarantorNameLF="";
Family fam=null;
Provider priProv=null;
if(pat!=null) {
switch(pat.Gender) {
case PatientGender.Male:
genderHeShe="He";
genderheshe="he";
genderHimHer="Him";
genderhimher="him";
genderHimselfHerself="Himself";
genderhimselfherself="Herself";
genderHisHer="His";
genderhisher="his";
genderHisHers="His";
genderhishers="his";
break;
case PatientGender.Female:
genderHeShe="She";
genderheshe="she";
genderHimHer="Her";
genderhimher="her";
genderHimselfHerself="Herself";
genderhimselfherself="herself";
genderHisHer="Her";
genderhisher="her";
genderHisHers="Hers";
genderhishers="hers";
break;
case PatientGender.Unknown:
genderHeShe="The patient";
genderheshe="the patient";
genderHimHer="The patient";
genderhimher="the patient";
genderHimselfHerself="The patient";
genderhimselfherself="the patient";
genderHisHer="The patient's";
genderhisher="the patient's";
genderHisHers="The patient's";
genderhishers="the patient's";
break;
}
Patient guar=Patients.GetPat(pat.Guarantor);
if(guar!=null) {
guarantorNameF=guar.FName;
guarantorNameFL=guar.GetNameFL();
guarantorNameL=guar.LName;
guarantorNameLF=guar.GetNameLF();
guarantorNamePref=guar.Preferred;
}
address=pat.Address;
if(pat.Address2!="") {
address+=", "+pat.Address2;
}
birthdate=pat.Birthdate.ToShortDateString();
if(pat.Birthdate.Year<1880) {
birthdate="";
}
dateFirstVisit=pat.DateFirstVisit.ToShortDateString();
if(pat.DateFirstVisit.Year<1880) {
dateFirstVisit="";
}
fam=Patients.GetFamily(pat.PatNum);
List<Procedure> procsList=null;
if(Sheets.ContainsStaticField(sheet,"treatmentPlanProcs") || Sheets.ContainsStaticField(sheet,"plannedAppointmentInfo")) {
procsList=Procedures.Refresh(pat.PatNum);
if(Sheets.ContainsStaticField(sheet,"treatmentPlanProcs")) {
for(int i=0;i<procsList.Count;i++) {
if(procsList[i].ProcStatus!=ProcStat.TP) {
continue;
}
if(treatmentPlanProcs!="") {
treatmentPlanProcs+="\r\n";
}
treatmentPlanProcs+=ProcedureCodes.GetStringProcCode(procsList[i].CodeNum)+", "
+Procedures.GetDescription(procsList[i])+", "
+procsList[i].ProcFee.ToString("c");
}
}
}
serviceNote=PatientNotes.Refresh(pat.PatNum,pat.Guarantor).Service;
List<RefAttach> RefAttachList=RefAttaches.Refresh(pat.PatNum);
Referral tempReferralFrom = Referrals.GetReferralForPat(pat.PatNum);
if(Referrals.GetReferralForPat(pat.PatNum)!=null) {
if(tempReferralFrom.IsDoctor) {
referredFrom+=tempReferralFrom.FName+" "+tempReferralFrom.LName+" "+tempReferralFrom.Title+" : "+tempReferralFrom.Specialty.ToString();
}
else {
referredFrom+=tempReferralFrom.FName+" "+tempReferralFrom.LName;
}
}
for(int i=0;i<RefAttachList.Count;i++) {
if(RefAttachList[i].IsFrom) {
continue;
}
Referral tempRef = Referrals.GetReferral(RefAttachList[i].ReferralNum);
if(tempRef.IsDoctor) {
referredTo+=tempRef.FName+" "+tempRef.LName+" "+tempRef.Title+" : "+tempRef.Specialty.ToString()+" "+RefAttachList[i].RefDate.ToShortDateString()+"\r\n";
}
else {
referredTo+=tempRef.FName+" "+tempRef.LName+" "+RefAttachList[i].RefDate.ToShortDateString()+"\r\n";
}
}
//Insurance-------------------------------------------------------------------------------------------------------------------
List<PatPlan> patPlanList=PatPlans.Refresh(pat.PatNum);
long subNum=PatPlans.GetInsSubNum(patPlanList,1);
long patPlanNum=PatPlans.GetPatPlanNum(subNum,patPlanList);
List<InsSub> subList=InsSubs.RefreshForFam(fam);
List<InsPlan> planList=InsPlans.RefreshForSubList(subList);
InsSub sub=InsSubs.GetSub(subNum,subList);
InsPlan plan=null;
if(sub!=null) {
plan=InsPlans.GetPlan(sub.PlanNum,planList);
insSubNote=sub.SubscNote;
}
Carrier carrier=null;
List<Benefit> benefitList=Benefits.Refresh(patPlanList,subList);
List<ClaimProcHist> histList=ClaimProcs.GetHistList(pat.PatNum,benefitList,patPlanList,planList,DateTime.Today,subList);
double doubAnnualMax;
double doubDeductible;
double doubDeductibleUsed;
double doubPending;
double doubRemain;
double doubUsed;
if(plan!=null) {
insPlanGroupName=plan.GroupName;
insPlanGroupNumber=plan.GroupNum;
insPlanNote=plan.PlanNote;
carrier=Carriers.GetCarrier(plan.CarrierNum);
carrierName=carrier.CarrierName;
carrierAddress=carrier.Address;
if(carrier.Address2!="") {
carrierAddress+=", "+carrier.Address2;
}
carrierCityStZip=carrier.City+", "+carrier.State+" "+carrier.Zip;
subscriberId=sub.SubscriberID;
subscriberNameFL=Patients.GetLim(sub.Subscriber).GetNameFL();
doubAnnualMax=Benefits.GetAnnualMaxDisplay(benefitList,plan.PlanNum,patPlanNum,false);
doubRemain=-1;
if(doubAnnualMax!=-1) {
insAnnualMax=doubAnnualMax.ToString("c");
doubRemain=doubAnnualMax;
}
doubDeductible=Benefits.GetDeductGeneralDisplay(benefitList,plan.PlanNum,patPlanNum,BenefitCoverageLevel.Individual);
if(doubDeductible!=-1) {
insDeductible=doubDeductible.ToString("c");
}
doubDeductibleUsed=InsPlans.GetDedUsedDisplay(histList,DateTime.Today,plan.PlanNum,patPlanNum,-1,planList,BenefitCoverageLevel.Individual,pat.PatNum);
if(doubDeductibleUsed!=-1) {
insDeductibleUsed=doubDeductibleUsed.ToString("c");
}
doubPending=InsPlans.GetPendingDisplay(histList,DateTime.Today,plan,patPlanNum,-1,pat.PatNum,subNum);
if(doubPending!=-1) {
insPending=doubPending.ToString("c");
if(doubRemain!=-1) {
doubRemain-=doubPending;
}
}
doubUsed=InsPlans.GetInsUsedDisplay(histList,DateTime.Today,plan.PlanNum,patPlanNum,-1,planList,benefitList,pat.PatNum,subNum);
if(doubUsed!=-1) {
insUsed=doubUsed.ToString("c");
if(doubRemain!=-1) {
doubRemain-=doubUsed;
}
}
if(doubRemain!=-1) {
insRemaining=doubRemain.ToString("c");
}
for(int j=0;j<benefitList.Count;j++) {
if(benefitList[j].PlanNum != plan.PlanNum) {
continue;
}
if(benefitList[j].BenefitType != InsBenefitType.CoInsurance) {
continue;
}
if(insPercentages!="") {
insPercentages+=", ";
}
insPercentages+=CovCats.GetDesc(benefitList[j].CovCatNum)+" "+benefitList[j].Percent.ToString()+"%";
}
insFreqBW=Benefits.GetFrequencyDisplay(FrequencyType.BW,benefitList);
insFreqExams=Benefits.GetFrequencyDisplay(FrequencyType.Exam,benefitList);
insFreqPanoFMX=Benefits.GetFrequencyDisplay(FrequencyType.PanoFMX,benefitList);
switch(plan.PlanType) {//(ppo, etc)
case "p":
insType="PPO Percentage";
break;
case "f":
insType="Medicaid or Flat Copay";
break;
case "c":
insType="Capitation";
break;
case "":
insType="Category Percentage";
break;
}
}
subNum=PatPlans.GetInsSubNum(patPlanList,2);
patPlanNum=PatPlans.GetPatPlanNum(subNum,patPlanList);
sub=InsSubs.GetSub(subNum,subList);
if(sub!=null) {
plan=InsPlans.GetPlan(sub.PlanNum,planList);
}
if(plan!=null) {
carrier=Carriers.GetCarrier(plan.CarrierNum);
carrier2Name=carrier.CarrierName;
//carrierAddress=carrier.Address;
//if(carrier.Address2!="") {
// carrierAddress+=", "+carrier.Address2;
//}
//carrierCityStZip=carrier.City+", "+carrier.State+" "+carrier.Zip;
//subscriberId=plan.SubscriberID;
subscriber2NameFL=Patients.GetLim(sub.Subscriber).GetNameFL();
doubAnnualMax=Benefits.GetAnnualMaxDisplay(benefitList,plan.PlanNum,patPlanNum,false);
doubRemain=-1;
if(doubAnnualMax!=-1) {
ins2AnnualMax=doubAnnualMax.ToString("c");
doubRemain=doubAnnualMax;
}
doubDeductible=Benefits.GetDeductGeneralDisplay(benefitList,plan.PlanNum,patPlanNum,BenefitCoverageLevel.Individual);
if(doubDeductible!=-1) {
ins2Deductible=doubDeductible.ToString("c");
}
doubDeductibleUsed=InsPlans.GetDedUsedDisplay(histList,DateTime.Today,plan.PlanNum,patPlanNum,-1,planList,BenefitCoverageLevel.Individual,pat.PatNum);
if(doubDeductibleUsed!=-1) {
ins2DeductibleUsed=doubDeductibleUsed.ToString("c");
}
doubPending=InsPlans.GetPendingDisplay(histList,DateTime.Today,plan,patPlanNum,-1,pat.PatNum,subNum);
if(doubPending!=-1) {
ins2Pending=doubPending.ToString("c");
if(doubRemain!=-1) {
doubRemain-=doubPending;
}
}
doubUsed=InsPlans.GetInsUsedDisplay(histList,DateTime.Today,plan.PlanNum,patPlanNum,-1,planList,benefitList,pat.PatNum,subNum);
if(doubUsed!=-1) {
ins2Used=doubUsed.ToString("c");
if(doubRemain!=-1) {
doubRemain-=doubUsed;
}
}
if(doubRemain!=-1) {
ins2Remaining=doubRemain.ToString("c");
}
for(int j=0;j<benefitList.Count;j++) {
if(benefitList[j].PlanNum != plan.PlanNum) {
continue;
}
if(benefitList[j].BenefitType != InsBenefitType.CoInsurance) {
continue;
}
if(ins2Percentages!="") {
ins2Percentages+=", ";
}
ins2Percentages+=CovCats.GetDesc(benefitList[j].CovCatNum)+" "+benefitList[j].Percent.ToString()+"%";
}
}
//Treatment plan-----------------------------------------------------------------------------------------------------------
TreatPlan[] treatPlanList=TreatPlans.Refresh(pat.PatNum);
TreatPlan treatPlan=null;
if(treatPlanList.Length>0) {
treatPlan=treatPlanList[treatPlanList.Length-1].Copy();
dateOfLastSavedTP=treatPlan.DateTP.ToShortDateString();
Patient patRespParty=Patients.GetPat(treatPlan.ResponsParty);
if(patRespParty!=null) {
tpResponsPartyAddress=patRespParty.Address;
if(patRespParty.Address2!="") {
tpResponsPartyAddress+=", "+patRespParty.Address2;
}
tpResponsPartyCityStZip=patRespParty.City+", "+patRespParty.State+" "+patRespParty.Zip;
tpResponsPartyNameFL=patRespParty.GetNameFL();
}
}
//Procedure Log-------------------------------------------------------------------------------------------------------------
List<Procedure> proceduresList=Procedures.Refresh(pat.PatNum);
DateTime dBW=DateTime.MinValue;
DateTime dExam=DateTime.MinValue;
DateTime dPanoFMX=DateTime.MinValue;
DateTime dProphy=DateTime.MinValue;
for(int i=0;i<proceduresList.Count;i++) {
Procedure proc = proceduresList[i];//cache Proc to speed up process
if(proc.ProcStatus!=ProcStat.C
&& proc.ProcStatus!=ProcStat.EC
&& proc.ProcStatus!=ProcStat.EO) {
continue;//only look at completed or existing procedures
}
if((proc.CodeNum==ProcedureCodes.GetCodeNum("D0210")//intraoral - complete series (including bitewings)
||proc.CodeNum==ProcedureCodes.GetCodeNum("D0270")//bitewing - single film
||proc.CodeNum==ProcedureCodes.GetCodeNum("D0272")//bitewings - two films
||proc.CodeNum==ProcedureCodes.GetCodeNum("D0274")//bitewings - four films
||proc.CodeNum==ProcedureCodes.GetCodeNum("D0277")//vertical bitewings - 7 to 8 films
||proc.CodeNum==ProcedureCodes.GetCodeNum("D0273"))//bitewings - three films
&& proc.ProcDate>dBW) //newest
{
dBW=proc.ProcDate;
dateLastBW=proc.ProcDate.ToShortDateString();
}
if((proc.CodeNum==ProcedureCodes.GetCodeNum("D0120")//periodic oral evaluation - established patient
||proc.CodeNum==ProcedureCodes.GetCodeNum("D0140")//limited oral evaluation - problem focused
||proc.CodeNum==ProcedureCodes.GetCodeNum("D0150")//comprehensive oral evaluation - new or established patient
||proc.CodeNum==ProcedureCodes.GetCodeNum("D0160"))//detailed and extensive oral evaluation - problem focused, by report
&& proc.ProcDate>dExam) //newest
{
dExam=proc.ProcDate;
dateLastExam=proc.ProcDate.ToShortDateString();
}
if((proc.CodeNum==ProcedureCodes.GetCodeNum("D0210")//intraoral - complete series (including bitewings)
||proc.CodeNum==ProcedureCodes.GetCodeNum("D0330"))//panoramic film
&& proc.ProcDate>dPanoFMX) //newest
{
dPanoFMX=proc.ProcDate;
dateLastPanoFMX=proc.ProcDate.ToShortDateString();
}
if((proc.CodeNum==ProcedureCodes.GetCodeNum("D1110")//prophylaxis - adult
||proc.CodeNum==ProcedureCodes.GetCodeNum("D1120")//prophylaxis - child
||proc.CodeNum==ProcedureCodes.GetCodeNum("D1201")//Topical Fluoride Including Prophy-Child
||proc.CodeNum==ProcedureCodes.GetCodeNum("D1205"))//Topical Fluoride Including Prophy-Adult
&& proc.ProcDate>dProphy) //newest
{
dProphy=proc.ProcDate;
dateLastProphy=proc.ProcDate.ToShortDateString(); ;
}
}
//Recall--------------------------------------------------------------------------------------------------------------------
Recall recall=Recalls.GetRecallProphyOrPerio(pat.PatNum);
if(recall!=null) {
if(recall.DateDue.Year>1880) {
dateRecallDue=recall.DateDue.ToShortDateString();
}
recallInterval=recall.RecallInterval.ToString();
}
//Appointments--------------------------------------------------------------------------------------------------------------
List<Appointment> apptList=Appointments.GetListForPat(pat.PatNum);
List<Appointment> apptFutureList=Appointments.GetFutureSchedApts(pat.PatNum);
for(int i=0;i<apptList.Count;i++) {
if(apptList[i].AptStatus != ApptStatus.Scheduled
&& apptList[i].AptStatus != ApptStatus.Complete
&& apptList[i].AptStatus != ApptStatus.None
&& apptList[i].AptStatus != ApptStatus.ASAP) {
continue;
}
if(apptList[i].AptDateTime < DateTime.Now) {
//this will happen repeatedly up until the most recent.
dateTimeLastAppt=apptList[i].AptDateTime.ToShortDateString()+" "+apptList[i].AptDateTime.ToShortTimeString();
}
else {//after now
if(nextSchedApptDateT=="") {//only the first one found
nextSchedApptDateT=apptList[i].AptDateTime.ToShortDateString()+" "+apptList[i].AptDateTime.ToShortTimeString();
break;//we're done with the list now.
}
}
}
for(int i=0;i<apptFutureList.Count;i++) {//cannot be combined in loop above because of the break in the loop.
apptsAllFuture+=apptFutureList[i].AptDateTime.ToShortDateString()+" "+apptFutureList[i].AptDateTime.ToShortTimeString()+" : "+apptFutureList[i].ProcDescript+"\r\n";
}
for(int i=0;i<fam.ListPats.Length;i++) {
List<Appointment> futAptsList=Appointments.GetFutureSchedApts(fam.ListPats[i].PatNum);
if(futAptsList.Count>0) {//just gets one future appt for each person
nextSchedApptsFam+=fam.ListPats[i].FName+": "+futAptsList[0].AptDateTime.ToShortDateString()+" "+futAptsList[0].AptDateTime.ToShortTimeString()+" : "+futAptsList[0].ProcDescript+"\r\n";
}
}
if(Sheets.ContainsStaticField(sheet,"plannedAppointmentInfo")) {
PlannedAppt plannedAppt=PlannedAppts.GetOneOrderedByItemOrder(pat.PatNum);
for(int i=0;i<apptList.Count;i++) {
if(plannedAppt!=null && apptList[i].AptNum==plannedAppt.AptNum) {
plannedAppointmentInfo="Procedures: ";
plannedAppointmentInfo+=apptList[i].ProcDescript+"\r\n";
int minutesTotal=apptList[i].Pattern.Length*5;
int hours=minutesTotal/60;//automatically rounds down
int minutes=minutesTotal-hours*60;
plannedAppointmentInfo+="Appt Length: ";
if(hours>0) {
plannedAppointmentInfo+=hours.ToString()+" hours, ";
}
plannedAppointmentInfo+=minutes.ToString()+" min\r\n";
if(Programs.UsingOrion) {
DateTime newDateSched=new DateTime();
for(int p=0;p<procsList.Count;p++) {
if(procsList[p].PlannedAptNum==apptList[i].AptNum) {
OrionProc op=OrionProcs.GetOneByProcNum(procsList[p].ProcNum);
if(op!=null && op.DateScheduleBy.Year>1880) {
if(newDateSched.Year<1880) {
newDateSched=op.DateScheduleBy;
}
else {
if(op.DateScheduleBy<newDateSched) {
newDateSched=op.DateScheduleBy;
}
}
}
}
}
if(newDateSched.Year>1880) {
plannedAppointmentInfo+="Schedule by: "+newDateSched.ToShortDateString();
}
else {
plannedAppointmentInfo+="No schedule by date.";
}
}
}
}
}
priProv=Providers.GetProv(Patients.GetProvNum(pat));//guaranteed to work
//Clinic-------------------------------------------------------------------------------------------------------------
Clinic clinic=Clinics.GetClinic(pat.ClinicNum);
if(clinic==null) {
clinicDescription=PrefC.GetString(PrefName.PracticeTitle);
clinicAddress=PrefC.GetString(PrefName.PracticeAddress);
if(PrefC.GetString(PrefName.PracticeAddress2)!="") {
clinicAddress+=", "+PrefC.GetString(PrefName.PracticeAddress2);
}
clinicCityStZip=PrefC.GetString(PrefName.PracticeCity)+", "+PrefC.GetString(PrefName.PracticeST)+" "+PrefC.GetString(PrefName.PracticeZip);
phone=PrefC.GetString(PrefName.PracticePhone);
}
else {
clinicDescription=clinic.Description;
clinicAddress=clinic.Address;
if(clinic.Address2!="") {
clinicAddress+=", "+clinic.Address2;
}
clinicCityStZip=clinic.City+", "+clinic.State+" "+clinic.Zip;
phone=clinic.Phone;
}
if(phone.Length==10 && System.Globalization.CultureInfo.CurrentCulture.Name=="en-US") {
clinicPhone="("+phone.Substring(0,3)+")"+phone.Substring(3,3)+"-"+phone.Substring(6);
}
else {
clinicPhone=phone;
}
}//End of if(pat!=null)
//Fill fields---------------------------------------------------------------------------------------------------------
foreach(SheetField field in sheet.SheetFields) {
if(field.FieldType!=SheetFieldType.StaticText) {
continue;
}
fldval=field.FieldValue;
if(pat!=null) {
fldval=fldval.Replace("[address]",address);
fldval=fldval.Replace("[apptsAllFuture]",apptsAllFuture.TrimEnd());
fldval=fldval.Replace("[age]",Patients.AgeToString(pat.Age));
fldval=fldval.Replace("[balTotal]",fam.ListPats[0].BalTotal.ToString("c"));
fldval=fldval.Replace("[bal_0_30]",fam.ListPats[0].Bal_0_30.ToString("c"));
fldval=fldval.Replace("[bal_31_60]",fam.ListPats[0].Bal_31_60.ToString("c"));
fldval=fldval.Replace("[bal_61_90]",fam.ListPats[0].Bal_61_90.ToString("c"));
fldval=fldval.Replace("[balOver90]",fam.ListPats[0].BalOver90.ToString("c"));
fldval=fldval.Replace("[balInsEst]",fam.ListPats[0].InsEst.ToString("c"));
fldval=fldval.Replace("[balTotalMinusInsEst]",(fam.ListPats[0].BalTotal-fam.ListPats[0].InsEst).ToString("c"));
fldval=fldval.Replace("[BillingType]",DefC.GetName(DefCat.BillingTypes,pat.BillingType));
fldval=fldval.Replace("[Birthdate]",birthdate);
fldval=fldval.Replace("[carrierName]",carrierName);
fldval=fldval.Replace("[carrier2Name]",carrier2Name);
fldval=fldval.Replace("[ChartNumber]",pat.ChartNumber);
fldval=fldval.Replace("[carrierAddress]",carrierAddress);
fldval=fldval.Replace("[carrierCityStZip]",carrierCityStZip);
fldval=fldval.Replace("[cityStateZip]",pat.City+", "+pat.State+" "+pat.Zip);
fldval=fldval.Replace("[clinicDescription]",clinicDescription);
fldval=fldval.Replace("[clinicAddress]",clinicAddress);
fldval=fldval.Replace("[clinicCityStZip]",clinicCityStZip);
fldval=fldval.Replace("[clinicPhone]",clinicPhone);
fldval=fldval.Replace("[DateFirstVisit]",dateFirstVisit);
fldval=fldval.Replace("[dateLastBW]",dateLastBW);
fldval=fldval.Replace("[dateLastExam]",dateLastExam);
fldval=fldval.Replace("[dateLastPanoFMX]",dateLastPanoFMX);
fldval=fldval.Replace("[dateLastProphy]",dateLastProphy);
fldval=fldval.Replace("[dateOfLastSavedTP]",dateOfLastSavedTP);
fldval=fldval.Replace("[dateRecallDue]",dateRecallDue);
fldval=fldval.Replace("[dateTimeLastAppt]",dateTimeLastAppt);
fldval=fldval.Replace("[Email]",pat.Email);
fldval=fldval.Replace("[famFinUrgNote]",fam.ListPats[0].FamFinUrgNote);
fldval=fldval.Replace("[guarantorNameF]",guarantorNameF);
fldval=fldval.Replace("[guarantorNameFL]",guarantorNameFL);
fldval=fldval.Replace("[guarantorNameL]",guarantorNameL);
fldval=fldval.Replace("[guarantorNamePref]",guarantorNamePref);
fldval=fldval.Replace("[guarantorNameLF]",guarantorNameLF);
fldval=fldval.Replace("[gender]",Lan.g("enumPatientGender",pat.Gender.ToString()));
fldval=fldval.Replace("[genderHeShe]",genderHeShe);
fldval=fldval.Replace("[genderheshe]",genderheshe);
fldval=fldval.Replace("[genderHimHer]",genderHimHer);
fldval=fldval.Replace("[genderhimher]",genderhimher);
fldval=fldval.Replace("[genderHimselfHerself]",genderHimselfHerself);
fldval=fldval.Replace("[genderhimselfherself]",genderhimselfherself);
fldval=fldval.Replace("[genderHisHer]",genderHisHer);
fldval=fldval.Replace("[genderhisher]",genderhisher);
fldval=fldval.Replace("[genderHisHers]",genderHisHers);
fldval=fldval.Replace("[genderhishers]",genderhishers);
fldval=fldval.Replace("[guarantorNameFL]",fam.ListPats[0].GetNameFL());
fldval=fldval.Replace("[HmPhone]",StripPhoneBeyondSpace(pat.HmPhone));
fldval=fldval.Replace("[insAnnualMax]",insAnnualMax);
fldval=fldval.Replace("[insDeductible]",insDeductible);
fldval=fldval.Replace("[insDeductibleUsed]",insDeductibleUsed);
fldval=fldval.Replace("[insFreqBW]",insFreqBW.TrimEnd());
fldval=fldval.Replace("[insFreqExams]",insFreqExams.TrimEnd());
fldval=fldval.Replace("[insFreqPanoFMX]",insFreqPanoFMX.TrimEnd());
fldval=fldval.Replace("[insPending]",insPending);
fldval=fldval.Replace("[insPercentages]",insPercentages);
fldval=fldval.Replace("[insPlanGroupNumber]",insPlanGroupNumber);
fldval=fldval.Replace("[insPlanGroupName]",insPlanGroupName);
fldval=fldval.Replace("[insPlanNote]",insPlanNote);
fldval=fldval.Replace("[insType]",insType);
fldval=fldval.Replace("[insSubNote]",insSubNote);
fldval=fldval.Replace("[insRemaining]",insRemaining);
fldval=fldval.Replace("[insUsed]",insUsed);
fldval=fldval.Replace("[ins2AnnualMax]",ins2AnnualMax);
fldval=fldval.Replace("[ins2Deductible]",ins2Deductible);
fldval=fldval.Replace("[ins2DeductibleUsed]",ins2DeductibleUsed);
fldval=fldval.Replace("[ins2Pending]",ins2Pending);
fldval=fldval.Replace("[ins2Percentages]",ins2Percentages);
fldval=fldval.Replace("[ins2Remaining]",ins2Remaining);
fldval=fldval.Replace("[ins2Used]",ins2Used);
fldval=fldval.Replace("[MedUrgNote]",pat.MedUrgNote);
fldval=fldval.Replace("[nameF]",pat.FName);
fldval=fldval.Replace("[nameFL]",pat.GetNameFL());
fldval=fldval.Replace("[nameFLFormal]",pat.GetNameFLFormal());
fldval=fldval.Replace("[nameL]",pat.LName);
fldval=fldval.Replace("[nameLF]",pat.GetNameLF());
fldval=fldval.Replace("[nameMI]",pat.MiddleI);
fldval=fldval.Replace("[namePref]",pat.Preferred);
fldval=fldval.Replace("[nextSchedApptDateT]",nextSchedApptDateT);
fldval=fldval.Replace("[nextSchedApptsFam]",nextSchedApptsFam.TrimEnd());
fldval=fldval.Replace("[PatNum]",pat.PatNum.ToString());
fldval=fldval.Replace("[plannedAppointmentInfo]",plannedAppointmentInfo);
fldval=fldval.Replace("[priProvNameFormal]",priProv.GetFormalName());
fldval=fldval.Replace("[recallInterval]",recallInterval);
fldval=fldval.Replace("[referredFrom]",referredFrom);
fldval=fldval.Replace("[referredTo]",referredTo.TrimEnd());
fldval=fldval.Replace("[salutation]",pat.GetSalutation());
fldval=fldval.Replace("[serviceNote]",serviceNote);
fldval=fldval.Replace("[siteDescription]",Sites.GetDescription(pat.SiteNum));
fldval=fldval.Replace("[subscriberID]",subscriberId);
fldval=fldval.Replace("[subscriberNameFL]",subscriberNameFL);
fldval=fldval.Replace("[subscriber2NameFL]",subscriber2NameFL);
fldval=fldval.Replace("[timeNow]",DateTime.Now.ToShortTimeString());
fldval=fldval.Replace("[tpResponsPartyAddress]",tpResponsPartyAddress);
fldval=fldval.Replace("[tpResponsPartyCityStZip]",tpResponsPartyCityStZip);
fldval=fldval.Replace("[tpResponsPartyNameFL]",tpResponsPartyNameFL);
fldval=fldval.Replace("[treatmentPlanProcs]",treatmentPlanProcs);
fldval=fldval.Replace("[WirelessPhone]",StripPhoneBeyondSpace(pat.WirelessPhone));
fldval=fldval.Replace("[WkPhone]",StripPhoneBeyondSpace(pat.WkPhone));
}
fldval=fldval.Replace("[dateToday]",DateTime.Today.ToShortDateString());
fldval=fldval.Replace("[practiceTitle]",PrefC.GetString(PrefName.PracticeTitle));
field.FieldValue=fldval;
}
}
