public bool SuaDauSach(DauSach x) { OpenConnection(); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "SuaDauSach"; command.Connection = conn; command.Parameters.Add("@madausach", SqlDbType.NChar).Value = x.MaDauSach; command.Parameters.Add("@tendausach", SqlDbType.NChar).Value = x.TenDauSach; command.Parameters.Add("@tacgia", SqlDbType.NChar).Value = x.TacGia; command.Parameters.Add("@theloai", SqlDbType.NChar).Value = x.TheLoai; command.Parameters.Add("@NXB", SqlDbType.NChar).Value = x.NhaXuatBan; command.Parameters.Add("@ngonngu", SqlDbType.NChar).Value = x.NgonNgu; int kq = command.ExecuteNonQuery(); return(kq > 0); }
public bool ThemDauSach(DauSachDTO dauSachDTO) { try { DauSach dauSach = new DauSach { MaDauSach = dauSachDTO.MaDauSach, TenDauSach = dauSachDTO.TenDauSach, MaTheLoai = dauSachDTO.MaTheLoai, TrangThai = true }; data.DauSaches.Add(dauSach); data.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public List <DauSach> LayDauSach() { List <DauSach> dsDS = new List <DauSach>(); OpenConnection(); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.Text; command.CommandText = "select * from DauSach"; command.Connection = conn; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { DauSach temp = new DauSach(); temp.MaDauSach = reader.GetString(0); temp.TenDauSach = reader.GetString(1); dsDS.Add(temp); } reader.Close(); return(dsDS); }
public List <Sach> TimKiemSachChiTiet(DauSach temp) { List <Sach> ltk = new List <Sach>(); OpenConnection(); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.Text; command.CommandText = "select * from dbo.TimKiemNangCao(@tendausach,@tacgia,@theloai,@ngonngu,@nxb)"; command.Connection = conn; command.Parameters.Add("@tendausach", SqlDbType.NVarChar).Value = temp.TenDauSach; command.Parameters.Add("@tacgia", SqlDbType.NVarChar).Value = temp.TacGia; command.Parameters.Add("@theloai", SqlDbType.NVarChar).Value = temp.TheLoai; command.Parameters.Add("@ngonngu", SqlDbType.NVarChar).Value = temp.NgonNgu; command.Parameters.Add("@nxb", SqlDbType.NVarChar).Value = temp.NhaXuatBan; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Sach kq = new Sach(); kq.MaSach = reader.GetString(0); if (!reader.IsDBNull(1)) { kq.TenDauSach = reader.GetString(1); } else { kq.TenDauSach = "Chưa có thông tin"; } if (!reader.IsDBNull(2)) { kq.Tap = reader.GetInt32(2); } else { kq.Tap = 0; } if (!reader.IsDBNull(3)) { kq.LanTaiBan = reader.GetInt32(3); } else { kq.LanTaiBan = 0; } if (!reader.IsDBNull(4)) { kq.ViTri = reader.GetString(4); } else { kq.ViTri = "Chưa có thông tin"; } if (!reader.IsDBNull(5)) { kq.TacGia = reader.GetString(5); } else { kq.TacGia = "Chưa có thông tin"; } if (!reader.IsDBNull(6)) { kq.TheLoai = reader.GetString(6); } else { kq.TheLoai = "Chưa có thông tin"; } if (!reader.IsDBNull(7)) { kq.NgonNgu = reader.GetString(7); } else { kq.NgonNgu = "Chưa có thông tin"; } if (!reader.IsDBNull(8)) { kq.NXB = reader.GetString(8); } else { kq.NXB = "Chưa có thông tin"; } ltk.Add(kq); } reader.Close(); return(ltk); }
public DauSach LayThongTinDauSach(string MaDauSach) { DauSach kq = new DauSach(); OpenConnection(); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.Text; command.CommandText = "select * from dbo.ThongTinChiTietDauSach(@madausach)"; command.Connection = conn; command.Parameters.Add("@madausach", SqlDbType.NChar).Value = MaDauSach; SqlDataReader reader = command.ExecuteReader(); if (reader.Read()) { kq.MaDauSach = reader.GetString(0); if (!reader.IsDBNull(1)) { kq.TenDauSach = reader.GetString(1); } else { kq.TenDauSach = "Chưa có thông tin"; } if (!reader.IsDBNull(2)) { kq.TacGia = reader.GetString(2); } else { kq.TacGia = "Chưa có thông tin"; } if (!reader.IsDBNull(3)) { kq.TheLoai = reader.GetString(3); } else { kq.TheLoai = "Chưa có thông tin"; } if (!reader.IsDBNull(4)) { kq.NgonNgu = reader.GetString(4); } else { kq.NgonNgu = "Chưa có thông tin"; } if (!reader.IsDBNull(5)) { kq.NhaXuatBan = reader.GetString(5); } else { kq.NhaXuatBan = "Chưa có thông tin"; } } reader.Close(); return(kq); }
public string timTheLoai(string MaDauSach) { DauSach dauSach = data.DauSaches.SingleOrDefault(u => u.MaDauSach == MaDauSach); return(dauSach.MaTheLoai); }
public List <DauSach> ThongKeDauSach() { List <DauSach> LS = new List <DauSach>(); OpenConnection(); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.Text; command.CommandText = "select * from ThongKeDauSach"; command.Connection = conn; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { DauSach temp = new DauSach(); temp.MaDauSach = reader.GetString(0); if (!reader.IsDBNull(1)) { temp.TenDauSach = reader.GetString(1); } else { temp.TenDauSach = "Chưa có thông tin"; } if (!reader.IsDBNull(2)) { temp.TacGia = reader.GetString(2); } else { temp.TacGia = "Chưa có thông tin"; } if (!reader.IsDBNull(3)) { temp.NgonNgu = reader.GetString(3); } else { temp.NgonNgu = "Chưa có thông tin"; } if (!reader.IsDBNull(4)) { temp.TheLoai = reader.GetString(4); } else { temp.TheLoai = "Chưa có thông tin"; } if (!reader.IsDBNull(5)) { temp.NhaXuatBan = reader.GetString(5); } else { temp.NhaXuatBan = "Chưa có thông tin"; } if (!reader.IsDBNull(6)) { temp.SoCuon = reader.GetInt32(6); } else { temp.SoCuon = 0; } LS.Add(temp); } reader.Close(); return(LS); }