public string[] setStudentDataBase2(StudentData2 StudentData)
{
string[] returnValue = new string[2];
returnValue[0] = "0";
returnValue[1] = "";
DataBase Base = new DataBase();
SqlConnection Sqlconn = new SqlConnection(Base.GetConnString());
using (Sqlconn)
{
try
{
Sqlconn.Open();
//Unit=@Unit,
string sql = "UPDATE StudentDatabase SET FamilyAppellation1=@FamilyAppellation1, FamilyName1=@FamilyName1, FamilyBirthday1=@FamilyBirthday1, " +
"FamilyEducation1=@FamilyEducation1, FamilyProfession1=@FamilyProfession1, FamilyLive1=@FamilyLive1, FamilyHearing1=@FamilyHearing1, FamilyHealth1=@FamilyHealth1, " +
"FamilyHealthText1=@FamilyHealthText1, FamilyAppellation2=@FamilyAppellation2, FamilyName2=@FamilyName2, FamilyBirthday2=@FamilyBirthday2, " +
"FamilyEducation2=@FamilyEducation2, FamilyProfession2=@FamilyProfession2, FamilyLive2=@FamilyLive2, FamilyHearing2=@FamilyHearing2, FamilyHealth2=@FamilyHealth2, " +
"FamilyHealthText2=@FamilyHealthText2, FamilyAppellation3=@FamilyAppellation3, FamilyName3=@FamilyName3, FamilyBirthday3=@FamilyBirthday3, " +
"FamilyEducation3=@FamilyEducation3, FamilyProfession3=@FamilyProfession3, FamilyLive3=@FamilyLive3, FamilyHearing3=@FamilyHearing3, FamilyHealth3=@FamilyHealth3, " +
"FamilyHealthText3=@FamilyHealthText3, FamilyAppellation4=@FamilyAppellation4, FamilyName4=@FamilyName4, FamilyBirthday4=@FamilyBirthday4, " +
"FamilyEducation4=@FamilyEducation4, FamilyProfession4=@FamilyProfession4, FamilyLive4=@FamilyLive4, FamilyHearing4=@FamilyHearing4, FamilyHealth4=@FamilyHealth4, " +
"FamilyHealthText4=@FamilyHealthText4, FamilyAppellation5=@FamilyAppellation5, FamilyName5=@FamilyName5, FamilyBirthday5=@FamilyBirthday5, " +
"FamilyEducation5=@FamilyEducation5, FamilyProfession5=@FamilyProfession5, FamilyLive5=@FamilyLive5, FamilyHearing5=@FamilyHearing5, FamilyHealth5=@FamilyHealth5, " +
"FamilyHealthText5=@FamilyHealthText5, FamilyAppellation6=@FamilyAppellation6, FamilyName6=@FamilyName6, FamilyBirthday6=@FamilyBirthday6, " +
"FamilyEducation6=@FamilyEducation6, FamilyProfession6=@FamilyProfession6, FamilyLive6=@FamilyLive6, FamilyHearing6=@FamilyHearing6, FamilyHealth6=@FamilyHealth6, " +
"FamilyHealthText6=@FamilyHealthText6, FamilyAppellation7=@FamilyAppellation7, FamilyName7=@FamilyName7, FamilyBirthday7=@FamilyBirthday7, " +
"FamilyEducation7=@FamilyEducation7, FamilyProfession7=@FamilyProfession7, FamilyLive7=@FamilyLive7, FamilyHearing7=@FamilyHearing7, FamilyHealth7=@FamilyHealth7, " +
"FamilyHealthText7=@FamilyHealthText7, FamilyAppellation8=@FamilyAppellation8, FamilyName8=@FamilyName8, FamilyBirthday8=@FamilyBirthday8, " +
"FamilyEducation8=@FamilyEducation8, FamilyProfession8=@FamilyProfession8, FamilyLive8=@FamilyLive8, FamilyHearing8=@FamilyHearing8, FamilyHealth8=@FamilyHealth8, " +
"FamilyHealthText8=@FamilyHealthText8, FamilyLanguage=@FamilyLanguage, FamilyLanguageText=@FamilyLanguageText, FamilyConnectLanguage=@FamilyConnectLanguage, " +
"FamilyConnectLanguageText=@FamilyConnectLanguageText " +
"WHERE StudentID=@StudentID AND ID=@ID";
SqlCommand cmd = new SqlCommand(sql, Sqlconn);
cmd.Parameters.Add("@StudentID", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.studentID);
cmd.Parameters.Add("@ID", SqlDbType.BigInt).Value = StudentData.ID;
cmd.Parameters.Add("@FamilyAppellation1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fAppellation1);
cmd.Parameters.Add("@FamilyName1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fName1);
cmd.Parameters.Add("@FamilyBirthday1", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentData.fBirthday1);
cmd.Parameters.Add("@FamilyEducation1", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fEDU1);
cmd.Parameters.Add("@FamilyProfession1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fProfession1);
cmd.Parameters.Add("@FamilyLive1", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fLive1);
cmd.Parameters.Add("@FamilyHearing1", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fHearing1);
cmd.Parameters.Add("@FamilyHealth1", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fHealthy1);
cmd.Parameters.Add("@FamilyHealthText1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.familyText01);
cmd.Parameters.Add("@FamilyAppellation2", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fAppellation2);
cmd.Parameters.Add("@FamilyName2", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fName2);
cmd.Parameters.Add("@FamilyBirthday2", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentData.fBirthday2);
cmd.Parameters.Add("@FamilyEducation2", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fEDU2);
cmd.Parameters.Add("@FamilyProfession2", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fProfession2);
cmd.Parameters.Add("@FamilyLive2", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fLive2);
cmd.Parameters.Add("@FamilyHearing2", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fHearing2);
cmd.Parameters.Add("@FamilyHealth2", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fHealthy2);
cmd.Parameters.Add("@FamilyHealthText2", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.familyText02);
cmd.Parameters.Add("@FamilyAppellation3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fAppellation3);
cmd.Parameters.Add("@FamilyName3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fName3);
cmd.Parameters.Add("@FamilyBirthday3", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentData.fBirthday3);
cmd.Parameters.Add("@FamilyEducation3", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fEDU3);
cmd.Parameters.Add("@FamilyProfession3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fProfession3);
cmd.Parameters.Add("@FamilyLive3", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fLive3);
cmd.Parameters.Add("@FamilyHearing3", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fHearing3);
cmd.Parameters.Add("@FamilyHealth3", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fHealthy3);
cmd.Parameters.Add("@FamilyHealthText3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.familyText03);
cmd.Parameters.Add("@FamilyAppellation4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fAppellation4);
cmd.Parameters.Add("@FamilyName4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fName4);
cmd.Parameters.Add("@FamilyBirthday4", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentData.fBirthday4);
cmd.Parameters.Add("@FamilyEducation4", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fEDU4);
cmd.Parameters.Add("@FamilyProfession4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fProfession4);
cmd.Parameters.Add("@FamilyLive4", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fLive4);
cmd.Parameters.Add("@FamilyHearing4", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fHearing4);
cmd.Parameters.Add("@FamilyHealth4", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fHealthy4);
cmd.Parameters.Add("@FamilyHealthText4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.familyText04);
cmd.Parameters.Add("@FamilyAppellation5", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fAppellation5);
cmd.Parameters.Add("@FamilyName5", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fName5);
cmd.Parameters.Add("@FamilyBirthday5", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentData.fBirthday5);
cmd.Parameters.Add("@FamilyEducation5", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fEDU5);
cmd.Parameters.Add("@FamilyProfession5", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fProfession5);
cmd.Parameters.Add("@FamilyLive5", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fLive5);
cmd.Parameters.Add("@FamilyHearing5", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fHearing5);
cmd.Parameters.Add("@FamilyHealth5", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fHealthy5);
cmd.Parameters.Add("@FamilyHealthText5", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.familyText05);
cmd.Parameters.Add("@FamilyAppellation6", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fAppellation6);
cmd.Parameters.Add("@FamilyName6", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fName6);
cmd.Parameters.Add("@FamilyBirthday6", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentData.fBirthday6);
cmd.Parameters.Add("@FamilyEducation6", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fEDU6);
cmd.Parameters.Add("@FamilyProfession6", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fProfession6);
cmd.Parameters.Add("@FamilyLive6", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fLive6);
cmd.Parameters.Add("@FamilyHearing6", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fHearing6);
cmd.Parameters.Add("@FamilyHealth6", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fHealthy6);
cmd.Parameters.Add("@FamilyHealthText6", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.familyText06);
cmd.Parameters.Add("@FamilyAppellation7", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fAppellation7);
cmd.Parameters.Add("@FamilyName7", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fName7);
cmd.Parameters.Add("@FamilyBirthday7", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentData.fBirthday7);
cmd.Parameters.Add("@FamilyEducation7", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fEDU7);
cmd.Parameters.Add("@FamilyProfession7", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fProfession7);
cmd.Parameters.Add("@FamilyLive7", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fLive7);
cmd.Parameters.Add("@FamilyHearing7", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fHearing7);
cmd.Parameters.Add("@FamilyHealth7", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fHealthy7);
cmd.Parameters.Add("@FamilyHealthText7", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.familyText07);
cmd.Parameters.Add("@FamilyAppellation8", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fAppellation8);
cmd.Parameters.Add("@FamilyName8", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fName8);
cmd.Parameters.Add("@FamilyBirthday8", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentData.fBirthday8);
cmd.Parameters.Add("@FamilyEducation8", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fEDU8);
cmd.Parameters.Add("@FamilyProfession8", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fProfession8);
cmd.Parameters.Add("@FamilyLive8", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fLive8);
cmd.Parameters.Add("@FamilyHearing8", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fHearing8);
cmd.Parameters.Add("@FamilyHealth8", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fHealthy8);
cmd.Parameters.Add("@FamilyHealthText8", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.familyText08);
cmd.Parameters.Add("@FamilyLanguage", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.lang1);
cmd.Parameters.Add("@FamilyLanguageText", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.lang1t01);
cmd.Parameters.Add("@FamilyConnectLanguage", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.lang2);
cmd.Parameters.Add("@FamilyConnectLanguageText", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.lang2t01);
returnValue[0] = cmd.ExecuteNonQuery().ToString();
Sqlconn.Close();
}
catch (Exception e)
{
returnValue[0] = "-1";
returnValue[1] = e.Message;
}
}
return returnValue;
}
public string[] setStudentDataBase2(StudentData2 StudentData)
{
CaseDataBase SDB = new CaseDataBase();
//if (int.Parse(SDB._StaffhaveRoles[1]) == 1)
//{
return SDB.setStudentDataBase2(StudentData);
//}
//else
//{
// return new string[2] { _noRole, _errorMsg };
//}
}
public StudentData2 getStudentData2(string ID)
{
StudentData2 returnValue = new StudentData2();
DataBase Base = new DataBase();
using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()))
{
try
{
Sqlconn.Open();
string sql = "SELECT * FROM StudentDatabase WHERE isDeleted=0 AND ID=(@ID)";
SqlCommand cmd = new SqlCommand(sql, Sqlconn);
cmd.Parameters.Add("@ID", SqlDbType.BigInt).Value = Chk.CheckStringtoInt64Function(ID);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
StaffDataBase sDB = new StaffDataBase();
returnValue.ID = dr["ID"].ToString();
returnValue.fAppellation1 = dr["FamilyAppellation1"].ToString();
returnValue.fName1 = dr["FamilyName1"].ToString();
returnValue.fBirthday1 = DateTime.Parse(dr["FamilyBirthday1"].ToString()).ToString("yyyy-MM-dd");
returnValue.fEDU1 = dr["FamilyEducation1"].ToString();
returnValue.fProfession1 = dr["FamilyProfession1"].ToString();
returnValue.fLive1 = dr["FamilyLive1"].ToString();
returnValue.fHearing1 = dr["FamilyHearing1"].ToString();
returnValue.fHealthy1 = dr["FamilyHealth1"].ToString();
returnValue.familyText01 = dr["FamilyHealthText1"].ToString();
returnValue.fAppellation2 = dr["FamilyAppellation2"].ToString();
returnValue.fName2 = dr["FamilyName2"].ToString();
returnValue.fBirthday2 = DateTime.Parse(dr["FamilyBirthday2"].ToString()).ToString("yyyy-MM-dd");
returnValue.fEDU2 = dr["FamilyEducation2"].ToString();
returnValue.fProfession2 = dr["FamilyProfession2"].ToString();
returnValue.fLive2 = dr["FamilyLive2"].ToString();
returnValue.fHearing2 = dr["FamilyHearing2"].ToString();
returnValue.fHealthy2 = dr["FamilyHealth2"].ToString();
returnValue.familyText02 = dr["FamilyHealthText2"].ToString();
returnValue.fAppellation3 = dr["FamilyAppellation3"].ToString();
returnValue.fName3 = dr["FamilyName3"].ToString();
returnValue.fBirthday3 = DateTime.Parse(dr["FamilyBirthday3"].ToString()).ToString("yyyy-MM-dd");
returnValue.fEDU3 = dr["FamilyEducation3"].ToString();
returnValue.fProfession3 = dr["FamilyProfession3"].ToString();
returnValue.fLive3 = dr["FamilyLive3"].ToString();
returnValue.fHearing3 = dr["FamilyHearing3"].ToString();
returnValue.fHealthy3 = dr["FamilyHealth3"].ToString();
returnValue.familyText03 = dr["FamilyHealthText3"].ToString();
returnValue.fAppellation4 = dr["FamilyAppellation4"].ToString();
returnValue.fName4 = dr["FamilyName4"].ToString();
returnValue.fBirthday4 = DateTime.Parse(dr["FamilyBirthday4"].ToString()).ToString("yyyy-MM-dd");
returnValue.fEDU4 = dr["FamilyEducation4"].ToString();
returnValue.fProfession4 = dr["FamilyProfession4"].ToString();
returnValue.fLive4 = dr["FamilyLive4"].ToString();
returnValue.fHearing4 = dr["FamilyHearing4"].ToString();
returnValue.fHealthy4 = dr["FamilyHealth4"].ToString();
returnValue.familyText04 = dr["FamilyHealthText4"].ToString();
returnValue.fAppellation5 = dr["FamilyAppellation5"].ToString();
returnValue.fName5 = dr["FamilyName5"].ToString();
returnValue.fBirthday5 = DateTime.Parse(dr["FamilyBirthday5"].ToString()).ToString("yyyy-MM-dd");
returnValue.fEDU5 = dr["FamilyEducation5"].ToString();
returnValue.fProfession5 = dr["FamilyProfession5"].ToString();
returnValue.fLive5 = dr["FamilyLive5"].ToString();
returnValue.fHearing5 = dr["FamilyHearing5"].ToString();
returnValue.fHealthy5 = dr["FamilyHealth5"].ToString();
returnValue.familyText05 = dr["FamilyHealthText5"].ToString();
returnValue.fAppellation6 = dr["FamilyAppellation6"].ToString();
returnValue.fName6 = dr["FamilyName6"].ToString();
returnValue.fBirthday6 = DateTime.Parse(dr["FamilyBirthday6"].ToString()).ToString("yyyy-MM-dd");
returnValue.fEDU6 = dr["FamilyEducation6"].ToString();
returnValue.fProfession6 = dr["FamilyProfession6"].ToString();
returnValue.fLive6 = dr["FamilyLive6"].ToString();
returnValue.fHearing6 = dr["FamilyHearing6"].ToString();
returnValue.fHealthy6 = dr["FamilyHealth6"].ToString();
returnValue.familyText06 = dr["FamilyHealthText6"].ToString();
returnValue.fAppellation7 = dr["FamilyAppellation7"].ToString();
returnValue.fName7 = dr["FamilyName7"].ToString();
returnValue.fBirthday7 = DateTime.Parse(dr["FamilyBirthday7"].ToString()).ToString("yyyy-MM-dd");
returnValue.fEDU7 = dr["FamilyEducation7"].ToString();
returnValue.fProfession7 = dr["FamilyProfession7"].ToString();
returnValue.fLive7 = dr["FamilyLive7"].ToString();
returnValue.fHearing7 = dr["FamilyHearing7"].ToString();
returnValue.fHealthy7 = dr["FamilyHealth7"].ToString();
returnValue.familyText07 = dr["FamilyHealthText7"].ToString();
returnValue.fAppellation8 = dr["FamilyAppellation8"].ToString();
returnValue.fName8 = dr["FamilyName8"].ToString();
returnValue.fBirthday8 = DateTime.Parse(dr["FamilyBirthday8"].ToString()).ToString("yyyy-MM-dd");
returnValue.fEDU8 = dr["FamilyEducation8"].ToString();
returnValue.fProfession8 = dr["FamilyProfession8"].ToString();
returnValue.fLive8 = dr["FamilyLive8"].ToString();
returnValue.fHearing8 = dr["FamilyHearing8"].ToString();
returnValue.fHealthy8 = dr["FamilyHealth8"].ToString();
returnValue.familyText08 = dr["FamilyHealthText8"].ToString();
returnValue.lang1 = dr["FamilyLanguage"].ToString();
returnValue.lang1t01 = dr["FamilyLanguageText"].ToString();
returnValue.lang2 = dr["FamilyConnectLanguage"].ToString();
returnValue.lang2t01 = dr["FamilyConnectLanguageText"].ToString();
}
dr.Close();
Sqlconn.Close();
}
catch (Exception e)
{
returnValue.checkNo = "-1";
returnValue.errorMsg = e.Message.ToString();
}
}
return returnValue;
}
public StudentData2 getStudentDataBase2(string ID)
{
CaseDataBase SDB = new CaseDataBase();
StudentData2 returnValue = new StudentData2();
if (int.Parse(SDB._StaffhaveRoles[3]) == 1)
{
returnValue = SDB.getStudentData2(ID);
}
else
{
returnValue.checkNo = _noRole;
returnValue.errorMsg = _errorMsg;
}
return returnValue;
}
