private void cbService_SelectedIndexChanged(object sender, EventArgs e) { ComboBox cmb = (ComboBox)sender; int selectedIndex = cmb.SelectedIndex; int selectedValue = (int)cmb.SelectedValue; var exceptionList = new List <int> { 206, 207, 7 }; var query = (from inv in selectedServices.AsEnumerable() where inv.Field <int>("ModuleID") == selectedValue select new { IdentifierID = inv["IdentifierID"], IdentifierName = inv["IdentifierName"] }); DataTable dt = DatatTableUtil.LINQResultToDataTable(query); DataRow theDR = dt.NewRow(); theDR["IdentifierName"] = "All"; theDR["IdentifierID"] = 9999; dt.Rows.InsertAt(theDR, 0); theDR = dt.NewRow(); theDR["IdentifierName"] = "IQNumber"; theDR["IdentifierID"] = 10000; dt.Rows.InsertAt(theDR, 1); cbIdentifier.DataSource = null; cbIdentifier.Items.Clear(); cbIdentifier.DisplayMember = "IdentifierName"; cbIdentifier.ValueMember = "IdentifierID"; cbIdentifier.DataSource = dt; //DatatTableUtil.BindCombo(cbIdentifier, dt, "IdentifierName", "IdentifierID"); }
private void BindDetails(DataSet ds) { try { var exceptionList = new List <int> { 206, 207, 7 }; IEnumerable <DataRow> filterdata = (from inv in ds.Tables[0].AsEnumerable() where !exceptionList.Contains(inv.Field <int>("ModuleID")) select inv); DataTable dt = filterdata.CopyToDataTable(); selectedServices = dt; var query1 = (from inv in selectedServices.AsEnumerable() select new { ModuleID = inv["ModuleID"], ModuleName = inv["ModuleName"] }).Distinct(); DataTable dtService = DatatTableUtil.LINQResultToDataTable(query1); cbService.DisplayMember = "ModuleName"; cbService.ValueMember = "ModuleID"; cbService.DataSource = dtService; //DatatTableUtil.BindCombo(cbService, dtService, "ModuleName", "ModuleID"); } catch (Exception ex) { MessageBox.Show(ex.Message, "IQCare", MessageBoxButtons.OK, MessageBoxIcon.Error); CLogger.WriteLog(ELogLevel.ERROR, ex.ToString()); } }
private void GetPatientIPTDetails(Patient cust) { try { IIPTDetails iiptdetails; DataSet ds = new DataSet(); iiptdetails = new BIPTDetails(); patientId = cust.PatientId; ds = iiptdetails.GetPatientIPTDetails(Convert.ToInt32(ConfigurationSettings.AppSettings["AppLocationId"].ToString()) , cust.PatientId); #region DataManupulation dsPatientDetails = ds; IEnumerable <DataRow> drTBbAssessment = (from fdata in ds.Tables[1].AsEnumerable() where fdata.Field <Int32>("Ptn_Pk") == cust.PatientId select fdata); List <CodeDeCodeTables> iptadherence = new List <CodeDeCodeTables>(); List <CodeDeCodeTables> iptcontraindication = new List <CodeDeCodeTables>(); List <CodeDeCodeTables> iptdiscontinued = new List <CodeDeCodeTables>(); List <CodeDeCodeTables> tbstatus = new List <CodeDeCodeTables>(); iptadherence = (from dt in ds.Tables[0].AsEnumerable().Where(o => o.Field <string>("CodeName") == "IPTAdherence").ToList() select new CodeDeCodeTables() { CodeId = dt.Field <int>("CodeId"), CodeName = dt.Field <string>("CodeName"), DeCodeId = dt.Field <int>("DeCodeId"), DeCodeName = dt.Field <string>("DeCodeName") }).ToList(); iptcontraindication = (from dt in ds.Tables[0].AsEnumerable().Where(o => o.Field <string>("CodeName") == "IPTContraindication").ToList() select new CodeDeCodeTables() { CodeId = dt.Field <int>("CodeId"), CodeName = dt.Field <string>("CodeName"), DeCodeId = dt.Field <int>("DeCodeId"), DeCodeName = dt.Field <string>("DeCodeName") }).ToList(); iptdiscontinued = (from dt in ds.Tables[0].AsEnumerable().Where(o => o.Field <string>("CodeName") == "IPTDiscontinued").ToList() select new CodeDeCodeTables() { CodeId = dt.Field <int>("CodeId"), CodeName = dt.Field <string>("CodeName"), DeCodeId = dt.Field <int>("DeCodeId"), DeCodeName = dt.Field <string>("DeCodeName") }).ToList(); tbstatus = (from dt in ds.Tables[0].AsEnumerable().Where(o => o.Field <string>("CodeName") == "TB Status").ToList() select new CodeDeCodeTables() { CodeId = dt.Field <int>("CodeId"), CodeName = dt.Field <string>("CodeName"), DeCodeId = dt.Field <int>("DeCodeId"), DeCodeName = dt.Field <string>("DeCodeName") }).ToList(); DataTable dtResult = DatatTableUtil.LINQResultToDataTable(iptcontraindication); DataRow theDR = dtResult.NewRow(); theDR["DeCodeName"] = "Select"; theDR["DeCodeId"] = 0; dtResult.Rows.InsertAt(theDR, 0); cbIPTContraindication.DataSource = null; cbIPTContraindication.Items.Clear(); cbIPTContraindication.DisplayMember = "DeCodeName"; cbIPTContraindication.ValueMember = "DeCodeId"; cbIPTContraindication.DataSource = dtResult; dtResult = DatatTableUtil.LINQResultToDataTable(iptcontraindication); DataRow theDR1 = dtResult.NewRow(); theDR1["DeCodeName"] = "Select"; theDR1["DeCodeId"] = 0; dtResult.Rows.InsertAt(theDR1, 0); //cbIPTContraindication.DataSource = null; //cbIPTContraindication.Items.Clear(); //cbIPTContraindication.DisplayMember = "DeCodeName"; //cbIPTContraindication.ValueMember = "DeCodeId"; //cbIPTContraindication.DataSource = dtResult; dtResult = DatatTableUtil.LINQResultToDataTable(iptdiscontinued); DataRow theDR2 = dtResult.NewRow(); theDR2["DeCodeName"] = "Select"; theDR2["DeCodeId"] = 0; dtResult.Rows.InsertAt(theDR2, 0); cbIPTDiscontinued.DataSource = null; cbIPTDiscontinued.Items.Clear(); cbIPTDiscontinued.DisplayMember = "DeCodeName"; cbIPTDiscontinued.ValueMember = "DeCodeId"; cbIPTDiscontinued.DataSource = dtResult; this.cbIPTContraindication.SelectedValue = 0; this.cbIPTDiscontinued.SelectedValue = 0; string tbFindings = string.Empty; string dtStartDate = string.Empty; string dtEndDate = string.Empty; int eligibleforIPT = 0; this.chkEligibleForIPT.Checked = false; int ddlIPTContraindication = 0, ddlIPTAdherence = 0, ddlIPTDiscontinued = 0; string strIPT = string.Empty, otherReasonDiscontinuedIPT = String.Empty, otherReasonDeclinedIPT = String.Empty; #endregion #region Data Extract IEnumerable <DataRow> filterdata1 = (from fdata in ds.Tables[2].AsEnumerable() where fdata.Field <Int32>("Ptn_Pk") == cust.PatientId select fdata).OrderBy(o => o.Field <DateTime>("CreateDate")); foreach (DataRow drow in filterdata1) { if (!DBNull.Value.Equals(drow["TBFindings"])) { tbFindings = drow["TBFindings"].ToString(); } if (!DBNull.Value.Equals(drow["INHStartDate"])) { dtStartDate = DateTime.Parse(drow["INHStartDate"].ToString()).ToString(); } if (!DBNull.Value.Equals(drow["INHEndDate"])) { dtEndDate = DateTime.Parse(drow["INHEndDate"].ToString()).ToString(); } if (!DBNull.Value.Equals(drow["EligibleForIPT"])) { eligibleforIPT = Convert.ToInt32(drow["EligibleForIPT"].ToString()); } if (!DBNull.Value.Equals(drow["IPTAdherence"])) { ddlIPTAdherence = Convert.ToInt32(drow["IPTAdherence"].ToString()); } if (!DBNull.Value.Equals(drow["IPTContraindication"])) { ddlIPTContraindication = Convert.ToInt32(drow["IPTContraindication"].ToString()); } if (!DBNull.Value.Equals(drow["IPTDiscontinued"])) { ddlIPTDiscontinued = Convert.ToInt32(drow["IPTDiscontinued"].ToString()); } if (!DBNull.Value.Equals(drow["IPT"])) { strIPT = drow["IPT"].ToString(); } if (!DBNull.Value.Equals(drow["OtherReasonDiscontinuedIPT"])) { otherReasonDiscontinuedIPT = drow["OtherReasonDiscontinuedIPT"].ToString(); } if (!DBNull.Value.Equals(drow["OtherReasonDeclinedIPT"])) { otherReasonDeclinedIPT = drow["OtherReasonDeclinedIPT"].ToString(); } } #endregion #region Assign data String[] names = drTBbAssessment.Select(o => o["NAME"].ToString()).ToArray(); this.txtTBAssessment.Text = string.Join(",", names); if (!string.IsNullOrEmpty(tbFindings)) { DataView theCodeDV = new DataView(ds.Tables[0]); theCodeDV.RowFilter = "CodeName in ('TB Status','TBFindings') and DeCodeId = '" + tbFindings + "'"; DataTable theCodeDT = (DataTable)DatatTableUtil.CreateTableFromDataView(theCodeDV); //string strTbFinding = tbstatus.Where(o => o.DeCodeId == Convert.ToInt32(tbFindings)).FirstOrDefault().DeCodeName; string strTbFinding = theCodeDT.AsEnumerable().FirstOrDefault().Field <string>("DeCodeName").ToString(); this.txtTBFinding.Text = GetTBStatusName(strTbFinding); } if (eligibleforIPT == 1) { this.chkEligibleForIPT.Checked = true; } this.dtIPTEndDate.Enabled = false; this.cbIPTContraindication.Enabled = false; //this.cbIPTContraindication.Enabled = false; this.cbIPTDiscontinued.Enabled = false; this.chkEligibleForIPT.Enabled = false; this.rbCompletedIPT.Enabled = false; this.rbDeclinedIpt.Enabled = false; this.rbDiscontinued.Enabled = false; //if (ValidatePatient(ds, cust.PatientId)) //{ this.chkEligibleForIPT.Enabled = false; this.rbCompletedIPT.Enabled = true; this.rbDeclinedIpt.Enabled = true; this.rbDiscontinued.Enabled = true; if (!string.IsNullOrEmpty(dtStartDate)) { this.dtIPTStartDate.Format = DateTimePickerFormat.Custom; this.dtIPTStartDate.CustomFormat = "dd-MMM-yyyy"; this.dtIPTStartDate.Value = DateTime.Parse(dtStartDate.ToString()); } if (!string.IsNullOrEmpty(dtEndDate)) { this.dtIPTEndDate.Format = DateTimePickerFormat.Custom; this.dtIPTEndDate.CustomFormat = "dd-MMM-yyyy"; this.dtIPTEndDate.Value = DateTime.Parse(dtEndDate.ToString()); } this.cbIPTContraindication.SelectedValue = ddlIPTContraindication; this.cbIPTDiscontinued.SelectedValue = ddlIPTDiscontinued; if (ddlIPTContraindication > 0) { this.txtOtherReasonContraindication.Text = otherReasonDeclinedIPT; } if (ddlIPTDiscontinued > 0) { this.txtOtherReasonDiscontinued.Text = otherReasonDiscontinuedIPT; } bool isValidForUpdate = true; if (!string.IsNullOrEmpty(strIPT)) { DataView theCodeDV = new DataView(ds.Tables[0]); theCodeDV.RowFilter = "CodeName in ('IPT') and DeCodeId = '" + strIPT + "'"; DataTable theCodeDT = (DataTable)DatatTableUtil.CreateTableFromDataView(theCodeDV); if (theCodeDT.Rows.Count > 0) { string str = theCodeDT.AsEnumerable().FirstOrDefault().Field <string>("DeCodeName").ToString(); switch (str.Trim().ToLower()) { case "completed ipt": this.rbCompletedIPT.Checked = true; this.dtIPTEndDate.Enabled = true; isValidForUpdate = false; break; case "discontinued": this.rbDiscontinued.Checked = true; this.dtIPTEndDate.Enabled = true; this.cbIPTDiscontinued.Enabled = true; isValidForUpdate = false; break; case "declined ipt": this.rbDeclinedIpt.Checked = true; this.cbIPTContraindication.Enabled = true; isValidForUpdate = false; break; } } } if (!string.IsNullOrEmpty(dtStartDate.ToString()) && !string.IsNullOrEmpty(dtEndDate.ToString())) { if (!isValidForUpdate) { MessageBox.Show("Patient is not eligible for IPT update.", "IQCare.IPT", MessageBoxButtons.OK, MessageBoxIcon.Error); this.btnSave.Enabled = false; } } else { this.btnSave.Enabled = true; } //this.dtIPTEndDate.SelectedDate = DateTime.Parse(inMyString); //} //else //{ // MessageBox.Show("Patient is not eligible for IPT update.", "IQCare.IPT", MessageBoxButtons.OK, MessageBoxIcon.Error); // this.btnSave.Enabled = false; //} #endregion } catch (Exception ex) { MessageBox.Show(ex.Message, "IQCare", MessageBoxButtons.OK, MessageBoxIcon.Error); CLogger.WriteLog(ELogLevel.ERROR, ex.ToString()); } }