private void FormJournal_Load(object sender, EventArgs e)
{
DateTime firstofYear = new DateTime(InitialAsOfDate.Year, 1, 1);
textDateTo.Text = InitialAsOfDate.ToShortDateString();
if (AccountCur.AcctType == AccountType.Income || AccountCur.AcctType == AccountType.Expense)
{
textDateFrom.Text = firstofYear.ToShortDateString();
}
LayoutToolBar();
FillGrid();
gridMain.ScrollToEnd();
}
private void butAdd_Click(object sender, System.EventArgs e)
{
if (comboClass.SelectedIndex == -1 || comboCourse.SelectedIndex == -1)
{
MsgBox.Show(this, "Please select a Class and Course first.");
return;
}
FormReqNeededEdit FormR = new FormReqNeededEdit();
FormR.ReqCur = new ReqNeeded();
FormR.ReqCur.SchoolClassNum = SchoolClasses.List[comboClass.SelectedIndex].SchoolClassNum;
FormR.ReqCur.SchoolCourseNum = SchoolCourses.List[comboCourse.SelectedIndex].SchoolCourseNum;
FormR.IsNew = true;
FormR.ShowDialog();
if (FormR.DialogResult != DialogResult.OK)
{
return;
}
FillGrid();
gridMain.ScrollToEnd();
for (int i = 0; i < table.Rows.Count; i++)
{
if (table.Rows[i]["ReqNeededNum"].ToString() == FormR.ReqCur.ReqNeededNum.ToString())
{
gridMain.SetSelected(i, true);
break;
}
}
}
private void FillGrid()
{
SecurityLog[] logList = SecurityLogs.Refresh(PatNum, PermTypes, FKey);
grid.BeginUpdate();
grid.Columns.Clear();
ODGridColumn col;
col = new ODGridColumn(Lan.g("TableAudit", "Date Time"), 120);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableAudit", "User"), 70);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableAudit", "Permission"), 110);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableAudit", "Log Text"), 569);
grid.Columns.Add(col);
grid.Rows.Clear();
ODGridRow row;
for (int i = 0; i < logList.Length; i++)
{
row = new ODGridRow();
row.Cells.Add(logList[i].LogDateTime.ToShortDateString() + " " + logList[i].LogDateTime.ToShortTimeString());
row.Cells.Add(Userods.GetUser(logList[i].UserNum).UserName);
row.Cells.Add(logList[i].PermType.ToString());
row.Cells.Add(logList[i].LogText);
grid.Rows.Add(row);
}
grid.EndUpdate();
grid.ScrollToEnd();
}
private void butAdd_Click(object sender, System.EventArgs e)
{
FormProvEdit FormP = new FormProvEdit();
FormP.ProvCur = new Provider();
FormP.ProvCur.ItemOrder = Providers.ListLong.Length;
FormP.IsNew = true;
FormP.ShowDialog();
if (FormP.DialogResult != DialogResult.OK)
{
return;
}
changed = true;
//Providers.Selected=Providers.ListLong.Length;//this is one more than allowed, but it's ok;
FillGrid();
gridMain.ScrollToEnd();
for (int i = 0; i < Providers.ListLong.Length; i++)
{
if (Providers.ListLong[i].ProvNum == FormP.ProvCur.ProvNum)
{
gridMain.SetSelected(1, true);
break;
}
}
}
private void butAdd_Click(object sender, System.EventArgs e)
{
FormProvEdit FormP = new FormProvEdit();
FormP.ProvCur = new Provider();
FormP.ProvCur.ItemOrder = Providers.GetNextItemOrder();
if (groupDentalSchools.Visible && comboClass.SelectedIndex > 0)
{
FormP.ProvCur.SchoolClassNum = SchoolClasses.List[comboClass.SelectedIndex - 1].SchoolClassNum;
}
FormP.IsNew = true;
FormP.ShowDialog();
if (FormP.DialogResult != DialogResult.OK)
{
return;
}
changed = true;
FillGrid();
gridMain.ScrollToEnd();
for (int i = 0; i < table.Rows.Count; i++) //Providers.ListLong.Length;i++) {
{
if (table.Rows[i]["ProvNum"].ToString() == FormP.ProvCur.ProvNum.ToString())
{
//Providers.ListLong[i].ProvNum==FormP.ProvCur.ProvNum) {
gridMain.SetSelected(i, true);
break;
}
}
}
private void FillGrid()
{
if (IsSelectionMode)
{
DList = Deposits.GetUnattached();
}
else
{
DList = Deposits.Refresh();
}
grid.BeginUpdate();
grid.Columns.Clear();
ODGridColumn col = new ODGridColumn(Lan.g("TableDepositSlips", "Date"), 80);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableDepositSlips", "Amount"), 90);
grid.Columns.Add(col);
grid.Rows.Clear();
OpenDental.UI.ODGridRow row;
for (int i = 0; i < DList.Length; i++)
{
row = new OpenDental.UI.ODGridRow();
row.Cells.Add(DList[i].DateDeposit.ToShortDateString());
row.Cells.Add(DList[i].Amount.ToString("F"));
grid.Rows.Add(row);
}
grid.EndUpdate();
grid.ScrollToEnd();
}
private void checkHideOlder_CheckedChanged(object sender, EventArgs e)
{
FillGrid();
if (checkHideOlder.Checked)
{
gridMain.ScrollToEnd();
}
}
private void FillGrid()
{
if (!PrefC.HasClinicsEnabled)
{
if (IsSelectionMode)
{
DList = Deposits.GetUnattached();
}
else
{
DList = Deposits.Refresh();
}
}
else
{
//GetForClinics uses an empty list to indicate "all", which is a loophole if user doesn't select an item. So:
if (comboClinics.ListSelectedClinicNums.Count == 0)
{
DList = Deposits.GetForClinics(new List <long>()
{
Clinics.ClinicNum
}, IsSelectionMode); //restrict to current clinic
}
else
{
DList = Deposits.GetForClinics(comboClinics.ListSelectedClinicNums, IsSelectionMode);
}
}
grid.BeginUpdate();
grid.ListGridColumns.Clear();
GridColumn col = new GridColumn(Lan.g("TableDepositSlips", "Date"), 80);
grid.ListGridColumns.Add(col);
col = new GridColumn(Lan.g("TableDepositSlips", "Amount"), 90, HorizontalAlignment.Right);
grid.ListGridColumns.Add(col);
if (PrefC.HasClinicsEnabled)
{
col = new GridColumn(Lan.g("TableDepositSlips", "Clinic"), 150);
grid.ListGridColumns.Add(col);
}
grid.ListGridRows.Clear();
OpenDental.UI.GridRow row;
for (int i = 0; i < DList.Length; i++)
{
row = new OpenDental.UI.GridRow();
row.Cells.Add(DList[i].DateDeposit.ToShortDateString());
row.Cells.Add(DList[i].Amount.ToString("F"));
if (PrefC.HasClinicsEnabled)
{
row.Cells.Add(" " + DList[i].ClinicAbbr); //padding left with space to add separation between amount and clinic abbr
}
grid.ListGridRows.Add(row);
}
grid.EndUpdate();
grid.ScrollToEnd();
}
private void FillGrid()
{
if (!PrefC.HasClinicsEnabled)
{
if (IsSelectionMode)
{
DList = Deposits.GetUnattached();
}
else
{
DList = Deposits.Refresh();
}
}
else
{
List <long> listSelectedClinicNums = new List <long>();
if (!Security.CurUser.ClinicIsRestricted && comboClinic.SelectedIndices.Contains(0)) //All is an option in comboClinic and is selected.
//Blank by design for Deposits.GetForClinics(...).
{
}
else
{
int listStep = (Security.CurUser.ClinicIsRestricted?0:1); //If the All option is available, then all indices are offset by 1.
comboClinic.ListSelectedIndices.ForEach(x => listSelectedClinicNums.Add(_listClinics[x - listStep].ClinicNum));
}
DList = Deposits.GetForClinics(listSelectedClinicNums, IsSelectionMode);
}
grid.BeginUpdate();
grid.Columns.Clear();
ODGridColumn col = new ODGridColumn(Lan.g("TableDepositSlips", "Date"), 80);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableDepositSlips", "Amount"), 90, HorizontalAlignment.Right);
grid.Columns.Add(col);
if (PrefC.HasClinicsEnabled)
{
col = new ODGridColumn(Lan.g("TableDepositSlips", "Clinic"), 150);
grid.Columns.Add(col);
}
grid.Rows.Clear();
OpenDental.UI.ODGridRow row;
for (int i = 0; i < DList.Length; i++)
{
row = new OpenDental.UI.ODGridRow();
row.Cells.Add(DList[i].DateDeposit.ToShortDateString());
row.Cells.Add(DList[i].Amount.ToString("F"));
if (PrefC.HasClinicsEnabled)
{
row.Cells.Add(" " + DList[i].ClinicAbbr); //padding left with space to add separation between amount and clinic abbr
}
grid.Rows.Add(row);
}
grid.EndUpdate();
grid.ScrollToEnd();
}
private void FillGrid()
{
try {
LogList = SecurityLogs.Refresh(PatNum, PermTypes, FKey);
}
catch (Exception ex) {
FriendlyException.Show(Lan.g(this, "There was a problem refreshing the Audit Trail with the current filters."), ex);
LogList = new SecurityLog[0];
}
grid.BeginUpdate();
grid.ListGridColumns.Clear();
GridColumn col;
col = new GridColumn(Lan.g("TableAudit", "Date Time"), 120);
grid.ListGridColumns.Add(col);
col = new GridColumn(Lan.g("TableAudit", "User"), 70);
grid.ListGridColumns.Add(col);
col = new GridColumn(Lan.g("TableAudit", "Permission"), 170);
grid.ListGridColumns.Add(col);
col = new GridColumn(Lan.g("TableAudit", "Log Text"), 510);
grid.ListGridColumns.Add(col);
grid.ListGridRows.Clear();
GridRow row;
Userod user;
foreach (SecurityLog logCur in LogList)
{
row = new GridRow();
row.Cells.Add(logCur.LogDateTime.ToShortDateString() + " " + logCur.LogDateTime.ToShortTimeString());
user = Userods.GetUser(logCur.UserNum);
if (user == null) //Will be null for audit trails made by outside entities that do not require users to be logged in. E.g. Web Sched.
{
row.Cells.Add("unknown");
}
else
{
row.Cells.Add(user.UserName);
}
row.Cells.Add(logCur.PermType.ToString());
row.Cells.Add(logCur.LogText);
grid.ListGridRows.Add(row);
}
grid.EndUpdate();
grid.ScrollToEnd();
}
private void FillGrid()
{
//Fill the log if it wasn't filled outside of this window.
if (LogList == null)
{
LogList = SecurityLogs.Refresh(PatNum, PermTypes, FKey, checkIncludeArchived.Checked);
}
grid.BeginUpdate();
grid.Columns.Clear();
ODGridColumn col;
col = new ODGridColumn(Lan.g("TableAudit", "Date Time"), 120);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableAudit", "User"), 70);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableAudit", "Permission"), 170);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableAudit", "Log Text"), 510);
grid.Columns.Add(col);
grid.Rows.Clear();
ODGridRow row;
Userod user;
for (int i = 0; i < LogList.Length; i++)
{
row = new ODGridRow();
row.Cells.Add(LogList[i].LogDateTime.ToShortDateString() + " " + LogList[i].LogDateTime.ToShortTimeString());
user = Userods.GetUser(LogList[i].UserNum);
if (user == null) //Will be null for audit trails made by outside entities that do not require users to be logged in. E.g. Web Sched.
{
row.Cells.Add("unknown");
}
else
{
row.Cells.Add(user.UserName);
}
row.Cells.Add(LogList[i].PermType.ToString());
row.Cells.Add(LogList[i].LogText);
grid.Rows.Add(row);
}
grid.EndUpdate();
grid.ScrollToEnd();
}
private void FillGrid()
{
SecurityLog[] logList = SecurityLogs.Refresh(PatNum, PermTypes);
grid.BeginUpdate();
grid.Rows.Clear();
ODGridRow row;
for (int i = 0; i < logList.Length; i++)
{
row = new ODGridRow();
row.Cells.Add(logList[i].LogDateTime.ToShortDateString() + " " + logList[i].LogDateTime.ToShortTimeString());
row.Cells.Add(UserodB.GetUser(logList[i].UserNum).UserName);
row.Cells.Add(logList[i].PermType.ToString());
row.Cells.Add(logList[i].LogText);
grid.Rows.Add(row);
}
grid.EndUpdate();
grid.ScrollToEnd();
}
private void FillGrid()
{
RList = Reconciles.GetList(AccountNum);
grid.BeginUpdate();
grid.Columns.Clear();
ODGridColumn col = new ODGridColumn(Lan.g("TableReconciles", "Date"), 80);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableReconciles", "Ending Bal"), 100, HorizontalAlignment.Right);
grid.Columns.Add(col);
grid.Rows.Clear();
OpenDental.UI.ODGridRow row;
for (int i = 0; i < RList.Length; i++)
{
row = new OpenDental.UI.ODGridRow();
row.Cells.Add(RList[i].DateReconcile.ToShortDateString());
row.Cells.Add(RList[i].EndingBal.ToString("F"));
grid.Rows.Add(row);
}
grid.EndUpdate();
grid.ScrollToEnd();
}
private void butAdd_Click(object sender, System.EventArgs e)
{
FormProvEdit FormP = new FormProvEdit();
FormP.ProvCur = new Provider();
if (gridMain.SelectedIndices.Length > 0) //place new provider after the first selected index. No changes are made to DB until after provider is actually inserted.
{
FormP.ProvCur.ItemOrder = Providers.GetProv(PIn.Long(table.Rows[gridMain.SelectedIndices[0]]["ProvNum"].ToString())).ItemOrder; //now two with this itemorder
}
else
{
FormP.ProvCur.ItemOrder = Providers.GetNextItemOrder(); //this is clumsy and needs rewrite.
}
if (groupDentalSchools.Visible && comboClass.SelectedIndex > 0)
{
FormP.ProvCur.SchoolClassNum = SchoolClasses.List[comboClass.SelectedIndex - 1].SchoolClassNum;
}
FormP.IsNew = true;
FormP.ShowDialog();
if (FormP.DialogResult != DialogResult.OK)
{
return;
}
//new provider has already been inserted into DB from FormP.
Providers.MoveDownBelow(FormP.ProvCur); //safe to run even if none selected.
changed = true;
FillGrid();
gridMain.ScrollToEnd();
for (int i = 0; i < table.Rows.Count; i++) //ProviderC.ListLong.Count;i++) {
{
if (table.Rows[i]["ProvNum"].ToString() == FormP.ProvCur.ProvNum.ToString())
{
//ProviderC.ListLong[i].ProvNum==FormP.ProvCur.ProvNum) {
gridMain.SetSelected(i, true);
break;
}
}
}
private void FillGrid()
{
int userNum = 0;
if (comboUser.SelectedIndex > 0)
{
userNum = Userods.Listt[comboUser.SelectedIndex - 1].UserNum;
}
SecurityLog[] logList = SecurityLogs.Refresh(PIn.PDate(textDateFrom.Text), PIn.PDate(textDateTo.Text),
(Permissions)comboPermission.SelectedIndex, PatNum, userNum);
grid.BeginUpdate();
grid.Columns.Clear();
ODGridColumn col = new ODGridColumn(Lan.g("TableAudit", "Date Time"), 120);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableAudit", "User"), 70);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableAudit", "Permission"), 110);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableAudit", "Log Text"), 570);
grid.Columns.Add(col);
grid.Rows.Clear();
ODGridRow row;
for (int i = 0; i < logList.Length; i++)
{
row = new ODGridRow();
row.Cells.Add(logList[i].LogDateTime.ToShortDateString() + " " + logList[i].LogDateTime.ToShortTimeString());
row.Cells.Add(UserodB.GetUser(logList[i].UserNum).UserName);
row.Cells.Add(logList[i].PermType.ToString());
row.Cells.Add(logList[i].LogText);
grid.Rows.Add(row);
}
grid.EndUpdate();
grid.ScrollToEnd();
}
private void FillGrid()
{
long userNum = 0;
if (comboUser.SelectedIndex > 0)
{
userNum = UserodC.Listt[comboUser.SelectedIndex - 1].UserNum;
}
SecurityLog[] logList = null;
if (comboPermission.SelectedIndex == 0)
{
logList = SecurityLogs.Refresh(PIn.Date(textDateFrom.Text), PIn.Date(textDateTo.Text),
Permissions.None, PatNum, userNum);
}
else
{
logList = SecurityLogs.Refresh(PIn.Date(textDateFrom.Text), PIn.Date(textDateTo.Text),
(Permissions)Enum.Parse(typeof(Permissions), comboPermission.SelectedItem.ToString()), PatNum, userNum);
}
grid.BeginUpdate();
grid.Columns.Clear();
ODGridColumn col = new ODGridColumn(Lan.g("TableAudit", "Date"), 70);
col.SortingStrategy = GridSortingStrategy.DateParse;
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableAudit", "Time"), 60);
col.SortingStrategy = GridSortingStrategy.DateParse;
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableAudit", "Patient"), 100);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableAudit", "User"), 70);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableAudit", "Permission"), 110);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableAudit", "Computer"), 70);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableAudit", "Log Text"), 560);
grid.Columns.Add(col);
grid.Rows.Clear();
ODGridRow row;
Userod user;
for (int i = 0; i < logList.Length; i++)
{
row = new ODGridRow();
row.Cells.Add(logList[i].LogDateTime.ToShortDateString());
row.Cells.Add(logList[i].LogDateTime.ToShortTimeString());
row.Cells.Add(logList[i].PatientName);
user = Userods.GetUser(logList[i].UserNum);
//user might be null due to old bugs.
if (user == null)
{
row.Cells.Add("unknown");
}
else
{
row.Cells.Add(Userods.GetUser(logList[i].UserNum).UserName);
}
if (logList[i].PermType == Permissions.ChartModule)
{
row.Cells.Add("ChartModuleViewed");
}
else if (logList[i].PermType == Permissions.FamilyModule)
{
row.Cells.Add("FamilyModuleViewed");
}
else if (logList[i].PermType == Permissions.AccountModule)
{
row.Cells.Add("AccountModuleViewed");
}
else if (logList[i].PermType == Permissions.ImagesModule)
{
row.Cells.Add("ImagesModuleViewed");
}
else if (logList[i].PermType == Permissions.TPModule)
{
row.Cells.Add("TreatmentPlanModuleViewed");
}
else
{
row.Cells.Add(logList[i].PermType.ToString());
}
row.Cells.Add(logList[i].CompName);
row.Cells.Add(logList[i].LogText);
//Get the hash for the audit log entry from the database and rehash to compare
string newHash = SecurityLogHashes.GetHashString(logList[i]);
if (logList[i].LogHash != newHash)
{
row.ColorText = Color.Red; //Bad hash or no hash entry at all. This prevents users from deleting the entire hash table to make the audit trail look valid and encrypted.
//historical entries will show as red.
}
grid.Rows.Add(row);
}
grid.EndUpdate();
grid.ScrollToEnd();
}
private void FillGrid()
{
long userNum = 0;
if (comboUser.SelectedIndex > 0)
{
userNum = UserodC.Listt[comboUser.SelectedIndex - 1].UserNum;
}
SecurityLog[] logList = null;
if (comboPermission.SelectedIndex == 0)
{
logList = SecurityLogs.Refresh(PIn.Date(textDateFrom.Text), PIn.Date(textDateTo.Text),
Permissions.None, PatNum, userNum);
}
else
{
logList = SecurityLogs.Refresh(PIn.Date(textDateFrom.Text), PIn.Date(textDateTo.Text),
(Permissions)Enum.Parse(typeof(Permissions), comboPermission.SelectedItem.ToString()), PatNum, userNum);
}
grid.BeginUpdate();
grid.Columns.Clear();
ODGridColumn col = new ODGridColumn(Lan.g("TableAudit", "Date"), 70);
col.SortingStrategy = GridSortingStrategy.DateParse;
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableAudit", "Time"), 60);
col.SortingStrategy = GridSortingStrategy.DateParse;
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableAudit", "Patient"), 100);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableAudit", "User"), 70);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableAudit", "Permission"), 110);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableAudit", "Computer"), 70);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableAudit", "Log Text"), 560);
grid.Columns.Add(col);
grid.Rows.Clear();
ODGridRow row;
Userod user;
for (int i = 0; i < logList.Length; i++)
{
row = new ODGridRow();
row.Cells.Add(logList[i].LogDateTime.ToShortDateString());
row.Cells.Add(logList[i].LogDateTime.ToShortTimeString());
row.Cells.Add(logList[i].PatientName);
user = Userods.GetUser(logList[i].UserNum);
//user might be null due to old bugs.
if (user == null)
{
row.Cells.Add("unknown");
}
else
{
row.Cells.Add(Userods.GetUser(logList[i].UserNum).UserName);
}
if (logList[i].PermType == Permissions.ChartModule)
{
row.Cells.Add("ChartModuleViewed");
}
else
{
row.Cells.Add(logList[i].PermType.ToString());
}
row.Cells.Add(logList[i].CompName);
row.Cells.Add(logList[i].LogText);
grid.Rows.Add(row);
}
grid.EndUpdate();
grid.ScrollToEnd();
}
