public bool Insert(LocationNotAvail c) { bool isSuccess = false; SqlConnection Con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\TimeTableDatabase.mdf;Integrated Security=True"); try { string sql = "INSERT INTO Location_not_Avaible(lecid,day,room,dur,stime,etime)VALUES(@lecid,@day,@room,@dur,@stime,@etime)"; SqlCommand cmd = new SqlCommand(sql, Con); cmd.Parameters.AddWithValue("@lecid", c.lecid); cmd.Parameters.AddWithValue("@day", c.day); cmd.Parameters.AddWithValue("@room", c.room); cmd.Parameters.AddWithValue("@dur", c.dur); cmd.Parameters.AddWithValue("@stime", c.stime); cmd.Parameters.AddWithValue("@etime", c.etime); Con.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { } finally { Con.Close(); } return(isSuccess); }
public bool Delete(LocationNotAvail c) { bool isSuccess = false; SqlConnection Con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\TimeTableDatabase.mdf;Integrated Security=True"); try { string sql = "DELETE FROM Location_not_Avaible WHERE lid=@lid"; SqlCommand cmd = new SqlCommand(sql, Con); cmd.Parameters.AddWithValue("@lid", c.lid); Con.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { } finally { Con.Close(); } return(isSuccess); }