private void saveup_Click(object sender, EventArgs e)
{
Student p = new Student();
Regexp(@"^[a-zA-Z]{1,100}", firstnameTxtBox, stufName, "First name");
Regexp(@"^[a-zA-Z]{1,100}", stulastnametext, lastnamestu, "Last name");
Regexp(@"^[0-9]{1,20}", stucontacttext, stucontact, "Contact");
Regexp(@"^([\\w\\.\\-]+)@([\\w\\-]+)((\\.(\\w){2,3})+)$", stuemailtext, stuemail, "Email");
Regexp(@"^[0-9]{4}-[A-Z]{2,3}-[0-9]{1,3}$", regtext, label2, "Registration Number");
p.FirstName = firstnameTxtBox.Text;
p.LastName = stulastnametext.Text;
p.Contact = stucontacttext.Text;
p.Email = stuemailtext.Text;
p.DateOfBirth = dobstu.Value;
p.RegistrationNumber = regtext.Text;
String cmd = String.Format("Select Id from Lookup Where Value = '{0}'", stugendercombo.Text);
SqlCommand a = new SqlCommand(cmd, DatabaseConnection.getInstance().getConnection());
int Gender;
Gender = (Int32)a.ExecuteScalar();
cmd = String.Format("Update Person SET FirstName = '{0}', LastName = '{1}', Contact = '{2}', Email = '{3}', DateOfBirth = '{4}', Gender = '{5}' WHERE Id = '{6}'", p.FirstName, p.LastName, p.Contact, p.Email, p.DateOfBirth, Gender, ide);
DatabaseConnection.getInstance().exectuteQuery(cmd);
cmd = String.Format("UPDATE Student SET Id = '{0}', RegistrationNo = '{1}' WHERE Id = '{2}'", ide, p.RegistrationNumber, ide);
DatabaseConnection.getInstance().exectuteQuery(cmd);
students s = new students();
this.Hide();
s.Show();
}
private void studlist_Click(object sender, EventArgs e)
{
students s = new students();
this.Hide();
s.Show();
}
private void delstu_Click(object sender, EventArgs e)
{
if (dataGridstudent.SelectedCells.Count != 0)
{
int rw = dataGridstudent.SelectedCells[0].RowIndex;
string cmd = string.Format("DELETE FROM Student where Id = '{0}'", dataGridstudent.Rows[rw].Cells["Id"].Value.ToString());
SqlCommand del = new SqlCommand(cmd, DatabaseConnection.getInstance().getConnection());
int count = del.ExecuteNonQuery();
students s = new students();
this.Hide();
s.Show();
}
}
private void stulist_Click(object sender, EventArgs e)
{
s.Show();
this.Hide();
}
