public bool Insert(SocietateBLL s, SqlConnection conn)
{
//set bool var
bool isSuccess = false;
try
{
//sql Query
string sql = "INSERT INTO Societati(Punct_lucru, Societate, Adresa, Cod_fiscal, Cont, Banca, NrRegCom) VALUES (@Punct_lucru, @Societate, @Adresa, @Cod_fiscal, @Cont, @Banca, @NrRegCom)";
//sql comand
SqlCommand cmd = new SqlCommand(sql, conn);
//param to get value
cmd.Parameters.AddWithValue("@Punct_lucru", s.Punct_lucru);
cmd.Parameters.AddWithValue("@Societate", s.Societate);
cmd.Parameters.AddWithValue("@Adresa", s.Adresa);
cmd.Parameters.AddWithValue("@Cod_fiscal", s.Cod_fiscal);
cmd.Parameters.AddWithValue("@Cont", s.Cont);
cmd.Parameters.AddWithValue("@Banca", s.Banca);
cmd.Parameters.AddWithValue("@NrRegCom", s.NrRegCom);
//open conection
conn.Open();
//var to hold value after quer executed
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
//eror
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
public bool Delete(SocietateBLL a, SqlConnection conn)
{
//set bool var
bool isSuccess = false;
try
{
//sql Query
string sql = "DELETE FROM Societati ";
//sql comand
SqlCommand cmd = new SqlCommand(sql, conn);
//param to get value
//open conection
conn.Open();
//var to hold value after quer executed
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
//eror
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
