private void createButton_Click(object sender, RoutedEventArgs e) { Domain.DecreciationType tempDecType = new Domain.DecreciationType(); switch (decreciationTypeComboBox.Text) { case "Lineær": tempDecType = Domain.DecreciationType.Lineær; break; case "Saldo": tempDecType = Domain.DecreciationType.Saldo; break; case "Annuitet": tempDecType = Domain.DecreciationType.Annuitet; break; default: break; } //insert values til database myAssetController.CreateNewAsset(nameTextBox.Text, decimal.Parse(purchasePriceTextBox.Text), purchaseDateTextBox.Text, decimal.Parse(scrapValueTextBox.Text), int.Parse(lifeSpanTextBox.Text), statusComboBox.Text, tempDecType); ClearTextbox(); MessageBox.Show("Anlæg oprettet", "Succes"); }
public Asset LoadAsset(int inAssetID) { Asset returnAsset; string tempname = "UNKNOWN/VOID"; decimal tempprice = 1000; string tempdate = "01/01/1000"; decimal scrapvalue = 10; int lifespan = 0; string status = "false"; Domain.DecreciationType type = Domain.DecreciationType.Lineær; // StoredProcedureCall SqlConnection conn = new SqlConnection("Server=ealdb1.eal.local;Database=ejl49_db; User ID = ejl49_usr; Password = Baz1nga49"); try { conn.Open(); //SqlCommand cmd = new SqlCommand(); //cmd.Connection = conn; //cmd.CommandText = "SELECT * from Asset"; SqlCommand comd = new SqlCommand("spCompoundAssDesc", conn); comd.CommandType = CommandType.StoredProcedure; comd.Parameters.Add(new SqlParameter("@AssetId", inAssetID)); SqlDataReader rdr = comd.ExecuteReader(); while (rdr.Read()) { tempname = rdr["AssetName"].ToString(); tempprice = decimal.Parse(rdr["AssetPurchasePrice"].ToString()); tempdate = rdr["AssetPurchaseDate"].ToString(); scrapvalue = decimal.Parse(rdr["AssetScrapValue"].ToString()); lifespan = int.Parse(rdr["AssetLifeSpan"].ToString()); status = rdr["AssetStatus"].ToString(); string inType = rdr["DecreciationType"].ToString(); switch (inType) { case "Lineær": type = Domain.DecreciationType.Lineær; break; case "Saldo": type = Domain.DecreciationType.Saldo; break; case "Annuitet": type = Domain.DecreciationType.Annuitet; break; } // string Asset = "Id: " + rdr.GetInt32(0) + " Name: " + rdr.GetString(1); } } catch (SqlException es) { Console.WriteLine("UPS " + es.Message); Console.ReadLine(); } finally { conn.Close(); } returnAsset = new Asset(tempname, tempprice, tempdate, scrapvalue, lifespan, status, type); return(returnAsset); }