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