public void BindGridview() { try { oDS = AdoUDIRS.GetAllInformation(IncidentID); if (AdoUDIRS.BlnError) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; return; } else if (oDS.Tables.Count == 0) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; return; } else if (oDS.Tables.Count > 0) { gvActionPlan.DataSource = oDS.Tables[3]; gvActionPlan.DataBind(); } } catch (Exception ex) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; } //gvCommentsHistory.DataSource = dt; //gvCommentsHistory.DataBind(); }
private void LoadAllData() { try { oDS = AdoUDIRS.GetAllInformation(IncidentID); if (AdoUDIRS.BlnError) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; return; } else if (oDS.Tables.Count == 0) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; return; } else if (oDS.Tables.Count > 0) { string mystring = string.Empty; foreach (DataRow dr in oDS.Tables[0].Rows) { if (dr["NatureOfIncident"] != null) { mystring += dr["NatureOfIncident"] + ", ".ToString(); } } if (mystring.IndexOf(',') > 0) { mystring = mystring.Substring(0, mystring.Length - 2); } lblNature.Text = mystring; string myAction = string.Empty; foreach (DataRow dr in oDS.Tables[1].Rows) { if (dr["Suggestion"] != null) { myAction += dr["Suggestion"] + ", ".ToString(); } } if (myAction.IndexOf(',') > 0) { myAction = myAction.Substring(0, myAction.Length - 2); } lblSuggestion.Text = myAction; lblDateTime.Text = oDS.Tables[2].Rows[0]["IncidentDate"].ToString(); lblIncidentDesc.Text = oDS.Tables[2].Rows[0]["IncidentDescription"].ToString(); lblInjuryDesc.Text = oDS.Tables[2].Rows[0]["InjuryDescription"].ToString(); lblTypeTeatment.Text = oDS.Tables[2].Rows[0]["TreatmentLocation"].ToString(); lblAction.Text = oDS.Tables[2].Rows[0]["ActionDescription"].ToString(); lblAddtional.Text = oDS.Tables[2].Rows[0]["AdditionalInfo"].ToString(); lblReference.Text = oDS.Tables[2].Rows[0]["RefNumber"].ToString(); string myfactors = string.Empty; foreach (DataRow dr in oDS.Tables[4].Rows) { if (dr["IncidentInvestigation"] != null) { myfactors += dr["IncidentInvestigation"] + ", ".ToString(); } } if (myfactors.IndexOf(',') > 0) { myfactors = myfactors.Substring(0, myfactors.Length - 2); } lblFactors.Text = myfactors; /* -- Action Taken to prevent * string myprevent = string.Empty; * foreach (DataRow dr in oDS.Tables[3].Rows) * if (dr["ActionDescription"] != null) * myprevent += dr["ActionDescription"] + ", ".ToString(); * if (myprevent.IndexOf(',') > 0) * myprevent = myprevent.Substring(0, myprevent.Length - 2); * lblToPrevent.Text = myprevent; * */ // -- Display Status in Lable slblStatus = oDS.Tables[2].Rows[0]["Incident_Status"].ToString(); if (slblStatus == "PE") { lblStatus.Text = "Pending"; } else if (slblStatus == "IP") { lblStatus.Text = "In Progress"; } else if (slblStatus == "EV") { lblStatus.Text = "Escalate to VDQ"; } else if (slblStatus == "CL") { lblStatus.Text = "Closed"; } else if (slblStatus == "RP") { lblStatus.Text = "RMO Pending"; } sLocation = oDS.Tables[2].Rows[0]["UnitName"].ToString(); if (sLocation == "Other") { lblLocation.Text = oDS.Tables[2].Rows[0]["OtherLocation"].ToString(); } else { if (oDS.Tables[2].Rows[0]["UnitName"] != null) { lblLocation.Text = oDS.Tables[2].Rows[0]["UnitName"].ToString(); } } string sInjured = oDS.Tables[2].Rows[0]["PersonInjured"].ToString(); if (sInjured == "Y") { lblPersonInjured.Text = "Yes"; } else { lblPersonInjured.Text = "NO"; } string sProvided = oDS.Tables[2].Rows[0]["TreatmentProvided"].ToString(); if (sInjured == "Y") { lblTreatmentProvided.Text = "Yes"; } else { lblTreatmentProvided.Text = "NO"; } } } catch (Exception ex) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; } }
private void LoadAllData() { try { oDS = AdoUDIRS.GetAllInformation(IncidentID); if (AdoUDIRS.BlnError) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; return; } else if (oDS.Tables.Count == 0) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; return; } else if (oDS.Tables.Count > 0) { string mystring = string.Empty; foreach (DataRow dr in oDS.Tables[0].Rows) { if (dr["NatureOfIncident"] != null) { mystring += dr["NatureOfIncident"] + ", ".ToString(); } } if (mystring.IndexOf(',') > 0) { mystring = mystring.Substring(0, mystring.Length - 2); } lblNature.Text = mystring; string myAction = string.Empty; foreach (DataRow dr in oDS.Tables[1].Rows) { if (dr["Suggestion"] != null) { myAction += dr["Suggestion"] + ", ".ToString(); } } if (myAction.IndexOf(',') > 0) { myAction = myAction.Substring(0, myAction.Length - 2); } lblSuggestion.Text = myAction; lblName.Text = oDS.Tables[2].Rows[0]["Fullname"].ToString(); lblContact.Text = oDS.Tables[2].Rows[0]["Mobile"].ToString(); lblEmail.Text = oDS.Tables[2].Rows[0]["WorkEmail"].ToString(); lblDateTime.Text = oDS.Tables[2].Rows[0]["IncidentDate"].ToString(); lblIncidentDesc.Text = oDS.Tables[2].Rows[0]["IncidentDescription"].ToString(); lblInjuryDesc.Text = oDS.Tables[2].Rows[0]["InjuryDescription"].ToString(); lblTypeTeatment.Text = oDS.Tables[2].Rows[0]["TreatmentLocation"].ToString(); lblAction.Text = oDS.Tables[2].Rows[0]["ActionDescription"].ToString(); lblAddtional.Text = oDS.Tables[2].Rows[0]["AdditionalInfo"].ToString(); lblReference.Text = oDS.Tables[2].Rows[0]["RefNumber"].ToString(); //lblPersonInjured.Text = oDS.Tables[2].Rows[0]["PersonInjured"].ToString(); if (ddlStatus.Items.FindByValue(oDS.Tables[2].Rows[0]["Incident_Status"].ToString()) != null) { ddlStatus.SelectedValue = oDS.Tables[2].Rows[0]["Incident_Status"].ToString(); PreviousIncidentStatus = ddlStatus.SelectedValue; } if (oDS.Tables[2].Rows[0]["Comments"] != null && oDS.Tables[2].Rows[0]["Comments"].ToString() != string.Empty) { PreviousIncidentComment = oDS.Tables[2].Rows[0]["Comments"].ToString(); } // ____________________________________ Working Retrieve Checkboxlist _____________________________________________ if (oDS.Tables[4].Rows.Count > 0) { BindRMOCheckboxlist(); DisableCheckBoxList(); } // ____________________________________ Working Retrieve Checkboxlist _____________________________________________ if (oDS.Tables[3].Rows.Count > 0) { BindActionPlan(oDS.Tables[3]); } else { SetInitialRow(); } sLocation = oDS.Tables[2].Rows[0]["UnitName"].ToString(); if (sLocation == "Other") { lblLocation.Text = oDS.Tables[2].Rows[0]["OtherLocation"].ToString(); } else { if (oDS.Tables[2].Rows[0]["UnitName"] != null) { lblLocation.Text = oDS.Tables[2].Rows[0]["UnitName"].ToString(); } } string sInjured = oDS.Tables[2].Rows[0]["PersonInjured"].ToString(); if (sInjured == "Y") { lblPersonInjured.Text = "Yes"; } else { lblPersonInjured.Text = "NO"; } string sProvided = oDS.Tables[2].Rows[0]["TreatmentProvided"].ToString(); if (sInjured == "Y") { lblTreatmentProvided.Text = "Yes"; } else { lblTreatmentProvided.Text = "NO"; } } } catch (Exception ex) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; } }