private void ShowSupplierDetails()
{
try
{
TechnicalBAL objbal = new TechnicalBAL();
//DataTable dtSupplierData = objbal.GetSupplier_HSEQuestion(Request.QueryString["SupplierCode"].ToString()).Tables[0];
DataTable dtSupplierData = objbal.GetSupplier_HSEQuestion(Session["SupplierCode"].ToString(), Convert.ToInt16(Request.QueryString["HSEId"].ToString())).Tables[0];
txtCompanyName.Text = Convert.ToString(dtSupplierData.Rows[0]["Company_Name"]);
txtOperations.Text = Convert.ToString(dtSupplierData.Rows[0]["Company_Operations"]);
txtAddress.Text = Convert.ToString(dtSupplierData.Rows[0]["Company_Address"]);
txtCountry.Text = Convert.ToString(dtSupplierData.Rows[0]["Company_Country"]);
txtPhone.Text = Convert.ToString(dtSupplierData.Rows[0]["Company_Phone"]);
txtFax.Text = Convert.ToString(dtSupplierData.Rows[0]["Company_Fax"]);
txtEmail.Text = Convert.ToString(dtSupplierData.Rows[0]["Company_Email"]);
txtWebsiet.Text = Convert.ToString(dtSupplierData.Rows[0]["Company_WebSite"]);
txtPIC.Text = Convert.ToString(dtSupplierData.Rows[0]["Company_PIC"]);
txtEmergencyContactNo.Text = Convert.ToString(dtSupplierData.Rows[0]["Emergency_Contact_No"]);
txtSizeTurnover.Text = Convert.ToString(dtSupplierData.Rows[0]["Size_Turnover"]);
txtAgeOfBusiness.Text = Convert.ToString(dtSupplierData.Rows[0]["Age_Of_Business"]);
txtServicesProvided.Text = Convert.ToString(dtSupplierData.Rows[0]["Services_Provided"]);
ddlRegulatoryControl.Text = Convert.ToString(dtSupplierData.Rows[0]["Regulatory_Control"]);
txtRegulatoryControlRemarks.Text = Convert.ToString(dtSupplierData.Rows[0]["Regulatory_Control_Remarks"]);
txtCustomer1Name.Text = Convert.ToString(dtSupplierData.Rows[0]["Customer1_Name"]);
txtCustomer1Years.Text = Convert.ToString(dtSupplierData.Rows[0]["Customer1_Years"]);
txtServiceDescription1.Text = Convert.ToString(dtSupplierData.Rows[0]["Service_Description1"]);
txtCustomer2Name.Text = Convert.ToString(dtSupplierData.Rows[0]["Customer2_Name"]);
txtCustomer2Years.Text = Convert.ToString(dtSupplierData.Rows[0]["Customer2_Years"]);
txtServiceDescription2.Text = Convert.ToString(dtSupplierData.Rows[0]["Service_Description2"]);
txtCustomer3Name.Text = Convert.ToString(dtSupplierData.Rows[0]["Customer3_Name"]);
txtCustomer3Years.Text = Convert.ToString(dtSupplierData.Rows[0]["Customer3_Years"]);
txtServiceDescription3.Text = Convert.ToString(dtSupplierData.Rows[0]["Service_Description3"]);
txtHoursWorkedYTD.Text = Convert.ToString(dtSupplierData.Rows[0]["Hours_Worked_YTD"]);
txtHoursWorked2Yrs.Text = Convert.ToString(dtSupplierData.Rows[0]["Hours_Worked_2Yrs"]);
txtFatalInjuriesYTD.Text = Convert.ToString(dtSupplierData.Rows[0]["Fatal_injuries_YTD"]);
txtFatalInjuries2Yrs.Text = Convert.ToString(dtSupplierData.Rows[0]["Fatal_Injuries_2Yrs"]);
txtLostDayInjuriesYTD.Text = Convert.ToString(dtSupplierData.Rows[0]["LostDay_Injuries_YTD"]);
txtLostDayInjuries2Yrs.Text = Convert.ToString(dtSupplierData.Rows[0]["LostDay_Injuries_2Yrs"]);
txtIncidenceRateYTD.Text = Convert.ToString(dtSupplierData.Rows[0]["Incidence_Rate_YTD"]);
txtIncidenceRate2Yrs.Text = Convert.ToString(dtSupplierData.Rows[0]["Incidence_Rate_2Yrs"]);
txtGovernmentInsp3Yrs.Text = Convert.ToString(dtSupplierData.Rows[0]["Government_Insp_3Yrs"]);
txtSignificantIncidents3Yrs.Text = Convert.ToString(dtSupplierData.Rows[0]["Significant_Incidents_3Yrs"]);
ddlInsuranceIndemity.Text = Convert.ToString(dtSupplierData.Rows[0]["Insurance_Indemity"]);
txtInsuranceIndemityRemarks.Text = Convert.ToString(dtSupplierData.Rows[0]["Insurance_Indemity_Remarks"]);
ddlQualityAssurance.Text = Convert.ToString(dtSupplierData.Rows[0]["Quality_Assurance"]);
txtQualityAssuranceRemarks.Text = Convert.ToString(dtSupplierData.Rows[0]["Quality_Assurance_Remarks"]);
ddlTrainingNewEmployees.Text = Convert.ToString(dtSupplierData.Rows[0]["Training_New_Employees"]);
txtTrainingNewEmployeesRemarks.Text = Convert.ToString(dtSupplierData.Rows[0]["Training_New_Employees_Remarks"]);
ddlTrainingExisitingEmployees.Text = Convert.ToString(dtSupplierData.Rows[0]["Training_Exisiting_Employees"]);
txtTrainingExisitingEmployeesRemarks.Text = Convert.ToString(dtSupplierData.Rows[0]["Training_Exisiting_Employees_Remarks"]);
txtClientList.Text = Convert.ToString(dtSupplierData.Rows[0]["Client_List"]);
ddlIncidentReporting.Text = Convert.ToString(dtSupplierData.Rows[0]["Incident_Reporting"]);
txtIncidentReportingRemarks.Text = Convert.ToString(dtSupplierData.Rows[0]["Incident_Reporting_Remarks"]);
ddlNearMissReporting.Text = Convert.ToString(dtSupplierData.Rows[0]["Near_Miss_Reporting"]);
txtNearMissReportingRemarks.Text = Convert.ToString(dtSupplierData.Rows[0]["Near_Miss_Reporting_Remarks"]);
ddlSafetyEquipment.Text = Convert.ToString(dtSupplierData.Rows[0]["Safety_Equipment"]);
txtSafetyEquipmentRemarks.Text = Convert.ToString(dtSupplierData.Rows[0]["Safety_Equipment_Remarks"]);
ddlEmployeeEquipTraining.Text = Convert.ToString(dtSupplierData.Rows[0]["Employee_Equip_Training"]);
txtEmployeeEquipTrainingRemarks.Text = Convert.ToString(dtSupplierData.Rows[0]["Employee_Equip_Training_Remarks"]);
ddlContractorEquipTraining.Text = Convert.ToString(dtSupplierData.Rows[0]["Contractor_Equip_Training"]);
txtContractorEquipTrainingRemark.Text = Convert.ToString(dtSupplierData.Rows[0]["Contractor_Equip_Training_Remarks"]);
ddlCleanWorkingEnvironment.Text = Convert.ToString(dtSupplierData.Rows[0]["Clean_Working_Environment"]);
txtCleanWorkingEnvironmentRemarks.Text = Convert.ToString(dtSupplierData.Rows[0]["Clean_Working_Environment_Remarks"]);
ddlEquipmentCalibration.Text = Convert.ToString(dtSupplierData.Rows[0]["Equipment_Calibration"]);
txtEquipmentCalibrationRemarks.Text = Convert.ToString(dtSupplierData.Rows[0]["Equipment_Calibration_Remarks"]);
ddlCalibrationCertificates.Text = Convert.ToString(dtSupplierData.Rows[0]["Calibration_Certificates"]);
txtCalibrationCertificatesRemarks.Text = Convert.ToString(dtSupplierData.Rows[0]["Calibration_Certificates_Remarks"]);
ddlClientFamiliarizationvisits.Text = Convert.ToString(dtSupplierData.Rows[0]["Client_Familiarization_visits"]);
txtClientFamiliarizationVisitsRemarks.Text = Convert.ToString(dtSupplierData.Rows[0]["Calibration_Certificates_Remarks"]);
ddlMeetStandardRequirements.Text = Convert.ToString(dtSupplierData.Rows[0]["Meet_Standard_Requirements"]);
txtMeetStandardRequirementsRemarks.Text = Convert.ToString(dtSupplierData.Rows[0]["Meet_Standard_Requirements_Remarks"]);
txtHSEQSubmittedDate.Text = Convert.ToDateTime(dtSupplierData.Rows[0]["HSEQ_Submitted_Date"]).ToString("dd-MM-yyyy");
txtHSEQSubmittedBy.Text = Convert.ToString(dtSupplierData.Rows[0]["HSEQ_Submitted_By"]);
ddlESMCompetitiveQuote.Text = Convert.ToString(dtSupplierData.Rows[0]["ESM_Competitive_Quote"]);
txtESMCompetitiveQuoteRemarks.Text = Convert.ToString(dtSupplierData.Rows[0]["ESM_Competitive_Quote_Remarks"]);
ddlESMQuickResponsee.Text = Convert.ToString(dtSupplierData.Rows[0]["ESM_Quick_Response"]);
txtESMQuickResponseRemarks.Text = Convert.ToString(dtSupplierData.Rows[0]["ESM_Quick_Response_Remarks"]);
ddlESMOntimeDelivery.Text = Convert.ToString(dtSupplierData.Rows[0]["ESM_Ontime_Delivery"]);
txtESMOntimeDeliveryRemarks.Text = Convert.ToString(dtSupplierData.Rows[0]["ESM_Ontime_Delivery_Remarks"]);
ddlESMPromptAdvice.Text = Convert.ToString(dtSupplierData.Rows[0]["ESM_Prompt_Advice"]);
txtESMPromptAdviceRemarks.Text = Convert.ToString(dtSupplierData.Rows[0]["ESM_Prompt_Advice_Remarks"]);
lblDateOfCreation.Text = Convert.ToDateTime(dtSupplierData.Rows[0]["Date_Of_Creatation"]).ToString("dd-MMM-yyyy");
}
catch (Exception ex)
{
//.WriteError(this.GetType().Name.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name.ToString(), ex);
}
}