//Delete Method public bool Delete(SessionClass s, int id) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstring); try { string sql = "DELETE FROM Session_Table WHERE SessionID = @SessionID"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@SessionID", 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(SessionClass s) { bool isSuccess = true; SqlConnection conn = new SqlConnection(myconnstring); try { string sql = "insert into Session_Table( LecturerName1, LecturerName2, StudentGroup, Subject, Tag, StudentSubGroup, NoOfStudent, Duration) " + "values (@LecturerName1, @LecturerName2, @StudentGroup, @Subject, @Tag, @StudentSubGroup, @NoOfStudent, @Duration)"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@LecturerName1", s.LecturerName1); cmd.Parameters.AddWithValue("@LecturerName2", s.LecturerName2); cmd.Parameters.AddWithValue("@StudentGroup", s.StudentGroup); cmd.Parameters.AddWithValue("@Subject", s.Subject); cmd.Parameters.AddWithValue("@Tag", s.Tag); cmd.Parameters.AddWithValue("@StudentSubGroup", s.StudentSubGroup); cmd.Parameters.AddWithValue("@NoOfStudent", s.NoOfStudent); cmd.Parameters.AddWithValue("@Duration", s.Duration); 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(SessionClass s, int id) { SqlConnection conn = new SqlConnection(myconnstring); try { string sql = "UPDATE Session_Table SET LecturerName1 = @LecturerName1, LecturerName2 = @LecturerName2, StudentGroup = @StudentGroup, Subject = @Subject, Tag = @Tag, StudentSubGroup = @StudentSubGroup, NoOfStudent = @NoOfStudent, Duration = @Duration WHERE SessionID = @SessionID"; SqlCommand cmd = new SqlCommand(sql, conn); if (conn.State == ConnectionState.Open) { conn.Close(); } cmd.Parameters.AddWithValue("@SessionID", id); cmd.Parameters.AddWithValue("@LecturerName1", s.LecturerName1); cmd.Parameters.AddWithValue("@LecturerName2", s.LecturerName2); cmd.Parameters.AddWithValue("@StudentGroup", s.StudentGroup); cmd.Parameters.AddWithValue("@Subject", s.Subject); cmd.Parameters.AddWithValue("@Tag", s.Tag); cmd.Parameters.AddWithValue("@StudentSubGroup", s.StudentSubGroup); cmd.Parameters.AddWithValue("@NoOfStudent", s.NoOfStudent); cmd.Parameters.AddWithValue("@Duration", s.Duration); conn.Open(); cmd.ExecuteNonQuery(); return(true); } catch (Exception ex) { return(false); } finally { conn.Close(); } }