///<summary></summary>
public static void Update(PlannedAppt plannedAppt) {
if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
Meth.GetVoid(MethodBase.GetCurrentMethod(),plannedAppt);
return;
}
Crud.PlannedApptCrud.Update(plannedAppt);
}
///<summary></summary>
public static long Insert(PlannedAppt plannedAppt) {
if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
plannedAppt.PlannedApptNum=Meth.GetLong(MethodBase.GetCurrentMethod(),plannedAppt);
return plannedAppt.PlannedApptNum;
}
return Crud.PlannedApptCrud.Insert(plannedAppt);
}
public static string AppointmentPlannedNoPlannedApt(bool verbose,bool isCheck)
{
if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
return Meth.GetString(MethodBase.GetCurrentMethod(),verbose,isCheck);
}
string log="";
if(isCheck) {
command="SELECT COUNT(*) FROM appointment WHERE AptStatus=6 AND AptNum NOT IN (SELECT AptNum FROM plannedappt)";
int numFound=PIn.Int(Db.GetCount(command));
if(numFound!=0 || verbose) {
log+=Lans.g("FormDatabaseMaintenance","Appointments with status set to planned without Planned Appointment: ")+numFound.ToString()+"\r\n";
}
}
else {
command="SELECT * FROM appointment WHERE AptStatus=6 AND AptNum NOT IN (SELECT AptNum FROM plannedappt)";
DataTable appts=Db.GetTable(command);
if(appts.Rows.Count > 0 || verbose){
PlannedAppt plannedAppt;
for(int i=0;i<appts.Rows.Count;i++) {
plannedAppt=new PlannedAppt();
plannedAppt.PatNum=PIn.Long(appts.Rows[i]["PatNum"].ToString());
plannedAppt.AptNum=PIn.Long(appts.Rows[i]["AptNum"].ToString());
plannedAppt.ItemOrder=1;
PlannedAppts.Insert(plannedAppt);
}
log+=Lans.g("FormDatabaseMaintenance","Planned Appointments created for Appointments with status set to planned and no Planned Appointment: ")+appts.Rows.Count+"\r\n";
}
}
return log;
}
///<summary></summary>
public static void Update(PlannedAppt plannedAppt)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
Meth.GetVoid(MethodBase.GetCurrentMethod(), plannedAppt);
return;
}
Crud.PlannedApptCrud.Update(plannedAppt);
}
///<summary></summary>
public static long Insert(PlannedAppt plannedAppt)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
plannedAppt.PlannedApptNum = Meth.GetLong(MethodBase.GetCurrentMethod(), plannedAppt);
return(plannedAppt.PlannedApptNum);
}
return(Crud.PlannedApptCrud.Insert(plannedAppt));
}
private void butNew_Click(object sender,EventArgs e) {
/*if(ApptPlanned.Visible){
if(MessageBox.Show(Lan.g(this,"Replace existing planned appointment?")
,"",MessageBoxButtons.OKCancel)!=DialogResult.OK)
return;
//Procedures.UnattachProcsInPlannedAppt(ApptPlanned.Info.MyApt.AptNum);
AppointmentL.Delete(PIn.PInt(ApptPlanned.DataRoww["AptNum"].ToString()));
}*/
Appointment AptCur=new Appointment();
AptCur.PatNum=PatCur.PatNum;
AptCur.ProvNum=PatCur.PriProv;
AptCur.ClinicNum=PatCur.ClinicNum;
AptCur.AptStatus=ApptStatus.Planned;
AptCur.AptDateTime=DateTimeOD.Today;
AptCur.Pattern="/X/";
AptCur.TimeLocked=PrefC.GetBool(PrefName.AppointmentTimeIsLocked);
Appointments.Insert(AptCur);
PlannedAppt plannedAppt=new PlannedAppt();
plannedAppt.AptNum=AptCur.AptNum;
plannedAppt.PatNum=PatCur.PatNum;
plannedAppt.ItemOrder=TablePlanned.Rows.Count+1;
PlannedAppts.Insert(plannedAppt);
FormApptEdit FormApptEdit2=new FormApptEdit(AptCur.AptNum);
FormApptEdit2.IsNew=true;
FormApptEdit2.ShowDialog();
if(FormApptEdit2.DialogResult!=DialogResult.OK){
//delete new appt, delete plannedappt, and unattach procs already handled in dialog
Refresh();
return;
}
List<Procedure> myProcList=Procedures.Refresh(PatCur.PatNum);
bool allProcsHyg=true;
for(int i=0;i<myProcList.Count;i++){
if(myProcList[i].PlannedAptNum!=AptCur.AptNum)
continue;//only concerned with procs on this plannedAppt
if(!ProcedureCodes.GetProcCode(myProcList[i].CodeNum).IsHygiene){
allProcsHyg=false;
break;
}
}
if(allProcsHyg && PatCur.SecProv!=0){
Appointment aptOld=AptCur.Clone();
AptCur.ProvNum=PatCur.SecProv;
Appointments.Update(AptCur,aptOld);
}
Patient patOld=PatCur.Copy();
//PatCur.NextAptNum=AptCur.AptNum;
PatCur.PlannedIsDone=false;
Patients.Update(PatCur,patOld);
Refresh();//if procs were added in appt, then this will display them
}
///<summary>Runs the required queries to populate the necessary StaticTextData fields corresponding to staticTextDependencies.</summary>
private void LoadData(StaticTextFieldDependency staticTextDependencies, Patient pat, Family fam, List <long> listProcCodeNums)
{
bool isMiddleTier = (RemotingClient.RemotingRole == RemotingRole.ServerWeb);
System.Diagnostics.Stopwatch timer = null;
if (ODBuild.IsDebug())
{
timer = new System.Diagnostics.Stopwatch();
timer.Start();
}
if (staticTextDependencies.HasFlag(StaticTextFieldDependency.Pat))
{
//patient should already be loaded.
}
if (fam == null && staticTextDependencies.HasFlag(StaticTextFieldDependency.Fam))
{
fam = Patients.GetFamily(pat.PatNum);
}
if (PatNote == null)
{
if (staticTextDependencies.HasFlag(StaticTextFieldDependency.PatNote))
{
PatNote = PatientNotes.Refresh(pat.PatNum, pat.Guarantor);
}
else
{
PatNote = new PatientNote();
}
}
bool IsQueryNeeded <T>(ref List <T> list, StaticTextFieldDependency dependency)
{
if (list == null || (isMiddleTier && list.Count == 0)) //Middle Tier deserializes null lists to empty lists.
{
if (staticTextDependencies.HasFlag(dependency))
{
return(true);
}
else
{
list = new List <T>();
}
}
return(false);
}
if (IsQueryNeeded(ref ListRefAttaches, StaticTextFieldDependency.ListRefAttaches))
{
ListRefAttaches = RefAttaches.Refresh(pat.PatNum);
}
if (IsQueryNeeded(ref ListInsSubs, StaticTextFieldDependency.ListInsSubs))
{
ListInsSubs = InsSubs.RefreshForFam(fam);
}
if (IsQueryNeeded(ref ListInsPlans, StaticTextFieldDependency.ListInsPlans))
{
ListInsPlans = InsPlans.RefreshForSubList(ListInsSubs);
}
if (IsQueryNeeded(ref ListPatPlans, StaticTextFieldDependency.ListPatPlans))
{
ListPatPlans = PatPlans.Refresh(pat.PatNum);
}
if (IsQueryNeeded(ref ListBenefits, StaticTextFieldDependency.ListBenefits))
{
ListBenefits = Benefits.Refresh(ListPatPlans, ListInsSubs);
}
if (IsQueryNeeded(ref HistList, StaticTextFieldDependency.HistList))
{
HistList = ClaimProcs.GetHistList(pat.PatNum, ListBenefits, ListPatPlans, ListInsPlans, DateTime.Today, ListInsSubs);
}
if (IsQueryNeeded(ref ListTreatPlans, StaticTextFieldDependency.ListTreatPlans))
{
ListTreatPlans = TreatPlans.Refresh(pat.PatNum);
}
if (IsQueryNeeded(ref ListRecallsForFam, StaticTextFieldDependency.ListRecallsForFam))
{
ListRecallsForFam = Recalls.GetList(fam.ListPats.Select(x => x.PatNum).ToList());
}
if (IsQueryNeeded(ref ListAppts, StaticTextFieldDependency.ListAppts))
{
ListAppts = Appointments.GetListForPat(pat.PatNum);
}
if (IsQueryNeeded(ref ListFutureApptsForFam, StaticTextFieldDependency.ListFutureApptsForFam))
{
ListFutureApptsForFam = Appointments.GetFutureSchedApts(fam.ListPats.Select(x => x.PatNum).ToList());
}
if (IsQueryNeeded(ref ListDiseases, StaticTextFieldDependency.ListDiseases))
{
ListDiseases = Diseases.Refresh(pat.PatNum, true);
}
if (IsQueryNeeded(ref ListAllergies, StaticTextFieldDependency.ListAllergies))
{
ListAllergies = Allergies.GetAll(pat.PatNum, false);
}
if (IsQueryNeeded(ref ListMedicationPats, StaticTextFieldDependency.ListMedicationPats))
{
ListMedicationPats = MedicationPats.Refresh(pat.PatNum, false);
}
if (IsQueryNeeded(ref ListFamPopups, StaticTextFieldDependency.ListFamPopups))
{
ListFamPopups = Popups.GetForFamily(pat);
}
if (IsQueryNeeded(ref ListProceduresSome, StaticTextFieldDependency.ListProceduresSome))
{
ListProceduresSome = Procedures.RefreshForProcCodeNums(pat.PatNum, listProcCodeNums);
}
if (IsQueryNeeded(ref ListProceduresPat, StaticTextFieldDependency.ListProceduresPat))
{
ListProceduresPat = Procedures.Refresh(pat.PatNum);
}
if (IsQueryNeeded(ref ListPlannedAppts, StaticTextFieldDependency.ListPlannedAppts))
{
ListPlannedAppts = new List <PlannedAppt>();
PlannedAppt plannedAppt = PlannedAppts.GetOneOrderedByItemOrder(pat.PatNum);
if (plannedAppt != null)
{
ListPlannedAppts.Add(plannedAppt);
}
}
if (ODBuild.IsDebug())
{
timer.Stop();
Console.WriteLine("Static text field query time (ms): " + timer.ElapsedMilliseconds);
}
}
