public bool Delete(LocNotAvailable l) { bool x = false; SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\ASUS\Documents\TimeTableManagement.mdf;Integrated Security=True;Connect Timeout=30"); try { string sql = "DELETE FROM LocNotAvailable WHERE sessionID = @id"; SqlCommand cmd = new SqlCommand(sql, con); cmd.Parameters.AddWithValue("@id", l.sessionID); con.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { x = true; } else { x = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.Close(); } return(x); }
public bool Insert(LocNotAvailable l) { bool x = false; SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\ASUS\Documents\TimeTableManagement.mdf;Integrated Security=True;Connect Timeout=30"); try { string sql = "INSERT INTO LocNotAvailable(sessionID,room,day,stime,etime) VALUES (@id,@room,@day,@stime,@etime)"; SqlCommand cmd = new SqlCommand(sql, con); cmd.Parameters.AddWithValue("@id", l.sessionID); cmd.Parameters.AddWithValue("@room", l.room); cmd.Parameters.AddWithValue("@day", l.day); cmd.Parameters.AddWithValue("@stime", l.stime); cmd.Parameters.AddWithValue("@etime", l.etime); con.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { x = true; } else { x = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.Close(); } return(x); }