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);
}