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