///<summary></summary>
public static void Insert(QuickPasteNote note)
{
if (PrefB.RandomKeys)
{
note.QuickPasteNoteNum = MiscData.GetKey("quickpastenote", "QuickPasteNoteNum");
}
string command = "INSERT INTO quickpastenote (";
if (PrefB.RandomKeys)
{
command += "QuickPasteNoteNum,";
}
command += "QuickPasteCatNum,ItemOrder,Note,Abbreviation) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(note.QuickPasteNoteNum) + "', ";
}
command +=
"'" + POut.PInt(note.QuickPasteCatNum) + "', "
+ "'" + POut.PInt(note.ItemOrder) + "', "
+ "'" + POut.PString(note.Note) + "', "
+ "'" + POut.PString(note.Abbreviation) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
note.QuickPasteNoteNum = General.NonQ(command, true);
}
}
///<summary></summary>
public static void Insert(Disease disease)
{
if (PrefB.RandomKeys)
{
disease.DiseaseNum = MiscData.GetKey("disease", "DiseaseNum");
}
string command = "INSERT INTO disease (";
if (PrefB.RandomKeys)
{
command += "DiseaseNum,";
}
command += "PatNum,DiseaseDefNum,PatNote) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(disease.DiseaseNum) + "', ";
}
command +=
"'" + POut.PInt(disease.PatNum) + "', "
+ "'" + POut.PInt(disease.DiseaseDefNum) + "', "
+ "'" + POut.PString(disease.PatNote) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
disease.DiseaseNum = General.NonQ(command, true);
}
}
///<summary></summary>
public static void Insert(CanadianNetwork network)
{
if (PrefB.RandomKeys)
{
network.CanadianNetworkNum = MiscData.GetKey("canadiannetwork", "CanadianNetworkNum");
}
string command = "INSERT INTO canadiannetwork (";
if (PrefB.RandomKeys)
{
command += "CanadianNetworkNum,";
}
command += "Abbrev, Descript) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(network.CanadianNetworkNum) + "', ";
}
command +=
"'" + POut.PString(network.Abbrev) + "', "
+ "'" + POut.PString(network.Descript) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
network.CanadianNetworkNum = General.NonQ(command, true);
}
}
///<summary></summary>
public static void Insert(QuickPasteCat cat)
{
if (PrefB.RandomKeys)
{
cat.QuickPasteCatNum = MiscData.GetKey("quickpastecat", "QuickPasteCatNum");
}
string command = "INSERT INTO quickpastecat (";
if (PrefB.RandomKeys)
{
command += "QuickPasteCatNum,";
}
command += "Description,ItemOrder,DefaultForTypes) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(cat.QuickPasteCatNum) + "', ";
}
command +=
"'" + POut.PString(cat.Description) + "', "
+ "'" + POut.PInt(cat.ItemOrder) + "', "
+ "'" + POut.PString(cat.DefaultForTypes) + "')";
//MessageBox.Show(string command);
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
cat.QuickPasteCatNum = General.NonQ(command, true);
}
}
///<summary></summary>
private static void Insert(SchoolCourse sc)
{
if (PrefB.RandomKeys)
{
sc.SchoolCourseNum = MiscData.GetKey("schoolcourse", "SchoolCourseNum");
}
string command = "INSERT INTO schoolcourse (";
if (PrefB.RandomKeys)
{
command += "SchoolCourseNum,";
}
command += "CourseID,Descript) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(sc.SchoolCourseNum) + "', ";
}
command +=
"'" + POut.PString(sc.CourseID) + "', "
+ "'" + POut.PString(sc.Descript) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
sc.SchoolCourseNum = General.NonQ(command, true);
}
}
///<summary></summary>
public static void Insert(Question quest)
{
if (PrefB.RandomKeys)
{
quest.QuestionNum = MiscData.GetKey("question", "QuestionNum");
}
string command = "INSERT INTO question (";
if (PrefB.RandomKeys)
{
command += "QuestionNum,";
}
command += "PatNum,ItemOrder,Description,Answer,FormPatNum) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(quest.QuestionNum) + "', ";
}
command +=
"'" + POut.PInt(quest.PatNum) + "', "
+ "'" + POut.PInt(quest.ItemOrder) + "', "
+ "'" + POut.PString(quest.Description) + "', "
+ "'" + POut.PString(quest.Answer) + "', "
+ "'" + POut.PInt(quest.FormPatNum) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
quest.QuestionNum = General.NonQ(command, true);
}
}
///<summary></summary>
private static void Insert(PayPlanCharge charge)
{
if (PrefB.RandomKeys)
{
charge.PayPlanChargeNum = MiscData.GetKey("payplancharge", "PayPlanChargeNum");
}
string command = "INSERT INTO payplancharge (";
if (PrefB.RandomKeys)
{
command += "PayPlanChargeNum,";
}
command += "PayPlanNum,Guarantor,PatNum,ChargeDate,Principal,Interest,Note) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(charge.PayPlanChargeNum) + "', ";
}
command +=
"'" + POut.PInt(charge.PayPlanNum) + "', "
+ "'" + POut.PInt(charge.Guarantor) + "', "
+ "'" + POut.PInt(charge.PatNum) + "', "
+ POut.PDate(charge.ChargeDate) + ", "
+ "'" + POut.PDouble(charge.Principal) + "', "
+ "'" + POut.PDouble(charge.Interest) + "', "
+ "'" + POut.PString(charge.Note) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
charge.PayPlanChargeNum = General.NonQ(command, true);
}
}
///<summary></summary>
public static void InsertCur()
{
if (PrefB.RandomKeys)
{
Cur.ScreenGroupNum = MiscData.GetKey("screengroup", "ScreenGroupNum");
}
string command = "INSERT INTO screengroup (";
if (PrefB.RandomKeys)
{
command += "ScreenGroupNum,";
}
command += "Description,SGDate) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(Cur.ScreenGroupNum) + "', ";
}
command +=
"'" + POut.PString(Cur.Description) + "', "
+ "'" + POut.PDate(Cur.SGDate) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
Cur.ScreenGroupNum = General.NonQ(command, true);
}
}
///<summary></summary>
public static void Insert(Account acct)
{
if (PrefB.RandomKeys)
{
acct.AccountNum = MiscData.GetKey("account", "AccountNum");
}
string command = "INSERT INTO account (";
if (PrefB.RandomKeys)
{
command += "AccountNum,";
}
command += "Description,AcctType,BankNumber,Inactive,AccountColor) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(acct.AccountNum) + "', ";
}
command +=
"'" + POut.PString(acct.Description) + "', "
+ "'" + POut.PInt((int)acct.AcctType) + "', "
+ "'" + POut.PString(acct.BankNumber) + "', "
+ "'" + POut.PBool(acct.Inactive) + "', "
+ "'" + POut.PInt(acct.AccountColor.ToArgb()) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
acct.AccountNum = General.NonQ(command, true);
}
}
///<summary></summary>
public static void Insert(ToothInitial init)
{
if (PrefB.RandomKeys)
{
init.ToothInitialNum = MiscData.GetKey("toothinitial", "ToothInitialNum");
}
string command = "INSERT INTO toothinitial (";
if (PrefB.RandomKeys)
{
command += "ToothInitialNum,";
}
command += "PatNum,ToothNum,InitialType,Movement) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(init.ToothInitialNum) + "', ";
}
command +=
"'" + POut.PInt(init.PatNum) + "', "
+ "'" + POut.PString(init.ToothNum) + "', "
+ "'" + POut.PInt((int)init.InitialType) + "', "
+ "'" + POut.PFloat(init.Movement) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
init.ToothInitialNum = General.NonQ(command, true);
}
}
///<summary></summary>
public static void Insert(Commlog comm)
{
if (PrefB.RandomKeys)
{
comm.CommlogNum = MiscData.GetKey("commlog", "CommlogNum");
}
string command = "INSERT INTO commlog (";
if (PrefB.RandomKeys)
{
command += "CommlogNum,";
}
command += "PatNum,CommDateTime,CommType,Note,Mode_,SentOrReceived,IsStatementSent) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(comm.CommlogNum) + "', ";
}
command +=
"'" + POut.PInt(comm.PatNum) + "', "
+ POut.PDateT(comm.CommDateTime) + ", "
+ "'" + POut.PInt(comm.CommType) + "', "
+ "'" + POut.PString(comm.Note) + "', "
+ "'" + POut.PInt((int)comm.Mode_) + "', "
+ "'" + POut.PInt((int)comm.SentOrReceived) + "', "
+ "'" + POut.PBool(comm.IsStatementSent) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
comm.CommlogNum = General.NonQ(command, true);
}
}
///<summary></summary>
public static void InsertCur()
{
if (PrefB.RandomKeys)
{
Cur.ZipCodeNum = MiscData.GetKey("zipcode", "ZipCodeNum");
}
string command = "INSERT INTO zipcode (";
if (PrefB.RandomKeys)
{
command += "ZipCodeNum,";
}
command += "zipcodedigits,city,state,isfrequent) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(Cur.ZipCodeNum) + "', ";
}
command +=
"'" + POut.PString(Cur.ZipCodeDigits) + "', "
+ "'" + POut.PString(Cur.City) + "', "
+ "'" + POut.PString(Cur.State) + "', "
+ "'" + POut.PBool(Cur.IsFrequent) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
Cur.ZipCodeNum = General.NonQ(command, true);
}
}
///<summary></summary>
public static void Insert(Medication Cur)
{
if (PrefB.RandomKeys)
{
Cur.MedicationNum = MiscData.GetKey("medication", "MedicationNum");
}
string command = "INSERT INTO medication (";
if (PrefB.RandomKeys)
{
command += "MedicationNum,";
}
command += "medname,genericnum,notes"
+ ") VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(Cur.MedicationNum) + "', ";
}
command +=
"'" + POut.PString(Cur.MedName) + "', "
+ "'" + POut.PInt(Cur.GenericNum) + "', "
+ "'" + POut.PString(Cur.Notes) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
Cur.MedicationNum = General.NonQ(command, true);
}
}
///<summary></summary>
private static void Insert(TreatPlan tp)
{
if (PrefB.RandomKeys)
{
tp.TreatPlanNum = MiscData.GetKey("treatplan", "TreatPlanNum");
}
string command = "INSERT INTO treatplan (";
if (PrefB.RandomKeys)
{
command += "TreatPlanNum,";
}
command += "PatNum,DateTP,Heading,Note) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(tp.TreatPlanNum) + "', ";
}
command +=
"'" + POut.PInt(tp.PatNum) + "', "
+ POut.PDate(tp.DateTP) + ", "
+ "'" + POut.PString(tp.Heading) + "', "
+ "'" + POut.PString(tp.Note) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
tp.TreatPlanNum = General.NonQ(command, true);
}
}
///<summary></summary>
private static void Insert(Instructor instr)
{
if (PrefB.RandomKeys)
{
instr.InstructorNum = MiscData.GetKey("instructor", "InstructorNum");
}
string command = "INSERT INTO instructor (";
if (PrefB.RandomKeys)
{
command += "InstructorNum,";
}
command += "LName,FName,Suffix) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(instr.InstructorNum) + "', ";
}
command +=
"'" + POut.PString(instr.LName) + "', "
+ "'" + POut.PString(instr.FName) + "', "
+ "'" + POut.PString(instr.Suffix) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
instr.InstructorNum = General.NonQ(command, true);
}
}
///<summary></summary>
public static void Insert(PatField pf)
{
if (PrefB.RandomKeys)
{
pf.PatFieldNum = MiscData.GetKey("patfield", "PatFieldNum");
}
string command = "INSERT INTO patfield (";
if (PrefB.RandomKeys)
{
command += "PatFieldNum,";
}
command += "PatNum,FieldName,FieldValue) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(pf.PatFieldNum) + "', ";
}
command +=
"'" + POut.PInt(pf.PatNum) + "', "
+ "'" + POut.PString(pf.FieldName) + "', "
+ "'" + POut.PString(pf.FieldValue) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
pf.PatFieldNum = General.NonQ(command, true);
}
}
///<summary>Inserts the given preference and ensures that the primary key is properly set.</summary>
public static void Insert(ComputerPref computerPref)
{
if (PrefB.RandomKeys)
{
computerPref.ComputerPrefNum = MiscData.GetKey("computerpref", "ComputerPrefNum");
}
string command = "INSERT INTO computerpref (";
if (PrefB.RandomKeys)
{
command += "ComputerPrefNum,";
}
command += "ComputerName,GraphicsUseHardware,GraphicsSimple,SensorType,SensorPort,SensorExposure,SensorBinned,GraphicsDoubleBuffering,PreferredPixelFormatNum) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(computerPref.ComputerPrefNum) + "',";
}
command += "'" + POut.PString(computerPref.ComputerName) + "',"
+ "'" + POut.PBool(computerPref.GraphicsUseHardware) + "',"
+ "'" + POut.PBool(computerPref.GraphicsSimple) + "',"
+ "'" + POut.PString(computerPref.SensorType) + "',"
+ "'" + POut.PBool(computerPref.SensorBinned) + "',"
+ "'" + POut.PInt(computerPref.SensorPort) + "',"
+ "'" + POut.PInt(computerPref.SensorExposure) + "',"
+ "'" + POut.PBool(computerPref.GraphicsDoubleBuffering) + "',"
+ "'" + POut.PInt(computerPref.PreferredPixelFormatNum) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
computerPref.ComputerPrefNum = General.NonQ(command, true);
}
}
///<summary></summary>
public static void Insert(LabTurnaround lab)
{
if (PrefB.RandomKeys)
{
lab.LabTurnaroundNum = MiscData.GetKey("labturnaround", "LabTurnaroundNum");
}
string command = "INSERT INTO labturnaround (";
if (PrefB.RandomKeys)
{
command += "LabTurnaroundNum,";
}
command += "LaboratoryNum,Description,DaysPublished,DaysActual) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(lab.LabTurnaroundNum) + "', ";
}
command +=
"'" + POut.PInt(lab.LaboratoryNum) + "', "
+ "'" + POut.PString(lab.Description) + "', "
+ "'" + POut.PInt(lab.DaysPublished) + "', "
+ "'" + POut.PInt(lab.DaysActual) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
lab.LabTurnaroundNum = General.NonQ(command, true);
}
}
///<summary></summary>
public static void Insert(Contact Cur)
{
if (PrefB.RandomKeys)
{
Cur.ContactNum = MiscData.GetKey("contact", "ContactNum");
}
string command = "INSERT INTO contact (";
if (PrefB.RandomKeys)
{
command += "ContactNum,";
}
command += "LName,FName,WkPhone,Fax,Category,"
+ "Notes) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(Cur.ContactNum) + "', ";
}
command +=
"'" + POut.PString(Cur.LName) + "', "
+ "'" + POut.PString(Cur.FName) + "', "
+ "'" + POut.PString(Cur.WkPhone) + "', "
+ "'" + POut.PString(Cur.Fax) + "', "
+ "'" + POut.PInt(Cur.Category) + "', "
+ "'" + POut.PString(Cur.Notes) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
Cur.ContactNum = General.NonQ(command, true);
}
}
///<summary></summary>
public static void Insert(Employer Cur)
{
if (PrefB.RandomKeys)
{
Cur.EmployerNum = MiscData.GetKey("employer", "EmployerNum");
}
string command = "INSERT INTO employer (";
if (PrefB.RandomKeys)
{
command += "EmployerNum,";
}
command += "EmpName,Address,Address2,City,State,Zip,Phone) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(Cur.EmployerNum) + "', ";
}
command +=
"'" + POut.PString(Cur.EmpName) + "', "
+ "'" + POut.PString(Cur.Address) + "', "
+ "'" + POut.PString(Cur.Address2) + "', "
+ "'" + POut.PString(Cur.City) + "', "
+ "'" + POut.PString(Cur.State) + "', "
+ "'" + POut.PString(Cur.Zip) + "', "
+ "'" + POut.PString(Cur.Phone) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
Cur.EmployerNum = General.NonQ(command, true);
}
}
///<summary></summary>
private static void Insert(Printer cur)
{
if (PrefB.RandomKeys)
{
cur.PrinterNum = MiscData.GetKey("printer", "PrinterNum");
}
string command = "INSERT INTO printer (";
if (PrefB.RandomKeys)
{
command += "PrinterNum,";
}
command += "ComputerNum,PrintSit,PrinterName,"
+ "DisplayPrompt) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(cur.PrinterNum) + "', ";
}
command +=
"'" + POut.PInt(cur.ComputerNum) + "', "
+ "'" + POut.PInt((int)cur.PrintSit) + "', "
+ "'" + POut.PString(cur.PrinterName) + "', "
+ "'" + POut.PBool(cur.DisplayPrompt) + "')";
//MessageBox.Show(string command);
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
cur.PrinterNum = General.NonQ(command, true);
}
}
///<summary></summary>
public static void Insert(Deposit dep)
{
if (PrefB.RandomKeys)
{
dep.DepositNum = MiscData.GetKey("deposit", "DepositNum");
}
string command = "INSERT INTO deposit (";
if (PrefB.RandomKeys)
{
command += "DepositNum,";
}
command += "DateDeposit,BankAccountInfo,Amount) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(dep.DepositNum) + "', ";
}
command +=
POut.PDate(dep.DateDeposit) + ", "
+ "'" + POut.PString(dep.BankAccountInfo) + "', "
+ "'" + POut.PDouble(dep.Amount) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
dep.DepositNum = General.NonQ(command, true);
}
}
///<summary>ONLY use this if compname is not already present</summary>
public static void Insert(Computer comp)
{
if (PrefB.RandomKeys)
{
comp.ComputerNum = MiscData.GetKey("computer", "ComputerNum");
}
string command = "INSERT INTO computer (";
if (PrefB.RandomKeys)
{
command += "ComputerNum,";
}
command += "CompName"
+ ") VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(comp.ComputerNum) + "', ";
}
command +=
"'" + POut.PString(comp.CompName) + "')";
//+"'"+POut.PString(PrinterName)+"')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
comp.ComputerNum = General.NonQ(command, true);
}
}
///<summary></summary>
public static void Insert(ReqNeeded req)
{
if (PrefB.RandomKeys)
{
req.ReqNeededNum = MiscData.GetKey("reqneeded", "ReqNeededNum");
}
string command = "INSERT INTO reqneeded (";
if (PrefB.RandomKeys)
{
command += "ReqNeededNum,";
}
command += "Descript,SchoolCourseNum,SchoolClassNum) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(req.ReqNeededNum) + "', ";
}
command +=
"'" + POut.PString(req.Descript) + "', "
+ "'" + POut.PInt(req.SchoolCourseNum) + "', "
+ "'" + POut.PInt(req.SchoolClassNum) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
req.ReqNeededNum = General.NonQ(command, true);
}
}
///<summary></summary>
public static void Insert(PerioExam Cur)
{
if (PrefB.RandomKeys)
{
Cur.PerioExamNum = MiscData.GetKey("perioexam", "PerioExamNum");
}
string command = "INSERT INTO perioexam (";
if (PrefB.RandomKeys)
{
command += "PerioExamNum,";
}
command += "PatNum,ExamDate,ProvNum"
+ ") VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(Cur.PerioExamNum) + "', ";
}
command +=
"'" + POut.PInt(Cur.PatNum) + "', "
+ POut.PDate(Cur.ExamDate) + ", "
+ "'" + POut.PInt(Cur.ProvNum) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
Cur.PerioExamNum = General.NonQ(command, true);
}
}
///<summary></summary>
private static void Insert(CanadianExtract cur)
{
if (PrefB.RandomKeys)
{
cur.CanadianExtractNum = MiscData.GetKey("canadianextract", "CanadianExtractNum");
}
string command = "INSERT INTO canadianextract (";
if (PrefB.RandomKeys)
{
command += "CanadianExtractNum,";
}
command += "ClaimNum,ToothNum,DateExtraction) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(cur.CanadianExtractNum) + "', ";
}
command +=
"'" + POut.PInt(cur.ClaimNum) + "', "
+ "'" + POut.PString(cur.ToothNum) + "', "
+ POut.PDate(cur.DateExtraction) + ")";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
cur.CanadianExtractNum = General.NonQ(command, true);
}
}
///<summary></summary>
public static void Insert(EmailTemplate template)
{
if (PrefB.RandomKeys)
{
template.EmailTemplateNum = MiscData.GetKey("emailtemplate", "EmailTemplateNum");
}
string command = "INSERT INTO emailtemplate (";
if (PrefB.RandomKeys)
{
command += "EmailTemplateNum,";
}
command += "Subject,BodyText"
+ ") VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(template.EmailTemplateNum) + "', ";
}
command +=
"'" + POut.PString(template.Subject) + "', "
+ "'" + POut.PString(template.BodyText) + "')";
//MessageBox.Show(string command);
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
template.EmailTemplateNum = General.NonQ(command, true);
}
}
///<summary></summary>
public static void Insert(ClockEvent ce)
{
if (PrefB.RandomKeys)
{
ce.ClockEventNum = MiscData.GetKey("clockevent", "ClockEventNum");
}
string command = "INSERT INTO clockevent (";
if (PrefB.RandomKeys)
{
command += "ClockEventNum,";
}
command += "EmployeeNum,TimeEntered,TimeDisplayed,ClockIn"
+ ",ClockStatus,Note) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(ce.ClockEventNum) + "', ";
}
command +=
"'" + POut.PInt(ce.EmployeeNum) + "', "
+ POut.PDateT(ce.TimeEntered) + ", "
+ POut.PDateT(ce.TimeDisplayed) + ", "
+ "'" + POut.PBool(ce.ClockIn) + "', "
+ "'" + POut.PInt((int)ce.ClockStatus) + "', "
+ "'" + POut.PString(ce.Note) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
ce.ClockEventNum = General.NonQ(command, true);
}
}
///<summary></summary>
public static void Insert(TimeAdjust adj)
{
if (PrefB.RandomKeys)
{
adj.TimeAdjustNum = MiscData.GetKey("timeadjust", "TimeAdjustNum");
}
string command = "INSERT INTO timeadjust (";
if (PrefB.RandomKeys)
{
command += "TimeAdjustNum,";
}
command += "EmployeeNum,TimeEntry,RegHours,OTimeHours,Note) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(adj.TimeAdjustNum) + "', ";
}
command +=
"'" + POut.PInt(adj.EmployeeNum) + "', "
+ POut.PDateT(adj.TimeEntry) + ", "
+ "'" + POut.PDouble(adj.RegHours.TotalHours) + "', "
+ "'" + POut.PDouble(adj.OTimeHours.TotalHours) + "', "
+ "'" + POut.PString(adj.Note) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
adj.TimeAdjustNum = General.NonQ(command, true);
}
}
///<summary></summary>
public static void Insert(Letter Cur)
{
if (PrefB.RandomKeys)
{
Cur.LetterNum = MiscData.GetKey("letter", "LetterNum");
}
string command = "INSERT INTO letter (";
if (PrefB.RandomKeys)
{
command += "LetterNum,";
}
command += "Description,BodyText) VALUES(";
if (PrefB.RandomKeys)
{
command += "'" + POut.PInt(Cur.LetterNum) + "', ";
}
command +=
"'" + POut.PString(Cur.Description) + "', "
+ "'" + POut.PString(Cur.BodyText) + "')";
if (PrefB.RandomKeys)
{
General.NonQ(command);
}
else
{
Cur.LetterNum = General.NonQ(command, true);
}
}