//Updating WTPerDay data in db public bool updateWTPerDay(WTPerDay wtpd) { bool isSuccess = false; //database connection SqlConnection conn = new SqlConnection(myconnstring); try { //sql query string sql = "UPDATE WTPerDay SET WTHours=@WTHours, WTMinutes=@WTMinutes WHERE WTPDID=@WTPDID"; //creating cmd using sql and conn SqlCommand cmd = new SqlCommand(sql, conn); //Creating parameters to add data cmd.Parameters.AddWithValue("@WTPDID", wtpd.WTPDID); cmd.Parameters.AddWithValue("@WTHours", wtpd.WTHours); cmd.Parameters.AddWithValue("@WTMinutes", wtpd.WTMinutes); //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 WTPerDay data into db public int insertWTPerDay(WTPerDay wtpd) { bool isSuccess = false; //database connection SqlConnection conn = new SqlConnection(myconnstring); try { //sql query string sql = "INSERT INTO WTPerDay (WTHours, WTMinutes) VALUES (@WTHours, @WTMinutes); 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("@WTHours", wtpd.WTHours); cmd.Parameters.AddWithValue("@WTMinutes", wtpd.WTMinutes); //Open connection conn.Open(); ID = Convert.ToInt32(cmd.ExecuteScalar()); } catch (Exception ex) { } finally { conn.Close(); } return(ID); }