public List<Sach> getListSach()
{
//String sql = @"SELECT [MaSach]
// ,[TenSach]
// ,[NoiDungTT]
// ,[SoTrang]
// ,[Gia]
// ,[SoLuong]
// ,[NgayNhap]
// ,[NXB].[MaNXB]
// ,[TenNXB]
// ,[DiaChiNXB]
// ,[DienThoaiNXB]
// ,[Website]
// ,[TacGia].[MaTG]
// ,[HoTenTG]
// ,[DiaChiTG]
// ,[DienThoaiTG]
// ,[TheLoai].[MaTL]
// ,[TenTL]
// ,[GhiChu]
// ,[TinhTrang]
// FROM [dbo].[Sach] JOIN [NXB] on [Sach].MaNXB = NXB.MaNXB
// JOIN TacGia ON [TacGia].MaTG = Sach.MaTG
// JOIN [TheLoai] ON [TheLoai].MaTL = Sach.MaTL";
string sql = "select * from viewSach";
DataTable table = dbcnn.getdata(sql);
List<Sach> listSach = new List<Sach>();
foreach (DataRow row in table.Rows)
{
Sach newSach = new Sach();
newSach.MaSach = (int)row["MaSach"];
newSach.TenSach = (string)row["TenSach"];
newSach.NoiDungTT = (string)row["NoiDungTT"];
newSach.SoTrang = (int)row["SoTrang"];
newSach.Gia = (int)row["Gia"];
newSach.SoLuong = (int)row["SoLuong"];
newSach.NgayNhap = (DateTime)row["NgayNhap"];
newSach.nxb.MaNXB = (int)row["MaNXB"];
newSach.nxb.TenNXB = (string)row["TenNXB"];
newSach.nxb.DiaChiNXB = (string)row["DiaChiNXB"];
newSach.nxb.DienThoaiNXB = (string)row["DienThoaiNXB"];
newSach.nxb.Website = (string)row["Website"];
newSach.tacGia.MaTG = (int)row["MaTG"];
newSach.tacGia.HoTenTG = (string)row["HoTenTG"];
newSach.tacGia.DiaChiTG = (string)row["DiaChiTG"];
newSach.tacGia.DienThoaiTG = (string)row["DienThoaiTG"];
newSach.theLoai.MaTL = (int)row["MaTL"];
newSach.theLoai.TenTL = (string)row["TenTL"];
newSach.theLoai.GhiChu = row["GhiChu"].ToString();
newSach.TinhTrang = (bool)row["TinhTrang"];
listSach.Add(newSach);
}
return listSach;
}
public ActionResult Xoa(int id)
{
KhachHang kh = new KhachHang();
kh = Session["KhachHang"] as KhachHang;
if (kh == null)
{
return(RedirectToAction("Index", "DangNhap"));
}
else if (kh.LoaiKH == "Khách Hàng")
{
return(RedirectToAction("Index", "Home"));
}
else if (kh.LoaiKH == "Nhập Liệu")
{
return(RedirectToAction("Index", "Sach"));
}
else
{
using (var db = new BookContext())
{
Log log = new Log();
log.ThoiGian = DateTime.Now;
log.TacVu = "Admin";
log.TaiKhoan = kh.TaiKhoan;
Sach sach = db.Sach.Find(id);
log.HanhDong = "Đã xóa sách có tên " + sach.TenSach;
db.Log.Add(log);
sach.flag = true;
db.SaveChanges();
return(RedirectToAction("Index", "Sach"));
}
}
}
public JsonResult saveBaoSach(DaiLyDebt O)
{
DateTime date = DateTime.Now; var dt = date.Date;
bool status = false;
if (ModelState.IsValid)
{
int i = int.Parse(Session["DaiLyId"].ToString());
NXBDebt u = db.NXBDebts.Where(x => x.fk_sachID == O.fk_sachID).SingleOrDefault();
if (u != null)
{
u.nxbdebt_banduoc += O.dailydebt_soluong;
}
DaiLyDebt d = db.DaiLyDebts.Where(x => x.fk_dailyID == i && x.fk_sachID == O.fk_sachID).SingleOrDefault();
d.dailydebt_soluong -= O.dailydebt_soluong;
if (d.dailydebt_soluong == 0)
{
db.DaiLyDebts.Remove(d);
}
List <DaiLyDebtTien> li = db.DaiLyDebtTiens.Where(x => x.fk_dailyID == i).ToList();
var maxdate = li.Select(x => x.dailydebttien_ngaycapnhat).Max();
DaiLyDebtTien n = db.DaiLyDebtTiens.Where(x => x.fk_dailyID == i && x.dailydebttien_ngaycapnhat == maxdate).FirstOrDefault();
Sach s = db.Saches.Where(x => x.sachID == O.fk_sachID).SingleOrDefault();
var maxDdoanhthu = db.DoanhThus.Select(x => x.doanhthu_ngaycapnhat).Max();
DoanhThu r = db.DoanhThus.Where(x => x.doanhthu_ngaycapnhat == maxDdoanhthu).SingleOrDefault();
if (r != null)
{
if (dt == r.doanhthu_ngaycapnhat)
{
r.doanhthu_tien += O.dailydebt_soluong * s.sach_giaxuat;
}
else if (dt > r.doanhthu_ngaycapnhat)
{
r.doanhthu_tien += O.dailydebt_soluong * s.sach_giaxuat;
r.doanhthu_ngaycapnhat = dt;
db.DoanhThus.Add(r);
}
else if (dt < r.doanhthu_ngaycapnhat)
{
List <DoanhThu> dd = db.DoanhThus.Where(x => x.doanhthu_ngaycapnhat >= dt).ToList();
foreach (var c in dd)
{
r.doanhthu_tien += O.dailydebt_soluong * s.sach_giaxuat;
}
DoanhThu m = db.DoanhThus.Where(x => x.doanhthu_ngaycapnhat == dt).SingleOrDefault();
if (m == null)
{
DoanhThu v = new DoanhThu {
doanhthu_tien = O.dailydebt_soluong * s.sach_giaxuat, doanhthu_ngaycapnhat = dt
};
db.DoanhThus.Add(v);
}
}
}
else
{
DoanhThu v = new DoanhThu {
doanhthu_tien = O.dailydebt_soluong * s.sach_giaxuat, doanhthu_ngaycapnhat = dt
};
db.DoanhThus.Add(v);
}
if (n != null)
{
if (dt == n.dailydebttien_ngaycapnhat)
{
n.dailydebttien_tien -= O.dailydebt_soluong * s.sach_giaxuat;
n.dailydebttien_sach -= O.dailydebt_soluong;
}
else if (dt > n.dailydebttien_ngaycapnhat)
{
n.dailydebttien_tien -= O.dailydebt_soluong * s.sach_giaxuat;
n.dailydebttien_sach -= O.dailydebt_soluong;
n.fk_dailyID = i;
n.dailydebttien_ngaycapnhat = dt;
db.DaiLyDebtTiens.Add(n);
}
else if (dt < n.dailydebttien_ngaycapnhat)
{
List <DaiLyDebtTien> dd = db.DaiLyDebtTiens.Where(x => x.fk_dailyID == i && x.dailydebttien_ngaycapnhat >= dt).ToList();
foreach (var c in dd)
{
c.dailydebttien_tien -= O.dailydebt_soluong * s.sach_giaxuat;
c.dailydebttien_sach -= O.dailydebt_soluong;
}
}
db.SaveChanges();
status = true;
}
else
{
status = false;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public ActionResult ImportExcel(HttpPostedFileBase upload)
{
using (var stream = upload.InputStream)
{
IExcelDataReader reader;
reader = ExcelDataReader.ExcelReaderFactory.CreateReader(stream);
var conf = new ExcelDataSetConfiguration()
{
ConfigureDataTable = _ => new ExcelDataTableConfiguration
{
UseHeaderRow = true
}
};
var dataSet = reader.AsDataSet(conf);
var dataTable = dataSet.Tables[0];
int count = 0;
while (reader.Read())
{
if (count > 0)
{
Sach sach = new Sach();
//MerchantID = (int)double.Parse(reader.GetString(0)),
//SachID = int.Parse(reader.GetString(0)),
sach.TenSach = reader.GetString(1);
sach.TacGia = reader.GetString(2);
sach.NhaXuatBanID = int.Parse(reader.GetString(3));
sach.NgayXuatBan = DateTime.Parse(reader.GetString(4));
sach.SoTrang = int.Parse(reader.GetString(5));
sach.LoaiBiaID = int.Parse(reader.GetString(6));
sach.MerchantID = int.Parse(reader.GetString(7));
sach.TrangThai = bool.Parse(reader.GetString(8));
sach.GiaTien = (decimal)decimal.Parse(reader.GetString(9));
if (reader.GetString(10) == null)
{
sach.GiaKhuyenMai = 0;
}
else
{
sach.GiaKhuyenMai = decimal.Parse(reader.GetString(10));
}
sach.MoTa = reader.GetString(11);
if (reader.GetString(12) == null)
{
sach.SoLuong = 0;
}
else
{
sach.SoLuong = int.Parse(reader.GetString(12));
}
sach.TheLoaiID = int.Parse(reader.GetString(13));
db.Saches.Add(sach);
db.SaveChanges();
}
count++;
}
var result = db.Saches.ToList();
ViewBag.DropdownStatus = new SelectList(db.TheLoais, "TenTheLoai", "TenTheLoai");
ViewBag.DropdownStatusNXB = new SelectList(db.NhaXuatBans, "TenNXB", "TenNXB");
var listSach = db.Saches.ToList();
return(View("Index", listSach));
}
}
private void Edit(Sach s)
{
InsertNew fm = new InsertNew(s);
fm.ShowDialog();
}
public Nullable <int> GetTongSachMuon(Sach sach)
{
return(_sachControls.getTongSachMuon(sach));
}
public async Task <JsonResult> Create()
{
bool status = false;
string mess = "";
var pic = HttpContext.Request.Form.Files["HelpSectionImages"];
Microsoft.Extensions.Primitives.StringValues book;
HttpContext.Request.Form.TryGetValue("Book", out book);
SachDTO sach = JsonConvert.DeserializeObject <SachDTO>(book);
if (sach.strTap != null && sach.strTap != "")
{
sach.Tap = int.Parse(sach.strTap);
}
else
{
sach.Tap = null;
}
Sach newBook = new Sach();
if (sachBL.CheckTitle(sach.TenSach, sach.Tap))
{
newBook.TenSach = sach.TenSach.Trim();
newBook.Gia = sach.Gia;
newBook.NgayThem = DateTime.Now.Date;
newBook.SoLuong = 0;
newBook.SoLuotMua = 0;
newBook.Tap = sach.Tap;
newBook.TomTat = sach.TomTat;
newBook.TrangThai = sach.TrangThai;
var fileName = newBook.TenSach + newBook.Tap;
var extension = Path.GetExtension(pic.FileName);
newBook.HinhAnh = LanguageHelper.RemoveUnicode(fileName) + extension;
var path = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot\\images\\HinhAnhSach", LanguageHelper.RemoveUnicode(fileName) + extension);
if (sachBL.CheckCategory(sach.TenDanhMuc))
{
newBook.IdDanhMuc = sachBL.SelectCategoryByName(sach.TenDanhMuc).Id;
if (sachBL.CheckAuthor(sach.TenTacGia))
{
newBook.IdTacGia = sachBL.SelectAuthorByName(sach.TenTacGia).Id;
if (sachBL.CheckPublisher(sach.TenNhaXuatBan))
{
newBook.IdNxb = sachBL.SelectPublisherByName(sach.TenNhaXuatBan).Id;
sachBL.Create(newBook);
using (var stream = new FileStream(path, FileMode.Create))
{
await pic.CopyToAsync(stream);
}
status = true;
mess = "Thêm sách mới thành công!";
}
else
{
mess = "Nhà xuất bản chưa được tạo!";
status = false;
}
}
else
{
mess = "Tác giả chưa được tạo!";
status = false;
}
}
else
{
mess = "Danh mục chưa được tạo!";
status = false;
}
}
else
{
mess = "Sách đã tồn tại!";
status = false;
}
return(Json(new
{
message = mess,
status = status
}));
}
public void LoadSach(Sach book)
{
txtTenSach.Text = book.Tensach;
txtTacGia.Text = book.Tacgia;
txtGioiThieu.Text = book.Gioithieu;
}
public bool Update(Sach item)
{
return(_repository.Update(item));
}
public Sach getSachById(int id)
{
//String sql = @"SELECT [MaSach]
// ,[TenSach]
// ,[NoiDungTT]
// ,[SoTrang]
// ,[Gia]
// ,[SoLuong]
// ,[NgayNhap]
// ,[NXB].[MaNXB]
// ,[TenNXB]
// ,[DiaChiNXB]
// ,[DienThoaiNXB]
// ,[Website]
// ,[TacGia].[MaTG]
// ,[HoTenTG]
// ,[DiaChiTG]
// ,[DienThoaiTG]
// ,[TheLoai].[MaTL]
// ,[TenTL]
// ,[GhiChu]
// ,[TinhTrang]
// FROM [dbo].[Sach] JOIN [NXB] on [Sach].MaNXB = NXB.MaNXB
// JOIN TacGia ON [TacGia].MaTG = Sach.MaTG
// JOIN [TheLoai] ON [TheLoai].MaTL = Sach.MaTL
// FROM [dbo].[Sach] WHERE [MaSach]=" + id;
string sql = @"select * from viewSach WHERE MaSach=" + id;
DataTable table = dbcnn.getdata(sql);
Sach newSach = new Sach();
if (table.Rows.Count == 1)
{
newSach.MaSach = (int)table.Rows[0]["MaSach"];
newSach.TenSach = (string)table.Rows[0]["TenSach"];
newSach.NoiDungTT = (string)table.Rows[0]["NoiDungTT"];
newSach.SoTrang = (int)table.Rows[0]["SoTrang"];
newSach.Gia = (int)table.Rows[0]["Gia"];
newSach.SoLuong = (int)table.Rows[0]["SoLuong"];
newSach.NgayNhap = (DateTime)table.Rows[0]["NgayNhap"];
newSach.nxb.MaNXB = (int)table.Rows[0]["MaNXB"];
newSach.nxb.TenNXB = (string)table.Rows[0]["TenNXB"];
newSach.nxb.DiaChiNXB = (string)table.Rows[0]["DiaChiNXB"];
newSach.nxb.DienThoaiNXB = (string)table.Rows[0]["DienThoaiNXB"];
newSach.nxb.Website = (string)table.Rows[0]["Website"];
newSach.tacGia.MaTG = (int)table.Rows[0]["MaTG"];
newSach.tacGia.HoTenTG = (string)table.Rows[0]["HoTenTG"];
newSach.tacGia.DiaChiTG = (string)table.Rows[0]["DiaChiTG"];
newSach.tacGia.DienThoaiTG = (string)table.Rows[0]["DienThoaiTG"];
newSach.theLoai.MaTL = (int)table.Rows[0]["MaTL"];
newSach.theLoai.TenTL = (string)table.Rows[0]["TenTL"];
newSach.theLoai.GhiChu = table.Rows[0]["GhiChu"].ToString();
newSach.TinhTrang = (bool)table.Rows[0]["TinhTrang"];
return newSach;
}
return null;
}
public bool deleteSach(Sach sach)
{
string sql = "DELETE FROM [dbo].[Sach]"
+ "WHERE MaSach = "+sach.MaSach;
return dbcnn.ThucThiSQL(sql);
}
public bool updateSach(Sach sach)
{
String sql = @"UPDATE [dbo].[Sach]
SET [TenSach] = N'" + sach.TenSach + @"'
,[NoiDungTT] = N'" + sach.NoiDungTT + @"'
,[SoTrang] = " + sach.SoTrang + @"
,[Gia] = " + sach.Gia + @"
,[SoLuong] = " + sach.SoLuong + @"
,[NgayNhap] = '" + sach.NgayNhap + @"'
,[MaNXB] = " + sach.nxb.MaNXB + @"
,[MaTG] = " + sach.tacGia.MaTG + @"
,[MaTL] = " + sach.theLoai.MaTL + @"
,[TinhTrang] = " + Convert.ToInt16(sach.TinhTrang) + @"
WHERE [MaSach]=" + sach.MaSach;
return dbcnn.ThucThiSQL(sql);
}
public bool insertSach(Sach sach)
{
String sql = @"INSERT INTO [dbo].[Sach]
([TenSach]
,[NoiDungTT]
,[SoTrang]
,[Gia]
,[SoLuong]
,[NgayNhap]
,[MaNXB]
,[MaTG]
,[MaTL]
,[TinhTrang])
VALUES
(N'" + sach.TenSach + @"'
,N'" + sach.NoiDungTT + @"'
," + sach.SoLuong + @"
," + sach.Gia + @"
," + sach.SoTrang + @"
,'" + sach.NgayNhap + @"'
," + sach.nxb.MaNXB + @"
," + sach.tacGia.MaTG + @"
," + sach.theLoai.MaTL + @"
," + Convert.ToInt16(sach.TinhTrang) + ")";
return dbcnn.ThucThiSQL(sql);
}
public bool xoaSach(Sach sach)
{
return sachDAL.deleteSach(sach);
}
public bool ThemSach(Sach sach)
{
return sachDAL.insertSach(sach);
}
private void lkBook_EditValueChanged(object sender, EventArgs e)
{
sach = sachBus.GetSachByID(int.Parse(lkBook.EditValue.ToString()));
}
public int Add(Sach item)
{
return(_repository.Add(item));
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Sach s = new Sach();
if (hdId.Value != null || hdId.Value != "")
{
s = sbll.LaySach(hdId.Value);
}
s.TenSach = Ten.Text;
s.Tap = short.Parse(Tap.Text);
s.MaNXB = NhaXB.SelectedValue;
s.MaPhanLoai = MsPhanLoai.Text;
s.MaNgonNgu = NgonNgu.SelectedValue;
s.NuocXuatBan = NuocXuatBan.Text;
s.ISBN_ISSN = MaVach.Text;
s.LanXuatBan = short.Parse(LanXuatBan.Text);
s.SoTrang = short.Parse(SoTrang.Text);
s.GiaBia = float.Parse(GiaBia.Text);
s.KichThuoc = KichThuoc.Text;
s.TuKhoa = TuKhoa.Text;
s.SachDichHayKhong = CoDich.Checked;
s.TomTatNoiDung = NoiDung.Text;
if (Anh.HasFile)
{
s.UrlAnhBia = Up(Anh);
}
if (Scan.HasFile)
{
s.DuongDanBanScan = Up(Scan);
}
s.GhiChu = GhiChu.Text;
if (hdId.Value == null || hdId.Value == "")
{
s.MaSach = Tool.SinhMa();
sbll.Them(s);
string[] dstg = txtDSTG.Text.Split(',');
foreach (string tg in dstg)
{
stgbll.Them(new Sach_TacGia(s.MaSach, tg));
}
string[] dslv = txtDSLV.Text.Split(',');
foreach (string lv in dslv)
{
slvbll.Them(new Sach_LinhVuc(s.MaSach, lv));
}
string[] dstl = txtDSTL.Text.Split(',');
foreach (string tl in dstl)
{
stlbll.Them(new Sach_TheLoai(s.MaSach, tl));
}
int sl = int.Parse(SoLuong.Text);
scbbll.ThemDSSachCB(s.MaSach, sl);
}
else
{
sbll.Sua(s);
stgbll.Xoa(s.MaSach);
stlbll.Xoa(s.MaSach);
slvbll.Xoa(s.MaSach);
string[] dstg = txtDSTG.Text.Split(',');
foreach (string tg in dstg)
{
stgbll.Them(new Sach_TacGia(s.MaSach, tg));
}
string[] dslv = txtDSLV.Text.Split(',');
foreach (string lv in dslv)
{
slvbll.Them(new Sach_LinhVuc(s.MaSach, lv));
}
string[] dstl = txtDSTL.Text.Split(',');
foreach (string tl in dstl)
{
stlbll.Them(new Sach_TheLoai(s.MaSach, tl));
}
}
EditState.Value = "hide";
}
public bool suaSach(Sach sach)
{
return sachDAL.updateSach(sach);
}
public int CheckChoMuon(Sach sach)
{
return(_sachControls.checkchomuon(sach));
}
//Quan Ly Sach
private void danhSáchSáchToolStripMenuItem1_Click_1(object sender, EventArgs e)
{
Sach sach = new Sach();
sach.ShowDialog();
}
public bool Add(Sach sach)
{
return(_sachControls.Insert(sach));
}
public ActionResult Create(Sach sach)
{
database.Saches.Add(sach);
database.SaveChanges();
return(RedirectToAction("Index"));
}
public bool Edit(Sach sach)
{
return(_sachControls.Update(sach));
}
public bool themSach(Sach s)
{
doc = new XmlDocument(); // Tao moi 1 doi tuong XmlDocument
doc.Load(fileName); // Load file xml theo duong dan
list = new List <Sach>(); // Tao moi 1 danh sach cac sach
loadDataFromDoc(doc, fileName, list);
if (isExistId(list, s.MaSach)) // Kiem tra da ton tai ma
{
return(false); //da ton tai tra ve false
}
//Khong roi vao hai truong hop day ta di thuc hien them sach
XmlElement sach = doc.CreateElement("Sach"); //tạo nút Sach
XmlElement linhVuc = doc.CreateElement("TenLinhVuc");
linhVuc.InnerText = s.LinhVuc;
sach.AppendChild(linhVuc);
XmlElement maSach = doc.CreateElement("MaSach"); //tạo nút con của Sach là MaSach
maSach.InnerText = s.MaSach; //gán giá trị cho MaSach
sach.AppendChild(maSach); //thêm MaSach vào trong Sach(nhận MaSach là con)
XmlElement tenSach = doc.CreateElement("TenSach");
tenSach.InnerText = s.TenSach;
sach.AppendChild(tenSach);
XmlElement tacGia = doc.CreateElement("TenTacGia");
tacGia.InnerText = s.TacGia;
sach.AppendChild(tacGia);
XmlElement namXB = doc.CreateElement("NamXuatBan");
namXB.InnerText = Convert.ToString(s.NamXB);
sach.AppendChild(namXB);
XmlElement ngonNgu = doc.CreateElement("NgonNgu");
ngonNgu.InnerText = s.NgonNgu;
sach.AppendChild(ngonNgu);
XmlElement soLuong = doc.CreateElement("SoLuong");
soLuong.InnerText = Convert.ToString(s.SoLuong);
sach.AppendChild(soLuong);
XmlElement gia = doc.CreateElement("Gia");
gia.InnerText = Convert.ToString(s.Gia);
sach.AppendChild(gia);
doc.DocumentElement.AppendChild(sach);
//root.AppendChild(sach); //sau khi tạo xong thì thêm Sach vào gốc root
doc.Save(fileName); //lưu dữ liệu
return(true);
}
public Sach Add(Sach sach)
{
return(sachRepository.Add(sach));
}
// admin
// Insert item
public long Insert(Sach entity)
{
db.Saches.Add(entity);
db.SaveChanges();
return(entity.MaSach);
}
public void Update(Sach sach)
{
sachRepository.Update(sach);
}
public ActionResult Create(
string tenSach,
string tacGia,
bool add_TacGia,
string tenTacGia,
string gioiTinhTG,
DateTime?ngaySinhTG,
string diaChiTG,
string nhaXuatBan,
bool add_NhaXuatBan,
string tenNhaXuatBan,
string diaChiNXB,
string soDienThoaiNXB,
int doTuoi,
string danhMuc,
bool add_DanhMuc,
string tenDanhMuc,
DateTime?ngayTaoDM,
string tinhTrangDM,
string loaiBia,
string khoGiay,
DateTime ngayXuatBan,
string loaiGiay,
int soTrang,
string chiTiet,
int gia,
double?giamGia,
DateTime?ngayBatDau,
DateTime?ngayKetThuc,
string tenSuKien)
{
if (Request.Files.Count > 0)
{
var image = new string[Request.Files.Count];
for (int i = 0; i < Request.Files.Count; i++)
{
var file = Request.Files[i];
if (file != null && file.ContentLength > 0)
{
var filename = Path.GetFileName(file.FileName);
var path = Path.Combine(Server.MapPath("~/Content/Images/"), filename);
file.SaveAs(path);
image[i] = filename;
}
}
var sach = new Sach();
var ctSach = new CTSach();
var anhSach = new AnhSach();
sach.MaDT = doTuoi;
if (add_TacGia)
{
var tac_Gia = new TacGia()
{
TenTG = tenTacGia,
GioiTinh = gioiTinhTG,
NgaySinh = ngaySinhTG,
DiaChi = diaChiTG
};
context.TacGia.Add(tac_Gia);
context.SaveChanges();
sach.MaTG = tac_Gia.MaTG;
}
else
{
sach.MaTG = int.Parse(tacGia);
}
if (add_NhaXuatBan)
{
var nha_Xuat_Ban = new NhaXuatBan()
{
TenNXB = tenNhaXuatBan,
DiaChi = diaChiNXB,
Sdt = soDienThoaiNXB
};
context.NhaXuatBan.Add(nha_Xuat_Ban);
context.SaveChanges();
sach.MaNXB = nha_Xuat_Ban.MaNXB;
}
else
{
sach.MaNXB = int.Parse(nhaXuatBan);
}
if (add_DanhMuc)
{
var danh_Muc = new DanhMuc()
{
TenDM = tenDanhMuc,
NgayTao = DateTime.Today,
TinhTrang = "Hoạt động"
};
context.DanhMuc.Add(danh_Muc);
context.SaveChanges();
sach.MaDM = danh_Muc.MaDM;
}
else
{
sach.MaDM = int.Parse(danhMuc);
}
context.Sach.Add(sach);
context.SaveChanges();
ctSach.MaS = sach.MaS;
anhSach.MaS = sach.MaS;
ctSach.TenS = tenSach;
ctSach.LoaiBia = loaiBia;
ctSach.NgayXuatBan = ngayXuatBan;
ctSach.Kho = khoGiay;
ctSach.SoTrang = soTrang;
ctSach.Gia = gia;
ctSach.LoaiGiay = loaiGiay;
ctSach.ChiTiet = chiTiet;
context.CTSach.Add(ctSach);
context.SaveChanges();
anhSach.Anh1 = "/Content/Images/" + image[0];
anhSach.Anh2 = "/Content/Images/" + image[1];
anhSach.Anh3 = "/Content/Images/" + image[2];
anhSach.Anh4 = "/Content/Images/" + image[3];
anhSach.Anh5 = "/Content/Images/" + image[4];
anhSach.Anh6 = "/Content/Images/" + image[5];
context.AnhSach.Add(anhSach);
context.SaveChanges();
//giảm giá
if (ngayBatDau.ToString() != "")
{
string bD = ngayBatDau.ToString();
bD = DateTime.Parse(bD).ToString();
string kT = ngayKetThuc.ToString();
kT = DateTime.Parse(kT).ToString();
string gg = giamGia.ToString();
var khuyenMai = new KhuyenMai()
{
MaS = sach.MaS,
KhuyenMai1 = float.Parse(gg),
BatDau = DateTime.Parse(bD),
KetThuc = DateTime.Parse(kT),
TenSuKien = tenSuKien
};
context.KhuyenMai.Add(khuyenMai);
context.SaveChanges();
}
}
return(Redirect("/Administrator/SanPham"));
}
public Sach Delete(Sach sach)
{
return(sachRepository.Delete(sach));
}
public Sach FindEntity(int ID_SP)
{
Sach dbEntry = db.Saches.Find(ID_SP);
return(dbEntry);
}
public void Create(Sach sach)
{
db.Saches.Add(sach);
db.SaveChanges();
}
//Khi chọn tạo sách
private void btnTao_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Bạn có muốn thêm sách", "Thông báo", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
if (String.IsNullOrEmpty(txbTenSach.Text))
{
MessageBox.Show("Tên Sách chưa hợp lệ");
return;
}
if (String.IsNullOrEmpty(txbTacGia.Text))
{
MessageBox.Show("Tên Tác giả chưa hợp lệ");
return;
}
if (String.IsNullOrEmpty(txbGiaBan.Text))
{
MessageBox.Show("Giá bán chưa hợp lệ");
return;
}
if (String.IsNullOrEmpty(txbGiaNhap.Text))
{
MessageBox.Show("Giá nhập chưa hợp lệ");
return;
}
if (cmbLinhVuc.SelectedIndex == -1)
{
MessageBox.Show("Lĩnh vực chưa hợp lệ");
return;
}
if (cmbNXB.SelectedIndex == -1)
{
MessageBox.Show("Nhà Xuất Bản chưa hợp lệ");
return;
}
//Tạo đối tượng
_sach = new Sach()
{
TenSach = txbTenSach.Text,
LinhVucSach = _DMLinhVuc[cmbLinhVuc.SelectedIndex],
TenTacGia = txbTacGia.Text,
NXB = _DMNXB[cmbNXB.SelectedIndex],
Soluong = Decimal.ToInt32(nmbSoLuong.Value),
GiaBan = Int32.Parse(txbGiaBan.Text),
GiaNhap = Int32.Parse(txbGiaNhap.Text),
HinhAnhTypeImage = picHinhAnh.Image,
MoTa = rtxbMoTa.Text.ToString(),
};
//Thêm vào database
if (_sach.isExisted() == true)
{
MessageBox.Show("Tên sách đã tồn tại");
}
else
{
var result = SachManager.add(_sach);
if (result != 0)
{
MessageBox.Show("Tạo mới thành công");
reset();
return;
}
else
{
MessageBox.Show("Không thêm được sách");
}
}
}
else if (dialogResult == DialogResult.No)
{
return;
}
//Kiểm tra điều kiện
}
public void Edit(Sach sp)
{
db.Entry(sp).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
public bool Delete(Sach entity)
{
return(_repository.Delete(entity));
}
private void btnThem_Click(object sender, EventArgs e)
{
if (loiNhap())
{
return;
}
#region nếu trùng khóa chính
var context = new Dtb_NhaSachContext();
var cSach = context.Saches
.Where(s => s.MaSach.Trim() == this.cbbMs.Text.Trim())
.Select(s => s.MaSach).ToList();
if (cSach.Count > 0)
{
this.errorProvider1.SetError(this.cbbMs, "Mã sách không được trùng");
return;
}
else
{
this.errorProvider1.SetError(this.cbbMs, null);
}
#endregion
try
{
var tg = context.Tacgia
.Where(t => t.TenTg == this.cbbMtg.Text.Trim())
.Select(t => new
{
t.MaTg,
}).FirstOrDefault().MaTg.Trim();
var nxb = context.Nxbs
.Where(n => n.TenNxb == this.cbbnxb.Text.Trim())
.Select(n => new
{
n.MaNxb,
}).FirstOrDefault().MaNxb.Trim();
var tl = context.Theloais
.Where(t => t.TenTl == this.cbbMtl.Text.Trim())
.Select(t => new
{
t.MaTl,
}).FirstOrDefault().MaTl.Trim();
var addBook = new Sach()
{
Stt = context.Saches.Count() + 1,
MaSach = this.cbbMs.Text.Trim(),
TenSach = this.txtTenSach.Text.Trim(),
SoLuong = int.Parse(this.txtSoLuong.Text.Trim()),
MaTl = tl,
MaTg = tg,
MaNxb = nxb,
GiaBan = int.Parse(this.txtGiaBan.Text.Trim()),
};
context.Saches.Add(addBook);
context.SaveChanges();
MessageBox.Show("Thêm thành công!!!");
refreshControl();
loadDgvBook();
}
catch
{
MessageBox.Show("Đã xảy ra lỗi. Vui lòng thử lại!");
return;
}
}
public void RemoveLine(Sach sp)
{
lineCollection.RemoveAll(l => l.sach.SachID == sp.SachID);
}
private void btnSua_Click(object sender, EventArgs e)
{
if (loiNhap())
{
return;
}
#region nếu trùng khóa chính khác
var context = new Dtb_NhaSachContext();
if (this.cbbMs.Text.Trim() != this.dgvBook.CurrentRow.Cells[1].Value.ToString().Trim())
{
var cSach = context.Saches
.Where(s => s.MaSach.Trim() == this.cbbMs.Text.Trim())
.Select(s => s.MaSach).ToList();
if (cSach.Count > 0)
{
this.errorProvider1.SetError(this.cbbMs, "Mã sách không được trùng");
return;
}
else
{
this.errorProvider1.SetError(this.cbbMs, null);
}
}
#endregion
try
{
var edit = new Sach()
{
//Stt = int.Parse(this.dgvBook.CurrentRow.Cells[0].Value.ToString().Trim()),
MaSach = this.dgvBook.CurrentRow.Cells[1].Value.ToString().Trim(),
};
var tg = context.Tacgia
.Where(t => t.TenTg == this.cbbMtg.Text.Trim())
.Select(t => new
{
t.MaTg,
}).FirstOrDefault().MaTg.Trim();
var nxb = context.Nxbs
.Where(n => n.TenNxb == this.cbbnxb.Text.Trim())
.Select(n => new
{
n.MaNxb,
}).FirstOrDefault().MaNxb.Trim();
var tl = context.Theloais
.Where(t => t.TenTl == this.cbbMtl.Text.Trim())
.Select(t => new
{
t.MaTl,
}).FirstOrDefault().MaTl.Trim();
edit.Stt = int.Parse(this.dgvBook.CurrentRow.Cells[0].Value.ToString().Trim());
edit.TenSach = this.txtTenSach.Text.Trim();
edit.SoLuong = int.Parse(this.txtSoLuong.Text.Trim());
edit.MaTl = tl;
edit.MaTg = tg;
edit.MaNxb = nxb;
edit.GiaBan = int.Parse(this.txtGiaBan.Text.Trim());
context.Update <Sach>(edit);
context.SaveChanges();
refreshControl();
loadDgvBook();
MessageBox.Show("Sửa thành công!!!!");
}
catch
{
MessageBox.Show("Đã xảy ra lỗi. Vui lòng thử lại!");
return;
}
}
