public int setTeachISPPage1(setTeachISP1 StudentISP)
{
int returnValue = 0;
DataBase Base = new DataBase();
SqlConnection Sqlconn = new SqlConnection(Base.GetConnString());
using (Sqlconn)
{
try
{
Sqlconn.Open();
string sql = "UPDATE CaseISPstate SET PhysicalAndMentalDisabilityHandbook=@PhysicalAndMentalDisabilityHandbook, DisabilityCategory1=@DisabilityCategory1, "+
"DisabilityGrade1=@DisabilityGrade1, DisabilityCategory2=@DisabilityCategory2, DisabilityGrade2=@DisabilityGrade2, DisabilityCategory3=@DisabilityCategory3, "+
"DisabilityGrade3=@DisabilityGrade3, NoDisabilityHandbook=@NoDisabilityHandbook, ApplyDisabilityHandbook=@ApplyDisabilityHandbook, "+
"DisabilityProve=@DisabilityProve, AidsManagement=@AidsManagement, AidsManagementTextAge=@AidsManagementTextAge, HearingAids_R=@HearingAids_R, "+
"AidsBrand_R=@AidsBrand_R, AidsOptionalTime_R=@AidsOptionalTime_R, AidsOptionalLocation_R=@AidsOptionalLocation_R, EEarHospital_R=@EEarHospital_R, "+
"EEarImplants_R=@EEarImplants_R, EEarOpen_R=@EEarOpen_R, HearingAids_L=@HearingAids_L, AidsBrand_L=@AidsBrand_L, AidsOptionalTime_L=@AidsOptionalTime_L, "+
"AidsOptionalLocation_L=@AidsOptionalLocation_L, EEarHospital_L=@EEarHospital_L, EEarImplants_L=@EEarImplants_L, EEarOpen_L=@EEarOpen_L, "+
"AcceptClass=@AcceptClass, MedicalEducation=@MedicalEducation, MedicalEducationText1=@MedicalEducationText1, MedicalEducationText2=@MedicalEducationText2, "+
"MedicalEducationText3=@MedicalEducationText3, MedicalEducationText4=@MedicalEducationText4, MedicalEducationText5=@MedicalEducationText5, "+
"MedicalEducationText6=@MedicalEducationText6, MedicalEducationText7=@MedicalEducationText7, ExecutionTimeSince=@ExecutionTimeSince, " +
"ExecutionTimeUntil=@ExecutionTimeUntil, ParticipantDate1=@ParticipantDate1, ParticipantParent1=@ParticipantParent1, ParticipantTeache1=@ParticipantTeache1, "+
"ParticipantSocialWorker1=@ParticipantSocialWorker1, ParticipantAudiologist1=@ParticipantAudiologist1, ParticipantHead1=@ParticipantHead1, "+
"ParticipantProfessionals1=@ParticipantProfessionals1, ParticipantDate2=@ParticipantDate2, ParticipantParent2=@ParticipantParent2, "+
"ParticipantTeache2=@ParticipantTeache2, ParticipantSocialWorker2=@ParticipantSocialWorker2, ParticipantAudiologist2=@ParticipantAudiologist2, "+
"ParticipantHead2=@ParticipantHead2, ParticipantProfessionals2=@ParticipantProfessionals2 "+
"WHERE ID=@ID AND StudentID=@StudentID";
SqlCommand cmd = new SqlCommand(sql, Sqlconn);
cmd.Parameters.Add("@ID", SqlDbType.BigInt).Value = StudentISP.Column;
cmd.Parameters.Add("@StudentID", SqlDbType.Int).Value = StudentISP.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 = cmd.ExecuteNonQuery();
Sqlconn.Close();
}
catch (Exception e)
{
string error = e.Message;
returnValue = -1;
}
}
return returnValue;
}
public int setTeachISPDate1(setTeachISP1 StudentISP)
{
TeachDataBase SDB = new TeachDataBase();
return SDB.setTeachISPPage1(StudentISP);
}
