public bool Insert(WorkTimeHour c) { bool isSuccess = false; //Connection String SqlConnection Con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\TimeTableDatabase.mdf;Integrated Security=True"); try { string sql = "INSERT INTO WorkingDays (noworkd,day1,day2,day3,day4,day5,day6,day7,stime,dura,etime,hours)VALUES(@noworkd,@day1,@day2,@day3,@day4,@day5,@day6,@day7,@stime,@dura,@etime,@hours)"; SqlCommand cmd = new SqlCommand(sql, Con); cmd.Parameters.AddWithValue("@noworkd ", c.noworkd); cmd.Parameters.AddWithValue("@day1", c.day1); cmd.Parameters.AddWithValue("@day2", c.day2); cmd.Parameters.AddWithValue("@day3", c.day3); cmd.Parameters.AddWithValue("@day4", c.day4); cmd.Parameters.AddWithValue("@day5", c.day5); cmd.Parameters.AddWithValue("@day6", c.day6); cmd.Parameters.AddWithValue("@day7", c.day7); cmd.Parameters.AddWithValue("@stime", c.stime); cmd.Parameters.AddWithValue("@dura", c.dura); cmd.Parameters.AddWithValue("@etime", c.etime); cmd.Parameters.AddWithValue("@hours", c.hours); Con.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { } finally { Con.Close(); } return(isSuccess); }
public bool Update(WorkTimeHour c) { bool isSuccess = false; //Connection String SqlConnection Con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\TimeTableDatabase.mdf;Integrated Security=True"); try { string sql = "UPDATE WorkingDays SET noworkd=@noworkd,day1=@day1,day2=@day2,day3=@day3,day4=@day4,day5=@day5,day6=@day6,day7=@day7,stime=@stime,dura=@dura,etime=@etime,hours=@hours WHERE lectureid=@lectureid"; SqlCommand cmd = new SqlCommand(sql, Con); cmd.Parameters.AddWithValue("@noworkd ", c.noworkd); cmd.Parameters.AddWithValue("@day1", c.day1); cmd.Parameters.AddWithValue("@day2", c.day2); cmd.Parameters.AddWithValue("@day3", c.day3); cmd.Parameters.AddWithValue("@day4", c.day4); cmd.Parameters.AddWithValue("@day5", c.day5); cmd.Parameters.AddWithValue("@day6", c.day6); cmd.Parameters.AddWithValue("@day7", c.day7); cmd.Parameters.AddWithValue("@stime", c.stime); cmd.Parameters.AddWithValue("@dura", c.dura); cmd.Parameters.AddWithValue("@etime", c.etime); cmd.Parameters.AddWithValue("@hours", c.hours); cmd.Parameters.AddWithValue("@lectureid", c.lectureid); 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(WorkTimeHour c) { bool isSuccess = false; //Connection String SqlConnection Con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\TimeTableDatabase.mdf;Integrated Security=True"); try { string sql = "DELETE FROM WorkingDays WHERE lectureid=@lectureid"; SqlCommand cmd = new SqlCommand(sql, Con); cmd.Parameters.AddWithValue("@lectureid", c.lectureid); Con.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { } finally { Con.Close(); } return(isSuccess); }