public bool update_tacgia(BEL.BEL_tacgia tacgia) { bool ketqua = false; using (SqlConnection connect = new SqlConnection(connectionString.connectionstring)) { try { connect.Open(); string query = "update tacgia set ten_tac_gia=@ten_tac_gia,tieu_su=@tieu_su,da_xoa=@da_xoa where ma_tac_gia=@ma_tac_gia"; SqlCommand cmd = new SqlCommand(query, connect); //SqlDataReader reader = null; SqlParameter param_ten_tac_gia = new SqlParameter(); param_ten_tac_gia.ParameterName = "@ten_tac_gia"; param_ten_tac_gia.Value = tacgia.Tentacgia; SqlParameter param_tieu_su = new SqlParameter(); param_tieu_su.ParameterName = "@tieu_su"; param_tieu_su.Value = tacgia.Tentacgia; SqlParameter param = new SqlParameter(); param.ParameterName = "@da_xoa"; param.Value = 0; SqlParameter param_ma_tac_gia = new SqlParameter(); param_ma_tac_gia.ParameterName = "@ma_tac_gia"; param_ma_tac_gia.Value = tacgia.Matacgia; // SqlCommand cmd = new SqlCommand(query, connect); cmd.Parameters.Add(param_ten_tac_gia); cmd.Parameters.Add(param_tieu_su); cmd.Parameters.Add(param); cmd.Parameters.Add(param_ma_tac_gia); if (cmd.ExecuteNonQuery() > 0) { ketqua = true; } } catch (Exception err) { throw; } finally { connect.Close(); } } return(ketqua); }
public bool insert_tacgia(BEL.BEL_tacgia tacgia) { bool ketqua = false; using (SqlConnection connect = new SqlConnection(connectionString.connectionstring)) { try { connect.Open(); string query = "insert into tacgia(ten_tac_gia,tieu_su,da_xoa) values(@ten_tac_gia,@tieu_su,@da_xoa)"; SqlCommand cmd = new SqlCommand(query, connect); //SqlDataReader reader = null; SqlParameter param_ten_tac_gia = new SqlParameter(); param_ten_tac_gia.ParameterName = "@ten_tac_gia"; param_ten_tac_gia.Value = tacgia.Tentacgia; SqlParameter param_tieu_su = new SqlParameter(); param_tieu_su.ParameterName = "@tieu_su"; param_tieu_su.Value = tacgia.Tieusu; SqlParameter param = new SqlParameter(); param.ParameterName = "@da_xoa"; param.Value = 0; // SqlCommand cmd = new SqlCommand(query, connect); cmd.Parameters.Add(param_ten_tac_gia); cmd.Parameters.Add(param_tieu_su); cmd.Parameters.Add(param); // reader = cmd.ExecuteReader(); // data.Load(reader); //SqlCommand command = new SqlCommand(sql, connect); if (cmd.ExecuteNonQuery() > 0) { ketqua = true; } } catch (Exception err) { } finally { connect.Close(); } } return(ketqua); }
public bool capnhat_trangthai_xoa(BEL.BEL_tacgia tacgia) { bool ketqua = false; using (SqlConnection connect = new SqlConnection(connectionString.connectionstring)) { try { connect.Open(); string query = "update tacgia set da_xoa=@da_xoa where ma_tac_gia=@ma_tac_gia"; SqlCommand cmd = new SqlCommand(query, connect); SqlParameter param = new SqlParameter(); param.ParameterName = "@da_xoa"; param.Value = 0; SqlParameter param_ma_tac_gia = new SqlParameter(); param_ma_tac_gia.ParameterName = "@ma_tac_gia"; param_ma_tac_gia.Value = tacgia.Matacgia; cmd.Parameters.Add(param); cmd.Parameters.Add(param_ma_tac_gia); // SqlCommand command = new SqlCommand(query, connect); if (cmd.ExecuteNonQuery() > 0) { ketqua = true; } } catch (Exception err) { throw; } finally { connect.Close(); } } return(ketqua); }