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();
}
}
