public void saveNhatKiNhapSach()
{
//NHATKINHAPSACH nhatkinhapsach = repository.getNhatKiNhapSach(view.selectedNhatKiNhapSach);
NHATKINHAPSACH nhatkinhapsach = ViewToModel();
if (valid(nhatkinhapsach) && repository.checkRepeat(nhatkinhapsach) == null)
{
NHATKINHAPSACH kq = repository.saveNhatKiNhapSach(nhatkinhapsach);
//view.Log("Đã lưu thành công");
getListNhatKiNhapSach();
}
else if (repository.checkRepeat(nhatkinhapsach) != null)
{
NHATKINHAPSACH temp = repository.checkRepeat(nhatkinhapsach);
if (view.Log("Mã sách và thời gian trùng lặp,bạn có muốn cộng dồn vào số lượng cũ") == DialogResult.Yes)
{
temp.SOLUONG = temp.SOLUONG + nhatkinhapsach.SOLUONG;
repository.editNhatKiNhapSach(temp, temp.STT);
}
getListNhatKiNhapSach();
}
}
public void editNhatKiNhapSach()
{
NHATKINHAPSACH nhatkinhapsach_moi = ViewToModel();
if (view.selectedNhatKiNhapSach != -1)
{
int manhatkinhapsach_cu = Convert.ToInt32(view.selectedNhatKiNhapSach);
nhatkinhapsach_moi.STT = manhatkinhapsach_cu;
if (valid(nhatkinhapsach_moi) && repository.checkRepeat(nhatkinhapsach_moi) == null)
{
nhatkinhapsach_moi.SOLUONG = nhatkinhapsach_moi.SOLUONG;
NHATKINHAPSACH kq = repository.editNhatKiNhapSach(nhatkinhapsach_moi, manhatkinhapsach_cu);
getListNhatKiNhapSach();
}
else
if (valid(nhatkinhapsach_moi) && repository.checkRepeat(nhatkinhapsach_moi) != null)
{
NHATKINHAPSACH temp = repository.checkRepeat(nhatkinhapsach_moi);
if (view.Log("Mã sách và thời gian trùng lặp,bạn có muốn cộng dồn vào số lượng cũ") == DialogResult.Yes)
{
temp.SOLUONG = temp.SOLUONG + nhatkinhapsach_moi.SOLUONG;
repository.editNhatKiNhapSach(temp, temp.STT);
repository.deleteNhatKiNhapSach(manhatkinhapsach_cu);
}
getListNhatKiNhapSach();
}
}
}
private void ModelToView(NHATKINHAPSACH nhatkinhapsach)
{
//view.STT=nhatkinhapsach.STT;
view.MASACH = nhatkinhapsach.MASACH;
view.NGAYNHAP = nhatkinhapsach.NGAYNHAP;
view.SOLUONG = nhatkinhapsach.SOLUONG;
}
public NHATKINHAPSACH editNhatKiNhapSach(NHATKINHAPSACH nkns, int oldMaNhatKiNhapSach)
{
NHATKINHAPSACH nhatkinhapsach_re = (from c in entity.NHATKINHAPSACHes where c.STT == oldMaNhatKiNhapSach select c).FirstOrDefault();
int change;
if (nhatkinhapsach_re.SOLUONG > nkns.SOLUONG)
{
change = (int)(nhatkinhapsach_re.SOLUONG - nkns.SOLUONG);
KHO kho = (from c in entity.KHOes
where c.MASACH == nhatkinhapsach_re.MASACH
select c).FirstOrDefault();
kho.TONGSOLUONG = kho.TONGSOLUONG - change;
}
else
{
change = (int)(nkns.SOLUONG - nhatkinhapsach_re.SOLUONG);
KHO kho = (from c in entity.KHOes
where c.MASACH == nhatkinhapsach_re.MASACH
select c).FirstOrDefault();
kho.TONGSOLUONG = kho.TONGSOLUONG + change;
}
nhatkinhapsach_re.MASACH = nkns.MASACH;
//saveNhatKiNhapSach(nkns);
//deleteNhatKiNhapSach(nhatkinhapsach_re.STT);
nhatkinhapsach_re.NGAYNHAP = nkns.NGAYNHAP;
nhatkinhapsach_re.SOLUONG = nkns.SOLUONG;
entity.SaveChanges();
return(nhatkinhapsach_re); //nhatkinhapsach cu
}
private NHATKINHAPSACH ViewToModel()
{
NHATKINHAPSACH nhatkinhapsach = new NHATKINHAPSACH();
nhatkinhapsach.MASACH = view.MASACH;
nhatkinhapsach.NGAYNHAP = view.NGAYNHAP;
nhatkinhapsach.SOLUONG = view.SOLUONG;
return(nhatkinhapsach);
}
public void showSelected()
{
if (view.selectedNhatKiNhapSach != -1)
{
NHATKINHAPSACH nhatkinhapsach = repository.getNhatKiNhapSach(view.selectedNhatKiNhapSach);
ModelToView(nhatkinhapsach);
//view.NhatKiNhapSach = nhatkinhapsach;
}
}
public void deleteNhatKiNhapSach()
{
//NHATKINHAPSACH nhatkinhapsach = repository.getNhatKiNhapSach(view.selectedNhatKiNhapSach);
if (view.selectedNhatKiNhapSach != -1)
{
int manhatkinhapsach = Convert.ToInt32(view.selectedNhatKiNhapSach);
NHATKINHAPSACH nhatkinhapsach = repository.getNhatKiNhapSach(manhatkinhapsach);
if (valid(nhatkinhapsach))
{
NHATKINHAPSACH kq = repository.deleteNhatKiNhapSach(manhatkinhapsach);
//view.Log("Đã lưu thành công");
getListNhatKiNhapSach();
}
}
}
public NHATKINHAPSACH saveNhatKiNhapSach(NHATKINHAPSACH nkns)
{
try
{
entity.NHATKINHAPSACHes.Add(nkns); entity.SaveChanges();
KHO kho = (from c in entity.KHOes
where c.MASACH == nkns.MASACH
select c).FirstOrDefault();
kho.TONGSOLUONG = kho.TONGSOLUONG + nkns.SOLUONG;
entity.SaveChanges();
return(nkns);
}
catch (DbUpdateException) // tranh loi update
{
return(null);
}
}
public NHATKINHAPSACH checkRepeat(NHATKINHAPSACH nkns)
{
NHATKINHAPSACH repeat_item = (from c in entity.NHATKINHAPSACHes
where nkns.MASACH == c.MASACH &&
nkns.NGAYNHAP == c.NGAYNHAP &&
nkns.STT != c.STT
select c).FirstOrDefault();
if (repeat_item == null)
{
return(null);
}
else
{
return(repeat_item);
}
}
public bool valid(NHATKINHAPSACH nhatkinhapsach)
{
//xet null
state.Clear();
//if (nhatkinhapsach.SOLUONGCON <0)
// state.addError("soluongcon", "Số lượng còn không được nhỏ hơn 0");
//if (nhatkinhapsach.TONGSOLUONG < 0)
// state.addError("tongsoluong", "Tổng số lượng không được nhỏ hơn 0");
//if (nhatkinhapsach.SOLUONGCON > nhatkinhapsach.TONGSOLUONG)
// state.addError("lonhon", "Số lượng còn không được lớn hơn tổng số lượng");
//if (nhatkinhapsach.MASACH == "")
// state.addError("sach", "Không còn sách để thêm thông tin");
if (nhatkinhapsach.MASACH == "a")
{
state.addError("sach", "Chọn sách để thêm thông tin");
}
return(state.isValid());
}
public NHATKINHAPSACH deleteNhatKiNhapSach(int MaNhatKiNhapSach)
{
NHATKINHAPSACH nhatkinhapsach = (from c in entity.NHATKINHAPSACHes where c.STT == MaNhatKiNhapSach select c).FirstOrDefault();
//entity.SaveChanges();
KHO kho = (from c in entity.KHOes
where c.MASACH == nhatkinhapsach.MASACH
select c).FirstOrDefault();
kho.TONGSOLUONG = kho.TONGSOLUONG - nhatkinhapsach.SOLUONG;
if (kho.SOLUONGCON > kho.TONGSOLUONG)
{
kho.SOLUONGCON = kho.TONGSOLUONG;
}
entity.NHATKINHAPSACHes.Remove(nhatkinhapsach);
entity.SaveChanges();
return(nhatkinhapsach);
}
