private void OKButton_Click(object sender, EventArgs e)
{
opacityform = new OpacityForm();
darkeropacityform = new DarkerOpacityForm();
notificationwindow = new NotificationWindow();
//EXCEPTION 2
try
{
//SHOW VISUAL REPRESENTATION FOR EMPTY TEXTBOXES
Show_Hide_Visual_Representation_Labels();
if (ServerNameTextbox.Text.Length == 0 || DatabaseNameTextbox.Text.Length == 0 ||
SqlServerUsernameTextbox.Text.Length == 0 || SqlServerPasswordTextbox.Text.Length == 0)
{
notificationwindow.CaptionText = "CONNECTION REFUSED";
notificationwindow.MsgImage.Image = Properties.Resources.warning;
notificationwindow.MessageText = "PLEASE PROVIDE THE REQUIRED\nINFORMATIONS BEING ASK !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
}
else if (ServerNameTextbox.Text.EndsWith(" ") || DatabaseNameTextbox.Text.EndsWith(" ") ||
SqlServerUsernameTextbox.Text.EndsWith(" ") || SqlServerPasswordTextbox.Text.EndsWith(" "))
{
notificationwindow.CaptionText = "CONNECTION REFUSED";
notificationwindow.MsgImage.Image = Properties.Resources.error;
notificationwindow.MessageText = "LOGIN FAILED !\nPLEASE REVIEW YOUR INFORMATION.";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
}
else if (ServerNameTextbox.Text.Length != 0 && DatabaseNameTextbox.Text.Length != 0 &&
SqlServerUsernameTextbox.Text.Length != 0 && SqlServerPasswordTextbox.Text.Length != 0)
{
//INNER EXCEPTION 2
try
{
variables = new Variables();
cryptography = new Cryptography();
sqlconfig = new SQLConnectionConfig();
tempconnectionstring = "Data Source=" + ServerNameTextbox.Text + ";" + "Initial Catalog=" + DatabaseNameTextbox.Text + ";"
+ "Persist Security Info=True;" + "User ID=" + SqlServerUsernameTextbox.Text + ";" + "Password="******"";
sqlconfig.SqlConnectionString = tempconnectionstring;
sqlconnection = new SqlConnection(sqlconfig.SqlConnectionString);
do
{
Cursor = Cursors.AppStarting;
sqlconnection.Open();
if (sqlconnection.State == ConnectionState.Open)
{
//PLEASE CHANGE THIS CODE !
if (DatabaseNameTextbox.Text.Trim().Equals("BUKSU.SLS_DB"))
{
notificationwindow.CaptionText = "CONNECTION RESULTS";
notificationwindow.MsgImage.Image = Properties.Resources.check;
notificationwindow.MessageText = "YOU'RE ALL SET ! CONNECTION\nWAS SUCCESSFULY ESTABLISHED.";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
variables.UserSqlConnectionString = tempconnectionstring;
//INNER EXCEPTION 3
try
{
RegistryKey registrykey = Registry.CurrentUser.CreateSubKey(@variables.pathname);
registrykey.SetValue("SQLServerConnectionString", cryptography.Encrypt(tempconnectionstring));
}
catch (Exception exception)
{
opacityform.Show();
MessageBox.Show(exception.Message.ToString(), "@Server Connection Inner Exception 3",
MessageBoxButtons.OK, MessageBoxIcon.Error);
opacityform.Hide();
}
Cursor = Cursors.Default;
DialogResult = DialogResult.OK;
break;
}
else
{
notificationwindow.CaptionText = "CONNECTION RESULTS";
notificationwindow.MsgImage.Image = Properties.Resources.error;
notificationwindow.MessageText = "INVALID DATABASE - " + DatabaseNameTextbox.Text.Trim() +
"\nDATABASE DOES NOT CONTAIN ALL\nTHE TABLES NEEDED TO RUN THE SYSTEM !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
Cursor = Cursors.Default;
break;
}
}
}while (sqlconnection.State == ConnectionState.Closed);
sqlconnection.Close();
}
catch (Exception exception)
{
Cursor = Cursors.Default;
opacityform.Show();
MessageBox.Show(exception.Message.ToString(), "@Server Connection Inner Exception 2",
MessageBoxButtons.OK, MessageBoxIcon.Error);
opacityform.Hide();
}
}
}
catch (Exception exception)
{
opacityform.Show();
MessageBox.Show(exception.Message.ToString(), "@Server Connection Exception 2",
MessageBoxButtons.OK, MessageBoxIcon.Error);
opacityform.Hide();
}
}
private void SubmitButton_Click(object sender, EventArgs e)
{
//EXCEPTION 2
try
{
opacityform = new OpacityForm();
darkeropacityform = new DarkerOpacityForm();
notificationwindow = new NotificationWindow();
if (NewUsernameTextbox.Text.Trim().Length == 0 || ConfirmUsernameTextbox.Text.Trim().Length == 0)
{
notificationwindow.CaptionText = "MESSAGE CONTENT";
notificationwindow.MsgImage.Image = Properties.Resources.warning;
notificationwindow.MessageText = "PLEASE PROVIDE THE REQUIRED\nINFORMATIONS BEING ASK !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
}
else if (NewUsernameTextbox.Text.Trim().Equals(OldUsernameTextbox.Text.Trim()) ||
OldUsernameTextbox.Text.Trim().Equals(NewUsernameTextbox.Text.Trim()))
{
notificationwindow.CaptionText = "MESSAGE CONTENT";
notificationwindow.MsgImage.Image = Properties.Resources.warning;
notificationwindow.MessageText = "YOUR NEW USERNAME AND OLD ARE\nJUST THE SAME !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
}
else if (!NewUsernameTextbox.Text.Trim().Equals(ConfirmUsernameTextbox.Text.Trim()) ||
!ConfirmUsernameTextbox.Text.Trim().Equals(NewUsernameTextbox.Text.Trim()))
{
notificationwindow.CaptionText = "MESSAGE CONTENT";
notificationwindow.MsgImage.Image = Properties.Resources.warning;
notificationwindow.MessageText = "PLEASE CONFIRM YOUR NEW USERNAME !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
}
else if (NewUsernameTextbox.Text.Trim().Length != 0 && ConfirmUsernameTextbox.Text.Trim().Length != 0)
{
//INNER EXCEPTION 2
try
{
//CHECK IF THE NEW USERNAME IS ALREADY TAKEN BY ANOTHER USER
sqlquery2 = "SELECT COUNT(*) FROM [Tbl.Users] WHERE USERNAME = '******'";
sqldataadapter = new SqlDataAdapter(sqlquery2, sqlconnection);
DataTable datatable = new DataTable();
sqldataadapter.Fill(datatable);
//OPPS, USERNAME IS ALREADY TAKEN
if (datatable.Rows[0][0].ToString() == "1")
{
notificationwindow.CaptionText = "UPDATE WAS ABORTED !";
notificationwindow.MsgImage.Image = Properties.Resources.error;
notificationwindow.MessageText = "OPPS, USERNAME IS ALREADY TAKEN,\nTRY A DIFFERENT ONE !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
}
//F**K YEAH, USERNAME IS NOT YET TAKEN !!
else if (datatable.Rows[0][0].ToString() == "0")
{
//ERROR EXIST HERE.
sqlquery3 = "UPDATE [Tbl.Users] SET USERNAME = @username WHERE [USER ID] = '" + currentuserid + "'";
sqlcommand = new SqlCommand(sqlquery3, sqlconnection);
sqlcommand.Parameters.AddWithValue("@username", cryptography.Encrypt(ConfirmUsernameTextbox.Text.Trim()));
sqlcommand.ExecuteNonQuery();
notificationwindow.CaptionText = "SUCCESS !";
notificationwindow.MsgImage.Image = Properties.Resources.check;
notificationwindow.MessageText = "SUCCESSFULLY UPDATED !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
sqlconnection.Close();
DialogResult = DialogResult.OK;
}
}
catch (Exception exception)
{
opacityform.Show();
MessageBox.Show(exception.Message.ToString(), "@Change Username Form Inner Exception 2",
MessageBoxButtons.OK, MessageBoxIcon.Error);
opacityform.Hide();
}
}
}
catch (Exception exception)
{
opacityform.Show();
MessageBox.Show(exception.Message.ToString(), "@Change Username Form Exception 2",
MessageBoxButtons.OK, MessageBoxIcon.Error);
opacityform.Hide();
}
}
private void SubmitButton_Click(object sender, EventArgs e)
{
//EXCEPTION 2
try
{
opacityform = new OpacityForm();
darkeropacityform = new DarkerOpacityForm();
notificationwindow = new NotificationWindow();
if (NewPasswordTextbox.Text.Trim().Length == 0 || ConfirmPasswordTextbox.Text.Trim().Length == 0)
{
notificationwindow.CaptionText = "MESSAGE CONTENT";
notificationwindow.MsgImage.Image = Properties.Resources.warning;
notificationwindow.MessageText = "PLEASE PROVIDE THE REQUIRED\nINFORMATIONS BEING ASK !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
}
else if (OldPasswordTextbox.Text.Trim().Equals(NewPasswordTextbox.Text.Trim()) ||
NewPasswordTextbox.Text.Trim().Equals(OldPasswordTextbox.Text.Trim()))
{
notificationwindow.CaptionText = "MESSAGE CONTENT";
notificationwindow.MsgImage.Image = Properties.Resources.warning;
notificationwindow.MessageText = "YOUR NEW PASSWORD AND OLD ARE\nJUST THE SAME !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
}
else if (!NewPasswordTextbox.Text.Trim().Equals(ConfirmPasswordTextbox.Text.Trim()) ||
!ConfirmPasswordTextbox.Text.Trim().Equals(NewPasswordTextbox.Text.Trim()))
{
notificationwindow.CaptionText = "MESSAGE CONTENT";
notificationwindow.MsgImage.Image = Properties.Resources.warning;
notificationwindow.MessageText = "PLEASE CONFIRM YOUR NEW PASSWORD !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
}
else if (NewPasswordTextbox.Text.Trim().Length < 8 || ConfirmPasswordTextbox.Text.Trim().Length < 8)
{
notificationwindow.CaptionText = "MESSAGE CONTENT";
notificationwindow.MsgImage.Image = Properties.Resources.warning;
notificationwindow.MessageText = "YOUR PASSWORD IS TOO SHORT, MAKE IT\n8-CHARACTERS OR ABOVE LONG !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
}
else
{
//INNER EXCEPTION 2
try
{
//ERROR EXIST HERE.
sqlquery2 = "UPDATE [Tbl.Users] SET PASSWORD = @password WHERE [USER ID] = '" + currentuserid + "'";
sqlcommand = new SqlCommand(sqlquery2, sqlconnection);
sqlcommand.Parameters.AddWithValue("@password", cryptography.Encrypt(ConfirmPasswordTextbox.Text.Trim()));
sqlcommand.ExecuteNonQuery();
notificationwindow.CaptionText = "SUCCESS !";
notificationwindow.MsgImage.Image = Properties.Resources.check;
notificationwindow.MessageText = "SUCCESSFULLY UPDATED !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
sqlconnection.Close();
DialogResult = DialogResult.OK;
}
catch (Exception exception)
{
opacityform.Show();
MessageBox.Show(exception.Message.ToString(), "@Change Password Form Exception 2",
MessageBoxButtons.OK, MessageBoxIcon.Error);
opacityform.Hide();
}
}
}
catch (Exception exception)
{
opacityform.Show();
MessageBox.Show(exception.Message.ToString(), "@Change Password Form Exception 2",
MessageBoxButtons.OK, MessageBoxIcon.Error);
opacityform.Hide();
}
}
//SAVE DATA
private void bunifuFlatButton2_Click(object sender, EventArgs e)
{
try
{
//START WORKING STATE
SaveButton.Cursor = Cursors.AppStarting;
variables = new Variables();
cryptography = new Cryptography();
darkeropacityform = new DarkerOpacityForm();
notificationwindow = new NotificationWindow();
int _row = 0; Set_Refers();
foreach (DataRow row in datatable.Rows)
{
//VERIFY SECTION EXISTENSE
string VerifyQuery1 = "SELECT COUNT(*) FROM [Tbl.Sections] WHERE [SECTION NAME] = '" +
GridView.Rows[_row].Cells[11].Value.ToString().Trim().ToUpper() + "'";
sqldataadapter = new SqlDataAdapter(VerifyQuery1, sqlconnection);
DataTable VirtualTable1 = new DataTable();
sqldataadapter.Fill(VirtualTable1);
//VERIFY STUDENT REGISTRATION
string VerifyQuery2 = "SELECT COUNT(*) FROM [Tbl.Students] WHERE [FIRST NAME] = '" +
GridView.Rows[_row].Cells[3].Value.ToString().Trim() + "' AND [MIDDLE NAME] = '" + GridView.Rows[_row].Cells[4].Value.ToString().Trim() +
"' AND [LAST NAME] = '" + GridView.Rows[_row].Cells[5].Value.ToString().Trim() + "'";
sqldataadapter = new SqlDataAdapter(VerifyQuery2, sqlconnection);
DataTable VirtualTable2 = new DataTable();
sqldataadapter.Fill(VirtualTable2);
if (GridView.Rows[_row].Cells[0].Value.ToString().Trim() == "" || GridView.Rows[_row].Cells[1].Value.ToString().Trim() == "" ||
GridView.Rows[_row].Cells[2].Value.ToString().Trim() == "" || GridView.Rows[_row].Cells[3].Value.ToString().Trim() == "" ||
GridView.Rows[_row].Cells[4].Value.ToString().Trim() == "" || GridView.Rows[_row].Cells[5].Value.ToString().Trim() == "" ||
GridView.Rows[_row].Cells[6].Value.ToString().Trim() == "" || GridView.Rows[_row].Cells[7].Value.ToString().Trim() == "" ||
GridView.Rows[_row].Cells[8].Value.ToString().Trim() == "" || GridView.Rows[_row].Cells[9].Value.ToString().Trim() == "" ||
GridView.Rows[_row].Cells[10].Value.ToString().Trim() == "" || GridView.Rows[_row].Cells[11].Value.ToString().Trim() == "" ||
GridView.Rows[_row].Cells[12].Value.ToString().Trim() == "" || GridView.Rows[_row].Cells[13].Value.ToString().Trim() == "" ||
GridView.Rows[_row].Cells[14].Value.ToString().Trim() == "")
{
notificationwindow.CaptionText = "MESSAGE CONTENT";
notificationwindow.MsgImage.Image = Properties.Resources.warning;
notificationwindow.MessageText = "SOME CELL CONTAINS A NULL CHARACTER !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
Import_Student_Data_Begin = false;
break;
}
else if (VirtualTable1.Rows[0][0].ToString() == "0")
{
notificationwindow.CaptionText = "MESSAGE CONTENT";
notificationwindow.MsgImage.Image = Properties.Resources.warning;
notificationwindow.MessageText = "THERE IS UNKNOWN SECTION NAME !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
Import_Student_Data_Begin = false;
break;
}
else if (int.Parse(VirtualTable2.Rows[0][0].ToString()) > 0)
{
notificationwindow.CaptionText = "MESSAGE CONTENT";
notificationwindow.MsgImage.Image = Properties.Resources.warning;
notificationwindow.MessageText = "THERE ARE STUDENT ENTRY THAT IS\nALREADY REGISTERED !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
Import_Student_Data_Begin = false;
break;
}
else if (!GridView.Rows[_row].Cells[6].Value.ToString().ToUpper().Trim().Equals("MALE") &&
!GridView.Rows[_row].Cells[6].Value.ToString().ToUpper().Trim().Equals("FEMALE"))
{
notificationwindow.CaptionText = "MESSAGE CONTENT";
notificationwindow.MsgImage.Image = Properties.Resources.warning;
notificationwindow.MessageText = "THERE IS UNKNOWN GENDER TYPE !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
Import_Student_Data_Begin = false;
break;
}
else if (GridView.Rows[_row].Cells[9].Value.ToString().Trim().Length < 11 ||
GridView.Rows[_row].Cells[9].Value.ToString().Trim().Length > 11)
{
notificationwindow.CaptionText = "MESSAGE CONTENT";
notificationwindow.MsgImage.Image = Properties.Resources.warning;
notificationwindow.MessageText = "THERE IS INVALID MOBILE NUMBER !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
Import_Student_Data_Begin = false;
break;
}
else if (isNumber(GridView.Rows[_row].Cells[9].Value.ToString().Trim()) == false)
{
notificationwindow.CaptionText = "MESSAGE CONTENT";
notificationwindow.MsgImage.Image = Properties.Resources.warning;
notificationwindow.MessageText = "THERE IS MOBILE NUMBER THAT\nCONTAINS AN INVALID CHARACTER !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
Import_Student_Data_Begin = false;
break;
}
else if (!GridView.Rows[_row].Cells[10].Value.ToString().Trim().Contains("@") ||
!GridView.Rows[_row].Cells[10].Value.ToString().Trim().Contains(".com"))
{
notificationwindow.CaptionText = "MESSAGE CONTENT";
notificationwindow.MsgImage.Image = Properties.Resources.warning;
notificationwindow.MessageText = "THERE IS INVALID EMAIL ADDRESS !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
Import_Student_Data_Begin = false;
break;
}
else if (!GridView.Rows[_row].Cells[11].Value.ToString().ToUpper().Trim().Equals(ReferSectionName))
{
notificationwindow.CaptionText = "MESSAGE CONTENT";
notificationwindow.MsgImage.Image = Properties.Resources.error;
notificationwindow.MessageText = "SYSTEM CANNOT IMPORT MULTIPLE\nDIFFERENT SECTIONS AT ONE TIME !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
Import_Student_Data_Begin = false;
break;
}
else if (!GridView.Rows[_row].Cells[12].Value.ToString().ToUpper().Trim().Equals(ReferGradeLevelName))
{
notificationwindow.CaptionText = "MESSAGE CONTENT";
notificationwindow.MsgImage.Image = Properties.Resources.error;
notificationwindow.MessageText = "SYSTEM CANNOT IMPORT MULTIPLE\nDIFFERENT GRADE LEVEL AT ONE TIME !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
Import_Student_Data_Begin = false;
break;
}
else if (!GridView.Rows[_row].Cells[12].Value.ToString().ToUpper().Trim().Equals("GRADE 7") && !GridView.Rows[_row].Cells[12].Value.ToString().ToUpper().Trim().Equals("GRADE 8") &&
!GridView.Rows[_row].Cells[12].Value.ToString().ToUpper().Trim().Equals("GRADE 9") && !GridView.Rows[_row].Cells[12].Value.ToString().ToUpper().Trim().Equals("GRADE 10"))
{
notificationwindow.CaptionText = "MESSAGE CONTENT";
notificationwindow.MsgImage.Image = Properties.Resources.warning;
notificationwindow.MessageText = "THERE IS UNKNOWN GRADE LEVEL !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
Import_Student_Data_Begin = false;
break;
}
else if (EntryCount > int.Parse(Maximum_Students))
{
notificationwindow.CaptionText = "MESSAGE CONTENT";
notificationwindow.MsgImage.Image = Properties.Resources.error;
notificationwindow.MessageText = "STUDENT DATA EXCEEDS THE\nSECTION'S REGISTRATION LIMIT !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
Import_Student_Data_Begin = false;
break;
}
else
{
Import_Student_Data_Begin = true;
}
_row++;
}
//SHOW MESSAGE AFTER SUCCESSFULL IMPORT
if (Import_Student_Data_Begin == true)
{
int row = 0; Set_Refers();
foreach (DataRow rows in datatable.Rows)
{
string query2, query3, query4, query5, query6, query7, query8, query9, query10;
string FullName = GridView.Rows[row].Cells[5].Value.ToString().Trim() + ", " + GridView.Rows[row].Cells[3].Value.ToString().Trim() + " "
+ GridView.Rows[row].Cells[4].Value.ToString().Trim().Remove(1, GridView.Rows[row].Cells[4].Value.ToString().Trim().Length - 1) + ".";
//INSERT INTO STUDENTS TABLE
query2 = "INSERT INTO [Tbl.Students]([STUDENT ID], [USER ID], LRN, [FIRST NAME], [MIDDLE NAME], [LAST NAME], [GRADE LEVEL]," +
"SECTION, GENDER, [BIRTH DATE], [PRESENT ADDRESS], [PLACE OF BIRTH], [BLOOD TYPE], RELIGION, [INDIGINOUS GROUP]," +
"[EMAIL ADDRESS], [MOBILE NUMBER]) VALUES(@studentid, @userid, @lrn, @firstname, @middlename, @lastname, @gradelevel," +
"@section, @gender, @birthdate, @presentaddress, @placeofbirth, @bloodtype, @religion, @indiginousgroup, @emailaddress," +
"@mobilenumber)";
sqlcommand = new SqlCommand(query2, sqlconnection);
sqlcommand.Parameters.AddWithValue("@studentid", GridView.Rows[row].Cells[0].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@userid", GridView.Rows[row].Cells[1].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@lrn", GridView.Rows[row].Cells[2].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@firstname", GridView.Rows[row].Cells[3].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@middlename", GridView.Rows[row].Cells[4].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@lastname", GridView.Rows[row].Cells[5].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@gradelevel", GridView.Rows[row].Cells[12].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@section", GridView.Rows[row].Cells[11].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@gender", GridView.Rows[row].Cells[6].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@birthdate", GridView.Rows[row].Cells[7].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@presentaddress", GridView.Rows[row].Cells[8].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@placeofbirth", "");
sqlcommand.Parameters.AddWithValue("@bloodtype", "");
sqlcommand.Parameters.AddWithValue("@religion", "");
sqlcommand.Parameters.AddWithValue("@indiginousgroup", "");
sqlcommand.Parameters.AddWithValue("@emailaddress", GridView.Rows[row].Cells[10].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@mobilenumber", GridView.Rows[row].Cells[9].Value.ToString().Trim());
sqlcommand.ExecuteNonQuery();
//INSERT INTO FAMILY BACKGROUND TABLE
query3 = "INSERT INTO [Tbl.FamilyBackgrounds]([STUDENT ID], [FATHERS NAME], [FATHERS OCCUPATION], [FATHERS CONTACT NUMBER]," +
"[FATHERS ADDRESS], [MOTHERS NAME], [MOTHERS OCCUPATION], [MOTHERS CONTACT NUMBER], [MOTHERS ADDRESS]) VALUES(@studentid," +
"@fathersname, @fatheroccupation, @fathersnumber, @fathersaddress, @mothername, @motheroccupation, @mothernumber, @motheraddress)";
sqlcommand = new SqlCommand(query3, sqlconnection);
sqlcommand.Parameters.AddWithValue("@studentid", GridView.Rows[row].Cells[0].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@fathersname", "");
sqlcommand.Parameters.AddWithValue("@fatheroccupation", "");
sqlcommand.Parameters.AddWithValue("@fathersnumber", "");
sqlcommand.Parameters.AddWithValue("@fathersaddress", "");
sqlcommand.Parameters.AddWithValue("@mothername", "");
sqlcommand.Parameters.AddWithValue("@motheroccupation", "");
sqlcommand.Parameters.AddWithValue("@mothernumber", "");
sqlcommand.Parameters.AddWithValue("@motheraddress", "");
sqlcommand.ExecuteNonQuery();
//INSERT INTO USERS TABLE
query4 = "INSERT INTO [Tbl.Users]([USER ID], USERNAME, PASSWORD, [ACCOUNT STATUS], [ACCOUNT TYPE], [LAST LOGIN]," +
"[IS PWD CHANGED], [SITUATION STATUS]) VALUES(@userid, @username, @password, @accountstatus, @account_type, @last_login, @ispwdchanged, @stat)";
sqlcommand = new SqlCommand(query4, sqlconnection);
sqlcommand.Parameters.AddWithValue("@userid", GridView.Rows[row].Cells[1].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@username", cryptography.Encrypt(GridView.Rows[row].Cells[13].Value.ToString().Trim()));
sqlcommand.Parameters.AddWithValue("@password", cryptography.Encrypt(GridView.Rows[row].Cells[14].Value.ToString().Trim()));
sqlcommand.Parameters.AddWithValue("@accountstatus", "Active");
sqlcommand.Parameters.AddWithValue("@account_type", "Student");
sqlcommand.Parameters.AddWithValue("@last_login", "NO LOGIN HISTORY");
sqlcommand.Parameters.AddWithValue("@ispwdchanged", "False");
sqlcommand.Parameters.AddWithValue("@stat", "0");
sqlcommand.ExecuteNonQuery();
//UPDATE SECTIONS TABLE --> ENROLLED
query5 = "UPDATE [Tbl.Sections] SET ENROLLED = @enrolled WHERE [SECTION NAME] = @section_nane" +
" AND [SCHOOL YEAR] = '" + CurrentSchoolYear + "'";
sqlcommand = new SqlCommand(query5, sqlconnection);
sqlcommand.Parameters.AddWithValue("@enrolled", (long.Parse(Enrolled_Students) + 1).ToString());
sqlcommand.Parameters.AddWithValue("@section_nane", GridView.Rows[row].Cells[11].Value.ToString().Trim());
sqlcommand.ExecuteNonQuery();
//INSERT INTO STUDENT LOAD TABLE --> 1st Grading
query6 = "INSERT INTO [Tbl.FirstGradingStudentLoad]([STUDENT ID], [STUDENT NAME], GENDER, [GRADE LEVEL], SECTION," +
"FILIPINO, ENGLISH, MATHEMATICS, SCIENCE, AP, TLE, MAPEH, ESP, [SCHOOL YEAR]) VALUES(@studentid1g, @studentname1g," +
"@gender1g, @gradelevel1g, @section1g, @sb11g, @sb21g, @sb31g, @sb41g, @sb51g, @sb61g, @sb71g, @sb81g, @schoolyear1g)";
sqlcommand = new SqlCommand(query6, sqlconnection);
sqlcommand.Parameters.AddWithValue("@studentid1g", GridView.Rows[row].Cells[0].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@studentname1g", FullName);
sqlcommand.Parameters.AddWithValue("@gender1g", GridView.Rows[row].Cells[6].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@gradelevel1g", GridView.Rows[row].Cells[12].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@section1g", GridView.Rows[row].Cells[11].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@sb11g", "");
sqlcommand.Parameters.AddWithValue("@sb21g", "");
sqlcommand.Parameters.AddWithValue("@sb31g", "");
sqlcommand.Parameters.AddWithValue("@sb41g", "");
sqlcommand.Parameters.AddWithValue("@sb51g", "");
sqlcommand.Parameters.AddWithValue("@sb61g", "");
sqlcommand.Parameters.AddWithValue("@sb71g", "");
sqlcommand.Parameters.AddWithValue("@sb81g", "");
sqlcommand.Parameters.AddWithValue("@schoolyear1g", CurrentSchoolYear);
sqlcommand.ExecuteNonQuery();
//INSERT INTO STUDENT LOAD TABLE --> 2nd Grading
query7 = "INSERT INTO [Tbl.SecondGradingStudentLoad]([STUDENT ID], [STUDENT NAME], GENDER, [GRADE LEVEL], SECTION," +
"FILIPINO, ENGLISH, MATHEMATICS, SCIENCE, AP, TLE, MAPEH, ESP, [SCHOOL YEAR]) VALUES(@studentid2g, @studentname2g," +
"@gender2g, @gradelevel2g, @section2g, @sb12g, @sb22g, @sb32g, @sb42g, @sb52g, @sb62g, @sb72g, @sb82g, @schoolyear2g)";
sqlcommand = new SqlCommand(query7, sqlconnection);
sqlcommand.Parameters.AddWithValue("@studentid2g", GridView.Rows[row].Cells[0].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@studentname2g", FullName);
sqlcommand.Parameters.AddWithValue("@gender2g", GridView.Rows[row].Cells[6].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@gradelevel2g", GridView.Rows[row].Cells[12].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@section2g", GridView.Rows[row].Cells[11].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@sb12g", "");
sqlcommand.Parameters.AddWithValue("@sb22g", "");
sqlcommand.Parameters.AddWithValue("@sb32g", "");
sqlcommand.Parameters.AddWithValue("@sb42g", "");
sqlcommand.Parameters.AddWithValue("@sb52g", "");
sqlcommand.Parameters.AddWithValue("@sb62g", "");
sqlcommand.Parameters.AddWithValue("@sb72g", "");
sqlcommand.Parameters.AddWithValue("@sb82g", "");
sqlcommand.Parameters.AddWithValue("@schoolyear2g", CurrentSchoolYear);
sqlcommand.ExecuteNonQuery();
//INSERT INTO STUDENT LOAD TABLE --> 3rd Grading
query8 = "INSERT INTO [Tbl.ThirdGradingStudentLoad]([STUDENT ID], [STUDENT NAME], GENDER, [GRADE LEVEL], SECTION," +
"FILIPINO, ENGLISH, MATHEMATICS, SCIENCE, AP, TLE, MAPEH, ESP, [SCHOOL YEAR]) VALUES(@studentid3g, @studentname3g," +
"@gender3g, @gradelevel3g, @section3g, @sb13g, @sb23g, @sb33g, @sb43g, @sb53g, @sb63g, @sb73g, @sb83g, @schoolyear3g)";
sqlcommand = new SqlCommand(query8, sqlconnection);
sqlcommand.Parameters.AddWithValue("@studentid3g", GridView.Rows[row].Cells[0].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@studentname3g", FullName);
sqlcommand.Parameters.AddWithValue("@gender3g", GridView.Rows[row].Cells[6].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@gradelevel3g", GridView.Rows[row].Cells[12].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@section3g", GridView.Rows[row].Cells[11].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@sb13g", "");
sqlcommand.Parameters.AddWithValue("@sb23g", "");
sqlcommand.Parameters.AddWithValue("@sb33g", "");
sqlcommand.Parameters.AddWithValue("@sb43g", "");
sqlcommand.Parameters.AddWithValue("@sb53g", "");
sqlcommand.Parameters.AddWithValue("@sb63g", "");
sqlcommand.Parameters.AddWithValue("@sb73g", "");
sqlcommand.Parameters.AddWithValue("@sb83g", "");
sqlcommand.Parameters.AddWithValue("@schoolyear3g", CurrentSchoolYear);
sqlcommand.ExecuteNonQuery();
//INSERT INTO STUDENT LOAD TABLE --> 4rth Grading
query9 = "INSERT INTO [Tbl.FourthGradingStudentLoad]([STUDENT ID], [STUDENT NAME], GENDER, [GRADE LEVEL], SECTION," +
"FILIPINO, ENGLISH, MATHEMATICS, SCIENCE, AP, TLE, MAPEH, ESP, [SCHOOL YEAR]) VALUES(@studentid4g, @studentname4g," +
"@gender4g, @gradelevel4g, @section4g, @sb14g, @sb24g, @sb34g, @sb44g, @sb54g, @sb64g, @sb74g, @sb84g, @schoolyear4g)";
sqlcommand = new SqlCommand(query9, sqlconnection);
sqlcommand.Parameters.AddWithValue("@studentid4g", GridView.Rows[row].Cells[0].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@studentname4g", FullName);
sqlcommand.Parameters.AddWithValue("@gender4g", GridView.Rows[row].Cells[6].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@gradelevel4g", GridView.Rows[row].Cells[12].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@section4g", GridView.Rows[row].Cells[11].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@sb14g", "");
sqlcommand.Parameters.AddWithValue("@sb24g", "");
sqlcommand.Parameters.AddWithValue("@sb34g", "");
sqlcommand.Parameters.AddWithValue("@sb44g", "");
sqlcommand.Parameters.AddWithValue("@sb54g", "");
sqlcommand.Parameters.AddWithValue("@sb64g", "");
sqlcommand.Parameters.AddWithValue("@sb74g", "");
sqlcommand.Parameters.AddWithValue("@sb84g", "");
sqlcommand.Parameters.AddWithValue("@schoolyear4g", CurrentSchoolYear);
sqlcommand.ExecuteNonQuery();
//INSERT INTO [Tbl.StudentAverages]
query10 = "INSERT INTO [Tbl.StudentAverages]([STUDENT ID], [STUDENT NAME], LRN, [GRADE LEVEL], SECTION, " +
"[FIRST GRADING], [SECOND GRADING], [THIRD GRADING], [FOURTH GRADING], GPA, [SCHOOL YEAR]) " +
"VALUES(@sid, @studname, @lrn, @glevel, @section, @fga, @sga, @tga, @ffga, @gpa, @schoolyear)";
sqlcommand = new SqlCommand(query10, sqlconnection);
sqlcommand.Parameters.AddWithValue("@sid", GridView.Rows[row].Cells[0].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@studname", FullName);
sqlcommand.Parameters.AddWithValue("@lrn", GridView.Rows[row].Cells[2].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@glevel", GridView.Rows[row].Cells[12].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@section", GridView.Rows[row].Cells[11].Value.ToString().Trim());
sqlcommand.Parameters.AddWithValue("@fga", "");
sqlcommand.Parameters.AddWithValue("@sga", "");
sqlcommand.Parameters.AddWithValue("@tga", "");
sqlcommand.Parameters.AddWithValue("@ffga", "");
sqlcommand.Parameters.AddWithValue("@gpa", "");
sqlcommand.Parameters.AddWithValue("@schoolyear", CurrentSchoolYear);
sqlcommand.ExecuteNonQuery();
isSuccessfull = true;
row++;
}
}
if (isSuccessfull == true)
{
notificationwindow.CaptionText = "REGISTRATION SUCCESS !";
notificationwindow.MsgImage.Image = Properties.Resources.check;
notificationwindow.MessageText = "ALL DATA WAS SAVED SUCCESSFULLY !";
darkeropacityform.Show();
notificationwindow.ShowDialog();
darkeropacityform.Hide();
DialogResult = DialogResult.OK;
}
//STOP WORKING STATE
SaveButton.Cursor = Cursors.Default;
}
catch (Exception)
{
//DON'T DO ANYTHING BITCH !
}
}
