//GET Fiskar med Fiskar public List <Fiskar> GetFiskarWithFiskModell(out string errormsg) { SqlConnection dbConnection = new SqlConnection(); dbConnection.ConnectionString = @"Data Source=(localdb)\mssqllocaldb;Initial Catalog=FiskDB_Labb3;Integrated Security=True"; String sqlstring = "SELECT * FROM Fiskar"; SqlCommand dbCommand = new SqlCommand(sqlstring, dbConnection); SqlDataAdapter myAdapter = new SqlDataAdapter(dbCommand); DataSet myDS = new DataSet(); List <Fiskar> FiskLista = new List <Fiskar>(); try { dbConnection.Open(); myAdapter.Fill(myDS, "myFisk"); int count = 0; int i = 0; count = myDS.Tables["myFisk"].Rows.Count; if (count > 0) { while (i < count) { Fiskar f1 = new Fiskar(); // pd.ID = Convert.ToInt32(myDS.Tables["myFisk"].Rows[i]["FiskID"]); f1.ID = Convert.ToInt32(myDS.Tables["myFisk"].Rows[i]["FiskID"]); f1.Art = myDS.Tables["myFisk"].Rows[i]["Art"].ToString(); f1.Vikt = Convert.ToInt32(myDS.Tables["myFisk"].Rows[i]["Vikt"]); f1.Vatten = myDS.Tables["myFisk"].Rows[i]["Vatten"].ToString(); i++; FiskLista.Add(f1); } errormsg = ""; return(FiskLista); } else { errormsg = "Det hämtas ingen Fisk!"; return(null); } } catch (Exception e) { errormsg = e.Message; return(null); } finally { dbConnection.Close(); } }
public int InsertFisk(Fiskar f1, out string errormsg) { SqlConnection dbConnection = new SqlConnection(); dbConnection.ConnectionString = @"Data Source=(localdb)\mssqllocaldb;Initial Catalog=FiskDB_Labb3;Integrated Security=True"; string sqlstring = "INSERT INTO Fiskar (Art, Vikt, Vatten, Persnr, Betenr) VALUES (@art, @vikt, @vatten, @persnr, @betenr)"; SqlCommand dbCommand = new SqlCommand(sqlstring, dbConnection); dbCommand.Parameters.Add("art", SqlDbType.NVarChar, 50).Value = f1.Art; dbCommand.Parameters.Add("vikt", SqlDbType.Int).Value = f1.Vikt; dbCommand.Parameters.Add("vatten", SqlDbType.NVarChar, 50).Value = f1.Vatten; dbCommand.Parameters.Add("persnr", SqlDbType.BigInt).Value = f1.Persnr; dbCommand.Parameters.Add("betenr", SqlDbType.Int).Value = f1.Betenr; try { dbConnection.Open(); int i = 0; i = dbCommand.ExecuteNonQuery(); if (i == 1) { errormsg = ""; } else { errormsg = "Det skapas ej en person i databasen"; } return(i); } catch (Exception e) { errormsg = e.Message; return(0); } finally { dbConnection.Close(); } }
public int UpdateFisk(Fiskar p1, int Fisk_id, out string errormsg) { SqlConnection dbConnection = new SqlConnection(); dbConnection.ConnectionString = @"Data Source=(localdb)\mssqllocaldb;Initial Catalog=FiskDB_Labb3;Integrated Security=True"; string sqlstring = "UPDATE Fiskar SET Art = @art, Vikt = @vikt, Vatten = @vatten WHERE FiskID = @id"; SqlCommand dbCommand = new SqlCommand(sqlstring, dbConnection); //dbCommand.Parameters.Add("fiskid", SqlDbType.NVarChar, 50).Value = p1.ID; dbCommand.Parameters.Add("art", SqlDbType.NVarChar, 50).Value = p1.Art; dbCommand.Parameters.Add("vikt", SqlDbType.NVarChar, 50).Value = p1.Vikt; dbCommand.Parameters.Add("vatten", SqlDbType.NVarChar, 50).Value = p1.Vatten; dbCommand.Parameters.Add("id", SqlDbType.Int).Value = Fisk_id; try { dbConnection.Open(); int i = 0; i = dbCommand.ExecuteNonQuery(); if (i == 1) { errormsg = ""; } else { errormsg = "Gick ej att uppdatera Fisk"; } return(i); } catch (Exception e) { errormsg = e.Message; return(0); } finally { dbConnection.Close(); } }