public bool Delete(NonOverlaping w) { 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 NonOverlaping WHERE sessionID = @id"; SqlCommand cmd = new SqlCommand(sql, con); cmd.Parameters.AddWithValue("@id", w.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(NonOverlaping w) { 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 NonOverlaping(sessionID,L1,L2,sub_code,subject,tag,grp) VALUES(@sID,@lec,@lecs,@subcode,@sub,@Tag,@grp)"; SqlCommand cmd = new SqlCommand(sql, con); MessageBox.Show(w.grp); cmd.Parameters.AddWithValue("@sID", w.sessionID); cmd.Parameters.AddWithValue("@lec", w.L1); cmd.Parameters.AddWithValue("@lecs", w.L2); cmd.Parameters.AddWithValue("@subcode", w.sub_code); cmd.Parameters.AddWithValue("@sub", w.subject); cmd.Parameters.AddWithValue("@Tag", w.tag); cmd.Parameters.AddWithValue("@grp", w.grp); 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); }