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