private void buttonThem_Click(object sender, EventArgs e) { try { Chitietxuat ctx = new Chitietxuat() { maPX = MaPX, maHH = comboBoxMaHH.SelectedValue.ToString(), soLuong = int.Parse(textBoxSL.Text), thanhTien = decimal.Parse(textBoxDonGia.Text) }; px.tongTien += ctx.soLuong * ctx.thanhTien; HangHoa hh = db.HangHoas.Single(x => x.maHH == ctx.maHH); hh.soluong += ctx.soLuong; db.Chitietxuats.Add(ctx); db.SaveChanges(); FormCTXuat_Load(sender, e); MessageBox.Show("Thêm thành công!"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void buttonSua_Click(object sender, EventArgs e) { try { Chitietxuat ctx = db.Chitietxuats.SingleOrDefault(x => x.maPX == MaPX && x.maHH == selectedMaHH); int soLuongHHcu = int.Parse(ctx.soLuong.ToString()); decimal donGiaCu = decimal.Parse(ctx.thanhTien.ToString()); ctx.maHH = comboBoxMaHH.SelectedValue.ToString(); ctx.soLuong = int.Parse(textBoxSL.Text); ctx.thanhTien = decimal.Parse(textBoxDonGia.Text); decimal thanhTienCu = soLuongHHcu * donGiaCu; decimal thanhTienMoi = decimal.Parse(ctx.thanhTien.ToString()) * int.Parse(ctx.soLuong.ToString()); px.tongTien += (thanhTienMoi - thanhTienCu); HangHoa hh = db.HangHoas.Single(x => x.maHH == ctx.maHH); hh.soluong = soLuongHHcu - ctx.soLuong; db.SaveChanges(); FormCTXuat_Load(sender, e); MessageBox.Show("Sửa thành công!"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void buttonXoa_Click(object sender, EventArgs e) { if (MessageBox.Show("Ban muon xoa?", "Thong bao", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes) { try { Chitietxuat ctx = db.Chitietxuats.SingleOrDefault(x => x.maPX == MaPX && x.maHH == selectedMaHH); px.tongTien -= ctx.soLuong * ctx.thanhTien; HangHoa hh = db.HangHoas.SingleOrDefault(x => x.maHH == ctx.maHH); hh.soluong += ctx.soLuong; db.Chitietxuats.Remove(ctx); db.SaveChanges(); FormCTXuat_Load(sender, e); MessageBox.Show("Xóa thành công!"); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
public ActionResult DeleteConfirmed(int id) { Chitietxuat chitietxuat = db.Chitietxuats.Find(id); db.Chitietxuats.Remove(chitietxuat); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "STT,Maphieuxuat,Mahanghoa,soluong,Ngayxuat,Makhachhang")] Chitietxuat chitietxuat) { if (ModelState.IsValid) { db.Entry(chitietxuat).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Mahanghoa = new SelectList(db.Hanghoas, "Mahanghoa", "Tenhanghoa", chitietxuat.Mahanghoa); ViewBag.Maphieuxuat = new SelectList(db.Phieuxuats, "Maphieuxuat", "Makhachhang", chitietxuat.Maphieuxuat); return(View(chitietxuat)); }
// GET: Chitietxuats/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Chitietxuat chitietxuat = db.Chitietxuats.Find(id); if (chitietxuat == null) { return(HttpNotFound()); } return(View(chitietxuat)); }
// GET: Chitietxuats/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Chitietxuat chitietxuat = db.Chitietxuats.Find(id); if (chitietxuat == null) { return(HttpNotFound()); } ViewBag.Mahanghoa = new SelectList(db.Hanghoas, "Mahanghoa", "Tenhanghoa", chitietxuat.Mahanghoa); ViewBag.Maphieuxuat = new SelectList(db.Phieuxuats, "Maphieuxuat", "Makhachhang", chitietxuat.Maphieuxuat); return(View(chitietxuat)); }