protected void Sort(string sortExpression, params string[] sortExpr)
{
DataTable dataTable = Session["condition_data"] as DataTable;
if (dataTable != null)
{
if (Session["condition_sortexpression"] == null)
{
Session["condition_sortexpression"] = "";
}
DataView dataView = new DataView(dataTable);
string[] sortData = Session["condition_sortexpression"].ToString().Trim().Split(' ');
string newSortExpr = (sortExpr.Length == 0) ?
(sortExpression == sortData[0] && sortData[1] == "ASC") ? "DESC" : "ASC" :
sortExpr[0];
dataView.Sort = sortExpression + " " + newSortExpr;
Session["condition_sortexpression"] = sortExpression + " " + newSortExpr;
GrdCondition.DataSource = dataView;
GrdCondition.DataBind();
}
}
protected void FillGrid()
{
DataTable dt = ConditionDB.GetDataTable(chkShowDeleted.Checked);
Session["condition_data"] = dt;
if (dt.Rows.Count > 0)
{
GrdCondition.DataSource = dt;
try
{
GrdCondition.DataBind();
}
catch (Exception ex)
{
SetErrorMessage("", ex.ToString());
}
//Sort("parent_descr", "ASC");
}
else
{
dt.Rows.Add(dt.NewRow());
GrdCondition.DataSource = dt;
GrdCondition.DataBind();
int TotalColumns = GrdCondition.Rows[0].Cells.Count;
GrdCondition.Rows[0].Cells.Clear();
GrdCondition.Rows[0].Cells.Add(new TableCell());
GrdCondition.Rows[0].Cells[0].ColumnSpan = TotalColumns;
GrdCondition.Rows[0].Cells[0].Text = "No Conditions Found";
}
}
protected void FillGrdCondition(Patient patient = null)
{
if (patient == null)
{
patient = PatientDB.GetByID(GetFormPatientID());
}
DataTable dt = ConditionDB.GetDataTable(false);
Hashtable conditionHash = ConditionDB.GetHashtable(false);
Session["patientcondition_data"] = dt;
if (dt.Rows.Count > 0)
{
GrdCondition.DataSource = dt;
try
{
GrdCondition.DataBind();
Hashtable selectedConditions = PatientConditionDB.GetHashtable_ByPatientID(patient.PatientID, false);
foreach (GridViewRow row in GrdCondition.Rows)
{
Label lblId = row.FindControl("lblId") as Label;
CheckBox chkSelect = row.FindControl("chkSelect") as CheckBox;
DropDownList ddlDate_Day = (DropDownList)row.FindControl("ddlDate_Day");
DropDownList ddlDate_Month = (DropDownList)row.FindControl("ddlDate_Month");
DropDownList ddlDate_Year = (DropDownList)row.FindControl("ddlDate_Year");
DropDownList ddlNbrWeeksDue = (DropDownList)row.FindControl("ddlNbrWeeksDue");
Label lblNextDue = row.FindControl("lblNextDue") as Label;
Label lblWeeksLater = row.FindControl("lblWeeksLater") as Label;
Label lblAdditionalInfo = row.FindControl("lblAdditionalInfo") as Label;
System.Web.UI.HtmlControls.HtmlControl br_date = (System.Web.UI.HtmlControls.HtmlControl)row.FindControl("br_date");
System.Web.UI.HtmlControls.HtmlControl br_nweeksdue = (System.Web.UI.HtmlControls.HtmlControl)row.FindControl("br_nweeksdue");
System.Web.UI.HtmlControls.HtmlControl br_text = (System.Web.UI.HtmlControls.HtmlControl)row.FindControl("br_text");
TextBox txtText = (TextBox)row.FindControl("txtText");
if (lblId == null || chkSelect == null)
{
continue;
}
Condition condition = (Condition)conditionHash[Convert.ToInt32(lblId.Text)];
br_date.Visible = condition.ShowDate;
ddlDate_Day.Visible = condition.ShowDate;
ddlDate_Month.Visible = condition.ShowDate;
ddlDate_Year.Visible = condition.ShowDate;
br_nweeksdue.Visible = condition.ShowNWeeksDue;
ddlNbrWeeksDue.Visible = condition.ShowNWeeksDue;
lblNextDue.Visible = condition.ShowNWeeksDue;
lblWeeksLater.Visible = condition.ShowNWeeksDue;
br_text.Visible = condition.ShowText;
txtText.Visible = condition.ShowText;
lblAdditionalInfo.Visible = condition.ShowText;
if (selectedConditions[Convert.ToInt32(lblId.Text)] != null)
{
PatientCondition ptCondition = (PatientCondition)selectedConditions[Convert.ToInt32(lblId.Text)];
chkSelect.Checked = selectedConditions[Convert.ToInt32(lblId.Text)] != null;
if (condition.ShowDate)
{
if (ptCondition.Date != DateTime.MinValue)
{
ddlDate_Day.SelectedValue = ptCondition.Date.Day.ToString();
ddlDate_Month.SelectedValue = ptCondition.Date.Month.ToString();
ddlDate_Year.SelectedValue = ptCondition.Date.Year.ToString();
}
}
if (condition.ShowNWeeksDue)
{
ddlNbrWeeksDue.SelectedValue = ptCondition.NWeeksDue.ToString();
}
if (condition.ShowText)
{
txtText.Text = ptCondition.Text;
}
}
}
}
catch (Exception ex)
{
SetErrorMessage("", ex.ToString());
}
//Sort("parent_descr", "ASC");
}
else
{
dt.Rows.Add(dt.NewRow());
GrdCondition.DataSource = dt;
GrdCondition.DataBind();
int TotalColumns = GrdCondition.Rows[0].Cells.Count;
GrdCondition.Rows[0].Cells.Clear();
GrdCondition.Rows[0].Cells.Add(new TableCell());
GrdCondition.Rows[0].Cells[0].ColumnSpan = TotalColumns;
GrdCondition.Rows[0].Cells[0].Text = "No Record Found";
}
}
