private void btn_indsæt_Click(object sender, EventArgs e) { worksOn = new WorksOnBLL(SagsID(), TotHours()); beregn_hentData_btn_Click(sender, e); try { if (!WorksOnBLL.RecordExists(SagsID())) //if there is no record in the db then create new { worksOn.IndsætTimer(worksOn); } else //else update the existing record { worksOn.Update(worksOn); } } catch (Exception ex) { MessageBox.Show(ex.Message); } if (HandelDAL.HandelExists(SagsID())) //if there is a handel record in the Handel tabel { result_txt.Text = worksOn.BeregnSalær(WorksOnBLL.HentSalgspris(SagsID().ToString()), TotHours()); //beregn salær med en procentsats af boligens salgspris } else { result_txt.Text = worksOn.BeregnSalær(0, TotHours()); //else beregn TotHours * 150 kr } }
public void TestBeregnSalær() { //Arrange int antalTimer = 100; int salgspris = 1000000; string expected = "35000"; WorksOnBLL Salær = new WorksOnBLL(); //BeregnSalærForm Salær = new BeregnSalærForm(); //Act string actual = Salær.BeregnSalær(salgspris, antalTimer); //Assert Assert.AreEqual(expected, actual); }
//method to insert the amount of hour worked on a project public void IndsætTimer(WorksOnBLL worksOn) { //SQL QUERY string sqlCommandWorksOn = "INSERT INTO WORKS_ON VALUES(@SagsID, @TotHours)"; //SQL COMMAND + PARAMETERS SqlCommand cmdWorksOn = new SqlCommand(sqlCommandWorksOn, conn); cmdWorksOn.Parameters.AddWithValue("@SagsID", worksOn.SagsID); cmdWorksOn.Parameters.AddWithValue("@TotHours", worksOn.TotHours); try { //OPEN CONNECTION if (conn.State == System.Data.ConnectionState.Closed) { conn.Open(); } //BEGIN TRANSACTION Transactions.BeginRepeatableReadTransaction(conn); //EXECUTE QUERY cmdWorksOn.ExecuteNonQuery(); //COMMIT OR ROLLBACK if (!Transactions.Commit(conn)) { Transactions.Rollback(conn); } } catch (SqlException ex) { Console.WriteLine(ex.Message); } //CLOSE CONNECTION if (conn.State == System.Data.ConnectionState.Open) { conn.Close(); } }