//Updating WorkingDays data in db public bool updateWorkingDays(WorkingDays wd) { bool isSuccess = false; //database connection SqlConnection conn = new SqlConnection(myconnstring); try { //sql query string sql = "UPDATE WorkingDays SET NumberOfWorkingDays=@NumberOfWorkingDays, Day1=@Day1, Day2=@Day2, Day3=@Day3, Day4=@Day4, Day5=@Day5, Day6=@Day6, Day7=@Day7 WHERE WDID=@WDID"; //creating cmd using sql and conn SqlCommand cmd = new SqlCommand(sql, conn); //Creating parameters to add data cmd.Parameters.AddWithValue("@WDID", wd.WDID); cmd.Parameters.AddWithValue("@NumberOfWorkingDays", wd.NumberOfWorkingDays); cmd.Parameters.AddWithValue("@Day1", wd.Day1); cmd.Parameters.AddWithValue("@Day2", wd.Day2); cmd.Parameters.AddWithValue("@Day3", wd.Day3); cmd.Parameters.AddWithValue("@Day4", wd.Day4); cmd.Parameters.AddWithValue("@Day5", wd.Day5); cmd.Parameters.AddWithValue("@Day6", wd.Day6); cmd.Parameters.AddWithValue("@Day7", wd.Day7); //Open connection conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { } finally { conn.Close(); } return(isSuccess); }
//Deleting WorkingDays data in db public bool deleteWorkingDays(WorkingDays wd) { bool isSuccess = false; //database connection SqlConnection conn = new SqlConnection(myconnstring); try { //sql query string sql = "DELETE FROM WorkingDays WHERE WDID=@WDID"; //creating cmd using sql and conn SqlCommand cmd = new SqlCommand(sql, conn); //Creating parameters to add data cmd.Parameters.AddWithValue("@WDID", wd.WDID); //Open connection conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { } finally { conn.Close(); } return(isSuccess); }
//Inserting WorkingDays data into db public int insertWorkingDays(WorkingDays wd) { //database connection SqlConnection conn = new SqlConnection(myconnstring); try { //sql query string sql = "INSERT INTO WorkingDays (NumberOfWorkingDays, Day1, Day2, Day3, Day4, Day5, Day6, Day7) VALUES (@NumberOfWorkingDays, @Day1, @Day2, @Day3, @Day4, @Day5, @Day6, @Day7); SELECT SCOPE_IDENTITY()"; //creating cmd using sql and conn SqlCommand cmd = new SqlCommand(sql, conn); cmd.CommandType = CommandType.Text; //Creating parameters to add data cmd.Parameters.AddWithValue("@NumberOfWorkingDays", wd.NumberOfWorkingDays); cmd.Parameters.AddWithValue("@Day1", wd.Day1); cmd.Parameters.AddWithValue("@Day2", wd.Day2); cmd.Parameters.AddWithValue("@Day3", wd.Day3); cmd.Parameters.AddWithValue("@Day4", wd.Day4); cmd.Parameters.AddWithValue("@Day5", wd.Day5); cmd.Parameters.AddWithValue("@Day6", wd.Day6); cmd.Parameters.AddWithValue("@Day7", wd.Day7); //Open connection conn.Open(); ID = Convert.ToInt32(cmd.ExecuteScalar()); } catch (Exception ex) { } finally { conn.Close(); } return(ID); }