public override int GetHashCode()
{
unchecked {
const int randomPrime = 397;
int hashCode = Id.GetHashCode();
hashCode = (hashCode * randomPrime) ^ SourceTypeID.GetHashCode();
hashCode = (hashCode * randomPrime) ^ SourceId.GetHashCode();
hashCode = (hashCode * randomPrime) ^ (Name_Latin != null ? Name_Latin.GetHashCode() : 0);
hashCode = (hashCode * randomPrime) ^ (FamilyName_Latin != null ? FamilyName_Latin.GetHashCode() : 0);
hashCode = (hashCode * randomPrime) ^ (Name_Cyrillic != null ? Name_Cyrillic.GetHashCode() : 0);
hashCode = (hashCode * randomPrime) ^ (FamilyName_Cyrillic != null ? FamilyName_Cyrillic.GetHashCode() : 0);
hashCode = (hashCode * randomPrime) ^ (Sex != null ? Sex.GetHashCode() : 0);
hashCode = (hashCode * randomPrime) ^ (FatherName != null ? FatherName.GetHashCode() : 0);
hashCode = (hashCode * randomPrime) ^ (DateOfBirth != null ? DateOfBirth.GetHashCode() : 0);
hashCode = (hashCode * randomPrime) ^ (Citizenship != null ? Citizenship.GetHashCode() : 0);
hashCode = (hashCode * randomPrime) ^ (PlaceOfBirthId != null ? PlaceOfBirthId.GetHashCode() : 0);
hashCode = (hashCode * randomPrime) ^ (PlaceOfEmigrationId != null ? PlaceOfEmigrationId.GetHashCode() : 0);
hashCode = (hashCode * randomPrime) ^ (PlaceOfLivingId != null ? PlaceOfLivingId.GetHashCode() : 0);
hashCode = (hashCode * randomPrime) ^ (FatherId != null ? FatherId.GetHashCode() : 0);
hashCode = (hashCode * randomPrime) ^ (MotherId != null ? MotherId.GetHashCode() : 0);
hashCode = (hashCode * randomPrime) ^ (MaritalStatus != null ? MaritalStatus.GetHashCode() : 0);
hashCode = (hashCode * randomPrime) ^ (PartnerId != null ? PartnerId.GetHashCode() : 0);
hashCode = (hashCode * randomPrime) ^ (Profession != null ? Profession.GetHashCode() : 0);
hashCode = (hashCode * randomPrime) ^ (Notice != null ? Notice.GetHashCode() : 0);
hashCode = (hashCode * randomPrime) ^ (PhotoNumber != null ? PhotoNumber.GetHashCode() : 0);
return(hashCode);
}
}
private void FatherName_Enter(object sender, EventArgs e)
{
if (FatherName.Text.Equals("Father's Name"))
{
FatherName.Clear();
}
}
//Deserializes the JSON file in the path 'fatherNamePath'. Can be used to deserialize all data, not just the father one
public static void deserializeJson() //Possibly find a way to make it generic so you can use it to deserialize any JSON
{
string fJsonString = Resources.Load <TextAsset>("FatherNames").ToString(); //With Resources.Load<>() you only need the filepath from within /Resources
string mJsonString = Resources.Load <TextAsset>("MotherNames").ToString();
string nJsonString = Resources.Load <TextAsset>("Nicknames").ToString();
FatherName fNameCollection = JsonConvert.DeserializeObject <FatherName>(fJsonString);
MotherName mNameCollection = JsonConvert.DeserializeObject <MotherName>(mJsonString);
ParentNickname nNameCollection = JsonConvert.DeserializeObject <ParentNickname>(nJsonString);
//Put them into persistent data
ParentData.parentData.fatherFirstNames = fNameCollection.firstNames;
ParentData.parentData.fatherLastNames = fNameCollection.lastNames;
ParentData.parentData.motherFirstNames = mNameCollection.firstNames;
ParentData.parentData.strengthNicknames = nNameCollection.nicknames[0].nicknames;
ParentData.parentData.agilityNicknames = nNameCollection.nicknames[1].nicknames;
ParentData.parentData.willNicknames = nNameCollection.nicknames[2].nicknames;
ParentData.parentData.fortitudeNicknames = nNameCollection.nicknames[3].nicknames;
}
private void btnSave_Click(object sender, EventArgs e)
{
if (Gender.Text == "")
{
MessageBox.Show("Please select gender", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Gender.Focus();
return;
}
if (Category.Text == "")
{
MessageBox.Show("Please select Category", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Category.Focus();
return;
}
if (FatherName.Text == "")
{
MessageBox.Show("Please enter father's name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
FatherName.Focus();
return;
}
if (Session.Text == "")
{
MessageBox.Show("Please enter session", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Session.Focus();
return;
}
if (DOB.Text == "")
{
MessageBox.Show("Please enter dob", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
DOB.Focus();
return;
}
if (MotherName.Text == "")
{
MessageBox.Show("Please enter mother's name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
MotherName.Focus();
return;
}
if (Religion.Text == "")
{
MessageBox.Show("Please select religion", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Religion.Focus();
return;
}
if (Address.Text == "")
{
MessageBox.Show("Please select address", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Address.Focus();
return;
}
if (Address.Text == "")
{
MessageBox.Show("Please enter address", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Address.Focus();
return;
}
if (ContactNo.Text == "")
{
MessageBox.Show("Please enter contact no.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
ContactNo.Focus();
return;
}
if (Email.Text == "")
{
MessageBox.Show("Please enter email", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Email.Focus();
return;
}
if (Course.Text == "")
{
MessageBox.Show("Please select course", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Course.Focus();
return;
}
if (Branch.Text == "")
{
MessageBox.Show("Please select branch", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Branch.Focus();
return;
}
if (DocumentSubmitted.Text == "")
{
MessageBox.Show("Please enter submitted documents", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
DocumentSubmitted.Focus();
return;
}
if (Nationality.Text == "")
{
MessageBox.Show("Please enter nationality", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
Nationality.Focus();
return;
}
auto();
try
{
con = new SqlConnection(cs.DBConn);
con.Open();
string ct = "select Admission_No from studentRegistration where Admission_No=@find";
cmd = new SqlCommand(ct);
cmd.Connection = con;
cmd.Parameters.Add(new SqlParameter("@find", System.Data.SqlDbType.NChar, 20, "AdmissionNo"));
cmd.Parameters["@find"].Value = AdmissionNo.Text;
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
MessageBox.Show("Admission No. Already Exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
AdmissionNo.Text = "";
if ((rdr != null))
{
rdr.Close();
}
return;
}
con = new SqlConnection(cs.DBConn);
con.Open();
string cb = "insert into studentRegistration(Student_name,Admission_No,DateOfAdmission,Fathers_Name,Gender,DOB,Address,Session,Contact_No,Email,Course,Branch,Submitted_Documents,Nationality,GuardianName,GuardianContactNo,GuardianAddress,High_School_name,HS_Year_of_passing,HS_Percentage,HS_Board,Higher_secondary_Name,H_year_of_passing,H_percentage,H_board,Graduation,G_year_of_passing,G_percentage,G_University,Post_graduation,PG_year_of_passing,PG_percentage,PG_university,mother_name,religion,category) VALUES (@d2,@d3,@d4,@d6,@d7,@d8,@d9,@d10,@d11,@d12,@d13,@d14,@d15,@d16,@d17,@d18,@d19,@d20,@d21,@d22,@d23,@d24,@d25,@d26,@d27,@d28,@d29,@d30,@d31,@d32,@d33,@d34,@d35,@d36,@d37,@d38)";
cmd = new SqlCommand(cb);
cmd.Connection = con;
if (UG.SelectedIndex == -1)
{
UG.Text = "";
}
if (PG.SelectedIndex == -1)
{
PG.Text = "";
}
cmd.Parameters.Add(new SqlParameter("@d2", System.Data.SqlDbType.NChar, 30, "Student_name"));
cmd.Parameters.Add(new SqlParameter("@d3", System.Data.SqlDbType.NChar, 15, "Admission_No"));
cmd.Parameters.Add(new SqlParameter("@d4", System.Data.SqlDbType.NChar, 30, "DateOfAdmission"));
cmd.Parameters.Add(new SqlParameter("@d6", System.Data.SqlDbType.NChar, 30, "Fathers_Name"));
cmd.Parameters.Add(new SqlParameter("@d7", System.Data.SqlDbType.NChar, 10, "Gender"));
cmd.Parameters.Add(new SqlParameter("@d8", System.Data.SqlDbType.NChar, 15, "DOB"));
cmd.Parameters.Add(new SqlParameter("@d9", System.Data.SqlDbType.NChar, 50, "Address"));
cmd.Parameters.Add(new SqlParameter("@d10", System.Data.SqlDbType.NChar, 10, "Session"));
cmd.Parameters.Add(new SqlParameter("@d11", System.Data.SqlDbType.NChar, 10, "Contact_No"));
cmd.Parameters.Add(new SqlParameter("@d12", System.Data.SqlDbType.NChar, 30, "Email"));
cmd.Parameters.Add(new SqlParameter("@d13", System.Data.SqlDbType.NChar, 30, "Course"));
cmd.Parameters.Add(new SqlParameter("@d14", System.Data.SqlDbType.NChar, 30, "Branch"));
cmd.Parameters.Add(new SqlParameter("@d15", System.Data.SqlDbType.VarChar, 250, "Submitted_Documents"));
cmd.Parameters.Add(new SqlParameter("@d16", System.Data.SqlDbType.NChar, 20, "Nationality"));
cmd.Parameters.Add(new SqlParameter("@d17", System.Data.SqlDbType.NChar, 30, "GuardianName"));
cmd.Parameters.Add(new SqlParameter("@d18", System.Data.SqlDbType.NChar, 10, "GuardianContactNo"));
cmd.Parameters.Add(new SqlParameter("@d19", System.Data.SqlDbType.NChar, 50, "GuardianAddress"));
cmd.Parameters.Add(new SqlParameter("@d20", System.Data.SqlDbType.NChar, 30, "High_School_name"));
cmd.Parameters.Add(new SqlParameter("@d21", System.Data.SqlDbType.NChar, 10, "HS_Year_of_passing"));
cmd.Parameters.Add(new SqlParameter("@d22", System.Data.SqlDbType.NChar, 10, "HS_Percentage"));
cmd.Parameters.Add(new SqlParameter("@d23", System.Data.SqlDbType.NChar, 30, "HS_Board"));
cmd.Parameters.Add(new SqlParameter("@d24", System.Data.SqlDbType.NChar, 30, "Higher_secondary_Name"));
cmd.Parameters.Add(new SqlParameter("@d25", System.Data.SqlDbType.NChar, 10, "H_year_of_passing"));
cmd.Parameters.Add(new SqlParameter("@d26", System.Data.SqlDbType.NChar, 10, "H_percentage"));
cmd.Parameters.Add(new SqlParameter("@d27", System.Data.SqlDbType.NChar, 30, "H_board"));
cmd.Parameters.Add(new SqlParameter("@d28", System.Data.SqlDbType.NChar, 30, "Graduation"));
cmd.Parameters.Add(new SqlParameter("@d29", System.Data.SqlDbType.NChar, 10, "G_year_of_passing"));
cmd.Parameters.Add(new SqlParameter("@d30", System.Data.SqlDbType.NChar, 10, "G_percentage"));
cmd.Parameters.Add(new SqlParameter("@d31", System.Data.SqlDbType.NChar, 30, "G_University"));
cmd.Parameters.Add(new SqlParameter("@d32", System.Data.SqlDbType.NChar, 30, "Post_graduation"));
cmd.Parameters.Add(new SqlParameter("@d33", System.Data.SqlDbType.NChar, 10, "PG_year_of_passing"));
cmd.Parameters.Add(new SqlParameter("@d34", System.Data.SqlDbType.NChar, 10, "PG_percentage"));
cmd.Parameters.Add(new SqlParameter("@d35", System.Data.SqlDbType.NChar, 30, "PG_university"));
cmd.Parameters.Add(new SqlParameter("@d36", System.Data.SqlDbType.NChar, 30, "mother_name"));
cmd.Parameters.Add(new SqlParameter("@d37", System.Data.SqlDbType.NChar, 30, "religion"));
cmd.Parameters.Add(new SqlParameter("@d38", System.Data.SqlDbType.NChar, 15, "category"));
cmd.Parameters["@d2"].Value = StudentName.Text.Trim();
cmd.Parameters["@d3"].Value = AdmissionNo.Text.Trim();
cmd.Parameters["@d4"].Value = DateOfAdmission.Text.Trim();
cmd.Parameters["@d6"].Value = FatherName.Text.Trim();
cmd.Parameters["@d7"].Value = Gender.Text.Trim();
cmd.Parameters["@d8"].Value = DOB.Text.Trim();
cmd.Parameters["@d9"].Value = Address.Text.Trim();
cmd.Parameters["@d10"].Value = Session.Text.Trim();
cmd.Parameters["@d11"].Value = ContactNo.Text.Trim();
cmd.Parameters["@d12"].Value = Email.Text.Trim();
cmd.Parameters["@d13"].Value = Course.Text.Trim();
cmd.Parameters["@d14"].Value = Branch.Text.Trim();
cmd.Parameters["@d15"].Value = DocumentSubmitted.Text.Trim();
cmd.Parameters["@d16"].Value = Nationality.Text.Trim();
cmd.Parameters["@d17"].Value = GuardianName.Text.Trim();
cmd.Parameters["@d18"].Value = GuardianContactNo.Text.Trim();
cmd.Parameters["@d19"].Value = GuardianAddress.Text.Trim();
cmd.Parameters["@d20"].Value = HS.Text.Trim();
cmd.Parameters["@d21"].Value = HSYOP.Text.Trim();
cmd.Parameters["@d22"].Value = HSPercentage.Text.Trim();
cmd.Parameters["@d23"].Value = HSBoard.Text.Trim();
cmd.Parameters["@d24"].Value = HSS.Text.Trim();
cmd.Parameters["@d25"].Value = HSSYOP.Text.Trim();
cmd.Parameters["@d26"].Value = HSSPercentage.Text.Trim();
cmd.Parameters["@d27"].Value = HSSBoard.Text.Trim();
cmd.Parameters["@d28"].Value = UG.Text.Trim();
cmd.Parameters["@d29"].Value = GYOP.Text.Trim();
cmd.Parameters["@d30"].Value = GPercentage.Text.Trim();
cmd.Parameters["@d31"].Value = GUniy.Text.Trim();
cmd.Parameters["@d32"].Value = PG.Text.Trim();
cmd.Parameters["@d33"].Value = PGYOP.Text.Trim();
cmd.Parameters["@d34"].Value = PGpercentage.Text.Trim();
cmd.Parameters["@d35"].Value = PGUniy.Text.Trim();
cmd.Parameters["@d36"].Value = MotherName.Text.Trim();
cmd.Parameters["@d37"].Value = Religion.Text.Trim();
cmd.Parameters["@d38"].Value = Category.Text.Trim();
cmd.ExecuteNonQuery();
MessageBox.Show("Successfully Resistered", "Student", MessageBoxButtons.OK, MessageBoxIcon.Information);
btnSave.Enabled = false;
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void FatherName_Click(object sender, EventArgs e)
{
FatherName.Clear();
}
