protected List <Tuple <string, Organisation> > GetClinicList()
{
try
{
List <Tuple <string, Organisation> > list = new List <Tuple <string, Organisation> >();
bool allowPatientsToCreateOwnRecords = ((SystemVariables)Session["SystemVariables"])["AllowPatientsToCreateOwnRecords"].Value == "1";
if (allowPatientsToCreateOwnRecords)
{
Organisation[] orgs = OrganisationDB.GetAll(false, true, false, false, true, true);
if (orgs.Length > 0)
{
for (int j = 0; j < orgs.Length; j++)
{
if (orgs[j].IsClinic)
{
list.Add(new Tuple <string, Organisation>(((SystemVariables)Session["SystemVariables"])["Site"].Value, orgs[j]));
}
}
}
}
return(list);
}
catch (CustomMessageException cmEx)
{
this.lblErrorMessage.Text = cmEx.Message;
return(null);
}
}
protected void DisplayInfo()
{
string curDbName = Session["DB"].ToString();
ddlDBs.Items.Clear();
ddlDBs.Items.Add(new ListItem("All Clients", "0"));
ddlDBs2.Items.Clear();
ddlDBs2.Items.Add(new ListItem("All Clients", "0"));
ArrayList dbNames = new ArrayList();
Hashtable dbHash = new Hashtable();
try
{
bool isSupportStaff3 = Session != null && Session["StaffID"] != null && Convert.ToInt32(Session["StaffID"]) == -4;
List <Tuple <string, string> > list = new List <Tuple <string, string> >();
System.Data.DataTable tbl = DBBase.ExecuteQuery("EXEC sp_databases;", "master").Tables[0];
for (int i = 0; i < tbl.Rows.Count; i++)
{
string databaseName = tbl.Rows[i][0].ToString();
if (!Regex.IsMatch(databaseName, @"Mediclinic_\d{4}"))
{
continue;
}
//if (databaseName == "Mediclinic_0001")
// continue;
SystemVariables sysVariables = SystemVariableDB.GetAll(databaseName);
dbNames.Add(sysVariables["Site"].Value);
dbHash[sysVariables["Site"].Value] = databaseName;
System.Text.StringBuilder output = new System.Text.StringBuilder();
Session["DB"] = databaseName;
Session["SystemVariables"] = SystemVariableDB.GetAll();
string callCenterPrefix = ((SystemVariables)Session["SystemVariables"])["CallCenterPrefix"].Value;
int loginsPastWeek_Total = UserLoginDB.GetCount(7);
int loginsPastWeek_Staff = UserLoginDB.GetStaffCount(7);
if (((SystemVariables)Session["SystemVariables"])["UseMediclinicCallCenter"].Value == "1")
{
Organisation[] orgs = OrganisationDB.GetAll(false, true, false, false, true, true);
Site[] sites = SiteDB.GetAll();
int clinicSiteID = -1;
int agedCareSiteID = -1;
for (int j = 0; j < sites.Length; j++)
{
if (sites[j].SiteType.ID == 1)
{
clinicSiteID = sites[j].SiteID;
}
if (sites[j].SiteType.ID == 2)
{
agedCareSiteID = sites[j].SiteID;
}
}
string showHideID1 = "heading_" + databaseName;
string showHideLink1 = @"<a href=""javascript:void(0)"" onclick=""hide_show_all('" + showHideID1 + @"');return false;"">Show/Hide Clinics/Facs</a>";
string siteTitleLink = @"<span style=""display:inline-block;vertical-align:middle;max-width:300px;min-width:300px;overflow:hidden;text-overflow:ellipsis;""><a style=""white-space:nowrap;"" class=""call_centre_header"" title=""" + ((SystemVariables)Session["SystemVariables"])["Site"].Value + @""" href=""" + HttpContext.Current.Request.Url.AbsolutePath + "?db=" + databaseName + @""" onclick=""http_post('" + databaseName + @"','0','0',-1);return false;"">" + ((SystemVariables)Session["SystemVariables"])["Site"].Value + @"</a></span>";
//string siteTitleLink = @"<span style=""display:inline-block;min-width:250px;""><a class=""call_centre_header"" title=""" + ((SystemVariables)Session["SystemVariables"])["Site"].Value + @""" href=""" + HttpContext.Current.Request.Url.AbsolutePath + "?db=" + databaseName + @""" onclick=""http_post('" + databaseName + @"','0','0',-1);return false;"">" + ((SystemVariables)Session["SystemVariables"])["Site"].Value + @"</a></span>";
string callCentrePrefixText = @"<span style=""display:inline-block;min-width:160px;"">[Call Center Prefix: " + callCenterPrefix + "]</span>";
output.AppendLine("<tr>");
//output.AppendLine(" <td><u>" + ((SystemVariables)Session["SystemVariables"])["Site"].Value + "</u> [Call Center Prefix: " + callCenterPrefix + "] [" + Session["DB"] + "]</td>");
output.AppendLine(" <td>" + showHideLink1 + " " + (isSupportStaff3 ? @"<span style=""display:inline-block;min-width:55px;"">" + (loginsPastWeek_Staff == 0 && loginsPastWeek_Total == 0 ? "" : "[" + loginsPastWeek_Staff + "," + loginsPastWeek_Total + "]") + "</span>" + " " : "") + siteTitleLink + " " + callCentrePrefixText + " [" + Session["DB"] + "]</td>");
output.AppendLine("</tr>");
if (orgs.Length > 0)
{
for (int j = 0; j < orgs.Length; j++)
{
string showHideID = databaseName + "_" + orgs[j].OrganisationID;
string contactInfo = GetContactInfo(orgs[j].EntityID, 60, showHideID);
string titleLink = @"<a href=""" + HttpContext.Current.Request.Url.AbsolutePath + "?db=" + databaseName + @"&org=" + orgs[j].OrganisationID + @""" onclick=""http_post('" + databaseName + "','" + orgs[j].OrganisationID + @"','" + (orgs[j].IsClinic ? clinicSiteID : agedCareSiteID) + @"',-1);return false;"">" + orgs[j].Name + " " + (orgs[j].IsClinic ? @"(Clinic)" : "(Aged Care)") + @"</a>";
string showHideLink = @"<a href=""javascript:void(0)"" onclick=""hide_show('" + showHideID + @"');return false;"">Show/Hide Details</a>";
output.AppendLine(@"<tr id=""" + showHideID1 + j.ToString() + @""" style=""margin:0 0;display:none;"">");
output.AppendLine(@" <td style=""margin:0 0;"">");
output.AppendLine(@" <table><tr style=""vertical-align:top;""><td style=""width:500px;""><ul style=""margin:0 0;""><li>" + titleLink + @"</li></ul></td><td style=""min-width:10px;""></td><td>" + (contactInfo.Length > 0 ? showHideLink : "") + "</td></tr></table>");
if (contactInfo.Length > 0)
{
output.AppendLine(contactInfo);
}
output.AppendLine(@" </td>");
output.AppendLine(@"</tr>");
}
}
}
list.Add(new Tuple <string, string>(((SystemVariables)Session["SystemVariables"])["Site"].Value, output.ToString()));
Session.Remove("DB");
Session.Remove("SystemVariables");
}
dbNames.Sort();
foreach (string siteName in dbNames)
{
ddlDBs.Items.Add(new ListItem("[" + dbHash[siteName] + "] " + siteName, dbHash[siteName].ToString()));
ddlDBs2.Items.Add(new ListItem("[" + dbHash[siteName] + "] " + siteName, dbHash[siteName].ToString()));
}
list.Sort((a, b) => a.Item1.CompareTo(b.Item1));
System.Text.StringBuilder finalOutput = new System.Text.StringBuilder();
foreach (Tuple <string, string> item in list)
{
finalOutput.Append(item.Item2);
}
lblInfo1.Text = "<table>" + finalOutput.ToString() + "</table>";
}
finally
{
Session["DB"] = curDbName;
Session["SystemVariables"] = SystemVariableDB.GetAll();
}
}
protected void SetupGUI()
{
chkIncMedicare.Checked = IsValidFormIncMedicare() ? GetFormIncMedicare(false) : false;
chkIncDVA.Checked = IsValidFormIncDVA() ? GetFormIncDVA(false) : false;
chkIncPrivate.Checked = IsValidFormIncPrivate() ? GetFormIncPrivate(false) : true;
chkIncReconciled.Checked = IsValidFormIncReconciled() ? GetFormIncReconciled(false) : true;
UserView userView = UserView.GetInstance();
ddlOrgs.Style["width"] = "300px";
ddlOrgs.Items.Clear();
ddlOrgs.Items.Add(new ListItem("All " + (userView.IsAgedCareView ? "Facilities" : "Clinics"), (-1).ToString()));
foreach (Organisation curOrg in OrganisationDB.GetAll(false, true, !userView.IsClinicView && !userView.IsGPView, !userView.IsAgedCareView, true, true))
{
ddlOrgs.Items.Add(new ListItem(curOrg.Name, curOrg.OrganisationID.ToString()));
}
ddlProviders.Style["width"] = "300px";
ddlProviders.Items.Clear();
ddlProviders.Items.Add(new ListItem("All Staff", (-1).ToString()));
foreach (Staff curProv in StaffDB.GetAll())
{
ddlProviders.Items.Add(new ListItem(curProv.Person.FullnameWithoutMiddlename, curProv.StaffID.ToString()));
}
if (IsValidFormOrgID())
{
Organisation org = OrganisationDB.GetByID(GetFormOrgID());
if (org != null)
{
ddlOrgs.SelectedValue = org.OrganisationID.ToString();
}
}
if (!UserView.GetInstance().IsAdminView)
{
providerRow.Visible = false;
Staff provider = StaffDB.GetByID(Convert.ToInt32(Session["StaffID"]));
if (provider != null)
{
ddlProviders.SelectedValue = provider.StaffID.ToString();
}
}
else
{
if (IsValidFormProviderID())
{
Staff provider = StaffDB.GetByID(GetFormProviderID());
if (provider != null)
{
ddlProviders.SelectedValue = provider.StaffID.ToString();
}
}
}
ddlReceiptPaymentType.Style["width"] = "300px";
DataTable paymentTypes = DBBase.GetGenericDataTable_WithWhereOrderClause(null, "ReceiptPaymentType", "", "descr", "receipt_payment_type_id,descr");
ddlReceiptPaymentType.Items.Add(new ListItem("All Payment Types", "-1"));
for (int i = 0; i < paymentTypes.Rows.Count; i++)
{
ddlReceiptPaymentType.Items.Add(new ListItem(paymentTypes.Rows[i]["descr"].ToString(), paymentTypes.Rows[i]["receipt_payment_type_id"].ToString()));
}
if (IsValidFormPaymentType())
{
ddlReceiptPaymentType.SelectedValue = GetFormPaymentType(false).ToString();
}
txtStartDate.Text = IsValidFormStartDate() ? (GetFormStartDate(false) == DateTime.MinValue ? "" : GetFormStartDate(false).ToString("dd-MM-yyyy")) : DateTime.Today.ToString("dd-MM-yyyy");
txtEndDate.Text = IsValidFormEndDate() ? (GetFormEndDate(false) == DateTime.MinValue ? "" : GetFormEndDate(false).ToString("dd-MM-yyyy")) : DateTime.Today.ToString("dd-MM-yyyy");
txtStartDate_Picker.OnClientClick = "displayDatePicker('txtStartDate', this, 'dmy', '-'); return false;";
txtEndDate_Picker.OnClientClick = "displayDatePicker('txtEndDate', this, 'dmy', '-'); return false;";
}
protected void SetupGUI()
{
UserView userView = UserView.GetInstance();
chkIncAllSites.Text = userView.IsAgedCareView ? " Inc Clinics" : " Inc Aged Care Facilities";
chkIncAllSites.Checked = IsValidFormIncAllSites() ? GetFormIncAllSites(false) : true;
chkIncBookings.Checked = IsValidFormIncBookings() ? GetFormIncBookings(false) : true;
chkDateAcrossTop.Checked = IsValidFormDateAcrossTop() ? GetFormDateAcrossTop(false) : true;
ddlOrgs.Style["width"] = "300px";
ddlOrgs.Items.Clear();
ddlOrgs.Items.Add(new ListItem("All " + (userView.IsAgedCareView ? "Facilities" : "Clinics"), (-1).ToString()));
foreach (Organisation curOrg in OrganisationDB.GetAll(false, true, !userView.IsClinicView && !userView.IsGPView, !userView.IsAgedCareView, true, true))
{
ddlOrgs.Items.Add(new ListItem(curOrg.Name, curOrg.OrganisationID.ToString()));
}
ddlProviders.Style["width"] = "300px";
ddlProviders.Items.Clear();
ddlProviders.Items.Add(new ListItem("All Providers", (-1).ToString()));
foreach (Staff curProv in StaffDB.GetAll())
{
if (curProv.IsProvider)
{
ddlProviders.Items.Add(new ListItem(curProv.Person.FullnameWithoutMiddlename, curProv.StaffID.ToString()));
}
}
if (IsValidFormOrgID())
{
Organisation org = OrganisationDB.GetByID(GetFormOrgID());
if (org != null)
{
ddlOrgs.SelectedValue = org.OrganisationID.ToString();
}
}
if (!UserView.GetInstance().IsAdminView)
{
providerRow.Visible = false;
Staff provider = StaffDB.GetByID(Convert.ToInt32(Session["StaffID"]));
if (provider != null)
{
ddlProviders.SelectedValue = provider.StaffID.ToString();
}
}
else
{
if (IsValidFormProviderID())
{
Staff provider = StaffDB.GetByID(GetFormProviderID());
if (provider != null)
{
ddlProviders.SelectedValue = provider.StaffID.ToString();
}
}
}
txtStartDate.Text = IsValidFormStartDate() ? (GetFormStartDate(false) == DateTime.MinValue ? "" : GetFormStartDate(false).ToString("dd-MM-yyyy")) : DateTime.Today.ToString("dd-MM-yyyy");
txtEndDate.Text = IsValidFormEndDate() ? (GetFormEndDate(false) == DateTime.MinValue ? "" : GetFormEndDate(false).ToString("dd-MM-yyyy")) : DateTime.Today.AddMonths(1).ToString("dd-MM-yyyy");
txtStartDate_Picker.OnClientClick = "displayDatePicker('txtStartDate', this, 'dmy', '-'); return false;";
txtEndDate_Picker.OnClientClick = "displayDatePicker('txtEndDate', this, 'dmy', '-'); return false;";
}
protected void SetupGUI()
{
if (Request.QueryString["date_type"] != null)
{
rblDateType.SelectedValue = Request.QueryString["date_type"];
}
UserView userView = UserView.GetInstance();
ddlOrgs.Style["width"] = "300px";
ddlOrgs.Items.Clear();
ddlOrgs.Items.Add(new ListItem("All " + (userView.IsAgedCareView ? "Facilities" : "Clinics"), (-1).ToString()));
foreach (Organisation curOrg in OrganisationDB.GetAll(false, true, !userView.IsClinicView && !userView.IsGPView, !userView.IsAgedCareView, true, true))
{
ListItem li = new ListItem(curOrg.Name, curOrg.OrganisationID.ToString());
li.Attributes.Add("title", curOrg.Name);
ddlOrgs.Items.Add(li);
}
ddlProviders.Style["width"] = "300px";
ddlProviders.Items.Clear();
ddlProviders.Items.Add(new ListItem("All Providers", (-1).ToString()));
foreach (Staff curProv in StaffDB.GetAll())
{
if (curProv.IsProvider)
{
ddlProviders.Items.Add(new ListItem(curProv.Person.FullnameWithoutMiddlename, curProv.StaffID.ToString()));
}
}
ddlOfferings.Style["width"] = "300px";
ddlOfferings.Items.Clear();
ddlOfferings.Items.Add(new ListItem("All Products & Services", (-1).ToString()));
foreach (Offering offering in OfferingDB.GetAll(false, userView.IsAgedCareView ? "3,4" : "1,3", "63,89", false))
{
ddlOfferings.Items.Add(new ListItem(offering.Name, offering.OfferingID.ToString()));
}
if (IsValidFormOrgID())
{
Organisation org = OrganisationDB.GetByID(GetFormOrgID());
if (org != null)
{
ddlOrgs.SelectedValue = org.OrganisationID.ToString();
}
}
if (!UserView.GetInstance().IsAdminView)
{
providerRow.Visible = false;
Staff provider = StaffDB.GetByID(Convert.ToInt32(Session["StaffID"]));
if (provider != null)
{
ddlProviders.SelectedValue = provider.StaffID.ToString();
}
}
else
{
if (IsValidFormProviderID())
{
Staff provider = StaffDB.GetByID(GetFormProviderID());
if (provider != null)
{
ddlProviders.SelectedValue = provider.StaffID.ToString();
}
}
}
if (IsValidFormOfferingID())
{
Offering offering = OfferingDB.GetByID(GetFormOfferingID());
if (offering != null)
{
ddlOfferings.SelectedValue = offering.OfferingID.ToString();
}
}
txtStartDate.Text = IsValidFormStartDate() ? (GetFormStartDate(false) == DateTime.MinValue ? "" : GetFormStartDate(false).ToString("dd-MM-yyyy")) : DateTime.Today.ToString("dd-MM-yyyy");
txtEndDate.Text = IsValidFormEndDate() ? (GetFormEndDate(false) == DateTime.MinValue ? "" : GetFormEndDate(false).ToString("dd-MM-yyyy")) : DateTime.Today.ToString("dd-MM-yyyy");
txtStartDate_Picker.OnClientClick = "displayDatePicker('txtStartDate', this, 'dmy', '-'); return false;";
txtEndDate_Picker.OnClientClick = "displayDatePicker('txtEndDate', this, 'dmy', '-'); return false;";
}
private void FillEmptyAddForm()
{
UrlParamCreditType urlParamCreditType = GetUrlParamCreditType();
if (urlParamCreditType != UrlParamCreditType.Add)
{
throw new CustomMessageException("Can no add a '" + GetUrlParamCreditType().ToString() + "'");
}
ddlClinic.Items.Clear();
ddlClinic.Items.Add(new ListItem("--Select--", "0"));
foreach (Organisation org in OrganisationDB.GetAll(false, true, false, true, true, true))
{
ddlClinic.Items.Add(new ListItem(org.Name, org.OrganisationID.ToString()));
}
string heading = "";
if (urlParamCreditType == UrlParamCreditType.Add)
{
heading = "Voucher";
}
if (urlParamCreditType == UrlParamCreditType.Use)
{
heading = "Use Of Voucher";
}
if (urlParamCreditType == UrlParamCreditType.CashoutTyroToMC)
{
heading = "Cashout - Tyro To Mediclinic";
}
if (urlParamCreditType == UrlParamCreditType.CashoutMCtoPT)
{
heading = "Cashout - Mediclinic To Patient";
}
lblHeading.Text = "Add " + heading;
lblAmount.Visible = false;
lblDescr.Visible = false;
lblExpiry.Visible = false;
idRow.Visible = false;
typeRow.Visible = false;
amountUsedRow.Visible = false;
amountRemainingRow.Visible = false;
addedbyRow.Visible = false;
dateAddedRow.Visible = false;
modifiedbyRow.Visible = false;
dateModifiedRow.Visible = false;
deletedSpaceRow.Visible = false;
deletedbyRow.Visible = false;
dateDeletedRow.Visible = false;
preDeletedAmountRow.Visible = false;
invoiceListSpaceRow.Visible = false;
invoiceListRow.Visible = false;
if (urlParamCreditType != UrlParamCreditType.Add)
{
clinicRow.Visible = false;
descrRow.Visible = false;
expiryRow.Visible = false;
}
if (urlParamCreditType != UrlParamCreditType.Use)
{
voucherUsedRow.Visible = false;
invoiceRow.Visible = false;
}
btnSubmit.Text = "Add " + heading;
btnCancel.Visible = true;
}
