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