private void Submit_Click(object sender, EventArgs e)
{
if (Validate_Form())
{
DateTime today = DateTime.Today;
SQL_Operator sql_operator = new SQL_Operator();
int graduation_year = today.Year + 4;
string sqlQuery = null;
if (YesButton.Checked)
{
sqlQuery = "INSERT INTO STUDENT_INFO (usn, name, dob, graduation_year, hostel_id) VALUES ('" + USNBox.Text.ToUpper() + "', '" + NameBox.Text.ToUpper() + "', DATE '" + DOBBox.Text + "', " + graduation_year + ", HOSTEL_ID_SEQUENCE.NEXTVAL)";
}
else
{
sqlQuery = "INSERT INTO STUDENT_INFO (usn, name, dob, graduation_year) VALUES ('" + USNBox.Text.ToUpper() + "', '" + NameBox.Text.ToUpper() + "', DATE '" + DOBBox.Text + "', " + graduation_year + ")";
}
if (sql_operator.Insert(sqlQuery))
{
MessageBox.Show("Inserted Entry", "Successful");
Clear_All_Entries();
}
else
{
MessageBox.Show("USN Must Be Unique", "Failed");
}
}
}
private void Submit_Click(object sender, EventArgs e)
{
if (Validate_Form())
{
DateTime today = DateTime.Today;
string date = today.Year.ToString() + "-" + today.Month.ToString() + "-" + today.Day.ToString();
string sqlQuery = "INSERT INTO STAFF_INFO (employee_id, name, type, join_date, designation) VALUES ('" + EmployeeIDBox.Text.ToUpper() + "', '" + NameBox.Text.ToUpper() + "', '" + TypeList.Text.ToUpper() + "', date '" + date + "', '" + DesignationList.Text.ToUpper() + "')";
if (sql_operator.Insert(sqlQuery))
{
MessageBox.Show("Inserted Entry", "Successful");
Clear_All_Entries();
}
else
{
MessageBox.Show("Employee ID Must Be Unique", "Failed");
}
}
}