//Method to Update public bool Update(TimeDay t) { bool isSuccess = false; SqlConnection conn = new SqlConnection(ourconnstrng); try { //create sql update query string sql = "UPDATE day_time SET day1=@day1, time1=@time1, day2=@day2, time2=@time2, day3=@day3, time3=@time3, day4=@day4, time4=@time4, day5=@day5, time5=@time6, day6=@day6, time6=@time6, day7=@day7, time7=@time7 WHERE timeday=@timeday"; //create slq command usind sql and conn SqlCommand cmd = new SqlCommand(sql, conn); //Create parameter to add values cmd.Parameters.AddWithValue("@day1", t.day1); cmd.Parameters.AddWithValue("@time1", t.time1); cmd.Parameters.AddWithValue("@day2", t.day2); cmd.Parameters.AddWithValue("@time2", t.time2); cmd.Parameters.AddWithValue("@day3", t.day3); cmd.Parameters.AddWithValue("@time3", t.time3); cmd.Parameters.AddWithValue("@day4", t.day4); cmd.Parameters.AddWithValue("@time4", t.time4); cmd.Parameters.AddWithValue("@day5", t.day5); cmd.Parameters.AddWithValue("@time5", t.time5); cmd.Parameters.AddWithValue("@day6", t.day6); cmd.Parameters.AddWithValue("@time6", t.time6); cmd.Parameters.AddWithValue("@day7", t.day7); cmd.Parameters.AddWithValue("@time7", t.time7); cmd.Parameters.AddWithValue("@timeday", t.timeday); //Open database Connection conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { } finally { conn.Close(); } return(isSuccess); }
//Insert data into database public bool Insert(TimeDay t) { //create a default return type and setting its values to false bool isSuccess = false; //Connect Database SqlConnection conn = new SqlConnection(ourconnstrng); try { //Create query to insert data string sql = "INSERT INTO day_time(day1, time1,day2, time2,day3, time3,day4, time4,day5, time5,day6, time6,day7, time7) VALUES(@day1, @time1,@day2, @time2,@day3, @time3,@day4, @time4,@day5, @time5,@day6, @time6,@day7, @time7)"; //Create command using sql and conn SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@day1", t.day1); cmd.Parameters.AddWithValue("@time1", t.time1); cmd.Parameters.AddWithValue("@day2", t.day2); cmd.Parameters.AddWithValue("@time2", t.time2); cmd.Parameters.AddWithValue("@day3", t.day3); cmd.Parameters.AddWithValue("@time3", t.time3); cmd.Parameters.AddWithValue("@day4", t.day4); cmd.Parameters.AddWithValue("@time4", t.time4); cmd.Parameters.AddWithValue("@day5", t.day5); cmd.Parameters.AddWithValue("@time5", t.time5); cmd.Parameters.AddWithValue("@day6", t.day6); cmd.Parameters.AddWithValue("@time6", t.time6); cmd.Parameters.AddWithValue("@day7", t.day7); cmd.Parameters.AddWithValue("@time7", t.time7); //Connection open here conn.Open(); int rows = cmd.ExecuteNonQuery(); //if the query runs successfully then the vatues of rows will be greater than zero else its values will ne 0 if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { } finally { } return(isSuccess); }
//Method to delete data from databse public bool Delete(TimeDay t) { bool isSuccess = false; //create SQL Connection SqlConnection conn = new SqlConnection(ourconnstrng); try { //Sql delete data string sql = "DELETE FROM day_time WHERE timeday=@timeday "; //creating sql command SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@timeday", t.timeday); //Open Connection conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { } finally { conn.Close(); } return(isSuccess); }