protected void BuildStatusRptr(int PatientId, string EformName, string EformType) { StatusDa statusDa = new StatusDa(); DataSet statusDs = statusDa.GetStatus(PatientId, "Salivary Cancer"); DataView dv = new DataView(statusDs.Tables[0]); dv.RowFilter = Status.Status_Field + " LIKE '%Recurrence%' OR " + Status.Status_Field + " LIKE '%Metastasis%' "; if (dv.Count > 0) { StatusRptr.DataSource = dv; StatusRptr.DataBind(); } }
public override void Populate() { // get a list of status records for disease Prostate var statusRecords = BOL.BusinessObject.GetByFields <Status>(new Dictionary <string, object> { { Status.PatientId, base.patientId }, { Status.StatusDisease, STATUS_DISEASE } }); // build a left outer join against status list var dataSource = from status in STATUS_LIST join bizo in statusRecords on status equals bizo[Status.Status_Field].ToString() into g select new { Status = status, Bizo = g.FirstOrDefault() }; StatusRptr.DataSource = dataSource; StatusRptr.DataBind(); }