private void button1_Click_1(object sender, EventArgs e)
{
Manage_Student ms = new Manage_Student();
this.Hide();
ms.Show();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(conStr);
SqlCommand checkExist = new SqlCommand("select count(*) from Student where RegistrationNo=@registrationNo", con);
checkExist.Parameters.AddWithValue("@registrationNo", txtRegNo.Text);
// checkExist.CommandType = System.Data.CommandType.Text;
con.Open();
int asdas = (int)checkExist.ExecuteScalar();
if (txtRegNo.Text == "" || txtFName.Text == "" || txtLName.Text == "" || txtContact.Text == "" || txtEmail.Text == "" || txtGender.Text == "")
{
label8.Visible = true;
label8.Text = "Please fill the Required Field....";
}
else if (txtRegNo.Text.Count() != 11 || txtRegNo.Text.Split('-')[0].Any(char.IsLetter) || txtRegNo.Text[4] != '-' ||
txtRegNo.Text[5] != 'C' || txtRegNo.Text[6] != 'S' || txtRegNo.Text[7] != '-')
{
txtRegNo.Focus();
label8.Visible = true;
label8.Text = "i.e 2016-CS-315";
}
else if (txtContact.Text.Count() != 12 || txtContact.Text[4] != '-' || txtContact.Text.Any(char.IsLetter) == true)
{
label8.Text = "";
txtContact.Focus();
lbContact.Text = "i.e 0123-3456789";
lbContact.ForeColor = Color.Red;
}
else if (isEdit)
{
//if (asdas > 0)
//{
// label8.Visible = true;
// label8.Text = "Registration No already exist";
//}
//else
//{
string update = string.Format("update Person set FirstName='{0}', LastName='{1}', Contact='{2}',Email='{3}',DateOfBirth='{4}', Gender=(select Id from Lookup where Value='{5}') where Id='{6}'", txtFName.Text, txtLName.Text, txtContact.Text, txtEmail.Text, Convert.ToDateTime(txtDOB.Value), txtGender.Text, id);
DatabaseConnection.getInstance().executeQuery(update);
string updateStudent = string.Format("update Student set RegistrationNo='{0}' where Id='{1}'", txtRegNo.Text, id);
DatabaseConnection.getInstance().executeQuery(updateStudent);
MessageBox.Show("Data Updated Successfully...");
txtRegNo.Text = ""; txtFName.Text = ""; txtLName.Text = ""; txtContact.Text = ""; txtEmail.Text = ""; txtGender.Text = ""; label8.Text = "";
Manage_Student ms = new Manage_Student();
this.Hide();
ms.Show();
//}
}
else if (asdas > 0)
{
label8.Visible = true;
label8.Text = "Registration No already exist";
con.Close();
}
else
{
try
{
string countMaxId = string.Format("select max(Id) from Person");
var re = DatabaseConnection.getInstance().readData(countMaxId);
int count = 0;
while (re.Read())
{
count = re.GetInt32(0);
}
string query = string.Format("insert into Person(FirstName,LastName,Contact,Email,DateOfBirth,Gender) values('{0}','{1}','{2}','{3}','{4}',(select Id from Lookup where Value='{5}'))", txtFName.Text, txtLName.Text, txtContact.Text, txtEmail.Text, Convert.ToDateTime(txtDOB.Value), txtGender.Text);
DatabaseConnection.getInstance().executeQuery(query);
string qwrt = "insert into Student(Id, RegistrationNo) values('" + (count + 1) + "','" + txtRegNo.Text + "')";
DatabaseConnection.getInstance().executeQuery(qwrt);
MessageBox.Show("Data Inserted Successfully!");
txtRegNo.Text = ""; txtFName.Text = ""; txtLName.Text = ""; txtContact.Text = ""; txtEmail.Text = ""; txtGender.Text = ""; label8.Text = "";
Manage_Student ms = new Manage_Student();
this.Hide();
ms.Show();
}
catch
{
int count = 1;
string query = string.Format("insert into Person(FirstName,LastName,Contact,Email,DateOfBirth,Gender) values('{0}','{1}','{2}','{3}','{4}',(select Id from Lookup where Value='{5}'))", txtFName.Text, txtLName.Text, txtContact.Text, txtEmail.Text, Convert.ToDateTime(txtDOB.Value), txtGender.Text);
DatabaseConnection.getInstance().executeQuery(query);
string qwrt = "insert into Student(Id, RegistrationNo) values('" + count + "','" + txtRegNo.Text + "')";
DatabaseConnection.getInstance().executeQuery(qwrt);
MessageBox.Show("Data Inserted Successfully!");
txtRegNo.Text = ""; txtFName.Text = ""; txtLName.Text = ""; txtContact.Text = ""; txtEmail.Text = ""; txtGender.Text = ""; label8.Text = "";
Manage_Student ms = new Manage_Student();
this.Hide();
ms.Show();
}
}
}