public void xoaChiTiet_PhieuXuat(string mahd, string masp)
{
CHITIETPHIEUXUAT hd = qlch.CHITIETPHIEUXUATs.Where(d => d.MACTPHIEUXUAT == mahd && d.MASP == masp).FirstOrDefault();
qlch.CHITIETPHIEUXUATs.DeleteOnSubmit(hd);
qlch.SubmitChanges();
}
public static bool add(ChiTietPhieuXuat chitiet, int masophieuxuat)
{
try
{
using (EntitiesDataContext db = new EntitiesDataContext())
{
CHITIETPHIEUXUAT ct;
ct = (from c in db.CHITIETPHIEUXUATs
where c.masophieuxuat.Equals(masophieuxuat) &&
c.masosach.Equals(chitiet.MaSoSach)
select c).SingleOrDefault();
if (ct != null)
{
return(false);
}
ct = new CHITIETPHIEUXUAT
{
masophieuxuat = masophieuxuat,
masosach = chitiet.MaSoSach,
soluong = chitiet.SoLuong,
dongia = chitiet.DonGia,
trangthai = chitiet.TrangThai == null ? 0 : 1
};
db.CHITIETPHIEUXUATs.InsertOnSubmit(ct);
db.SubmitChanges();
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(false);
}
}
public ChiTietPhieuXuat(CHITIETPHIEUXUAT chitiet)
{
MaSoPhieuXuat = chitiet.masophieuxuat;
MaSoSach = chitiet.masosach;
SoLuong = chitiet.soluong;
DonGia = chitiet.dongia;
TrangThai = chitiet.trangthai;
}
public void suaChiTiet_PhieuXuat(string mahd, string masp, int soluong, decimal thanhtien, string chuthich)
{
CHITIETPHIEUXUAT hd = qlch.CHITIETPHIEUXUATs.Where(d => d.MACTPHIEUXUAT == mahd && d.MASP == masp).FirstOrDefault();
hd.MACTPHIEUXUAT = mahd;
hd.MASP = masp;
hd.SOLUONG = soluong;
hd.THANHTIEN = thanhtien;
hd.CHUTHICH = chuthich;
qlch.SubmitChanges();
}
public ActionResult Delete(string ID, string IDSP)
{
var temp = new CHITIETPHIEUXUAT {
MAPX = ID, MASP = IDSP
};
db.CHITIETPHIEUXUATs.Attach(temp);
db.CHITIETPHIEUXUATs.Remove(temp);
db.SaveChanges();
Session["tab1"] = "chitiet";
return(RedirectToAction("Index1", "PhieuXuat"));
}
public void ThemChiTiet_PhieuXuat(string mapx, string masp, decimal dongia,
int soluong, decimal thanhtien, string chuthich)
{
CHITIETPHIEUXUAT hd = new CHITIETPHIEUXUAT();
hd.MACTPHIEUXUAT = mapx;
hd.MASP = masp;
hd.DONGIA = dongia;
hd.SOLUONG = soluong;
hd.THANHTIEN = thanhtien;
hd.CHUTHICH = chuthich;
qlch.CHITIETPHIEUXUATs.InsertOnSubmit(hd);
qlch.SubmitChanges();
}
public ActionResult Insert()
{
string objmapn = Request.Form["tenpx2"];
string objmasp = Request.Form["tensp"];
int objsoluong = Int32.Parse(Request.Form["soluong"]);
double objdongia = double.Parse(Request.Form["dongia"]);
CHITIETPHIEUXUAT temp = new CHITIETPHIEUXUAT {
MAPX = objmapn, MASP = objmasp, SOLUONG = objsoluong, DONGIAXUAT = objdongia
};
db.CHITIETPHIEUXUATs.Add(temp);
db.SaveChanges();
Session["tab1"] = "chitiet";
return(RedirectToAction("Index1", "PhieuXuat"));
}
public bool insert_CTPX(int idkho, int idpx, int idsp, int soluong, int gianhap, int thanhtien)
{
try
{
CHITIETPHIEUXUAT insert = new CHITIETPHIEUXUAT();
TONKHO tonkho = quanLyKho.TONKHOs.SingleOrDefault(n => n.ID_KHO == idkho && n.ID_SP == idsp);
insert.ID_PX = idpx;
insert.ID_SP = idsp;
insert.SOLUONG = soluong;
insert.DONGIA = (float)gianhap;
insert.THANHTIEN = (float)thanhtien;
quanLyKho.CHITIETPHIEUXUATs.InsertOnSubmit(insert);
tonkho.SOLUONGTON = tonkho.SOLUONGTON - soluong;
quanLyKho.SubmitChanges();
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
public ChiTietPhieuXuat(CHITIETPHIEUXUAT chitiet, SACH sach)
: this(chitiet)
{
Sach = new Sach(sach);
}
