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