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