///<summary>Usually set useExistingPK=true. Inserts one Appointmentm into the database.</summary>
internal static long Insert(Appointmentm appointmentm,bool useExistingPK){
if(!useExistingPK) {
appointmentm.AptNum=ReplicationServers.GetKey("appointmentm","AptNum");
}
string command="INSERT INTO appointmentm (";
command+="AptNum,";
command+="CustomerNum,PatNum,AptStatus,Pattern,Confirmed,Op,Note,ProvNum,ProvHyg,AptDateTime,IsNewPatient,ProcDescript,ClinicNum,IsHygiene) VALUES(";
command+=POut.Long(appointmentm.AptNum)+",";
command+=
POut.Long (appointmentm.CustomerNum)+","
+ POut.Long (appointmentm.PatNum)+","
+ POut.Int ((int)appointmentm.AptStatus)+","
+"'"+POut.String(appointmentm.Pattern)+"',"
+ POut.Long (appointmentm.Confirmed)+","
+ POut.Long (appointmentm.Op)+","
+"'"+POut.String(appointmentm.Note)+"',"
+ POut.Long (appointmentm.ProvNum)+","
+ POut.Long (appointmentm.ProvHyg)+","
+ POut.DateT (appointmentm.AptDateTime)+","
+ POut.Bool (appointmentm.IsNewPatient)+","
+"'"+POut.String(appointmentm.ProcDescript)+"',"
+ POut.Long (appointmentm.ClinicNum)+","
+ POut.Bool (appointmentm.IsHygiene)+")";
Db.NonQ(command);//There is no autoincrement in the mobile server.
return appointmentm.AptNum;
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <Appointmentm> TableToList(DataTable table)
{
List <Appointmentm> retVal = new List <Appointmentm>();
Appointmentm appointmentm;
for (int i = 0; i < table.Rows.Count; i++)
{
appointmentm = new Appointmentm();
appointmentm.CustomerNum = PIn.Long(table.Rows[i]["CustomerNum"].ToString());
appointmentm.AptNum = PIn.Long(table.Rows[i]["AptNum"].ToString());
appointmentm.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
appointmentm.AptStatus = (ApptStatus)PIn.Int(table.Rows[i]["AptStatus"].ToString());
appointmentm.Pattern = PIn.String(table.Rows[i]["Pattern"].ToString());
appointmentm.Confirmed = PIn.Long(table.Rows[i]["Confirmed"].ToString());
appointmentm.Op = PIn.Long(table.Rows[i]["Op"].ToString());
appointmentm.Note = PIn.String(table.Rows[i]["Note"].ToString());
appointmentm.ProvNum = PIn.Long(table.Rows[i]["ProvNum"].ToString());
appointmentm.ProvHyg = PIn.Long(table.Rows[i]["ProvHyg"].ToString());
appointmentm.AptDateTime = PIn.DateT(table.Rows[i]["AptDateTime"].ToString());
appointmentm.IsNewPatient = PIn.Bool(table.Rows[i]["IsNewPatient"].ToString());
appointmentm.ProcDescript = PIn.String(table.Rows[i]["ProcDescript"].ToString());
appointmentm.ClinicNum = PIn.Long(table.Rows[i]["ClinicNum"].ToString());
appointmentm.IsHygiene = PIn.Bool(table.Rows[i]["IsHygiene"].ToString());
retVal.Add(appointmentm);
}
return(retVal);
}
///<summary>Usually set useExistingPK=true. Inserts one Appointmentm into the database.</summary>
internal static long Insert(Appointmentm appointmentm, bool useExistingPK)
{
if (!useExistingPK)
{
appointmentm.AptNum = ReplicationServers.GetKey("appointmentm", "AptNum");
}
string command = "INSERT INTO appointmentm (";
command += "AptNum,";
command += "CustomerNum,PatNum,AptStatus,Pattern,Confirmed,Op,Note,ProvNum,ProvHyg,AptDateTime,IsNewPatient,ProcDescript,ClinicNum,IsHygiene) VALUES(";
command += POut.Long(appointmentm.AptNum) + ",";
command +=
POut.Long(appointmentm.CustomerNum) + ","
+ POut.Long(appointmentm.PatNum) + ","
+ POut.Int((int)appointmentm.AptStatus) + ","
+ "'" + POut.String(appointmentm.Pattern) + "',"
+ POut.Long(appointmentm.Confirmed) + ","
+ POut.Long(appointmentm.Op) + ","
+ "'" + POut.String(appointmentm.Note) + "',"
+ POut.Long(appointmentm.ProvNum) + ","
+ POut.Long(appointmentm.ProvHyg) + ","
+ POut.DateT(appointmentm.AptDateTime) + ","
+ POut.Bool(appointmentm.IsNewPatient) + ","
+ "'" + POut.String(appointmentm.ProcDescript) + "',"
+ POut.Long(appointmentm.ClinicNum) + ","
+ POut.Bool(appointmentm.IsHygiene) + ")";
Db.NonQ(command); //There is no autoincrement in the mobile server.
return(appointmentm.AptNum);
}
public string GetProviderColor(Appointmentm ap)
{
string HexColor = "#FFFFFF";
try {
Providerm pv;
if (ap.AptStatus == ApptStatus.Complete)
{
return("#808080"); //gray
}
if (ap.IsHygiene)
{
if (ap.ProvHyg == 0) //no hygenist
{
return(HexColor);
}
pv = Providerms.GetOne(CustomerNum, ap.ProvHyg);
}
else
{
pv = Providerms.GetOne(CustomerNum, ap.ProvNum);
}
if (pv != null)
{
HexColor = ColorTranslator.ToHtml(pv.ProvColor);
}
return(HexColor);
}
catch (Exception ex) {
Logger.LogError("CustomerNum=" + CustomerNum + " ap.ProvNum=" + ap.ProvNum, ex);
return(HexColor);
}
}
public string GetApptBrokenStatus(Appointmentm ap)
{
if (ap.AptStatus == ApptStatus.Broken)
{
return(@"<div style=""font-style: italic;color: #FF0000;font-weight:normal"">Broken</div>");
}
return("");
}
///<summary>Updates one Appointmentm in the database.</summary>
internal static void Update(Appointmentm appointmentm)
{
string command = "UPDATE appointmentm SET "
+ "PatNum = " + POut.Long(appointmentm.PatNum) + ", "
+ "AptStatus = " + POut.Int((int)appointmentm.AptStatus) + ", "
+ "Pattern = '" + POut.String(appointmentm.Pattern) + "', "
+ "Confirmed = " + POut.Long(appointmentm.Confirmed) + ", "
+ "Op = " + POut.Long(appointmentm.Op) + ", "
+ "Note = '" + POut.String(appointmentm.Note) + "', "
+ "ProvNum = " + POut.Long(appointmentm.ProvNum) + ", "
+ "ProvHyg = " + POut.Long(appointmentm.ProvHyg) + ", "
+ "AptDateTime = " + POut.DateT(appointmentm.AptDateTime) + ", "
+ "IsNewPatient= " + POut.Bool(appointmentm.IsNewPatient) + ", "
+ "ProcDescript= '" + POut.String(appointmentm.ProcDescript) + "', "
+ "ClinicNum = " + POut.Long(appointmentm.ClinicNum) + ", "
+ "IsHygiene = " + POut.Bool(appointmentm.IsHygiene) + " "
+ "WHERE CustomerNum = " + POut.Long(appointmentm.CustomerNum) + " AND AptNum = " + POut.Long(appointmentm.AptNum);
Db.NonQ(command);
}
///<summary>Converts one Appointment object to its mobile equivalent. Warning! CustomerNum will always be 0.</summary>
internal static Appointmentm ConvertToM(Appointment appointment)
{
Appointmentm appointmentm = new Appointmentm();
//CustomerNum cannot be set. Remains 0.
appointmentm.AptNum = appointment.AptNum;
appointmentm.PatNum = appointment.PatNum;
appointmentm.AptStatus = appointment.AptStatus;
appointmentm.Pattern = appointment.Pattern;
appointmentm.Confirmed = appointment.Confirmed;
appointmentm.Op = appointment.Op;
appointmentm.Note = appointment.Note;
appointmentm.ProvNum = appointment.ProvNum;
appointmentm.ProvHyg = appointment.ProvHyg;
appointmentm.AptDateTime = appointment.AptDateTime;
appointmentm.IsNewPatient = appointment.IsNewPatient;
appointmentm.ProcDescript = appointment.ProcDescript;
appointmentm.ClinicNum = appointment.ClinicNum;
appointmentm.IsHygiene = appointment.IsHygiene;
return(appointmentm);
}
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);
}
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List<Appointmentm> TableToList(DataTable table){
List<Appointmentm> retVal=new List<Appointmentm>();
Appointmentm appointmentm;
for(int i=0;i<table.Rows.Count;i++) {
appointmentm=new Appointmentm();
appointmentm.CustomerNum = PIn.Long (table.Rows[i]["CustomerNum"].ToString());
appointmentm.AptNum = PIn.Long (table.Rows[i]["AptNum"].ToString());
appointmentm.PatNum = PIn.Long (table.Rows[i]["PatNum"].ToString());
appointmentm.AptStatus = (ApptStatus)PIn.Int(table.Rows[i]["AptStatus"].ToString());
appointmentm.Pattern = PIn.String(table.Rows[i]["Pattern"].ToString());
appointmentm.Confirmed = PIn.Long (table.Rows[i]["Confirmed"].ToString());
appointmentm.Op = PIn.Long (table.Rows[i]["Op"].ToString());
appointmentm.Note = PIn.String(table.Rows[i]["Note"].ToString());
appointmentm.ProvNum = PIn.Long (table.Rows[i]["ProvNum"].ToString());
appointmentm.ProvHyg = PIn.Long (table.Rows[i]["ProvHyg"].ToString());
appointmentm.AptDateTime = PIn.DateT (table.Rows[i]["AptDateTime"].ToString());
appointmentm.IsNewPatient= PIn.Bool (table.Rows[i]["IsNewPatient"].ToString());
appointmentm.ProcDescript= PIn.String(table.Rows[i]["ProcDescript"].ToString());
appointmentm.ClinicNum = PIn.Long (table.Rows[i]["ClinicNum"].ToString());
appointmentm.IsHygiene = PIn.Bool (table.Rows[i]["IsHygiene"].ToString());
retVal.Add(appointmentm);
}
return retVal;
}
///<summary>Updates one Appointmentm in the database.</summary>
internal static void Update(Appointmentm appointmentm){
string command="UPDATE appointmentm SET "
+"PatNum = "+POut.Long (appointmentm.PatNum)+", "
+"AptStatus = "+POut.Int ((int)appointmentm.AptStatus)+", "
+"Pattern = '"+POut.String(appointmentm.Pattern)+"', "
+"Confirmed = "+POut.Long (appointmentm.Confirmed)+", "
+"Op = "+POut.Long (appointmentm.Op)+", "
+"Note = '"+POut.String(appointmentm.Note)+"', "
+"ProvNum = "+POut.Long (appointmentm.ProvNum)+", "
+"ProvHyg = "+POut.Long (appointmentm.ProvHyg)+", "
+"AptDateTime = "+POut.DateT (appointmentm.AptDateTime)+", "
+"IsNewPatient= "+POut.Bool (appointmentm.IsNewPatient)+", "
+"ProcDescript= '"+POut.String(appointmentm.ProcDescript)+"', "
+"ClinicNum = "+POut.Long (appointmentm.ClinicNum)+", "
+"IsHygiene = "+POut.Bool (appointmentm.IsHygiene)+" "
+"WHERE CustomerNum = "+POut.Long(appointmentm.CustomerNum)+" AND AptNum = "+POut.Long(appointmentm.AptNum);
Db.NonQ(command);
}
///<summary>Converts one Appointment object to its mobile equivalent. Warning! CustomerNum will always be 0.</summary>
internal static Appointmentm ConvertToM(Appointment appointment){
Appointmentm appointmentm=new Appointmentm();
//CustomerNum cannot be set. Remains 0.
appointmentm.AptNum =appointment.AptNum;
appointmentm.PatNum =appointment.PatNum;
appointmentm.AptStatus =appointment.AptStatus;
appointmentm.Pattern =appointment.Pattern;
appointmentm.Confirmed =appointment.Confirmed;
appointmentm.Op =appointment.Op;
appointmentm.Note =appointment.Note;
appointmentm.ProvNum =appointment.ProvNum;
appointmentm.ProvHyg =appointment.ProvHyg;
appointmentm.AptDateTime =appointment.AptDateTime;
appointmentm.IsNewPatient=appointment.IsNewPatient;
appointmentm.ProcDescript=appointment.ProcDescript;
appointmentm.ClinicNum =appointment.ClinicNum;
appointmentm.IsHygiene =appointment.IsHygiene;
return appointmentm;
}
