/// <summary>
/// </summary>
private void FillGrid()
{
DateTime dateFrom = DateTimeOD.Today;
DateTime dateTo = DateTimeOD.Today;
try {
dateFrom = PIn.Date(textDateStart.Text); //handles blank
if (textDateEnd.Text != "") //if it is blank, default to today
{
dateTo = PIn.Date(textDateEnd.Text);
}
}
catch {
MsgBox.Show(this, "Invalid date");
return;
}
gridMain.Columns.Clear();
ODGridColumn col = new ODGridColumn(Lan.g(this, "Date"), 70);
gridMain.Columns.Add(col);
col = new ODGridColumn(Lan.g(this, "Time"), 42);
gridMain.Columns.Add(col);
col = new ODGridColumn(Lan.g(this, "Patient Last Name"), 110);
gridMain.Columns.Add(col);
col = new ODGridColumn(Lan.g(this, "Patient First Name"), 110);
gridMain.Columns.Add(col);
col = new ODGridColumn(Lan.g(this, "Description"), 240);
gridMain.Columns.Add(col);
col = new ODGridColumn(Lan.g(this, "Deleted"), 0, HorizontalAlignment.Center);
gridMain.Columns.Add(col);
gridMain.Rows.Clear();
DataTable table = Sheets.GetWebFormSheetsTable(dateFrom, dateTo, Clinics.ClinicNum);
for (int i = 0; i < table.Rows.Count; i++)
{
long patNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
long sheetNum = PIn.Long(table.Rows[i]["SheetNum"].ToString());
Patient pat = Patients.GetPat(patNum);
if (pat != null)
{
ODGridRow row = new ODGridRow();
row.Cells.Add(table.Rows[i]["date"].ToString());
row.Cells.Add(table.Rows[i]["time"].ToString());
row.Cells.Add(pat.LName);
row.Cells.Add(pat.FName);
row.Cells.Add(table.Rows[i]["description"].ToString());
row.Cells.Add(table.Rows[i]["IsDeleted"].ToString() == "0" ? "" : "X");
row.Tag = sheetNum;
gridMain.Rows.Add(row);
}
}
gridMain.EndUpdate();
}
