//Delete Method public bool Delete(SubjectClass s, int id) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstring); try { string sql = "DELETE FROM Subject_Table WHERE SubjectID = @SubjectID"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@SubjectID", id); if (conn.State == ConnectionState.Open) { conn.Close(); } conn.Open(); cmd.ExecuteNonQuery(); isSuccess = true; } catch (Exception ex) { } finally { conn.Close(); } return(isSuccess); }
//Insert Method public bool Insert(SubjectClass s) { bool isSuccess = true; SqlConnection conn = new SqlConnection(myconnstring); try { string sql = "insert into Subject_Table( OfferedYear, OfferedSemester, SubjectName, SubjectCode, LectureHours, TutorialHours, LabHours, EvaluationHours, OfferedLecturer) " + "values (@OfferedYear, @OfferedSemester, @SubjectName, @SubjectCode, @LectureHours, @TutorialHours, @LabHours, @EvaluationHours, @OfferedLecturer)"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@OfferedYear", s.OfferedYear); cmd.Parameters.AddWithValue("@OfferedSemester", s.OfferedSemester); cmd.Parameters.AddWithValue("@SubjectName", s.SubjectName); cmd.Parameters.AddWithValue("@SubjectCode", s.SubjectCode); cmd.Parameters.AddWithValue("@LectureHours", s.LectureHours); cmd.Parameters.AddWithValue("@TutorialHours", s.TutorialHours); cmd.Parameters.AddWithValue("@LabHours", s.LabHours); cmd.Parameters.AddWithValue("@EvaluationHours", s.EvaluationHours); cmd.Parameters.AddWithValue("@OfferedLecturer", s.OfferedLecturer); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { } finally { conn.Close(); } return(isSuccess); }
//Update Method public bool Update(SubjectClass s, int id) { SqlConnection conn = new SqlConnection(myconnstring); try { string sql = "UPDATE Subject_Table SET OfferedYear = @OfferedYear, OfferedSemester = @OfferedSemester, SubjectName = @SubjectName, SubjectCode = @SubjectCode, LectureHours = @LectureHours, TutorialHours = @TutorialHours, LabHours = @LabHours, EvaluationHours = @EvaluationHours, OfferedLecturer = @OfferedLecturer WHERE SubjectID = @SubjectID"; SqlCommand cmd = new SqlCommand(sql, conn); if (conn.State == ConnectionState.Open) { conn.Close(); } cmd.Parameters.AddWithValue("@SubjectID", id); cmd.Parameters.AddWithValue("@OfferedYear", s.OfferedYear); cmd.Parameters.AddWithValue("@OfferedSemester", s.OfferedSemester); cmd.Parameters.AddWithValue("@SubjectName", s.SubjectName); cmd.Parameters.AddWithValue("@SubjectCode", s.SubjectCode); cmd.Parameters.AddWithValue("@LectureHours", s.LectureHours); cmd.Parameters.AddWithValue("@TutorialHours", s.TutorialHours); cmd.Parameters.AddWithValue("@LabHours", s.LabHours); cmd.Parameters.AddWithValue("@EvaluationHours", s.EvaluationHours); cmd.Parameters.AddWithValue("@OfferedLecturer", s.OfferedLecturer); conn.Open(); cmd.ExecuteNonQuery(); return(true); } catch (Exception ex) { return(false); } finally { conn.Close(); } }