protected void PopulateCorrectiveAction() { try { oDV = AdoUDIRS.GetCorrectiveAction(); if (AdoUDIRS.BlnError) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; return; } else if (oDV.Count == 0) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; return; } else if (oDV.Count > 0) { chkCorrectiveAction.DataSource = oDV; chkCorrectiveAction.DataValueField = "Id"; chkCorrectiveAction.DataTextField = "Title"; chkCorrectiveAction.DataBind(); } } catch (Exception ex) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; } }
private void BindGridview(string refNumber, string incidentStatus, string isAnyPersonInjured, string isTreatmentProvided, string fromDate, string toDate, int personID) { try { oDV = AdoUDIRS.GET_InvestigationHistory_Search(refNumber, incidentStatus, isAnyPersonInjured, isTreatmentProvided, fromDate, toDate, personID); if (AdoUDIRS.BlnError) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; return; } else if (oDV.Count == 0) { lblMsg.Text = "No incident found."; lblMsg.Attributes.Add("style", "font-size:40px; color:Red; font-weight:bold;"); gvVDQHistory.DataSource = null; gvVDQHistory.DataBind(); return; } else if (oDV.Count > 0) { gvVDQHistory.DataSource = oDV; gvVDQHistory.DataBind(); lblMsg.Text = ""; } } catch (Exception ex) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; } }
protected void PopulateTreatmentLocation() { try { oDV = AdoUDIRS.GetTreatmentLocation(); if (AdoUDIRS.BlnError) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; return; } else if (oDV.Count == 0) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; return; } else if (oDV.Count > 0) { rblTreatmentPlace.DataSource = oDV; rblTreatmentPlace.DataValueField = "Id"; rblTreatmentPlace.DataTextField = "Title"; rblTreatmentPlace.DataBind(); } } catch (Exception ex) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; } }
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(); }
protected void PopulateLocation() { try { oDV = AdoUDIRS.GetIncidentLocation(); if (AdoUDIRS.BlnError) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; return; } else if (oDV.Count == 0) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; return; } else if (oDV.Count > 0) { ddlLocation.DataSource = oDV; ddlLocation.DataValueField = "Id"; ddlLocation.DataTextField = "Longname"; ddlLocation.DataBind(); ddlLocation.Items.Insert(0, new ListItem("--Select--", "-1")); } } catch (Exception ex) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; } }
protected void PopulateOthers() { try { oDV = AdoUDIRS.GetOthersIncident(); if (AdoUDIRS.BlnError) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; return; } else if (oDV.Count == 0) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; return; } else if (oDV.Count > 0) { //cbOthers.Text = oDV[0].Row["Title"].ToString(); chkOthers.DataSource = oDV; chkOthers.DataValueField = "Id"; chkOthers.DataTextField = "Title"; chkOthers.DataBind(); } } catch (Exception ex) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string personRoleID = string.Empty; if (Request.QueryString["vid"] != null) { if (Request.QueryString["vid"].ToString() != string.Empty) { personRoleID = Cryptography.Decrypt(Request.QueryString["vid"].ToString(), "sblw-3hn8-sqoy19"); DataView dv = AdoUDIRS.ActivatePersonRole(personRoleID); if (dv[0]["StatusMsg"] != null) { if (dv[0]["StatusMsg"].ToString() == "UpdatedSuccessfully") { // User activated successfully, Please click here to login. } else { //Failed to activate the user } } } } } }
protected void InsertInvestigation() { //string strIncidentID = "1"; string strPersonID = string.Empty; try { if (UDIRSHelper.PersonDetails != null) { strPersonID = UDIRSHelper.PersonDetails.Id.ToString(); } else { //redirect to login } BuildIncidentInvestigation(); if (PreviousIncidentStatus == ddlStatus.SelectedValue && txtComments.Text == string.Empty && PreviousIncidentComment != string.Empty) { txtComments.Text = PreviousIncidentComment; } // @PersonID , @IncidentID, @IncidentSubInvestigationCausesIDs, @OtherInvestigation, @IncidentStatus, @Comments) oDV = AdoUDIRS.InvestigationData(strPersonID, IncidentID, sbInvestigationSubCategoryIDs.ToString(), txtOthers.Text.Trim(), ddlStatus.SelectedValue, txtComments.Text.Trim()); // string RefId = oDV.ToTable().Rows[0]["IncidentID"].ToString(); if (oDV == null) { Label lbl = (Label)Page.Master.FindControl("lblMessage"); Message.Failure("Failed to save incident data.", lbl); ///// Pass label saleem return; } else { DataTable dt = oDV.ToTable(); //RefId = oDV.Table.Rows[0]["IncidentID"].ToString(); //Session["IncidentID"] = RefId; Label lbl = (Label)Page.Master.FindControl("lblMessage"); //--Response.Redirect("~/Web/ThankYou.aspx", true); //Message.Success("Incident data saved Successfullyssssssssssss", lbl); ///// Pass label saleem } if (AdoUDIRS.BlnError) { } else if (oDV.Count == 0) { } else if (oDV.Count > 0) { //RefId = oDV.ToTable().Rows[0]["IncidentID"].ToString(); //Session["PersonID"] = RefId; } } catch (Exception ex) { Label lbl = (Label)Page.Master.FindControl("lblMessage"); Message.Failure("Error 221, sorry, an error occured, " + AdoUDIRS.StrError, lbl); ///// Pass label saleem //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; } }
private void InsertActionPlan() { StringBuilder sb = new StringBuilder(); string str = string.Empty; Label lbl = null; TextBox txt1 = null; TextBox txt2 = null; DropDownList ddl = null; foreach (GridViewRow row in gvActionPlan.Rows) { lbl = (Label)row.Cells[0].FindControl("lblID"); txt1 = (TextBox)row.Cells[0].FindControl("txtAction"); txt2 = (TextBox)row.Cells[0].FindControl("txtDeadline"); ddl = (DropDownList)row.Cells[0].FindControl("ddlCompleted"); if (lbl != null && txt1 != null && txt2 != null && ddl != null) { if (lbl.Text != string.Empty || txt1.Text != string.Empty || txt2.Text != string.Empty || ddl.SelectedValue != "-1") { sb.Append(lbl.Text + "|$|"); sb.Append(txt1.Text + "|$|"); sb.Append(txt2.Text + "|$|"); sb.Append(ddl.SelectedValue + "|#|"); } } } str = sb.ToString(); if (str.LastIndexOf("|#|") > -1) { str = str.Substring(0, str.Length - 3); } if (str != string.Empty) { oDV = AdoUDIRS.DoActionPlan(IncidentID, str.ToString(), "|#|", "|$|"); } Response.Redirect("~/Web/ThankYou.aspx", true); /* * * using (SqlConnection connection = new SqlConnection(GetConnectionString())) * { * connection.Open(); * using (SqlCommand cmd = new SqlCommand(sb.ToString(), connection)) * { * cmd.CommandType = CommandType.Text; * cmd.ExecuteNonQuery(); * } * } * lblMessage.Text = "Records successfully saved!"; */ }
protected void InsertIncident(string fileName) { try { BuildNatureIncident(); BuildCorrectiveAction(); string strRoleID = string.Empty, strPersonID = string.Empty; strRoleID = UDIRSHelper.PersonRoleDetails.Where(p => p.Shortname == "USE" || p.Shortname == "Other").Select(s => s.RolesID).Single().ToString(); strPersonID = UDIRSHelper.PersonDetails.Id.ToString(); String combinedDateTime; //string selectedval = HiddenField1.Value; combinedDateTime = txtDate.Text + " " + ddlHours.Text + ":" + ddlMinutes.Text; oDV = AdoUDIRS.IncidentData(strRoleID, ddlLocation.SelectedValue, rblTreatmentPlace.SelectedValue, combinedDateTime, txtOtherlocation.Text.Trim(), txtIncidentDesc.Text.Trim(), rblInjured.SelectedValue, txtInjuryDesc.Text.Trim(), rblTreatmentProvided.SelectedValue, txtCorrectiveActionDesc.Text.Trim(), txtAdditionalInformationDesc.Text.Trim(), fileName, sbIncidentSubCategoryIDs.ToString(), txtOthers.Text.Trim(), strCorActionIDs, strPersonID, "PE", strHistorycomments); if (oDV == null) { Label lbl = (Label)Page.Master.FindControl("lblMessage"); Message.Failure("Failed to save incident data.", lbl); ///// Pass label saleem return; } else { DataTable dt = oDV.ToTable(); //RefId = oDV.Table.Rows[0]["IncidentID"].ToString(); //Session["IncidentID"] = RefId; Label lbl = (Label)Page.Master.FindControl("lblMessage"); Response.Redirect("~/Web/ThankYou.aspx", true); //Message.Success("Incident data saved Successfullyssssssssssss", lbl); ///// Pass label saleem } if (AdoUDIRS.BlnError) { } else if (oDV.Count == 0) { } else if (oDV.Count > 0) { //RefId = oDV.ToTable().Rows[0]["IncidentID"].ToString(); //Session["PersonID"] = RefId; } } catch (Exception ex) { Label lbl = (Label)Page.Master.FindControl("lblMessage"); Message.Failure("Error 221, sorry, an error occured, " + AdoUDIRS.StrError, lbl); ///// Pass label saleem //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; } }
protected void BindGridview() { /* * SqlConnection con = new SqlConnection("Data Source=SureshDasari;Integrated Security=true;Initial Catalog=MySampleDB"); * con.Open(); * SqlCommand cmd = new SqlCommand("select * from UserDetails", con); * * SqlDataAdapter da = new SqlDataAdapter(cmd); * con.Close(); * DataSet ds = new DataSet(); * da.Fill(ds); * gvHistory.DataSource = ds; * gvHistory.DataBind(); */ try { if (UDIRSHelper.PersonDetails != null) { oDV = AdoUDIRS.GET_IncidentsForPerson(UDIRSHelper.PersonDetails.Id.ToString()); } else { //redirect to logon page } if (AdoUDIRS.BlnError) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; return; } else if (oDV.Count == 0) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; lblMsg.Text = "No Incident Reported."; lblMsg.Attributes.Add("style", "font-size:40px; color:Red; font-weight:bold;"); return; } else if (oDV.Count > 0) { gvHistory.DataSource = oDV; gvHistory.DataBind(); } } catch (Exception ex) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; } }
protected void btnSubmit_Click(object sender, EventArgs e) { string Email = txtEmailID.Text.ToLower().Trim(); if ((Email.Contains("@iau.edu.sa") || Email.EndsWith("@uod.edu.sa"))) { lblRMsg.Attributes.CssStyle.Add("float", "right"); lblRMsg.Text = "Sorry! University Email address can not be used."; lblRMsg.ForeColor = System.Drawing.Color.Red; } else { DataView oDV = new DataView(); oDV = AdoUDIRS.Registration(txtEmailID.Text.Trim(), txtRpwd.Text.Trim(), txtFirstname.Text.Trim(), txtLastname.Text.Trim(), txtContact.Text.Trim(), rdoGender.SelectedItem.Value); if (AdoUDIRS.BlnError) { lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; } else { if (oDV.Table.Rows.Count > 0) { if (oDV[0].Row["PersonRoleID"] != null) { if (oDV[0].Row["PersonRoleID"].ToString() == "0") { Label lbl = (Label)Page.Master.FindControl("lblMessage"); Message.Success("User Already exist", lbl);//User Already exist } else { SendEmail(oDV[0].Row["PersonRoleID"].ToString()); } } } else { Label lbl = (Label)Page.Master.FindControl("lblMessage"); Message.Success("Try again after some time.", lbl);// try again after some time. } } } }
protected void Page_Load(object sender, EventArgs e) { oDV = AdoUDIRS.GetHealthSafety(); string fruits = ""; for (int i = 0; i < oDV.Count; i++) { } //oDV = AdoUDIRS.Regist("Visitor", "*****@*****.**", "j789rt", "Saleem", "Abdul", "23326666", // "05341039", "*****@*****.**", "Male", ""); if (AdoUDIRS.BlnError) { lblMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; } // Sub_cat.Text = oDV[0]["Title"].ToString(); }
protected void LoadSession() { try { //oDV = AdoUDIRS.GetIncidentHistory(); oDV = AdoUDIRS.GetReferenceNumber(); if (AdoUDIRS.BlnError) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; return; } else if (oDV.Count == 0) { return; } else if (oDV.Count > 0) { string sValue = oDV.ToTable().Rows[0]["RefNumber"].ToString(); lblRefID.Text = sValue; } } catch (Exception ex) { //lblRMsg.Text = "Error 40, sorry, an error occured, " + AdoUDIRS.StrError; } if (UDIRSHelper.PersonDetails != null) { if (UDIRSHelper.PersonDetails.Fullname != null) { lblName.Text = UDIRSHelper.PersonDetails.Fullname; } } else { //redirect to home or logout } //lblRefID.Text = ReferenceId; }
private bool DeleteActionPlanByID(string actionPlanID) { oDV = AdoUDIRS.DeleteActionPlanByID(actionPlanID); if (oDV == null) { Label lbl = (Label)Page.Master.FindControl("lblMessage"); Message.Failure("Failed to delete action plan data.", lbl); ///// Pass label saleem return(false); } else { DataTable dt = oDV.ToTable(); //RefId = oDV.Table.Rows[0]["IncidentID"].ToString(); //Session["IncidentID"] = RefId; Label lbl = (Label)Page.Master.FindControl("lblMessage"); //--Response.Redirect("~/Web/ThankYou.aspx", true); Message.Success("Action plan deleted successfully.", lbl); ///// Pass label saleem return(true); } }
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; } }
protected void Page_Load(object sender, EventArgs e) { oDV = AdoUDIRS.GetHealthSafety(); }
protected void btnLogIn_Click(object sender, EventArgs e) { try { UserName = txtUserName.Text.ToLower().Trim(); Password = txtPassword.Text.Trim(); if (UserName.Contains("@iau.edu.sa") || UserName.Contains("@uod.edu.sa") || !UserName.Contains('@')) { #region Active Directory Login if (IsUserExist()) { string FullName = string.Empty, Email = string.Empty, Phone = string.Empty, Mobile = string.Empty, NationalID = string.Empty; nsWebServices.GetUser[] oArray; oArray = GetUserDetails(); if (oArray != null) { if (oArray[0].ID != null && oArray[0].ID != string.Empty) { #region Person details from webservice NationalID = oArray[0].ID; if (oArray[0].FullName != null) { FullName = oArray[0].FullName; } if (oArray[0].Email != null) { Email = oArray[0].Email; } if (oArray[0].Phone != null) { Phone = oArray[0].Phone; } if (oArray[0].Mobile != null) { Mobile = oArray[0].Mobile; } #endregion DataSet dSet = new DataSet(); dSet = AdoUDIRS.AddUpdateUserDetailsByNationalID(NationalID, FullName, Email, Phone, Mobile); if (dSet != null) { if (dSet.Tables[0] != null) { if (dSet.Tables[0].Rows.Count > 0) { SetPersonDetails(dSet.Tables[0]); } else { Label lbl = (Label)Page.Master.FindControl("lblMessage"); Message.Success("PersonRoles does not exist/Database error", lbl);//Person does not exist/Database error } #region Set PersonRoleDetails Entity if (dSet.Tables[1] != null) { if (dSet.Tables[1].Rows.Count > 0) { SetPersonRoleDetails(dSet.Tables[1]); Response.Redirect("~/Web/Home.aspx", true); } } else { Label lbl = (Label)Page.Master.FindControl("lblMessage"); Message.Failure("PersonRoles does not exist/Database error", lbl); ///// Pass label saleem//PersonRoles does not exist/Database error } #endregion } else { Label lbl = (Label)Page.Master.FindControl("lblMessage"); Message.Failure("PersonRoles does not exist/Database error", lbl);//Person does not exist/Database error } } else { Label lbl = (Label)Page.Master.FindControl("lblMessage"); Message.Failure("PersonRoles does not exist/Database error", lbl);//Person does not exist/Database error } } else { Label lbl = (Label)Page.Master.FindControl("lblMessage"); Message.Failure("Your NationalID not found, Please contact [email protected] or 31111.", lbl);//Message: Your NationalID not found, Please contact [email protected] or 31111. } } else { Label lbl = (Label)Page.Master.FindControl("lblMessage"); Message.Failure("Server not responding, Please try after some time.", lbl);//Message: Server not responding, Please try after some time. } } else { Label lbl = (Label)Page.Master.FindControl("lblMessage"); Message.Failure("Incorrect login credentials", lbl);//Message: incorrect login credentials } #endregion } else { #region Other Login DataSet dSet = new DataSet(); dSet = AdoUDIRS.CheckAndGetDataForOthersLogin(UserName); if (dSet != null) { if (dSet.Tables[0] != null) { if (dSet.Tables[0].Rows.Count > 0) { SetPersonDetails(dSet.Tables[0]); } else { return; //Person does not exist/Database error } #region Set PersonRoleDetails Entity if (dSet.Tables[1] != null) { if (dSet.Tables[1].Rows.Count > 0) { SetPersonRoleDetails(dSet.Tables[1]); Response.Redirect("~/Web/Home.aspx", true); } } else { Label lbl = (Label)Page.Master.FindControl("lblMessage"); Message.Success("PersonRoles does not exist/Database error", lbl);//PersonRoles does not exist/Database error } #endregion } else { Label lbl = (Label)Page.Master.FindControl("lblMessage"); Message.Success("Incorrect Username/Password", lbl);//Incorrect Username/Password } } else { Label lbl = (Label)Page.Master.FindControl("lblMessage"); Message.Success("Incorrect Username/Password", lbl);//Incorrect Username/Password } #endregion } } catch (Exception ex) { } }
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; } }