public bool capnhattrangthaimoi(BEL.BEL_sach sach) { bool ketqua = false; using (SqlConnection connect = new SqlConnection(connectionString.connectionstring)) { try { connect.Open(); string query = "update sach set da_xoa=@da_xoa where ma_sach=@ma_sach"; SqlCommand cmd = new SqlCommand(query, connect); SqlParameter param = new SqlParameter(); param.ParameterName = "@da_xoa"; param.Value = 0; SqlParameter param_ma_sach = new SqlParameter(); param_ma_sach.ParameterName = "@ma_sach"; param_ma_sach.Value = sach.Ma_sach; cmd.Parameters.Add(param); cmd.Parameters.Add(param_ma_sach); // SqlCommand command = new SqlCommand(query, connect); if (cmd.ExecuteNonQuery() > 0) { ketqua = true; } } catch (Exception err) { throw; } finally { connect.Close(); } } return(ketqua); }
public bool insert_sach(BEL.BEL_sach sach) { bool ketqua = false; using (SqlConnection connect = new SqlConnection(connectionString.connectionstring)) { try { connect.Open(); string query = "insert into sach(ten_sach,so_luong,nam_xuat_ban,ma_nha_xuat_ban,tac_gia,the_loai,gia_muon,ngay_nhap,da_xoa) values(@ten_sach,@so_luong,@nam_xuat_ban,@nha_xuat_ban,@tac_gia,@the_loai,@gia_muon,@ngay_nhap,@da_xoa)"; SqlCommand cmd = new SqlCommand(query, connect); //SqlDataReader reader = null; SqlParameter param_ten_sach = new SqlParameter(); param_ten_sach.ParameterName = "@ten_sach"; param_ten_sach.Value = sach.Ten_sach; SqlParameter param_so_luong = new SqlParameter(); param_so_luong.ParameterName = "@so_luong"; param_so_luong.Value = sach.So_luong; SqlParameter param_nam_xuat_ban = new SqlParameter(); param_nam_xuat_ban.ParameterName = "@nam_xuat_ban"; param_nam_xuat_ban.Value = sach.Nam_xuat_ban; SqlParameter param_ma_nha_xuat_ban = new SqlParameter(); param_ma_nha_xuat_ban.ParameterName = "@nha_xuat_ban"; param_ma_nha_xuat_ban.Value = sach.Nha_xuat_ban; SqlParameter param_tac_gia = new SqlParameter(); param_tac_gia.ParameterName = "@tac_gia"; param_tac_gia.Value = sach.Tac_gia; SqlParameter param_the_loai = new SqlParameter(); param_the_loai.ParameterName = "@the_loai"; param_the_loai.Value = sach.The_loai; SqlParameter param_gia_muon = new SqlParameter(); param_gia_muon.ParameterName = "@gia_muon"; param_gia_muon.Value = sach.Gia_muon; SqlParameter param_ngay_nhap = new SqlParameter(); param_ngay_nhap.ParameterName = "@ngay_nhap"; param_ngay_nhap.Value = sach.Ngay_nhap; SqlParameter param_da_xoa = new SqlParameter(); param_da_xoa.ParameterName = "@da_xoa"; param_da_xoa.Value = 0; // SqlCommand cmd = new SqlCommand(query, connect); cmd.Parameters.Add(param_ten_sach); cmd.Parameters.Add(param_so_luong); cmd.Parameters.Add(param_nam_xuat_ban); cmd.Parameters.Add(param_ma_nha_xuat_ban); cmd.Parameters.Add(param_tac_gia); cmd.Parameters.Add(param_the_loai); cmd.Parameters.Add(param_gia_muon); cmd.Parameters.Add(param_ngay_nhap); cmd.Parameters.Add(param_da_xoa); // reader = cmd.ExecuteReader(); // data.Load(reader); //SqlCommand command = new SqlCommand(sql, connect); if (cmd.ExecuteNonQuery() > 0) { ketqua = true; } } catch (Exception err) { throw; } finally { connect.Close(); } } return(ketqua); }