public string[] createCaseISP(Int64 StuCaseDataID, CreateTeachISP StudentISP) { string[] returnValue = new string[2]; returnValue[0] = "0"; returnValue[1] = "0"; CaseDataBase CData = new CaseDataBase(); StudentResult getCaseData = CData.getStudentData(StuCaseDataID.ToString()); DataBase Base = new DataBase(); SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()); using (Sqlconn) { try { Sqlconn.Open(); string sql = "INSERT INTO CaseISPstate (Unit, StudentID, PhysicalAndMentalDisabilityHandbook, DisabilityCategory1, DisabilityGrade1, DisabilityCategory2, DisabilityGrade2, "+ "DisabilityCategory3, DisabilityGrade3, NoDisabilityHandbook, ApplyDisabilityHandbook, DisabilityProve, AidsManagement, AidsManagementTextAge, "+ "HearingAids_R, AidsBrand_R, AidsOptionalTime_R, AidsOptionalLocation_R, EEarHospital_R, EEarImplants_R, EEarOpen_R, HearingAids_L, AidsBrand_L, "+ "AidsOptionalTime_L, AidsOptionalLocation_L, EEarHospital_L, EEarImplants_L, EEarOpen_L, AcceptClass, MedicalEducation, MedicalEducationText1, "+ "MedicalEducationText2, MedicalEducationText3, MedicalEducationText4, MedicalEducationText5, MedicalEducationText6, MedicalEducationText7," + "ExecutionTimeSince, ExecutionTimeUntil, ParticipantDate1, ParticipantParent1, ParticipantTeache1, ParticipantSocialWorker1, ParticipantAudiologist1, "+ "ParticipantHead1, ParticipantProfessionals1, ParticipantDate2, ParticipantParent2, ParticipantTeache2, ParticipantSocialWorker2, ParticipantAudiologist2, "+ "ParticipantHead2, ParticipantProfessionals2, PlanWriter1, PlanWriteFrameDate1, PlanWriter2, PlanWriteFrameDate2, PlanWriter3, PlanWriteFrameDate3) " + "VALUES (@Unit, @StudentID, @PhysicalAndMentalDisabilityHandbook, @DisabilityCategory1, @DisabilityGrade1, @DisabilityCategory2, @DisabilityGrade2, "+ "@DisabilityCategory3, @DisabilityGrade3, @NoDisabilityHandbook, @ApplyDisabilityHandbook, @DisabilityProve, @AidsManagement, @AidsManagementTextAge, "+ "@HearingAids_R, @AidsBrand_R, @AidsOptionalTime_R, @AidsOptionalLocation_R, @EEarHospital_R, @EEarImplants_R, @EEarOpen_R, @HearingAids_L, @AidsBrand_L, "+ "@AidsOptionalTime_L, @AidsOptionalLocation_L, @EEarHospital_L, @EEarImplants_L, @EEarOpen_L, @AcceptClass, @MedicalEducation, @MedicalEducationText1, "+ "@MedicalEducationText2, @MedicalEducationText3, @MedicalEducationText4, @MedicalEducationText5, @MedicalEducationText6, @MedicalEducationText7," + "@ExecutionTimeSince, @ExecutionTimeUntil, @ParticipantDate1, @ParticipantParent1, @ParticipantTeache1, @ParticipantSocialWorker1, @ParticipantAudiologist1, "+ "@ParticipantHead1, @ParticipantProfessionals1, @ParticipantDate2, @ParticipantParent2, @ParticipantTeache2, @ParticipantSocialWorker2, "+ "@ParticipantAudiologist2, @ParticipantHead2, @ParticipantProfessionals2, @PlanWriter1, @PlanWriteFrameDate1, @PlanWriter2, @PlanWriteFrameDate2, @PlanWriter3, @PlanWriteFrameDate3)"; SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@Unit", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(getCaseData.StudentData.caseStatu); cmd.Parameters.Add("@StudentID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(getCaseData.StudentData.studentID); cmd.Parameters.Add("@PhysicalAndMentalDisabilityHandbook", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentISP.manualWhether); cmd.Parameters.Add("@DisabilityCategory1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentISP.manualCategory1); cmd.Parameters.Add("@DisabilityGrade1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentISP.manualGrade1); cmd.Parameters.Add("@DisabilityCategory2", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentISP.manualCategory2); cmd.Parameters.Add("@DisabilityGrade2", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentISP.manualGrade2); cmd.Parameters.Add("@DisabilityCategory3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentISP.manualCategory3); cmd.Parameters.Add("@DisabilityGrade3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentISP.manualGrade3); cmd.Parameters.Add("@NoDisabilityHandbook", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentISP.manualNo); cmd.Parameters.Add("@ApplyDisabilityHandbook", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentISP.manualUnit); cmd.Parameters.Add("@DisabilityProve", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentISP.studentManualImg); cmd.Parameters.Add("@AidsManagement", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentISP.assistmanage); cmd.Parameters.Add("@AidsManagementTextAge", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentISP.Accessory); cmd.Parameters.Add("@HearingAids_R", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentISP.assistmanageR); cmd.Parameters.Add("@AidsBrand_R", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentISP.BrandR1); cmd.Parameters.Add("@AidsOptionalTime_R", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentISP.BuyingtimeR); cmd.Parameters.Add("@AidsOptionalLocation_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentISP.BuyingPlaceR); cmd.Parameters.Add("@EEarHospital_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentISP.InsertHospitalR); cmd.Parameters.Add("@EEarImplants_R", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentISP.InsertDateR); cmd.Parameters.Add("@EEarOpen_R", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentISP.OpenHzDateR); cmd.Parameters.Add("@HearingAids_L", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentISP.assistmanageL); cmd.Parameters.Add("@AidsBrand_L", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentISP.BrandL1); cmd.Parameters.Add("@AidsOptionalTime_L", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentISP.BuyingtimeL); cmd.Parameters.Add("@AidsOptionalLocation_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentISP.BuyingPlaceL); cmd.Parameters.Add("@EEarHospital_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentISP.InsertHospitalL); cmd.Parameters.Add("@EEarImplants_L", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentISP.InsertDateL); cmd.Parameters.Add("@EEarOpen_L", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentISP.OpenHzDateL); cmd.Parameters.Add("@AcceptClass", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StudentISP.edu); cmd.Parameters.Add("@MedicalEducation", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentISP.edu1); cmd.Parameters.Add("@MedicalEducationText1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentISP.PandF1); cmd.Parameters.Add("@MedicalEducationText2", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentISP.PandF2); cmd.Parameters.Add("@MedicalEducationText3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentISP.PandF3); cmd.Parameters.Add("@MedicalEducationText4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentISP.PandF4); cmd.Parameters.Add("@MedicalEducationText5", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentISP.PandF5); cmd.Parameters.Add("@MedicalEducationText6", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentISP.PandF6); cmd.Parameters.Add("@MedicalEducationText7", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentISP.PandF7); cmd.Parameters.Add("@ExecutionTimeSince", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentISP.startPlanDate); cmd.Parameters.Add("@ExecutionTimeUntil", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentISP.endPlanDate); cmd.Parameters.Add("@ParticipantDate1", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentISP.ServiceDate1); cmd.Parameters.Add("@ParticipantParent1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentISP.Parent1); cmd.Parameters.Add("@ParticipantTeache1", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StudentISP.Teacher1); cmd.Parameters.Add("@ParticipantSocialWorker1", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StudentISP.Sociality1); cmd.Parameters.Add("@ParticipantAudiologist1", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StudentISP.ListenTutor1); cmd.Parameters.Add("@ParticipantHead1", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StudentISP.Manager1); cmd.Parameters.Add("@ParticipantProfessionals1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentISP.RelationalPeople1); cmd.Parameters.Add("@ParticipantDate2", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentISP.ServiceDate2); ; cmd.Parameters.Add("@ParticipantParent2", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentISP.Parent2); cmd.Parameters.Add("@ParticipantTeache2", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StudentISP.Teacher2); cmd.Parameters.Add("@ParticipantSocialWorker2", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StudentISP.Sociality2); cmd.Parameters.Add("@ParticipantAudiologist2", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StudentISP.ListenTutor2); cmd.Parameters.Add("@ParticipantHead2", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StudentISP.Manager2); cmd.Parameters.Add("@ParticipantProfessionals2", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentISP.RelationalPeople2); cmd.Parameters.Add("@PlanWriter1", SqlDbType.Int).Value = HttpContext.Current.User.Identity.Name; cmd.Parameters.Add("@PlanWriteFrameDate1", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentISP.startPlanDate); cmd.Parameters.Add("@PlanWriter2", SqlDbType.Int).Value = HttpContext.Current.User.Identity.Name; cmd.Parameters.Add("@PlanWriteFrameDate2", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentISP.startPlanDate); cmd.Parameters.Add("@PlanWriter3", SqlDbType.Int).Value = HttpContext.Current.User.Identity.Name; cmd.Parameters.Add("@PlanWriteFrameDate3", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentISP.startPlanDate); returnValue[0] = cmd.ExecuteNonQuery().ToString(); if (returnValue[0] == "1") { sql = "select IDENT_CURRENT('CaseISPstate') AS TID"; cmd = new SqlCommand(sql, Sqlconn); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { returnValue[1] = dr["TID"].ToString(); } dr.Close(); } Sqlconn.Close(); } catch (Exception e) { returnValue[0] = "-1"; returnValue[1] = e.Message.ToString(); } } return returnValue; }
public string[] createCaseISPData(Int64 cID, CreateTeachISP StudentISP) { TeachDataBase SDB = new TeachDataBase(); return SDB.createCaseISP(cID, StudentISP); }