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;
}
}