public void Load_mlc()
{
wizard1.SelectedTab = tabPage2;
IniFile ini = new IniFile(ClassSql.MMS_Path);
R_Seabase_MLC R_Seabase_MLC1 = new R_Seabase_MLC();
DataClasses1DataContext db = new DataClasses1DataContext(Properties.Settings.Default.MyConString);
DataTable dt = new ds_report2.sp_Seabase_MLCDataTable();
var list = db.sp_Seabase_MLC(this.Tag.ToString()).ToList();
foreach (var i in list)
{
dt.Rows.Add(i.lastname, i.firstname, i.middlename, i.address_1, i.position, i.marital_status, i.gender, i.birthdate, i.place_of_birth, i.employer, i.passport_no, i.nationality, i.religion, i.sirb, i.designation, i.picture.ToArray(), i.result_date, i.pathologist, i.fitness_date, i.valid_until, i.recommendation, i.medtech, i.medtech_license, i.restriction, i.ISHIHARA_C, i.SATISFACTORY_HEARING, i.SATISFACTORY_SIGHT_UNAID, i.VISUAL_AIDS, i.FIT_FOR_LOOKOUT, i.VISUAL_AIDS_REQUIRED, i.UNAIDED_HEARING_SATISFACTORY, i.IDENTITY_CONFIRMED, i.VISUAL_AIDS_WORN);
}
R_Seabase_MLC1.SetDataSource(dt);
TextObject FormNo = (TextObject)R_Seabase_MLC1.ReportDefinition.ReportObjects["txt_formNo"];
TextObject RevNo = (TextObject)R_Seabase_MLC1.ReportDefinition.ReportObjects["txt_RevNo"];
TextObject Iso = (TextObject)R_Seabase_MLC1.ReportDefinition.ReportObjects["txt_iso"];
TextObject TxtMedicalNumber = (TextObject)R_Seabase_MLC1.ReportDefinition.ReportObjects["txt_medicalNumber"];
FormNo.Text = ini.IniReadValue("FORM", "Seafarer_MLC");
RevNo.Text = ini.IniReadValue("REVISION", "Seafarer_MLC");
Iso.Text = ini.IniReadValue("ISO", "Seafarer_MLC");
TxtMedicalNumber.Text = "Medical Certification Number: " + MedCertNumber;
Viewer2.ReportSource = R_Seabase_MLC1;
RemoveTab(Viewer2);
}
void load_krpan()
{
try
{
wizard1.SelectedTab = tabPage2;
// tabControl1.SelectedTab = tabPage6;
IniFile ini = new IniFile(ClassSql.MMS_Path);
kpan kpan_rpeort = new kpan();
DataClasses1DataContext db = new DataClasses1DataContext(Properties.Settings.Default.MyConString);
DataClasses2DataContext db2 = new DataClasses2DataContext(Properties.Settings.Default.MyConString);
DataTable dt = new ds_report2.sp_Seabase_MLCDataTable();
var list = db.sp_Seabase_MLC(this.Tag.ToString()).ToList();
foreach (var i in list)
{
dt.Rows.Add(i.lastname, i.firstname, i.middlename, i.address_1, i.position, i.marital_status, i.gender, i.birthdate, i.place_of_birth, i.employer, i.passport_no, i.nationality, i.religion, i.sirb, i.designation, i.picture.ToArray(), i.result_date, i.pathologist, i.fitness_date, i.valid_until, i.recommendation, i.medtech, i.medtech_license, i.restriction, i.ISHIHARA_C, i.SATISFACTORY_HEARING, i.SATISFACTORY_SIGHT_UNAID, i.VISUAL_AIDS, i.FIT_FOR_LOOKOUT, i.VISUAL_AIDS_REQUIRED, i.UNAIDED_HEARING_SATISFACTORY, i.IDENTITY_CONFIRMED, i.VISUAL_AIDS_WORN);
}
var d = db.sp_Seabase_Deatail(this.Tag.ToString()).FirstOrDefault();
var k = db2.sp_krpan_report(this.Tag.ToString()).FirstOrDefault();
kpan_rpeort.SetDataSource(dt);
kpan_rpeort.SetParameterValue("recomendation", recomendation);
kpan_rpeort.SetParameterValue("Height", d.HEIGHT);
kpan_rpeort.SetParameterValue("Weight", d.WEIGHT);
string HEARING_LEFT = "";
if (d.HEARING_LEFT == "A")
{
HEARING_LEFT = "Adequate";
}
else
{
HEARING_LEFT = "Indequate";
}
string HEARING_RIGHT = "";
if (d.HEARING_RIGHT == "A")
{
HEARING_RIGHT = "Adequate";
}
else
{
HEARING_RIGHT = "Indequate";
}
kpan_rpeort.SetParameterValue("Hearing", "LT: " + HEARING_LEFT + " RT: " + HEARING_RIGHT);
kpan_rpeort.SetParameterValue("ColourVision", d.ISHIHARA_C);
string blood_disorders = "";
if (d.blood_disorders == "N")
{
blood_disorders = "No";
}
else
{
blood_disorders = "Yes";
}
kpan_rpeort.SetParameterValue("BloodDisoprder", blood_disorders);
kpan_rpeort.SetParameterValue("Mantaldisorders", k.MentalDisorder);
kpan_rpeort.SetParameterValue("CardiovascularSystem", k.Cardiovascular);
kpan_rpeort.SetParameterValue("Geni", d.GU_SYSTEM);
string diabetes_mellitus = "";
if (d.diabetes_mellitus == "N")
{
diabetes_mellitus = "No";
}
else
{
diabetes_mellitus = "Yes";
}
kpan_rpeort.SetParameterValue("Diabetes", diabetes_mellitus);
kpan_rpeort.SetParameterValue("Respiratoty", d.cxr);
kpan_rpeort.SetParameterValue("Bp", d.BP);
kpan_rpeort.SetParameterValue("BpType", d.blood_type);
kpan_rpeort.SetParameterValue("VisualAcuty", d.VISUAL_AIDS);
kpan_rpeort.SetParameterValue("CircumferenceChest", d.CHEST_BREAST_AXILLA);
kpan_rpeort.SetParameterValue("Infections", k.Infection);
kpan_rpeort.SetParameterValue("SkinDisorder", d.SKIN);
kpan_rpeort.SetParameterValue("NervousSystem", k.NervousSystem);
kpan_rpeort.SetParameterValue("DigestiveSystem", k.Digestive);
kpan_rpeort.SetParameterValue("Liver", k.Liver);
kpan_rpeort.SetParameterValue("Anemia", k.Anemia);
kpan_rpeort.SetParameterValue("UrineandSyphilis", k.UrineSyphilisis);
Viewer2.ReportSource = kpan_rpeort;
RemoveTab(Viewer2);
}
catch (Exception ex)
{
MessageBox.Show("Report not available", "No Report", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
