private void button1_Click(object sender, EventArgs e) { try { int c_id = Int32.Parse(textBox1.Text); int f_id = Int32.Parse(textBox2.Text); string cName = textBox3.Text; string cDesc = textBox4.Text; string cReq = textBox5.Text; int online = Int32.Parse(textBox6.Text); int pcReq = Int32.Parse(textBox8.Text); sqlConn.Open(); SqlCommand cmd = new SqlCommand("insert into course.course_offerings(c_id_num, f_id_num, course_name, course_desc, course_requirements, online_available, pc_required)" + " values ('" + c_id + "','" + f_id + "','" + cName + "','" + cDesc + "','" + cReq + "','" + online + "','" + pcReq + "')", sqlConn); cmd.ExecuteScalar(); sqlConn.Close(); frmAdmin objFrmAdmin = new frmAdmin(); this.Hide(); objFrmAdmin.Show(); } catch (Exception ex) { MessageBox.Show("An error occurred but your application did not crash. Please contact a system admin if this continues."); string filePath = @"C:\Users\Error.txt"; using (StreamWriter writer = new StreamWriter(filePath, true)) { writer.WriteLine("-----------------------------------------------------------------------------"); writer.WriteLine("Date : " + DateTime.Now.ToString()); writer.WriteLine(); while (ex != null) { writer.WriteLine(ex.GetType().FullName); writer.WriteLine("Message : " + ex.Message); writer.WriteLine("StackTrace : " + ex.StackTrace); } } } }
private void button1_Click(object sender, EventArgs e) { try { int s_id = Int32.Parse(textBox1.Text); string age = textBox2.Text; string fName = textBox3.Text; string lName = textBox4.Text; string addr = textBox5.Text; string year = textBox6.Text; sqlConn.Open(); SqlCommand cmd = new SqlCommand("insert into student.student_records(s_id_num, age, first_name, last_name, addr, school_year)" + " values ('" + s_id + "','" + age + "','" + fName + "','" + lName + "','" + addr + "','" + year + "')", sqlConn); cmd.ExecuteScalar(); sqlConn.Close(); frmAdmin objFrmAdmin = new frmAdmin(); this.Hide(); objFrmAdmin.Show(); } catch (Exception ex) { MessageBox.Show("An error occurred but your application did not crash. Please contact a system admin if this continues."); string filePath = @"C:\Users\Error.txt"; using (StreamWriter writer = new StreamWriter(filePath, true)) { writer.WriteLine("-----------------------------------------------------------------------------"); writer.WriteLine("Date : " + DateTime.Now.ToString()); writer.WriteLine(); while (ex != null) { writer.WriteLine(ex.GetType().FullName); writer.WriteLine("Message : " + ex.Message); writer.WriteLine("StackTrace : " + ex.StackTrace); } } } }
private void button2_Click(object sender, EventArgs e) { try { int c_id_del = Int32.Parse(textBox7.Text); sqlConn.Open(); SqlCommand cmd2 = new SqlCommand("delete from course.course_offerings where c_id_num ='" + c_id_del + "'", sqlConn); cmd2.ExecuteScalar(); sqlConn.Close(); frmAdmin objFrmAdmin = new frmAdmin(); this.Hide(); objFrmAdmin.Show(); } catch (Exception ex) { MessageBox.Show("An error occurred but your application did not crash. Please contact a system admin if this continues."); string filePath = @"C:\Users\Error.txt"; using (StreamWriter writer = new StreamWriter(filePath, true)) { writer.WriteLine("-----------------------------------------------------------------------------"); writer.WriteLine("Date : " + DateTime.Now.ToString()); writer.WriteLine(); while (ex != null) { writer.WriteLine(ex.GetType().FullName); writer.WriteLine("Message : " + ex.Message); writer.WriteLine("StackTrace : " + ex.StackTrace); } } } }
private void btnLogin_Click_1(object sender, EventArgs e) { try { string userName = textUsername.Text; string passWord = textPassword.Text; SqlCommand cmd = new SqlCommand("select username,password from tbl_Login where username ='******'and password ='******'", sqlConn); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataTable dtbl = new DataTable(); sda.Fill(dtbl); if (dtbl.Rows.Count > 0) { sqlConn.Open(); SqlCommand cmd2 = new SqlCommand("select login_type from tbl_Login where username ='******' and password ='******'", sqlConn); // Get result int result = ((int)cmd2.ExecuteScalar()); // Admin Dashboard if (result == 1) { frmAdmin objFrmDash = new frmAdmin(); this.Hide(); objFrmDash.Show(); } // Faculty Dashboard else if (result == 2) { frmFaculty objFrmDash = new frmFaculty(); this.Hide(); objFrmDash.Show(); } // Student Dashboard else if (result == 3) { int s_id; string uName = userName.Substring(userName.IndexOf('.') + 1); SqlCommand cmd1 = new SqlCommand("select s_id_num from student.student_records where last_name like '%" + uName + "%'", sqlConn); s_id = ((int)cmd1.ExecuteScalar()); frmStudent objFrmDash = new frmStudent(s_id, userName); this.Hide(); objFrmDash.Show(); } } else { MessageBox.Show("Check your username or password."); textUsername.Clear(); textPassword.Clear(); } sqlConn.Close(); } catch (Exception ex) { MessageBox.Show("An error occurred but your application did not crash. Please contact a system admin if this continues."); string filePath = @"C:\Users\Error.txt"; using (StreamWriter writer = new StreamWriter(filePath, true)) { writer.WriteLine("-----------------------------------------------------------------------------"); writer.WriteLine("Date : " + DateTime.Now.ToString()); writer.WriteLine(); while (ex != null) { writer.WriteLine(ex.GetType().FullName); writer.WriteLine("Message : " + ex.Message); writer.WriteLine("StackTrace : " + ex.StackTrace); } } } }