public string[] SearchStudentAidsUseBaseCount(SearchAidsUse SearchData)
{
Audiometry aDB = new Audiometry();
if (int.Parse(aDB._StaffhaveRoles[3]) == 1)
{
return aDB.SearchStudentAidsUseCount(SearchData);
}
else
{
return new string[2] { _noRole, _errorMsg };
}
}
public CreateHearingAssessment getHearingAssessmentDataBase(string sID)
{
Audiometry aDB = new Audiometry();
CreateHearingAssessment returnValue = new CreateHearingAssessment();
if (int.Parse(aDB._StaffhaveRoles[3]) == 1)
{
returnValue = aDB.getHearingAssessmentData(sID);
}
else
{
returnValue.checkNo = _getcheckNo;
returnValue.errorMsg = _errorMsg;
}
StaffDataBase sDB = new StaffDataBase();
List<string> UserFile = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name);
if (returnValue.caseUnit != UserFile[2] && int.Parse(aDB._StaffhaveRoles[4]) == 0 && UserFile[1].Length > 0)
{
returnValue.checkNo = _getcheckNo;
returnValue.errorMsg = _errorMsg;
}
return returnValue;
}
public List<SearchAidsUseResult> SearchStudentAidsUseBase(int index, SearchAidsUse SearchData)
{
Audiometry aDB = new Audiometry();
return aDB.SearchStudentAidsUse(index, SearchData);
}
public string[] setStudentAidsUseData(CreateStudentAidsUse StudentData)
{
Audiometry aDB = new Audiometry();
if (int.Parse(aDB._StaffhaveRoles[1]) == 1)
{
return aDB.setStudentAidsUse(StudentData);
}
else
{
return new string[2] { _noRole, _errorMsg };
}
}
public string[] createServiceDataBase(createAidsManageService StructData)
{
Audiometry aDB = new Audiometry();
if (int.Parse(aDB._StaffhaveRoles[2]) == 1)
{
return aDB.createServiceData(StructData);
}
else
{
return new string[2] { _noRole, _errorMsg };
}
}
public string[] setAudiometryAppointmentContent(SaveAudiometryAppointmentContent AaSystemData)
{
Audiometry aDB = new Audiometry();
if (int.Parse(aDB._StaffhaveRoles[1]) == 1)
{
return aDB.setAudiometryAppointmentContent(AaSystemData);
}
else
{
return new string[2] { _noRole, _errorMsg };
}
}
public string[] setHearingTestDataBase(setHearingTests StructData)
{
Audiometry aDB = new Audiometry();
if (int.Parse(aDB._StaffhaveRoles[1]) == 1)
{
return aDB.setHearingTestData(StructData);
}
else
{
return new string[2] { _noRole, _errorMsg };
}
}
public List<AADataList> SearchAudiometryAppointmentDataBase(int index, SearchAudiometryAppointment SearchAudiometryAppointmentData)
{
Audiometry aDB = new Audiometry();
return aDB.SearchAudiometryAppointmentDataBase(index, SearchAudiometryAppointmentData);
}
public string[] SearchAudiometryAppointmentDataBaseCount(SearchAudiometryAppointment SearchAudiometryAppointmentData)
{
Audiometry aDB = new Audiometry();
if (int.Parse(aDB._StaffhaveRoles[3]) == 1)
{
return aDB.SearchAudiometryAppointmentDataBaseCount(SearchAudiometryAppointmentData);
}
else
{
return new string[2] { _noRole, _errorMsg };
}
}
public CreateHearingInspection getStudentAidsUseNewDataBase(string SID)
{
Audiometry aDB = new Audiometry();
return aDB.getStudentAidsUseNewData(SID);
}
public List<SearchAidsManageResult> SearchAidsManageDataBase(int index, SearchAidsManageResult SearchData)
{
Audiometry aDB = new Audiometry();
return aDB.SearchAidsManageData(index, SearchData);
}
public CreateStudentAidsUse getStudentAidsUseDataBase(string ID)
{
Audiometry aDB = new Audiometry();
CreateStudentAidsUse returnValue = new CreateStudentAidsUse();
if (int.Parse(aDB._StaffhaveRoles[3]) == 1)
{
returnValue= aDB.getStudentAidsUse(ID);
}
else
{
returnValue.checkNo = _noRole;
returnValue.errorMsg = _errorMsg;
}
return returnValue;
}
public List<setHearingTests> getHearingTestDataBase(string stuID)
{
Audiometry aDB = new Audiometry();
List<setHearingTests> returnValue = new List<setHearingTests>();
if (int.Parse(aDB._StaffhaveRoles[0]) == 1)
{
returnValue= aDB.getHearingTestData(stuID);
}
else
{
setHearingTests addValue = new setHearingTests();
addValue.checkNo = _noRole;
addValue.errorMsg = _errorMsg;
returnValue.Add(addValue);
}
return returnValue;
}
public CreateHearingInspection getHearingInspectionDataBase(string sID)
{
Audiometry aDB = new Audiometry();
CreateHearingInspection returnValue=new CreateHearingInspection();
if (int.Parse(aDB._StaffhaveRoles[3]) == 1)
{
returnValue=aDB.getHearingInspectionData(sID);
}
else
{
returnValue.checkNo = _noRole;
returnValue.errorMsg = _errorMsg;
}
return returnValue;
}
public string[] setAidsManageDataBase(createAidsManage StructData)
{
Audiometry aDB = new Audiometry();
return aDB.setAidsManageData(StructData);
}
public List<SearchFMAidsAssessResult> SearchFmAssessmentDataBase(int index,SearchFMAidsAssess StructData)
{
Audiometry aDB = new Audiometry();
return aDB.SearchFmAssessmentData(index, StructData);
}
public string[] setAudiometryAppointment(CreateAudiometryAppointment StructData)
{
Audiometry aDB = new Audiometry();
//if (int.Parse(aDB._StaffhaveRoles[1]) == 1)
//{
return aDB.setAudiometryAppointment(StructData);
//}
//else
//{
// return new string[2] { _noRole, _errorMsg };
//}
}
public string[] SearchFmAssessmentDataBaseCount(SearchFMAidsAssess StructData)
{
Audiometry aDB = new Audiometry();
if (int.Parse(aDB._StaffhaveRoles[3]) == 1)
{
return aDB.SearchFmAssessmentDataCount(StructData);
}
else
{
return new string[2] { _noRole, _errorMsg };
}
}
public string[] setFmAssessmentDataBase(CreateFMAidsAssess StructData)
{
Audiometry aDB = new Audiometry();
if (int.Parse(aDB._StaffhaveRoles[1]) == 1)
{
return aDB.setFmAssessmentData(StructData);
}
else
{
return new string[2] { _noRole, _errorMsg };
}
}
public List<SearchHearingInspectionResult> SearchHearingInspectionDataBase(int index,SearchHearingAssessment SearchData)
{
Audiometry aDB = new Audiometry();
return aDB.SearchHearingInspectionData(index, SearchData);
}
public string[] setLendingDataBase(createAidsManageLoan StructData)
{
Audiometry aDB = new Audiometry();
if (int.Parse(aDB._StaffhaveRoles[1]) == 1)
{
return aDB.setLendingData(StructData);
}
else
{
return new string[2] { _noRole, _errorMsg };
}
}
public string[] SearchHearingInspectionDataBaseCount(SearchHearingAssessment SearchData)
{
Audiometry aDB = new Audiometry();
if (int.Parse(aDB._StaffhaveRoles[3]) == 1)
{
return aDB.SearchHearingInspectionDataCount(SearchData);
}
else
{
return new string[2] { _noRole, _errorMsg };
}
}
public string[] setStudentDataBase6(StudentHearingInformation StudentHearingData)
{
Audiometry aDB = new Audiometry();
CaseDataBase SDB = new CaseDataBase();
//if (int.Parse(aDB._StaffhaveRoles[1]) == 1)
//{
return SDB.setStudentDataBase6(StudentHearingData);
//}
//else
//{
// return new string[2] { _noRole, _errorMsg };
//}
}
public string[] createHearingInspectionDataBase(CreateHearingInspection StructData)
{
Audiometry aDB = new Audiometry();
if (int.Parse(aDB._StaffhaveRoles[2]) == 1)
{
return aDB.createHearingInspectionData(StructData);
}
else
{
return new string[2] { _noRole, _errorMsg };
}
}
public string[] setStudentDataBase6(StudentHearingInformation StudentHearing)
{
string[] returnValue = new string[2];
returnValue[0] = "0";
returnValue[1] = "";
StudentHearingInformation oldData = this.getStudentHearingInfo(StudentHearing.ID.ToString());
if ((oldData.accessory == "0" || oldData.accessory != StudentHearing.accessory) && StudentHearing.assistmanage == "3" && StudentHearing.accessory != "0")
{
StudentDataBasic DateItem = new StudentDataBasic();
DateItem.studentID = StudentHearing.studentID;
DateItem.assistmanageR = StudentHearing.assistmanageR;
DateItem.brandR = StudentHearing.brandR;
DateItem.modelR = StudentHearing.modelR;
DateItem.buyingPlaceR = StudentHearing.buyingPlaceR;
DateItem.buyingtimeR = StudentHearing.buyingtimeR;
DateItem.insertHospitalR = StudentHearing.insertHospitalR;
DateItem.openHzDateR = StudentHearing.openHzDateR;
DateItem.assistmanageL = StudentHearing.assistmanageL;
DateItem.brandL = StudentHearing.brandL;
DateItem.modelL = StudentHearing.modelL;
DateItem.buyingtimeL = StudentHearing.buyingtimeL;
DateItem.buyingPlaceL = StudentHearing.buyingPlaceL;
DateItem.insertHospitalL = StudentHearing.insertHospitalL;
DateItem.openHzDateL = StudentHearing.openHzDateL;
Audiometry aDB = new Audiometry();
aDB.ComparisonAidsData(DateItem);
}
DataBase Base = new DataBase();
SqlConnection Sqlconn = new SqlConnection(Base.GetConnString());
using (Sqlconn)
{
try
{
Sqlconn.Open();
string sql = "UPDATE StudentDatabase SET HearingProblemAge=@HearingProblemAge, HearingProblemMonth=@HearingProblemMonth, " +
"HearingProblem=@HearingProblem, HearingProblemText=@HearingProblemText, DiagnoseAge=@DiagnoseAge, DiagnoseMonth=@DiagnoseMonth, " +
"DiagnoseAgency=@DiagnoseAgency, DiagnoseR=@DiagnoseR, DiagnoseL=@DiagnoseL, NewbornHearing=@NewbornHearing, " +
"NewbornHearingInspection=@NewbornHearingInspection, NewbornHearingInspectionAgency=@NewbornHearingInspectionAgency, " +
"NewbornHearingInspectionDiagnoseR=@NewbornHearingInspectionDiagnoseR, NewbornHearingInspectionDiagnoseL=@NewbornHearingInspectionDiagnoseL, " +
"AuditoryElectrophysiology1=@AuditoryElectrophysiology1, AuditoryElectrophysiology_Date1=@AuditoryElectrophysiology_Date1, " +
"AuditoryElectrophysiology_Agency1=@AuditoryElectrophysiology_Agency1, AuditoryElectrophysiology_Item1=@AuditoryElectrophysiology_Item1, " +
"AuditoryElectrophysiology_Diagnose1R=@AuditoryElectrophysiology_Diagnose1R, AuditoryElectrophysiology_Diagnose1L=@AuditoryElectrophysiology_Diagnose1L, " +
"AuditoryElectrophysiology_Date2=@AuditoryElectrophysiology_Date2, AuditoryElectrophysiology_Agency2=@AuditoryElectrophysiology_Agency2, " +
"AuditoryElectrophysiology_Item2=@AuditoryElectrophysiology_Item2, AuditoryElectrophysiology_Diagnose2R=@AuditoryElectrophysiology_Diagnose2R, " +
"AuditoryElectrophysiology_Diagnose2L=@AuditoryElectrophysiology_Diagnose2L, AuditoryElectrophysiology_Date3=@AuditoryElectrophysiology_Date3, " +
"AuditoryElectrophysiology_Agency3=@AuditoryElectrophysiology_Agency3, AuditoryElectrophysiology_Item3=@AuditoryElectrophysiology_Item3, " +
"AuditoryElectrophysiology_Diagnose3R=@AuditoryElectrophysiology_Diagnose3R, AuditoryElectrophysiology_Diagnose3L=@AuditoryElectrophysiology_Diagnose3L, " +
"AuditoryElectrophysiology_Date4=@AuditoryElectrophysiology_Date4, AuditoryElectrophysiology_Agency4=@AuditoryElectrophysiology_Agency4, " +
"AuditoryElectrophysiology_Item4=@AuditoryElectrophysiology_Item4, AuditoryElectrophysiology_Diagnose4R=@AuditoryElectrophysiology_Diagnose4R, " +
"AuditoryElectrophysiology_Diagnose4L=@AuditoryElectrophysiology_Diagnose4L, AuditoryElectrophysiology_Date5=@AuditoryElectrophysiology_Date5, " +
"AuditoryElectrophysiology_Agency5=@AuditoryElectrophysiology_Agency5, AuditoryElectrophysiology_Item5=@AuditoryElectrophysiology_Item5, " +
"AuditoryElectrophysiology_Diagnose5R=@AuditoryElectrophysiology_Diagnose5R, AuditoryElectrophysiology_Diagnose5L=@AuditoryElectrophysiology_Diagnose5L, " +
"CTorMRI=@CTorMRI, CTorMRI_Date1=@CTorMRI_Date1, " +
"CTorMRI_Agency1=@CTorMRI_Agency1, CTorMRI_DiagnoseR=@CTorMRI_DiagnoseR, CTorMRI_DiagnoseL=@CTorMRI_DiagnoseL, " +
"GeneScreening=@GeneScreening, GeneScreening_Date=@GeneScreening_Date, GeneScreening_Agency=@GeneScreening_Agency, " +
"GeneScreening_Item=@GeneScreening_Item, " +
"FamilyHearingProblemHistory=@FamilyHearingProblemHistory, FamilyHearingProblemHistoryText=@FamilyHearingProblemHistoryText, " +
"HearingChangeHistory=@HearingChangeHistory, HearingChangeHistoryText=@HearingChangeHistoryText, AidsManagement=@AidsManagement, " +
"AidsManagementTextAge=@AidsManagementTextAge, HearingAids_R=@HearingAids_R, AidsBrand_R=@AidsBrand_R, AidsModel_R=@AidsModel_R, AidsOptionalTime_R=@AidsOptionalTime_R, " +
"AidsOptionalLocation_R=@AidsOptionalLocation_R, EEarHospital_R=@EEarHospital_R,EEarOpen_R=@EEarOpen_R, " +
"HearingAids_L=@HearingAids_L, AidsBrand_L=@AidsBrand_L, AidsModel_L=@AidsModel_L, AidsOptionalTime_L=@AidsOptionalTime_L, AidsOptionalLocation_L=@AidsOptionalLocation_L, " +
"EEarHospital_L=@EEarHospital_L, EEarOpen_L=@EEarOpen_L, AllDayAids=@AllDayAids, AllDayAidsText=@AllDayAidsText, " +
"ActiveReaction=@ActiveReaction, ActiveReactionText=@ActiveReactionText, BasicCare=@BasicCare, BasicCareText=@BasicCareText, UseFMsystem=@UseFMsystem, " +
"UseFMsystemBrand=@UseFMsystemBrand, HearingAssessmentSummary=@HearingAssessmentSummary, EarEndoscopy=@EarEndoscopy, " +
"EarEndoscopyAbnormalText=@EarEndoscopyAbnormalText, PureToneText=@PureToneText, Tympanogram=@Tympanogram, SATorSDT=@SATorSDT, " +
"SpeechRecognition=@SpeechRecognition, AidsSystem=@AidsSystem, HearingInspection=@HearingInspection, HearingOther=@HearingOther, " +
"Audiologist=@Audiologist, SurveyingDate=@SurveyingDate,accessory1=@accessory1,accessory2=@accessory2 " +
"WHERE ID=@ID ";
SqlCommand cmd = new SqlCommand(sql, Sqlconn);
cmd.Parameters.Add("@ID", SqlDbType.BigInt).Value = StudentHearing.ID;
cmd.Parameters.Add("@HearingProblemAge", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.problems01t01);
cmd.Parameters.Add("@HearingProblemMonth", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.problems01t02);
cmd.Parameters.Add("@HearingProblem", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.hearingQ);
cmd.Parameters.Add("@HearingProblemText", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.hearingQText);
cmd.Parameters.Add("@DiagnoseAge", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.problems02t01);
cmd.Parameters.Add("@DiagnoseMonth", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.problems02t02);
cmd.Parameters.Add("@DiagnoseAgency", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.problems02t03);
cmd.Parameters.Add("@DiagnoseR", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.problems02t04);
cmd.Parameters.Add("@DiagnoseL", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.problems02t05);
cmd.Parameters.Add("@NewbornHearing", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.hearingcheck);
cmd.Parameters.Add("@NewbornHearingInspection", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.hearingYescheck);
cmd.Parameters.Add("@NewbornHearingInspectionAgency", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.hearingYesPlace);
cmd.Parameters.Add("@NewbornHearingInspectionDiagnoseR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.hearingYesResultR);
cmd.Parameters.Add("@NewbornHearingInspectionDiagnoseL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.hearingYesResultL);
cmd.Parameters.Add("@AuditoryElectrophysiology1", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.sleepcheck);
cmd.Parameters.Add("@AuditoryElectrophysiology_Date1", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentHearing.sleepcheckTime1);
cmd.Parameters.Add("@AuditoryElectrophysiology_Agency1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckPlace1);
cmd.Parameters.Add("@AuditoryElectrophysiology_Item1", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.sleepcheckCheckItem1);
cmd.Parameters.Add("@AuditoryElectrophysiology_Diagnose1R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckResultL1);
cmd.Parameters.Add("@AuditoryElectrophysiology_Diagnose1L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckResultR1);
cmd.Parameters.Add("@AuditoryElectrophysiology_Date2", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentHearing.sleepcheckTime2);
cmd.Parameters.Add("@AuditoryElectrophysiology_Agency2", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckPlace2);
cmd.Parameters.Add("@AuditoryElectrophysiology_Item2", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.sleepcheckCheckItem2);
cmd.Parameters.Add("@AuditoryElectrophysiology_Diagnose2R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckResultL2);
cmd.Parameters.Add("@AuditoryElectrophysiology_Diagnose2L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckResultR2);
cmd.Parameters.Add("@AuditoryElectrophysiology_Date3", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentHearing.sleepcheckTime3);
cmd.Parameters.Add("@AuditoryElectrophysiology_Agency3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckPlace3);
cmd.Parameters.Add("@AuditoryElectrophysiology_Item3", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.sleepcheckCheckItem3);
cmd.Parameters.Add("@AuditoryElectrophysiology_Diagnose3R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckResultL3);
cmd.Parameters.Add("@AuditoryElectrophysiology_Diagnose3L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckResultR3);
cmd.Parameters.Add("@AuditoryElectrophysiology_Date4", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentHearing.sleepcheckTime4);
cmd.Parameters.Add("@AuditoryElectrophysiology_Agency4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckPlace4);
cmd.Parameters.Add("@AuditoryElectrophysiology_Item4", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.sleepcheckCheckItem4);
cmd.Parameters.Add("@AuditoryElectrophysiology_Diagnose4R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckResultL4);
cmd.Parameters.Add("@AuditoryElectrophysiology_Diagnose4L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckResultR4);
cmd.Parameters.Add("@AuditoryElectrophysiology_Date5", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentHearing.sleepcheckTime5);
cmd.Parameters.Add("@AuditoryElectrophysiology_Agency5", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckPlace5);
cmd.Parameters.Add("@AuditoryElectrophysiology_Item5", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.sleepcheckCheckItem5);
cmd.Parameters.Add("@AuditoryElectrophysiology_Diagnose5R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckResultL5);
cmd.Parameters.Add("@AuditoryElectrophysiology_Diagnose5L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckResultR5);
cmd.Parameters.Add("@CTorMRI", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.ctmri);
cmd.Parameters.Add("@CTorMRI_Date1", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentHearing.ctmriTime);
cmd.Parameters.Add("@CTorMRI_Agency1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.ctmriPlace);
cmd.Parameters.Add("@CTorMRI_DiagnoseR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.ctmriResultL);
cmd.Parameters.Add("@CTorMRI_DiagnoseL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.ctmriResultR);
cmd.Parameters.Add("@GeneScreening", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.gene);
cmd.Parameters.Add("@GeneScreening_Date", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentHearing.geneTime);
cmd.Parameters.Add("@GeneScreening_Agency", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.genePlace);
cmd.Parameters.Add("@GeneScreening_Item", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.geneResult);
cmd.Parameters.Add("@FamilyHearingProblemHistory", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.familyhistory);
cmd.Parameters.Add("@FamilyHearingProblemHistoryText", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.familyhistoryText);
cmd.Parameters.Add("@HearingChangeHistory", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.changehistory);
cmd.Parameters.Add("@HearingChangeHistoryText", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.changehistoryText);
cmd.Parameters.Add("@AidsManagement", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.assistmanage);
cmd.Parameters.Add("@AidsManagementTextAge", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.accessory);
cmd.Parameters.Add("@HearingAids_R", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.assistmanageR);
cmd.Parameters.Add("@AidsBrand_R", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.brandR);
cmd.Parameters.Add("@AidsModel_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.modelR);
cmd.Parameters.Add("@AidsOptionalTime_R", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentHearing.buyingtimeR);
cmd.Parameters.Add("@AidsOptionalLocation_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.buyingPlaceR);
cmd.Parameters.Add("@EEarHospital_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.insertHospitalR);
cmd.Parameters.Add("@EEarOpen_R", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentHearing.openHzDateR);
cmd.Parameters.Add("@HearingAids_L", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.assistmanageL);
cmd.Parameters.Add("@AidsBrand_L", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.brandL);
cmd.Parameters.Add("@AidsModel_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.modelL);
cmd.Parameters.Add("@AidsOptionalTime_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.buyingtimeL);
cmd.Parameters.Add("@AidsOptionalLocation_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.buyingPlaceL);
cmd.Parameters.Add("@EEarHospital_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.insertHospitalL);
cmd.Parameters.Add("@EEarOpen_L", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentHearing.openHzDateL);
cmd.Parameters.Add("@AllDayAids", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.allassis);
cmd.Parameters.Add("@AllDayAidsText", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.allassisNoText);
cmd.Parameters.Add("@ActiveReaction", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.assis1);
cmd.Parameters.Add("@ActiveReactionText", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.assis1NoText);
cmd.Parameters.Add("@BasicCare", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.assis2);
cmd.Parameters.Add("@BasicCareText", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.assis2NoText);
cmd.Parameters.Add("@UseFMsystem", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.assisFM);
cmd.Parameters.Add("@UseFMsystemBrand", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.assisFMBrand);
cmd.Parameters.Add("@HearingAssessmentSummary", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.assessnotes);
cmd.Parameters.Add("@EarEndoscopy", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.assessnotes1);
cmd.Parameters.Add("@EarEndoscopyAbnormalText", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.assessnotes102Text);
cmd.Parameters.Add("@PureToneText", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.problems11t02);
cmd.Parameters.Add("@Tympanogram", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.assessnotes2);
cmd.Parameters.Add("@SATorSDT", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.problems11t03);
cmd.Parameters.Add("@SpeechRecognition", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.problems11t04);
cmd.Parameters.Add("@AidsSystem", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.problems11t05);
cmd.Parameters.Add("@HearingInspection", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.problems11t06);
cmd.Parameters.Add("@HearingOther", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.problems11t07);
cmd.Parameters.Add("@Audiologist", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StudentHearing.inspectorID);
cmd.Parameters.Add("@SurveyingDate", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentHearing.inspectorDate);
cmd.Parameters.Add("@accessory1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.accessory1);
cmd.Parameters.Add("@accessory2", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.accessory2);
returnValue[0] = cmd.ExecuteNonQuery().ToString();
Sqlconn.Close();
}
catch (Exception e)
{
returnValue[0] = "-1";
returnValue[1] = e.Message;
}
}
return returnValue;
}
public CreateFMAidsAssess getFmAssessmentDataBase(string SID)
{
Audiometry aDB = new Audiometry();
CreateFMAidsAssess returnValue = new CreateFMAidsAssess();
if (int.Parse(aDB._StaffhaveRoles[3]) == 1)
{
returnValue=aDB.getFmAssessmentData(SID);
}
else
{
returnValue.checkNo = _noRole;
returnValue.errorMsg = _errorMsg;
}
return returnValue;
}
