public bool Update(classPrihodiTroskovi p)
{
//Create a boolean var and set its default value to false
bool isSuccess = false;
//Create an object of SqlConnection to connect DB
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
//Create a string var to store the insert query
String sql = "UPDATE tblPrihTros SET povecanje_zarade=@povecanje_zarade , smanjenje_troskova=@smanjenje_troskova,ukupni_prihodi=@ukupni_prihodi,ukupni_troskovi=@ukupni_troskovi,troskovi_rada=@troskovi_rada,troskovi_razvoja=@troskovi_razvoja WHERE name=@name AND year=@year";
//Create an SQL command to pass the value in our query
SqlCommand cmd = new SqlCommand(sql, conn);
//Create the paramater to get value from UI and pass it to SQL query above
cmd.Parameters.AddWithValue("@name", p.name);
cmd.Parameters.AddWithValue("@year", p.year);
cmd.Parameters.AddWithValue("@povecanje_zarade", p.povecanje_zarade);
cmd.Parameters.AddWithValue("@smanjenje_troskova", p.smanjenje_troskova);
cmd.Parameters.AddWithValue("@troskovi_rada", p.troskovi_rada);
cmd.Parameters.AddWithValue("@troskovi_razvoja", p.troskovi_razvoja);
cmd.Parameters.AddWithValue("@ukupni_prihodi", p.ukupni_prihodi);
cmd.Parameters.AddWithValue("@ukupni_troskovi", p.ukupni_troskovi);
//Open DB connection
conn.Open();
//INT value to hold the value after query is executed
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
//Query executed successfully
isSuccess = true;
}
else
{
//Failed to execute query
isSuccess = false;
}
}
catch (Exception ex)
{
//Display error mssg if there is any exceptional errors
MessageBox.Show(ex.Message);
}
finally
{
//Close DB connection
conn.Close();
}
return(isSuccess);
}
public bool Delete(classPrihodiTroskovi c)
{
bool isSuccess = false;
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
String sql = "DELETE FROM tblPrihTros WHERE name=@name";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@name", c.name);
conn.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
//Query executed successfully
isSuccess = true;
}
else
{
//Failed to execute query
isSuccess = false;
}
}
catch (Exception ex)
{
//Display error mssg if there is any exceptional errors
MessageBox.Show(ex.Message);
}
finally
{
//Close DB connection
conn.Close();
}
return(isSuccess);
}
public bool Insert(classPrihodiTroskovi p)
{
//Create a boolean var and set its default value to false
bool isSuccess = false;
//Create an object of SqlConnection to connect DB
SqlConnection conn = new SqlConnection(myconnstrng);
if (p.name != "" && p.year != 0)
{
try
{
//Create a string var to store the insert query
String sql = "INSERT INTO tblPrihTros(name,year,povecanje_zarade,smanjenje_troskova,troskovi_rada,troskovi_razvoja,ukupni_prihodi,ukupni_troskovi) VALUES (@name,@year,@povecanje_zarade,@smanjenje_troskova,@troskovi_rada,@troskovi_razvoja,@ukupni_prihodi,@ukupni_troskovi)";
//Create an SQL command to pass the value in our query
SqlCommand cmd = new SqlCommand(sql, conn);
//Create the paramater to get value from UI and pass it to SQL query above
cmd.Parameters.AddWithValue("@name", p.name);
cmd.Parameters.AddWithValue("@year", p.year);
cmd.Parameters.AddWithValue("@povecanje_zarade", p.povecanje_zarade);
cmd.Parameters.AddWithValue("@smanjenje_troskova", p.smanjenje_troskova);
cmd.Parameters.AddWithValue("@troskovi_rada", p.troskovi_rada);
cmd.Parameters.AddWithValue("@troskovi_razvoja", p.troskovi_razvoja);
cmd.Parameters.AddWithValue("@ukupni_prihodi", p.ukupni_prihodi);
cmd.Parameters.AddWithValue("@ukupni_troskovi", p.ukupni_troskovi);
//Open DB connection
conn.Open();
//INT value to hold the value after query is executed
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
//Query executed successfully
isSuccess = true;
}
else
{
//Failed to execute query
isSuccess = false;
}
}
catch (Exception ex)
{
//Display error mssg if there is any exceptional errors
MessageBox.Show(ex.Message + " BPgreska");
}
finally
{
//Close DB connection
conn.Close();
}
return(isSuccess);
}
else
{
MessageBox.Show("Niste unijeli neko obavezno polje", "Upozorenje!");
return(false);
}
}
