///<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); } }
private void ShowProgressForm(DateTime changedSince) { if (checkTroubleshooting.Checked) { IsTroubleshootMode = true; } else { IsTroubleshootMode = false; } DateTime timeSynchStarted = MiscData.GetNowDateTime(); FormP = new FormProgress(); FormP.MaxVal = 100; //to keep the form from closing until the real MaxVal is set. FormP.NumberMultiplication = 1; FormP.DisplayText = "Preparing records for upload."; FormP.NumberFormat = "F0"; //start the thread that will perform the upload ThreadStart uploadDelegate = delegate { UploadWorker(changedSince, timeSynchStarted); }; Thread workerThread = new Thread(uploadDelegate); workerThread.Start(); //display the progress dialog to the user: FormP.ShowDialog(); if (FormP.DialogResult == DialogResult.Cancel) { workerThread.Abort(); } changed = true; textDateTimeLastRun.Text = PrefC.GetDateT(PrefName.MobileSyncDateTimeLastRun).ToShortDateString() + " " + PrefC.GetDateT(PrefName.MobileSyncDateTimeLastRun).ToShortTimeString(); }
private void butHideUnused_Click(object sender, EventArgs e) { if (!MsgBox.Show(this, MsgBoxButtons.OKCancel, "Hide fee schedules that are not in use by insurance plans, patients, or providers?\r\n" + "A backup of the database will be made first.")) { return; } bool hasChanged = FeeScheds.Sync(_listFeeScheds, _listFeeSchedsOld); Action actionProgress = ODProgress.Show(ODEventType.HideUnusedFeeSchedules, startingMessage: Lans.g(this, "Backing up database...")); try { MiscData.MakeABackup(); } catch (Exception ex) { actionProgress?.Invoke(); FriendlyException.Show(Lans.g(this, "Unable to make a backup. No fee schedules have been altered."), ex); return; } ODEvent.Fire(ODEventType.HideUnusedFeeSchedules, Lans.g(this, "Hiding unused fee schedules...")); long countChanged = FeeScheds.HideUnusedScheds(); if (hasChanged || countChanged > 0) { DataValid.SetInvalid(InvalidType.FeeScheds); } actionProgress?.Invoke(); MessageBox.Show(countChanged.ToString() + " " + Lans.g(this, "unused fee schedules hidden.")); _listFeeScheds = FeeScheds.GetDeepCopy(_isSelectionMode); _listFeeSchedsOld = _listFeeScheds.Select(x => x.Copy()).ToList(); FillGrid(); }
///<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>Updates local time and Refreshes all time variables. Saves NIST server URL as preference.</summary> private void SynchTimes() { this.Cursor = Cursors.WaitCursor; //Get NistTime Offset double nistOffset = GetNistOffset(); if (nistOffset == double.MaxValue) //Timed out { MsgBox.Show(this, "No response received from NIST time server. Click synch time after four seconds."); this.Cursor = Cursors.Default; return; } if (nistOffset == double.MinValue) //Invalid Nist Server Address { this.Cursor = Cursors.Default; return; } double serverOffset = (MiscData.GetNowDateTimeWithMilli() - DateTime.Now).TotalMilliseconds; //Get current times from offsets _timeLocal = DateTime.Now; _timeServer = _timeLocal.AddMilliseconds(serverOffset); _timeNist = _timeLocal.AddMilliseconds(nistOffset); try { WindowsTime.SetTime(_timeNist); //Sets local machine time } catch { MsgBox.Show(this, "Error setting local machine time."); } _timeLocal = DateTime.Now; //Update time since it has now been set this.Cursor = Cursors.Default; refreshDisplays(); }
///<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); } }
private void FormPhoneTiles_Load(object sender, EventArgs e) { #if !DEBUG if (Environment.MachineName.ToLower() != "jordans") { checkBoxAll.Visible = false; //so this will also be visible in debug } #endif timeDelta = MiscData.GetNowDateTime() - DateTime.Now; PhoneTile tile; int x = 0; int y = 0; for (int i = 0; i < 26; i++) { tile = new PhoneTile(); tile.Name = "phoneTile" + (i + 1).ToString(); tile.LayoutHorizontal = true; tile.Location = new Point(tile.Width * x, 26 + (tile.Height * y)); //((PhoneTile)Controls.Find("phoneTile"+(i+1).ToString(),false)[0]); tile.GoToChanged += new System.EventHandler(this.phoneTile_GoToChanged); tile.SelectedTileChanged += new System.EventHandler(this.phoneTile_SelectedTileChanged); tile.ScreenshotClick += new EventHandler(this.phoneTile_ScreenshotClick); tile.MenuNumbers = menuNumbers; tile.MenuStatus = menuStatus; this.Controls.Add(tile); y++; if (y == 13) { y = 0; x++; } } FillTiles(true); //initial fast load and anytime data changes. After this, pumped in from main form. }
///<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(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(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></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(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> 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(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>Checks if Repeating Charges are already running on another workstation or by the OpenDental Service. If less than 24 hours have ///passed since the tool was started, user will be blocked from running Repeating Charges. Otherwise, SecurityAdmin users can restart the tool. ///</summary> private bool CheckBeginDateTime() { Prefs.RefreshCache(); //Just to be sure we don't miss someone who has just started running repeating charges. if (PrefC.GetString(PrefName.RepeatingChargesBeginDateTime) == "") { return(true); } DateTime repeatingChargesBeginDateTime = PrefC.GetDateT(PrefName.RepeatingChargesBeginDateTime); if ((MiscData.GetNowDateTime() - repeatingChargesBeginDateTime).TotalHours < 24) { MsgBox.Show(this, "Repeating charges already running on another workstation, you must wait for them to finish before continuing."); return(false); } //It's been more than 24 hours since repeat charges started. if (Security.IsAuthorized(Permissions.SecurityAdmin, true)) { string message = Lans.g(this, "Repeating Charges last started on") + " " + repeatingChargesBeginDateTime.ToString() + Lans.g(this, ". Restart repeating charges?"); if (MsgBox.Show(MsgBoxButtons.OKCancel, message)) { SecurityLogs.MakeLogEntry(Permissions.SecurityAdmin, 0, "Restarted repeating charges. Previous Repeating Charges Begin DateTime was " + repeatingChargesBeginDateTime.ToString() + "."); return(true); } return(false); //Security admin doesn't want to restart repeat charges. } //User isn't a security admin. MsgBox.Show(Lans.g(this, "Repeating Charges last started on") + " " + repeatingChargesBeginDateTime.ToString() + Lans.g(this, ". Contact a user with SecurityAdmin permission to restart repeating charges.")); return(false); }
///<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); } }
private void butOK_Click(object sender, EventArgs e) { if (!CheckBeginDateTime()) { return; } //If the AvaTax API is not available at HQ show popup and return. if (AvaTax.IsEnabled() && !AvaTax.PingAvaTax()) { MsgBox.Show(this, "Unable to connect to AvaTax API."); return; } Cursor = Cursors.WaitCursor; RepeatChargeResult result = RepeatCharges.RunRepeatingCharges(MiscData.GetNowDateTime(), checkRunAging.Checked); string metrics = result.ProceduresAddedCount + " " + Lan.g(this, "procedures added.") + "\r\n" + result.ClaimsAddedCount + " " + Lan.g(this, "claims added."); SecurityLogs.MakeLogEntry(Permissions.RepeatChargeTool, 0, "Repeat Charge Tool ran.\r\n" + metrics); Cursor = Cursors.Default; MessageBox.Show(metrics); if (!string.IsNullOrEmpty(result.ErrorMsg)) { SecurityLogs.MakeLogEntry(Permissions.RepeatChargeTool, 0, "Repeat Charge Tool Error: " + result.ErrorMsg); MessageBox.Show(result.ErrorMsg); } DialogResult = DialogResult.OK; }
///<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>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(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(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); } }
private static DateTime GetDateLimit(Permissions permType, int userGroupNum) { DateTime nowDate = MiscData.GetNowDateTime().Date; DateTime retVal = DateTime.MinValue; for (int i = 0; i < GroupPermissions.List.Length; i++) { if (GroupPermissions.List[i].UserGroupNum != userGroupNum || GroupPermissions.List[i].PermType != permType) { continue; } //this should only happen once. One match. if (GroupPermissions.List[i].NewerDate.Year > 1880) { retVal = GroupPermissions.List[i].NewerDate; } if (GroupPermissions.List[i].NewerDays == 0) //do not restrict by days //do not change retVal { } else if (nowDate.AddDays(-GroupPermissions.List[i].NewerDays) > retVal) { retVal = nowDate.AddDays(-GroupPermissions.List[i].NewerDays); } } return(retVal); }
///<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(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(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> 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 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> 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(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 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); } }