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