///<summary>Inserts one Dunning into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(Dunning dunning, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
dunning.DunningNum = ReplicationServers.GetKey("dunning", "DunningNum");
}
string command = "INSERT INTO dunning (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "DunningNum,";
}
command += "DunMessage,BillingType,AgeAccount,InsIsPending,MessageBold) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(dunning.DunningNum) + ",";
}
command +=
"'" + POut.String(dunning.DunMessage) + "',"
+ POut.Long(dunning.BillingType) + ","
+ POut.Byte(dunning.AgeAccount) + ","
+ POut.Int((int)dunning.InsIsPending) + ","
+ "'" + POut.String(dunning.MessageBold) + "')";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
dunning.DunningNum = Db.NonQ(command, true);
}
return(dunning.DunningNum);
}
///<summary>Inserts one JobLink into the database. Provides option to use the existing priKey.</summary>
public static long Insert(JobLink jobLink, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
jobLink.JobLinkNum = ReplicationServers.GetKey("joblink", "JobLinkNum");
}
string command = "INSERT INTO joblink (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "JobLinkNum,";
}
command += "JobNum,FKey,LinkType,Tag,DisplayOverride) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(jobLink.JobLinkNum) + ",";
}
command +=
POut.Long(jobLink.JobNum) + ","
+ POut.Long(jobLink.FKey) + ","
+ POut.Int((int)jobLink.LinkType) + ","
+ "'" + POut.String(jobLink.Tag) + "',"
+ "'" + POut.String(jobLink.DisplayOverride) + "')";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
jobLink.JobLinkNum = Db.NonQ(command, true, "JobLinkNum", "jobLink");
}
return(jobLink.JobLinkNum);
}
///<summary>Inserts one AutoNote into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(AutoNote autoNote, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
autoNote.AutoNoteNum = ReplicationServers.GetKey("autonote", "AutoNoteNum");
}
string command = "INSERT INTO autonote (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "AutoNoteNum,";
}
command += "AutoNoteName,MainText) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(autoNote.AutoNoteNum) + ",";
}
command +=
"'" + POut.String(autoNote.AutoNoteName) + "',"
+ "'" + POut.String(autoNote.MainText) + "')";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
autoNote.AutoNoteNum = Db.NonQ(command, true);
}
return(autoNote.AutoNoteNum);
}
///<summary>Inserts one ResellerService into the database. Provides option to use the existing priKey.</summary>
public static long Insert(ResellerService resellerService, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
resellerService.ResellerServiceNum = ReplicationServers.GetKey("resellerservice", "ResellerServiceNum");
}
string command = "INSERT INTO resellerservice (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "ResellerServiceNum,";
}
command += "ResellerNum,CodeNum,Fee) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(resellerService.ResellerServiceNum) + ",";
}
command +=
POut.Long(resellerService.ResellerNum) + ","
+ POut.Long(resellerService.CodeNum) + ","
+ "'" + POut.Double(resellerService.Fee) + "')";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
resellerService.ResellerServiceNum = Db.NonQ(command, true, "ResellerServiceNum", "resellerService");
}
return(resellerService.ResellerServiceNum);
}
///<summary>Inserts one Contact into the database. Provides option to use the existing priKey.</summary>
public static long Insert(Contact contact, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
contact.ContactNum = ReplicationServers.GetKey("contact", "ContactNum");
}
string command = "INSERT INTO contact (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "ContactNum,";
}
command += "LName,FName,WkPhone,Fax,Category,Notes) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(contact.ContactNum) + ",";
}
command +=
"'" + POut.String(contact.LName) + "',"
+ "'" + POut.String(contact.FName) + "',"
+ "'" + POut.String(contact.WkPhone) + "',"
+ "'" + POut.String(contact.Fax) + "',"
+ POut.Long(contact.Category) + ","
+ "'" + POut.String(contact.Notes) + "')";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
contact.ContactNum = Db.NonQ(command, true);
}
return(contact.ContactNum);
}
///<summary>Inserts one ElectID into the database. Provides option to use the existing priKey.</summary>
public static long Insert(ElectID electID, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
electID.ElectIDNum = ReplicationServers.GetKey("electid", "ElectIDNum");
}
string command = "INSERT INTO electid (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "ElectIDNum,";
}
command += "PayorID,CarrierName,IsMedicaid,ProviderTypes,Comments) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(electID.ElectIDNum) + ",";
}
command +=
"'" + POut.String(electID.PayorID) + "',"
+ "'" + POut.String(electID.CarrierName) + "',"
+ POut.Bool(electID.IsMedicaid) + ","
+ "'" + POut.String(electID.ProviderTypes) + "',"
+ "'" + POut.String(electID.Comments) + "')";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
electID.ElectIDNum = Db.NonQ(command, true);
}
return(electID.ElectIDNum);
}
///<summary>Inserts one ProcMultiVisit into the database. Provides option to use the existing priKey.</summary>
public static long Insert(ProcMultiVisit procMultiVisit, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
procMultiVisit.ProcMultiVisitNum = ReplicationServers.GetKey("procmultivisit", "ProcMultiVisitNum");
}
string command = "INSERT INTO procmultivisit (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "ProcMultiVisitNum,";
}
command += "GroupProcMultiVisitNum,ProcNum,ProcStatus,IsInProcess) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(procMultiVisit.ProcMultiVisitNum) + ",";
}
command +=
POut.Long(procMultiVisit.GroupProcMultiVisitNum) + ","
+ POut.Long(procMultiVisit.ProcNum) + ","
+ POut.Int((int)procMultiVisit.ProcStatus) + ","
+ POut.Bool(procMultiVisit.IsInProcess) + ")";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
procMultiVisit.ProcMultiVisitNum = Db.NonQ(command, true, "ProcMultiVisitNum", "procMultiVisit");
}
return(procMultiVisit.ProcMultiVisitNum);
}
///<summary>Inserts one PayPeriod into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(PayPeriod payPeriod, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
payPeriod.PayPeriodNum = ReplicationServers.GetKey("payperiod", "PayPeriodNum");
}
string command = "INSERT INTO payperiod (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "PayPeriodNum,";
}
command += "DateStart,DateStop,DatePaycheck) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(payPeriod.PayPeriodNum) + ",";
}
command +=
POut.Date(payPeriod.DateStart) + ","
+ POut.Date(payPeriod.DateStop) + ","
+ POut.Date(payPeriod.DatePaycheck) + ")";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
payPeriod.PayPeriodNum = Db.NonQ(command, true);
}
return(payPeriod.PayPeriodNum);
}
///<summary>Inserts one AutomationCondition into the database. Provides option to use the existing priKey.</summary>
public static long Insert(AutomationCondition automationCondition, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
automationCondition.AutomationConditionNum = ReplicationServers.GetKey("automationcondition", "AutomationConditionNum");
}
string command = "INSERT INTO automationcondition (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "AutomationConditionNum,";
}
command += "AutomationNum,CompareField,Comparison,CompareString) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(automationCondition.AutomationConditionNum) + ",";
}
command +=
POut.Long(automationCondition.AutomationNum) + ","
+ POut.Int((int)automationCondition.CompareField) + ","
+ POut.Int((int)automationCondition.Comparison) + ","
+ "'" + POut.String(automationCondition.CompareString) + "')";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
automationCondition.AutomationConditionNum = Db.NonQ(command, true, "AutomationConditionNum", "automationCondition");
}
return(automationCondition.AutomationConditionNum);
}
///<summary>Inserts one AllergyDef into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(AllergyDef allergyDef, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
allergyDef.AllergyDefNum = ReplicationServers.GetKey("allergydef", "AllergyDefNum");
}
string command = "INSERT INTO allergydef (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "AllergyDefNum,";
}
command += "Description,IsHidden,Snomed,MedicationNum) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(allergyDef.AllergyDefNum) + ",";
}
command +=
"'" + POut.String(allergyDef.Description) + "',"
+ POut.Bool(allergyDef.IsHidden) + ","
//DateTStamp can only be set by MySQL
+ POut.Int((int)allergyDef.Snomed) + ","
+ POut.Long(allergyDef.MedicationNum) + ")";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
allergyDef.AllergyDefNum = Db.NonQ(command, true);
}
return(allergyDef.AllergyDefNum);
}
///<summary>Inserts one VaccineDef into the database. Provides option to use the existing priKey.</summary>
public static long Insert(VaccineDef vaccineDef, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
vaccineDef.VaccineDefNum = ReplicationServers.GetKey("vaccinedef", "VaccineDefNum");
}
string command = "INSERT INTO vaccinedef (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "VaccineDefNum,";
}
command += "CVXCode,VaccineName,DrugManufacturerNum) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(vaccineDef.VaccineDefNum) + ",";
}
command +=
"'" + POut.String(vaccineDef.CVXCode) + "',"
+ "'" + POut.String(vaccineDef.VaccineName) + "',"
+ POut.Long(vaccineDef.DrugManufacturerNum) + ")";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
vaccineDef.VaccineDefNum = Db.NonQ(command, true, "VaccineDefNum", "vaccineDef");
}
return(vaccineDef.VaccineDefNum);
}
///<summary>Inserts one Letter into the database. Provides option to use the existing priKey.</summary>
public static long Insert(Letter letter,bool useExistingPK){
if(!useExistingPK && PrefC.RandomKeys) {
letter.LetterNum=ReplicationServers.GetKey("letter","LetterNum");
}
string command="INSERT INTO letter (";
if(useExistingPK || PrefC.RandomKeys) {
command+="LetterNum,";
}
command+="Description,BodyText) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(letter.LetterNum)+",";
}
command+=
"'"+POut.String(letter.Description)+"',"
+ DbHelper.ParamChar+"paramBodyText)";
if(letter.BodyText==null) {
letter.BodyText="";
}
OdSqlParameter paramBodyText=new OdSqlParameter("paramBodyText",OdDbType.Text,POut.StringParam(letter.BodyText));
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command,paramBodyText);
}
else {
letter.LetterNum=Db.NonQ(command,true,"LetterNum","letter",paramBodyText);
}
return letter.LetterNum;
}
///<summary>Inserts one FamilyHealth into the database. Provides option to use the existing priKey.</summary>
public static long Insert(FamilyHealth familyHealth, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
familyHealth.FamilyHealthNum = ReplicationServers.GetKey("familyhealth", "FamilyHealthNum");
}
string command = "INSERT INTO familyhealth (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "FamilyHealthNum,";
}
command += "PatNum,Relationship,DiseaseDefNum,PersonName) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(familyHealth.FamilyHealthNum) + ",";
}
command +=
POut.Long(familyHealth.PatNum) + ","
+ POut.Int((int)familyHealth.Relationship) + ","
+ POut.Long(familyHealth.DiseaseDefNum) + ","
+ "'" + POut.String(familyHealth.PersonName) + "')";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
familyHealth.FamilyHealthNum = Db.NonQ(command, true, "FamilyHealthNum", "familyHealth");
}
return(familyHealth.FamilyHealthNum);
}
///<summary>Inserts one CustRefEntry into the database. Provides option to use the existing priKey.</summary>
public static long Insert(CustRefEntry custRefEntry, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
custRefEntry.CustRefEntryNum = ReplicationServers.GetKey("custrefentry", "CustRefEntryNum");
}
string command = "INSERT INTO custrefentry (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "CustRefEntryNum,";
}
command += "PatNumCust,PatNumRef,DateEntry,Note) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(custRefEntry.CustRefEntryNum) + ",";
}
command +=
POut.Long(custRefEntry.PatNumCust) + ","
+ POut.Long(custRefEntry.PatNumRef) + ","
+ POut.Date(custRefEntry.DateEntry) + ","
+ "'" + POut.String(custRefEntry.Note) + "')";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
custRefEntry.CustRefEntryNum = Db.NonQ(command, true);
}
return(custRefEntry.CustRefEntryNum);
}
///<summary>Inserts one ConnGroupAttach into the database. Provides option to use the existing priKey.</summary>
public static long Insert(ConnGroupAttach connGroupAttach, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
connGroupAttach.ConnGroupAttachNum = ReplicationServers.GetKey("conngroupattach", "ConnGroupAttachNum");
}
string command = "INSERT INTO conngroupattach (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "ConnGroupAttachNum,";
}
command += "ConnectionGroupNum,CentralConnectionNum) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(connGroupAttach.ConnGroupAttachNum) + ",";
}
command +=
POut.Long(connGroupAttach.ConnectionGroupNum) + ","
+ POut.Long(connGroupAttach.CentralConnectionNum) + ")";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
connGroupAttach.ConnGroupAttachNum = Db.NonQ(command, true, "ConnGroupAttachNum", "connGroupAttach");
}
return(connGroupAttach.ConnGroupAttachNum);
}
///<summary>Inserts one Employee into the database. Provides option to use the existing priKey.</summary>
public static long Insert(Employee employee, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
employee.EmployeeNum = ReplicationServers.GetKey("employee", "EmployeeNum");
}
string command = "INSERT INTO employee (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "EmployeeNum,";
}
command += "LName,FName,MiddleI,IsHidden,ClockStatus,PhoneExt,PayrollID) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(employee.EmployeeNum) + ",";
}
command +=
"'" + POut.String(employee.LName) + "',"
+ "'" + POut.String(employee.FName) + "',"
+ "'" + POut.String(employee.MiddleI) + "',"
+ POut.Bool(employee.IsHidden) + ","
+ "'" + POut.String(employee.ClockStatus) + "',"
+ POut.Int(employee.PhoneExt) + ","
+ "'" + POut.String(employee.PayrollID) + "')";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
employee.EmployeeNum = Db.NonQ(command, true, "EmployeeNum", "employee");
}
return(employee.EmployeeNum);
}
///<summary>Inserts one Automation into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(Automation automation, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
automation.AutomationNum = ReplicationServers.GetKey("automation", "AutomationNum");
}
string command = "INSERT INTO automation (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "AutomationNum,";
}
command += "Description,Autotrigger,ProcCodes,AutoAction,SheetDefNum,CommType,MessageContent) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(automation.AutomationNum) + ",";
}
command +=
"'" + POut.String(automation.Description) + "',"
+ POut.Int((int)automation.Autotrigger) + ","
+ "'" + POut.String(automation.ProcCodes) + "',"
+ POut.Int((int)automation.AutoAction) + ","
+ POut.Long(automation.SheetDefNum) + ","
+ POut.Long(automation.CommType) + ","
+ "'" + POut.String(automation.MessageContent) + "')";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
automation.AutomationNum = Db.NonQ(command, true);
}
return(automation.AutomationNum);
}
///<summary>Inserts one EvaluationDef into the database. Provides option to use the existing priKey.</summary>
public static long Insert(EvaluationDef evaluationDef, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
evaluationDef.EvaluationDefNum = ReplicationServers.GetKey("evaluationdef", "EvaluationDefNum");
}
string command = "INSERT INTO evaluationdef (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "EvaluationDefNum,";
}
command += "SchoolCourseNum,EvalTitle,GradingScaleNum) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(evaluationDef.EvaluationDefNum) + ",";
}
command +=
POut.Long(evaluationDef.SchoolCourseNum) + ","
+ "'" + POut.String(evaluationDef.EvalTitle) + "',"
+ POut.Long(evaluationDef.GradingScaleNum) + ")";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
evaluationDef.EvaluationDefNum = Db.NonQ(command, true, "EvaluationDefNum", "evaluationDef");
}
return(evaluationDef.EvaluationDefNum);
}
///<summary>Inserts one EduResource into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(EduResource eduResource, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
eduResource.EduResourceNum = ReplicationServers.GetKey("eduresource", "EduResourceNum");
}
string command = "INSERT INTO eduresource (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "EduResourceNum,";
}
command += "DiseaseDefNum,MedicationNum,LabResultID,LabResultName,LabResultCompare,ResourceUrl,Icd9Num) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(eduResource.EduResourceNum) + ",";
}
command +=
POut.Long(eduResource.DiseaseDefNum) + ","
+ POut.Long(eduResource.MedicationNum) + ","
+ "'" + POut.String(eduResource.LabResultID) + "',"
+ "'" + POut.String(eduResource.LabResultName) + "',"
+ "'" + POut.String(eduResource.LabResultCompare) + "',"
+ "'" + POut.String(eduResource.ResourceUrl) + "',"
+ POut.Long(eduResource.Icd9Num) + ")";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
eduResource.EduResourceNum = Db.NonQ(command, true);
}
return(eduResource.EduResourceNum);
}
///<summary>Inserts one ReminderRule into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(ReminderRule reminderRule, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
reminderRule.ReminderRuleNum = ReplicationServers.GetKey("reminderrule", "ReminderRuleNum");
}
string command = "INSERT INTO reminderrule (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "ReminderRuleNum,";
}
command += "ReminderCriterion,CriterionFK,CriterionValue,Message) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(reminderRule.ReminderRuleNum) + ",";
}
command +=
POut.Int((int)reminderRule.ReminderCriterion) + ","
+ POut.Long(reminderRule.CriterionFK) + ","
+ "'" + POut.String(reminderRule.CriterionValue) + "',"
+ "'" + POut.String(reminderRule.Message) + "')";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
reminderRule.ReminderRuleNum = Db.NonQ(command, true);
}
return(reminderRule.ReminderRuleNum);
}
///<summary>Inserts one LabTurnaround into the database. Provides option to use the existing priKey.</summary>
public static long Insert(LabTurnaround labTurnaround, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
labTurnaround.LabTurnaroundNum = ReplicationServers.GetKey("labturnaround", "LabTurnaroundNum");
}
string command = "INSERT INTO labturnaround (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "LabTurnaroundNum,";
}
command += "LaboratoryNum,Description,DaysPublished,DaysActual) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(labTurnaround.LabTurnaroundNum) + ",";
}
command +=
POut.Long(labTurnaround.LaboratoryNum) + ","
+ "'" + POut.String(labTurnaround.Description) + "',"
+ POut.Int(labTurnaround.DaysPublished) + ","
+ POut.Int(labTurnaround.DaysActual) + ")";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
labTurnaround.LabTurnaroundNum = Db.NonQ(command, true);
}
return(labTurnaround.LabTurnaroundNum);
}
///<summary>Inserts one JobPermission into the database. Provides option to use the existing priKey.</summary>
public static long Insert(JobPermission jobPermission, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
jobPermission.JobPermissionNum = ReplicationServers.GetKey("jobpermission", "JobPermissionNum");
}
string command = "INSERT INTO jobpermission (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "JobPermissionNum,";
}
command += "UserNum,JobPermType) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(jobPermission.JobPermissionNum) + ",";
}
command +=
POut.Long(jobPermission.UserNum) + ","
+ "'" + POut.String(jobPermission.JobPermType.ToString()) + "')";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
jobPermission.JobPermissionNum = Db.NonQ(command, true, "JobPermissionNum", "jobPermission");
}
return(jobPermission.JobPermissionNum);
}
///<summary>Inserts one SupplyOrder into the database. Provides option to use the existing priKey.</summary>
public static long Insert(SupplyOrder supplyOrder, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
supplyOrder.SupplyOrderNum = ReplicationServers.GetKey("supplyorder", "SupplyOrderNum");
}
string command = "INSERT INTO supplyorder (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "SupplyOrderNum,";
}
command += "SupplierNum,DatePlaced,Note,AmountTotal) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(supplyOrder.SupplyOrderNum) + ",";
}
command +=
POut.Long(supplyOrder.SupplierNum) + ","
+ POut.Date(supplyOrder.DatePlaced) + ","
+ "'" + POut.String(supplyOrder.Note) + "',"
+ "'" + POut.Double(supplyOrder.AmountTotal) + "')";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
supplyOrder.SupplyOrderNum = Db.NonQ(command, true);
}
return(supplyOrder.SupplyOrderNum);
}
///<summary>Inserts one Referral into the database. Provides option to use the existing priKey.</summary>
public static long Insert(Referral referral, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
referral.ReferralNum = ReplicationServers.GetKey("referral", "ReferralNum");
}
string command = "INSERT INTO referral (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "ReferralNum,";
}
command += "LName,FName,MName,SSN,UsingTIN,Specialty,ST,Telephone,Address,Address2,City,Zip,Note,Phone2,IsHidden,NotPerson,Title,EMail,PatNum,NationalProvID,Slip,IsDoctor,IsTrustedDirect,IsPreferred) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(referral.ReferralNum) + ",";
}
command +=
"'" + POut.String(referral.LName) + "',"
+ "'" + POut.String(referral.FName) + "',"
+ "'" + POut.String(referral.MName) + "',"
+ "'" + POut.String(referral.SSN) + "',"
+ POut.Bool(referral.UsingTIN) + ","
+ POut.Long(referral.Specialty) + ","
+ "'" + POut.String(referral.ST) + "',"
+ "'" + POut.String(referral.Telephone) + "',"
+ "'" + POut.String(referral.Address) + "',"
+ "'" + POut.String(referral.Address2) + "',"
+ "'" + POut.String(referral.City) + "',"
+ "'" + POut.String(referral.Zip) + "',"
+ DbHelper.ParamChar + "paramNote,"
+ "'" + POut.String(referral.Phone2) + "',"
+ POut.Bool(referral.IsHidden) + ","
+ POut.Bool(referral.NotPerson) + ","
+ "'" + POut.String(referral.Title) + "',"
+ "'" + POut.String(referral.EMail) + "',"
+ POut.Long(referral.PatNum) + ","
+ "'" + POut.String(referral.NationalProvID) + "',"
+ POut.Long(referral.Slip) + ","
+ POut.Bool(referral.IsDoctor) + ","
+ POut.Bool(referral.IsTrustedDirect) + ","
//DateTStamp can only be set by MySQL
+ POut.Bool(referral.IsPreferred) + ")";
if (referral.Note == null)
{
referral.Note = "";
}
OdSqlParameter paramNote = new OdSqlParameter("paramNote", OdDbType.Text, POut.StringParam(referral.Note));
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command, paramNote);
}
else
{
referral.ReferralNum = Db.NonQ(command, true, "ReferralNum", "referral", paramNote);
}
return(referral.ReferralNum);
}
///<summary>Inserts one Provider into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(Provider provider, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
provider.ProvNum = ReplicationServers.GetKey("provider", "ProvNum");
}
string command = "INSERT INTO provider (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "ProvNum,";
}
command += "Abbr,ItemOrder,LName,FName,MI,Suffix,FeeSched,Specialty,SSN,StateLicense,DEANum,IsSecondary,ProvColor,IsHidden,UsingTIN,BlueCrossID,SigOnFile,MedicaidID,OutlineColor,SchoolClassNum,NationalProvID,CanadianOfficeNum,AnesthProvType,TaxonomyCodeOverride,IsCDAnet,EcwID,EhrKey,StateRxID,EhrHasReportAccess,IsNotPerson) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(provider.ProvNum) + ",";
}
command +=
"'" + POut.String(provider.Abbr) + "',"
+ POut.Int(provider.ItemOrder) + ","
+ "'" + POut.String(provider.LName) + "',"
+ "'" + POut.String(provider.FName) + "',"
+ "'" + POut.String(provider.MI) + "',"
+ "'" + POut.String(provider.Suffix) + "',"
+ POut.Long(provider.FeeSched) + ","
+ POut.Int((int)provider.Specialty) + ","
+ "'" + POut.String(provider.SSN) + "',"
+ "'" + POut.String(provider.StateLicense) + "',"
+ "'" + POut.String(provider.DEANum) + "',"
+ POut.Bool(provider.IsSecondary) + ","
+ POut.Int(provider.ProvColor.ToArgb()) + ","
+ POut.Bool(provider.IsHidden) + ","
+ POut.Bool(provider.UsingTIN) + ","
+ "'" + POut.String(provider.BlueCrossID) + "',"
+ POut.Bool(provider.SigOnFile) + ","
+ "'" + POut.String(provider.MedicaidID) + "',"
+ POut.Int(provider.OutlineColor.ToArgb()) + ","
+ POut.Long(provider.SchoolClassNum) + ","
+ "'" + POut.String(provider.NationalProvID) + "',"
+ "'" + POut.String(provider.CanadianOfficeNum) + "',"
//DateTStamp can only be set by MySQL
+ POut.Long(provider.AnesthProvType) + ","
+ "'" + POut.String(provider.TaxonomyCodeOverride) + "',"
+ POut.Bool(provider.IsCDAnet) + ","
+ "'" + POut.String(provider.EcwID) + "',"
+ "'" + POut.String(provider.EhrKey) + "',"
+ "'" + POut.String(provider.StateRxID) + "',"
+ POut.Bool(provider.EhrHasReportAccess) + ","
+ POut.Bool(provider.IsNotPerson) + ")";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
provider.ProvNum = Db.NonQ(command, true);
}
return(provider.ProvNum);
}
///<summary>Inserts one Payment into the database. Provides option to use the existing priKey.</summary>
public static long Insert(Payment payment, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
payment.PayNum = ReplicationServers.GetKey("payment", "PayNum");
}
string command = "INSERT INTO payment (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "PayNum,";
}
command += "PayType,PayDate,PayAmt,CheckNum,BankBranch,PayNote,IsSplit,PatNum,ClinicNum,DateEntry,DepositNum,Receipt,IsRecurringCC,SecUserNumEntry,PaymentSource,ProcessStatus,RecurringChargeDate) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(payment.PayNum) + ",";
}
command +=
POut.Long(payment.PayType) + ","
+ POut.Date(payment.PayDate) + ","
+ "'" + POut.Double(payment.PayAmt) + "',"
+ "'" + POut.String(payment.CheckNum) + "',"
+ "'" + POut.String(payment.BankBranch) + "',"
+ DbHelper.ParamChar + "paramPayNote,"
+ POut.Bool(payment.IsSplit) + ","
+ POut.Long(payment.PatNum) + ","
+ POut.Long(payment.ClinicNum) + ","
+ DbHelper.Now() + ","
+ POut.Long(payment.DepositNum) + ","
+ DbHelper.ParamChar + "paramReceipt,"
+ POut.Bool(payment.IsRecurringCC) + ","
+ POut.Long(payment.SecUserNumEntry) + ","
//SecDateTEdit can only be set by MySQL
+ POut.Int((int)payment.PaymentSource) + ","
+ POut.Int((int)payment.ProcessStatus) + ","
+ POut.Date(payment.RecurringChargeDate) + ")";
if (payment.PayNote == null)
{
payment.PayNote = "";
}
OdSqlParameter paramPayNote = new OdSqlParameter("paramPayNote", OdDbType.Text, POut.StringNote(payment.PayNote));
if (payment.Receipt == null)
{
payment.Receipt = "";
}
OdSqlParameter paramReceipt = new OdSqlParameter("paramReceipt", OdDbType.Text, POut.StringParam(payment.Receipt));
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command, paramPayNote, paramReceipt);
}
else
{
payment.PayNum = Db.NonQ(command, true, "PayNum", "payment", paramPayNote, paramReceipt);
}
return(payment.PayNum);
}
///<summary>Inserts one LanguageForeign into the database. Provides option to use the existing priKey.</summary>
public static long Insert(LanguageForeign languageForeign, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
languageForeign.LanguageForeignNum = ReplicationServers.GetKey("languageforeign", "LanguageForeignNum");
}
string command = "INSERT INTO languageforeign (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "LanguageForeignNum,";
}
command += "ClassType,English,Culture,Translation,Comments) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(languageForeign.LanguageForeignNum) + ",";
}
command +=
DbHelper.ParamChar + "paramClassType,"
+ DbHelper.ParamChar + "paramEnglish,"
+ "'" + POut.String(languageForeign.Culture) + "',"
+ DbHelper.ParamChar + "paramTranslation,"
+ DbHelper.ParamChar + "paramComments)";
if (languageForeign.ClassType == null)
{
languageForeign.ClassType = "";
}
OdSqlParameter paramClassType = new OdSqlParameter("paramClassType", OdDbType.Text, POut.StringParam(languageForeign.ClassType));
if (languageForeign.English == null)
{
languageForeign.English = "";
}
OdSqlParameter paramEnglish = new OdSqlParameter("paramEnglish", OdDbType.Text, POut.StringParam(languageForeign.English));
if (languageForeign.Translation == null)
{
languageForeign.Translation = "";
}
OdSqlParameter paramTranslation = new OdSqlParameter("paramTranslation", OdDbType.Text, POut.StringParam(languageForeign.Translation));
if (languageForeign.Comments == null)
{
languageForeign.Comments = "";
}
OdSqlParameter paramComments = new OdSqlParameter("paramComments", OdDbType.Text, POut.StringParam(languageForeign.Comments));
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command, paramClassType, paramEnglish, paramTranslation, paramComments);
}
else
{
languageForeign.LanguageForeignNum = Db.NonQ(command, true, "LanguageForeignNum", "languageForeign", paramClassType, paramEnglish, paramTranslation, paramComments);
}
return(languageForeign.LanguageForeignNum);
}
///<summary>Inserts one ComputerPref into the database. Provides option to use the existing priKey.</summary>
public static long Insert(ComputerPref computerPref, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
computerPref.ComputerPrefNum = ReplicationServers.GetKey("computerpref", "ComputerPrefNum");
}
string command = "INSERT INTO computerpref (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "ComputerPrefNum,";
}
command += "ComputerName,GraphicsUseHardware,GraphicsSimple,SensorType,SensorBinned,SensorPort,SensorExposure,GraphicsDoubleBuffering,PreferredPixelFormatNum,AtoZpath,TaskKeepListHidden,TaskDock,TaskX,TaskY,DirectXFormat,ScanDocSelectSource,ScanDocShowOptions,ScanDocDuplex,ScanDocGrayscale,ScanDocResolution,ScanDocQuality,ClinicNum,ApptViewNum,RecentApptView,PatSelectSearchMode,NoShowLanguage,NoShowDecimal,ComputerOS,HelpButtonXAdjustment) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(computerPref.ComputerPrefNum) + ",";
}
command +=
"'" + POut.String(computerPref.ComputerName) + "',"
+ POut.Bool(computerPref.GraphicsUseHardware) + ","
+ POut.Int((int)computerPref.GraphicsSimple) + ","
+ "'" + POut.String(computerPref.SensorType) + "',"
+ POut.Bool(computerPref.SensorBinned) + ","
+ POut.Int(computerPref.SensorPort) + ","
+ POut.Int(computerPref.SensorExposure) + ","
+ POut.Bool(computerPref.GraphicsDoubleBuffering) + ","
+ POut.Int(computerPref.PreferredPixelFormatNum) + ","
+ "'" + POut.String(computerPref.AtoZpath) + "',"
+ POut.Bool(computerPref.TaskKeepListHidden) + ","
+ POut.Int(computerPref.TaskDock) + ","
+ POut.Int(computerPref.TaskX) + ","
+ POut.Int(computerPref.TaskY) + ","
+ "'" + POut.String(computerPref.DirectXFormat) + "',"
+ POut.Bool(computerPref.ScanDocSelectSource) + ","
+ POut.Bool(computerPref.ScanDocShowOptions) + ","
+ POut.Bool(computerPref.ScanDocDuplex) + ","
+ POut.Bool(computerPref.ScanDocGrayscale) + ","
+ POut.Int(computerPref.ScanDocResolution) + ","
+ POut.Byte(computerPref.ScanDocQuality) + ","
+ POut.Long(computerPref.ClinicNum) + ","
+ POut.Long(computerPref.ApptViewNum) + ","
+ POut.Byte(computerPref.RecentApptView) + ","
+ POut.Int((int)computerPref.PatSelectSearchMode) + ","
+ POut.Bool(computerPref.NoShowLanguage) + ","
+ POut.Bool(computerPref.NoShowDecimal) + ","
+ "'" + POut.String(computerPref.ComputerOS.ToString()) + "',"
+ "'" + POut.Double(computerPref.HelpButtonXAdjustment) + "')";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
computerPref.ComputerPrefNum = Db.NonQ(command, true, "ComputerPrefNum", "computerPref");
}
return(computerPref.ComputerPrefNum);
}
///<summary>Inserts one MedLabResult into the database. Provides option to use the existing priKey.</summary>
public static long Insert(MedLabResult medLabResult, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
medLabResult.MedLabResultNum = ReplicationServers.GetKey("medlabresult", "MedLabResultNum");
}
string command = "INSERT INTO medlabresult (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "MedLabResultNum,";
}
command += "MedLabNum,ObsID,ObsText,ObsLoinc,ObsLoincText,ObsIDSub,ObsValue,ObsSubType,ObsUnits,ReferenceRange,AbnormalFlag,ResultStatus,DateTimeObs,FacilityID,DocNum,Note) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(medLabResult.MedLabResultNum) + ",";
}
command +=
POut.Long(medLabResult.MedLabNum) + ","
+ "'" + POut.String(medLabResult.ObsID) + "',"
+ "'" + POut.String(medLabResult.ObsText) + "',"
+ "'" + POut.String(medLabResult.ObsLoinc) + "',"
+ "'" + POut.String(medLabResult.ObsLoincText) + "',"
+ "'" + POut.String(medLabResult.ObsIDSub) + "',"
+ DbHelper.ParamChar + "paramObsValue,"
+ "'" + POut.String(medLabResult.ObsSubType.ToString()) + "',"
+ "'" + POut.String(medLabResult.ObsUnits) + "',"
+ "'" + POut.String(medLabResult.ReferenceRange) + "',"
+ "'" + POut.String(medLabResult.AbnormalFlag.ToString()) + "',"
+ "'" + POut.String(medLabResult.ResultStatus.ToString()) + "',"
+ POut.DateT(medLabResult.DateTimeObs) + ","
+ "'" + POut.String(medLabResult.FacilityID) + "',"
+ POut.Long(medLabResult.DocNum) + ","
+ DbHelper.ParamChar + "paramNote)";
if (medLabResult.ObsValue == null)
{
medLabResult.ObsValue = "";
}
OdSqlParameter paramObsValue = new OdSqlParameter("paramObsValue", OdDbType.Text, POut.StringParam(medLabResult.ObsValue));
if (medLabResult.Note == null)
{
medLabResult.Note = "";
}
OdSqlParameter paramNote = new OdSqlParameter("paramNote", OdDbType.Text, POut.StringParam(medLabResult.Note));
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command, paramObsValue, paramNote);
}
else
{
medLabResult.MedLabResultNum = Db.NonQ(command, true, "MedLabResultNum", "medLabResult", paramObsValue, paramNote);
}
return(medLabResult.MedLabResultNum);
}
///<summary>Inserts one Automation into the database. Provides option to use the existing priKey.</summary>
public static long Insert(Automation automation, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
automation.AutomationNum = ReplicationServers.GetKey("automation", "AutomationNum");
}
string command = "INSERT INTO automation (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "AutomationNum,";
}
command += "Description,Autotrigger,ProcCodes,AutoAction,SheetDefNum,CommType,MessageContent,AptStatus,AppointmentTypeNum,PatStatus) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(automation.AutomationNum) + ",";
}
command +=
DbHelper.ParamChar + "paramDescription,"
+ POut.Int((int)automation.Autotrigger) + ","
+ DbHelper.ParamChar + "paramProcCodes,"
+ POut.Int((int)automation.AutoAction) + ","
+ POut.Long(automation.SheetDefNum) + ","
+ POut.Long(automation.CommType) + ","
+ DbHelper.ParamChar + "paramMessageContent,"
+ POut.Int((int)automation.AptStatus) + ","
+ POut.Long(automation.AppointmentTypeNum) + ","
+ POut.Int((int)automation.PatStatus) + ")";
if (automation.Description == null)
{
automation.Description = "";
}
OdSqlParameter paramDescription = new OdSqlParameter("paramDescription", OdDbType.Text, POut.StringParam(automation.Description));
if (automation.ProcCodes == null)
{
automation.ProcCodes = "";
}
OdSqlParameter paramProcCodes = new OdSqlParameter("paramProcCodes", OdDbType.Text, POut.StringParam(automation.ProcCodes));
if (automation.MessageContent == null)
{
automation.MessageContent = "";
}
OdSqlParameter paramMessageContent = new OdSqlParameter("paramMessageContent", OdDbType.Text, POut.StringParam(automation.MessageContent));
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command, paramDescription, paramProcCodes, paramMessageContent);
}
else
{
automation.AutomationNum = Db.NonQ(command, true, "AutomationNum", "automation", paramDescription, paramProcCodes, paramMessageContent);
}
return(automation.AutomationNum);
}
