//Delete Method public bool Delete(DaysOfWorking d) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstrng); try { string sql = "DELETE FROM working_days WHERE workingdayID=@workingdayID"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@workingdayID ", d.workingdayID); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { } finally { conn.Close(); } return(isSuccess); }
//Data Update method public bool Update(DaysOfWorking d) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstrng); try { string sql = "UPDATE working_days SET day1=@day1 , day2=@day2 , day3=@day3, day4=@day4, day5=@day5, day6=@day6 ,day7=@day7 WHERE workingdayID=@workingdayID "; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@day1", d.day1); cmd.Parameters.AddWithValue("@day2", d.day2); cmd.Parameters.AddWithValue("@day3", d.day3); cmd.Parameters.AddWithValue("@day4", d.day4); cmd.Parameters.AddWithValue("@day5", d.day5); cmd.Parameters.AddWithValue("@day6", d.day6); cmd.Parameters.AddWithValue("@day7", d.day7); cmd.Parameters.AddWithValue("workingdayID", d.workingdayID); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { } finally { conn.Close(); } return(isSuccess); }
//Data insert method public bool Insert(DaysOfWorking d) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstrng); try { string sql = "INSERT INTO working_days (day1,day2,day3,day4,day5,day6,day7) VALUES (@day1,@day2,@day3,@day4,@day5,@day6,@day7)"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@day1", d.day1); cmd.Parameters.AddWithValue("@day2", d.day2); cmd.Parameters.AddWithValue("@day3", d.day3); cmd.Parameters.AddWithValue("@day4", d.day4); cmd.Parameters.AddWithValue("@day5", d.day5); cmd.Parameters.AddWithValue("@day6", d.day6); cmd.Parameters.AddWithValue("@day7", d.day7); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch { } finally { conn.Close(); } return(isSuccess); }