protected void Run1()
{
/*
* ReferralDB.Insert(26963, 2, 63312, new DateTime(2014, 1, 2), new DateTime(2014, 1, 2), -4, DateTime.Now, -1, DateTime.MinValue);
* ReferralDB.Insert(26963, 3, 63312, new DateTime(2014, 1, 2), new DateTime(2014, 1, 2), -4, DateTime.Now, -1, DateTime.MinValue);
*
* ReferralDB.Update(1, 26963, 1, 63312, new DateTime(2014, 1, 2), new DateTime(2014, 1, 2), -4, DateTime.Now, -1, DateTime.MinValue);
*
* ReferralRemainingDB.Insert(1, 68, 1);
* ReferralRemainingDB.Insert(1, 277, 2);
* ReferralRemainingDB.Insert(2, 68, 3);
* ReferralRemainingDB.Insert(2, 277, 4);
*
* ReferralRemainingDB.Update(4, 1, 68, 4);
*/
Referral[] referrals = ReferralDB.GetAll();
int[] referralIDs = referrals.Select(r => r.ReferralID).ToArray();
Hashtable referralsRemainingHash = ReferralRemainingDB.GetHashtableByHealthCardIDs(referralIDs);
string output = string.Empty;
for (int i = 0; i < referrals.Length; i++)
{
output += "<br />" + referrals[i].ReferralID + " - " + referrals[i].MedicalServiceType.Descr;
ReferralRemaining[] referralsRemaining = (ReferralRemaining[])referralsRemainingHash[referrals[i].ReferralID];
if (referralsRemaining != null)
{
for (int j = 0; j < referralsRemaining.Length; j++)
{
output += "<br />" + " " + referralsRemaining[j].ReferralRemainingID + " - " + referralsRemaining[j].NumServicesRemaining;
}
}
}
lblOutput.Text = output;
}
protected void FillGrdReferreralEmails()
{
try
{
GrdReferreralEmails.Visible = true;
Patient patient = PatientDB.GetByID(GetFormPTID());
lblHeading.Text = "Referrer Emails For " + patient.Person.FullnameWithoutMiddlename;
DataTable dt = ReferralDB.GetDataTable(false, patient.PatientID);
dt.Columns.Add("email", typeof(String));
for (int i = dt.Rows.Count - 1; i >= 0; i--)
{
int orgEntityID = dt.Rows[i]["organisation_entity_id"] == DBNull.Value ? 0 : Convert.ToInt32(dt.Rows[i]["organisation_entity_id"]);
string[] emailsList = ContactAusDB.GetEmailsByEntityID(orgEntityID);
if (emailsList.Length > 0)
{
dt.Rows[i]["email"] = string.Join(",", emailsList);
}
else
{
dt.Rows.RemoveAt(i);
}
}
ViewState["referreralemail_data"] = dt;
if (dt.Rows.Count > 0)
{
if (IsPostBack && ViewState["referreralemail_sortexpression"] != null && ViewState["referreralemail_sortexpression"].ToString().Length > 0)
{
DataView dataView = new DataView(dt);
dataView.Sort = ViewState["referreralemail_sortexpression"].ToString();
GrdReferreralEmails.DataSource = dataView;
}
else
{
GrdReferreralEmails.DataSource = dt;
}
GrdReferreralEmails.DataBind();
}
else
{
dt.Rows.Add(dt.NewRow());
GrdReferreralEmails.DataSource = dt;
GrdReferreralEmails.DataBind();
int TotalColumns = GrdReferreralEmails.Rows[0].Cells.Count;
GrdReferreralEmails.Rows[0].Cells.Clear();
GrdReferreralEmails.Rows[0].Cells.Add(new TableCell());
GrdReferreralEmails.Rows[0].Cells[0].ColumnSpan = TotalColumns;
GrdReferreralEmails.Rows[0].Cells[0].Text = "No Referrer Emails Exist";
}
}
catch (CustomMessageException ex)
{
SetErrorMessage(ex.ToString());
}
catch (Exception ex)
{
SetErrorMessage("", Utilities.IsDev() ? ex.ToString() : ex.Message);
}
}
