protected void GrdPatients_Sort(string sortExpression, params string[] sortExpr)
{
DataTable dataTable = Session["referrerinfoclinic_patients_data"] as DataTable;
if (dataTable != null)
{
if (Session["referrerinfoclinic_patients_sortexpression"] == null)
{
Session["referrerinfoclinic_patients_sortexpression"] = "";
}
DataView dataView = new DataView(dataTable);
string[] sortData = Session["referrerinfoclinic_patients_sortexpression"].ToString().Trim().Split(' ');
string newSortExpr = (sortExpr.Length == 0) ?
(sortExpression == sortData[0] && sortData[1] == "ASC") ? "DESC" : "ASC" :
sortExpr[0];
dataView.Sort = sortExpression + " " + newSortExpr;
Session["referrerinfoclinic_patients_sortexpression"] = sortExpression + " " + newSortExpr;
GrdPatients.DataSource = dataView;
GrdPatients.DataBind();
}
}
protected void ClearItems()
{
TxtPersonalId.Text = string.Empty;
CmbGender.ClearSelection();
DP_Birthday.Clear();
TxtFirstName.Text = string.Empty;
TxtSecondName.Text = string.Empty;
TxtLastName.Text = string.Empty;
TxtSecondLastName.Text = string.Empty;
TxtPhone.Text = string.Empty;
TxtCellPhone.Text = string.Empty;
TxtWhatsapp.Text = string.Empty;
TxtEmail.Text = string.Empty;
TxtAddress.Text = string.Empty;
GrdPatients.Rebind();
}
protected void GrdPatients_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
{
if (e.Item != null)
{
if (e.Item.ItemIndex >= 0)
{
int Id = int.Parse(e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["Id"].ToString());
switch (e.CommandName)
{
case "ViewData":
System.Data.DataTable dt = Data.DataProvider.Instance().GetPatients(Id);
foreach (System.Data.DataRow drow in dt.Rows)
{
TxtPersonalId.Text = drow["PersonalId"].ToString();
CmbGender.SelectedValue = drow["Gender"].ToString();
DP_Birthday.SelectedDate = DateTime.Parse(drow["Birthday"].ToString());
TxtFirstName.Text = drow["FirstName"].ToString();
TxtSecondName.Text = drow["SecondName"].ToString();
TxtLastName.Text = drow["LastName"].ToString();
TxtSecondLastName.Text = drow["SecondLastName"].ToString();
TxtPhone.Text = drow["Phone"].ToString();
TxtCellPhone.Text = drow["CellPhone"].ToString();
TxtWhatsapp.Text = drow["Whatsapp"].ToString();
TxtEmail.Text = drow["Email"].ToString();
TxtAddress.Text = drow["Address"].ToString();
}
break;
default:
GrdPatients.Rebind();
break;
}
e.Item.Selected = true;
}
}
}
protected void FillGrid_Patients(Type type, int id)
{
UserView userView = UserView.GetInstance();
DataTable dt = null;
if (type == typeof(Organisation))
{
Organisation org = OrganisationDB.GetByID(id);
lblPatientsHeading.Text = "Patients of <big><b>All Referrers</b></big> at <big><b>" + org.Name + "</b></big>";
if (userView.IsAdminView && userView.IsClinicView)
{
dt = PatientDB.GetDataTable(false, false, userView.IsClinicView, false, "", false, "", false, "", "", "", "", "", false, -1, -1, -1, "", "", "", "", id.ToString(), false, false, false);
}
if (userView.IsAdminView && !userView.IsClinicView)
{
dt = RegisterPatientDB.GetDataTable_PatientsOfOrgGroupType(false, "6", false, false, userView.IsClinicView, false, "", false, "", false, "", "", "", "", "", false, -1, -1, -1, "", "", "", "", id.ToString(), false, false, false);
}
if (!userView.IsAdminView)
{
dt = RegisterPatientDB.GetDataTable_PatientsOf(false, Convert.ToInt32(Session["OrgID"]), false, false, userView.IsClinicView, false, "", false, "", false, "", "", "", "", "", false, -1, -1, -1, "", "", "", "", id.ToString(), false, false, false);
}
}
else if (type == typeof(RegisterReferrer))
{
RegisterReferrer regRef = RegisterReferrerDB.GetByID(id);
lblPatientsHeading.Text = "Patients of <big><b>" + regRef.Referrer.Person.FullnameWithoutMiddlename + "</b></big> at <big><b>" + regRef.Organisation.Name + "</b></big>";
if (userView.IsAdminView && userView.IsClinicView)
{
dt = PatientDB.GetDataTable(false, false, userView.IsClinicView, false, "", false, "", false, "", "", "", "", "", false, -1, -1, -1, "", "", id.ToString(), "", "", false, false, false);
}
if (userView.IsAdminView && !userView.IsClinicView)
{
dt = RegisterPatientDB.GetDataTable_PatientsOfOrgGroupType(false, "6", false, false, userView.IsClinicView, false, "", false, "", false, "", "", "", "", "", false, -1, -1, -1, "", "", id.ToString(), "", "", false, false, false);
}
if (!userView.IsAdminView)
{
dt = RegisterPatientDB.GetDataTable_PatientsOf(false, Convert.ToInt32(Session["OrgID"]), false, false, userView.IsClinicView, false, "", false, "", false, "", "", "", "", "", false, -1, -1, -1, "", "", id.ToString(), "", "", false, false, false);
}
}
else
{
SetErrorMessage("Unknown type: " + type.ToString());
return;
}
lblPatientsHeading.Visible = true;
GrdPatients.Visible = true;
// put in epc info into the table in a bulk call
// epc exp date, if valid, how many epc's remaining...
int[] patientIDs = new int[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
patientIDs[i] = Convert.ToInt32(dt.Rows[i]["patient_id"]);
}
int MedicareMaxNbrServicesPerYear = Convert.ToInt32(SystemVariableDB.GetByDescr("MedicareMaxNbrServicesPerYear").Value);
Hashtable patientsMedicareCountThisYearCache = PatientsMedicareCardCountThisYearCacheDB.GetBullk(patientIDs, DateTime.Today.Year);
Hashtable patientsMedicareCountNextYearCache = PatientsMedicareCardCountThisYearCacheDB.GetBullk(patientIDs, DateTime.Today.Year + 1);
Hashtable patientsEPCRemainingCache = PatientsEPCRemainingCacheDB.GetBullk(patientIDs, DateTime.MinValue);
dt.Columns.Add("epc_signed_date", typeof(DateTime));
dt.Columns.Add("epc_expiry_date", typeof(DateTime));
dt.Columns.Add("epc_n_services_left", typeof(Int32));
for (int i = 0; i < dt.Rows.Count; i++)
{
int patientID = Convert.ToInt32(dt.Rows[i]["patient_id"]);
int totalServicesAllowedLeft = (MedicareMaxNbrServicesPerYear - (int)patientsMedicareCountThisYearCache[patientID]);
Pair totalEPCRemaining = patientsEPCRemainingCache[patientID] as Pair;
int nServicesLeft = 0;
if (totalEPCRemaining != null)
{
DateTime referralSignedDate = (DateTime)totalEPCRemaining.Second;
DateTime hcExpiredDate = referralSignedDate.AddYears(1);
if (DateTime.Today >= referralSignedDate.Date && DateTime.Today < hcExpiredDate.Date)
{
nServicesLeft = (int)totalEPCRemaining.First;
}
if (totalServicesAllowedLeft < nServicesLeft)
{
nServicesLeft = totalServicesAllowedLeft;
}
dt.Rows[i]["epc_signed_date"] = referralSignedDate;
dt.Rows[i]["epc_expiry_date"] = hcExpiredDate;
dt.Rows[i]["epc_n_services_left"] = nServicesLeft;
}
else
{
dt.Rows[i]["epc_signed_date"] = DBNull.Value;
dt.Rows[i]["epc_expiry_date"] = DBNull.Value;
dt.Rows[i]["epc_n_services_left"] = DBNull.Value;
}
}
Session["referrerinfoclinic_patients_data"] = dt;
if (dt.Rows.Count > 0)
{
if (IsPostBack && Session["referrerinfoclinic_patients_sortexpression"] != null && Session["referrerinfoclinic_patients_sortexpression"].ToString().Length > 0)
{
DataView dataView = new DataView(dt);
dataView.Sort = Session["referrerinfoclinic_patients_sortexpression"].ToString();
GrdPatients.DataSource = dataView;
}
else
{
GrdPatients.DataSource = dt;
}
try
{
GrdPatients.DataBind();
}
catch (Exception ex)
{
HideTableAndSetErrorMessage("", ex.ToString());
}
}
else
{
dt.Rows.Add(dt.NewRow());
GrdPatients.DataSource = dt;
GrdPatients.DataBind();
int TotalColumns = GrdPatients.Rows[0].Cells.Count;
GrdPatients.Rows[0].Cells.Clear();
GrdPatients.Rows[0].Cells.Add(new TableCell());
GrdPatients.Rows[0].Cells[0].ColumnSpan = TotalColumns;
GrdPatients.Rows[0].Cells[0].Text = "No Patients";
}
}
