private void addData(HoaDonXuat hdxObj) { hdxObj.Mahd = txtMahd.Text.Trim(); hdxObj.NgayLap = txtNgayLap.Text.Trim(); hdxObj.NguoiLap = cboNvl.SelectedValue.ToString(); hdxObj.KhachHang = cboKh.SelectedValue.ToString(); }
public IHttpActionResult PutHoaDonXuat(int id, HoaDonXuat hoaDonXuat) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != hoaDonXuat.IDHoaDonXuat) { return(BadRequest()); } db.Entry(hoaDonXuat).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!HoaDonXuatExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public List <HoaDonXuat> GetHoaDonXuat(string sql) { dp.connect(); List <HoaDonXuat> list = new List <HoaDonXuat>(); { int soluong, dongia; string maxuat, manv, makh, tenxe; try { SqlDataReader dr = dp.ExecuteReader(sql); while (dr.Read()) { maxuat = dr.GetString(0); manv = dr.GetString(1); makh = dr.GetString(2); tenxe = dr.GetString(4); soluong = dr.GetInt32(5); dongia = dr.GetInt32(6); HoaDonXuat em = new HoaDonXuat(maxuat, manv, makh, tenxe, soluong, dongia); list.Add(em); } dr.Close(); return(list); } catch (SqlException ex) { throw ex; } finally { dp.disconnect(); } } }
private void saveData() { //save data to chitietHDN ChiTietHDX ctHDX = new ChiTietHDX(); ctHDX.IDHDX = mIDHDX; ctHDX.IDSP = (long)cboSanPham.EditValue; ctHDX.SoLuong = Convert.ToDouble(txtSoLuong.Text.Trim()); ctHDX.DonGia = Convert.ToDouble(txtDonGia.Text.Trim()); ctHDX.VAT = Convert.ToDouble(txtVAT.Text.Trim()); //save data to SanPham: so luong nhap va gia nhap. SanPham sp = db.SanPhams.FirstOrDefault(x => x.ID == ctHDX.IDSP); sp.SoLuong = sp.SoLuong - ctHDX.SoLuong; if (sp.SoLuong < 0) { MsgUtil.MessageThongBao("Số lượng sản phẩm này trong kho không đủ để xuất! Vui lòng kiểm tra lại."); return; } sp.GiaBan = ctHDX.DonGia * (1 + (Double)ctHDX.VAT / 100); //save data to HDN HoaDonXuat hd = db.HoaDonXuats.FirstOrDefault(x => x.ID == ctHDX.IDHDX); hd.TongTien = hd.TongTien + sp.GiaBan * ctHDX.SoLuong; db.ChiTietHDXes.Add(ctHDX); db.SaveChanges(); loadDatatoGrid(); MsgUtil.MessageThemSuccess(); }
private void btThem_Click(object sender, EventArgs e) { string maxuat, manv, makh, tenxe; int soluong, dongia; maxuat = txtMaXuat.Text.Trim(); manv = txtMaNV.Text.Trim(); makh = txtMaKH.Text.Trim(); tenxe = txtTenXe.Text.Trim(); soluong = int.Parse(txtSoLuong.Text.Trim()); dongia = int.Parse(txtDonGia.Text.Trim()); HoaDonXuat emp = new HoaDonXuat(maxuat, manv, makh, tenxe, soluong, dongia); try { int i = new HoaDonXuatBUS().Add(emp); dgvHoaDonXuat.DataSource = GetHoaDonXuat(); } catch (SqlException ex) { MessageBox.Show(ex.Message); } }
private void btnThem_Click(object sender, EventArgs e) { try { QuanLyBanHangEntities db = new QuanLyBanHangEntities(); if (validate.CheckTextBoxisEmpty(txtMaHDX) && checkExistMaHDX(db)) { HoaDonXuat hdx = new HoaDonXuat(); hdx.IDTK = MsgUtil.userID; hdx.MaHDX = txtMaHDX.Text.Trim(); hdx.NgayXuat = dtNgayXuat.Value; if (txtKhachHang.Text.Length > 0) { hdx.TenKhachHang = txtKhachHang.Text.Trim(); } if (txtDienThoai.Text.Length > 0) { hdx.DienThoai = txtDienThoai.Text.Trim(); } db.HoaDonXuats.Add(hdx); db.SaveChanges(); loadDatatoGrid(); MsgUtil.MessageThemSuccess(); } } catch (Exception v_e) { MsgUtil.MessageThongBao("Lỗi " + v_e); } }
void getDulieu(HoaDonXuat hdxobj) { hdxobj.Mahd = txtMahd.Text.Trim(); hdxobj.NgayLap = txtNgayLap.Text.Trim(); hdxobj.NguoiLap = cboNvl.Text.Trim(); hdxobj.KhachHang = cboKh.Text.Trim(); }
public async Task <ActionResult> DeleteConfirmed(int id) { HoaDonXuat hoaDonXuat = await db.HoaDonXuats.FindAsync(id); db.HoaDonXuats.Remove(hoaDonXuat); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public void ghiFile(ArrayList arrayList) { StreamWriter streamWriter = new StreamWriter(path); foreach (HoaDonXuat HoaDonXuat in arrayList) { streamWriter.WriteLine(HoaDonXuat.ToString()); } streamWriter.Close(); }
private bool checkExistMaHDX(QuanLyBanHangEntities db) { HoaDonXuat dhx = db.HoaDonXuats.FirstOrDefault(x => x.MaHDX == txtMaHDX.Text.Trim()); if (dhx == null) { return(true); } MsgUtil.MessageThongBao("Mã đơn hóa đơn đã tồn tại!"); return(false); }
public IHttpActionResult GetHoaDonXuat(int id) { HoaDonXuat hoaDonXuat = db.HoaDonXuats.Find(id); if (hoaDonXuat == null) { return(NotFound()); } return(Ok(hoaDonXuat)); }
public IHttpActionResult PostHoaDonXuat(HoaDonXuat hoaDonXuat) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.HoaDonXuats.Add(hoaDonXuat); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = hoaDonXuat.IDHoaDonXuat }, hoaDonXuat)); }
public async Task <ActionResult> Edit([Bind(Include = "MaHDXuat,NgayXuat,MaKH,TongTien")] HoaDonXuat hoaDonXuat) { if (ModelState.IsValid) { db.Entry(hoaDonXuat).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.MaKH = new SelectList(db.KhachHangs, "MaKH", "TenKH", hoaDonXuat.MaKH); return(View(hoaDonXuat)); }
// GET: HoaDonXuat/Create public ActionResult Create() { HoaDonXuat model = new HoaDonXuat() { NgayXuat = DateTime.Now, }; ViewBag.MaNV = new SelectList(db.NhanViens, "MaNV", "TenNV"); ViewBag.LoaiSanPham = new SelectList(db.LoaiGiays, "MaLG", "TenLG"); ViewBag.MaKH = new SelectList(db.KhachHangs, "MaKH", "TenKH"); return(View(model)); }
// GET: HoaDonXuat/Delete/5 public async Task <ActionResult> Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HoaDonXuat hoaDonXuat = await db.HoaDonXuats.FindAsync(id); if (hoaDonXuat == null) { return(HttpNotFound()); } return(View(hoaDonXuat)); }
public IHttpActionResult DeleteHoaDonXuat(int id) { HoaDonXuat hoaDonXuat = db.HoaDonXuats.Find(id); if (hoaDonXuat == null) { return(NotFound()); } db.HoaDonXuats.Remove(hoaDonXuat); db.SaveChanges(); return(Ok(hoaDonXuat)); }
// GET: HoaDonXuat/Edit/5 public async Task <ActionResult> Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HoaDonXuat hoaDonXuat = await db.HoaDonXuats.FindAsync(id); if (hoaDonXuat == null) { return(HttpNotFound()); } ViewBag.MaKH = new SelectList(db.KhachHangs, "MaKH", "TenKH", hoaDonXuat.MaKH); return(View(hoaDonXuat)); }
public IHttpActionResult Delete(int id) { using (QuanLyCoffeeDbContext entities = new QuanLyCoffeeDbContext()) { HoaDonXuat hdx = entities.HoaDonXuats.Find(id); if (hdx == null) { return(NotFound()); } entities.HoaDonXuats.Remove(hdx); entities.SaveChanges(); return(Ok("Deleted successfully")); } }
public int Add(HoaDonXuat emp) { //ktra rang buoc tự nhiên if (emp.MaXuat == "") { return(-2); // khong thanh cong se return -2, thành công sẽ return 1 trong DataProvider } try { return(new HoaDonXuatDAO().Add(emp)); } catch (SqlException ex) { throw ex; } }
// GET: HoaDonXuat/Details/5 public async Task <ActionResult> Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HoaDonXuat hoaDonXuat = await db.HoaDonXuats.FindAsync(id); if (hoaDonXuat == null) { return(HttpNotFound()); } ViewData["CT_HoaDonXuat"] = await db.CT_HoaDonXuat.Where(t => t.MaHDXuat == id).ToListAsync(); return(View(hoaDonXuat)); }
public ActionResult EditHoaDonXuat(HoaDonXuatJson hdx) { try { HoaDonXuat temp = db.HoaDonXuat.Where(n => n.MaHDX == hdx.MaHDX).SingleOrDefault(); temp.MaNV = hdx.MaNV; temp.MaKH = hdx.MaKH; temp.NgayXuat = Convert.ToDateTime(hdx.NgayXuat); temp.BacSi = hdx.BacSi; temp.DVCT = hdx.DVCT; db.Entry(temp).State = EntityState.Modified; db.SaveChanges(); return(Json(new { success = true, message = "Sửa thành công" }, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json(new { success = false, message = "Sửa không thành công, lỗi: " + e.Message }, JsonRequestBehavior.AllowGet)); } }
public async Task <JsonResult> CreateConfirmed(HoaDonXuat info, string json1) { string msg = "ok"; //HoaDonNhap info = /*JsonConvert.DeserializeObject<HoaDonNhap>(json0);*/ new HoaDonNhap(); List <CT_HoaDonXuat> cT_HoaDonXuats = JsonConvert.DeserializeObject <List <CT_HoaDonXuat> >(json1); try { //Lấy giá tiền var maGiays = cT_HoaDonXuats.Select(t => t.MaGiay).ToArray(); var giays = await db.Giays.Where(t => maGiays.Contains(t.MaGiay)).ToArrayAsync(); foreach (var giay in giays) { var cT_HoaDonXuat = cT_HoaDonXuats.Where(t => t.MaGiay == giay.MaGiay).FirstOrDefault(); cT_HoaDonXuat.Gia = giay.Gia; } info.TongTien = cT_HoaDonXuats.Select(t => (decimal)t.SoLuong * t.Gia).Sum(); db.HoaDonXuats.Add(info); await db.SaveChangesAsync(); foreach (var cT_HoaDonXuat in cT_HoaDonXuats) { cT_HoaDonXuat.MaHDXuat = info.MaHDXuat; } db.CT_HoaDonXuat.AddRange(cT_HoaDonXuats); await UpdateCount(cT_HoaDonXuats, -1); await db.SaveChangesAsync(); } catch (Exception ex) { msg = "fail"; } return(Json(new { msg = msg })); }
public bool AddData(HoaDonXuat hdObj) { cmd.CommandText = "insert into tb_HoaDonBan (MaHD, MaThe, NgayLap, NhanVien) values ('" + hdObj.Mahd + "','" + hdObj.KhachHang + "', CONVERT (date,'" + hdObj.NgayLap + "',103),'" + hdObj.NguoiLap + "')"; cmd.CommandType = CommandType.Text; cmd.Connection = con.Connection; try { con.OpenConn(); cmd.ExecuteNonQuery(); return(true); } catch (Exception ex) { string mex = ex.Message; cmd.Dispose(); con.CloseConn(); } return(false); }
public IHttpActionResult Update(HoaDonXuatDTO hdx) { using (QuanLyCoffeeDbContext entities = new QuanLyCoffeeDbContext()) { HoaDonXuat hd = entities.HoaDonXuats.Find(hdx.HoaDonXuatID); if (hdx == null) { return(NotFound()); } hd.HoaDonXuatID = hdx.HoaDonXuatID; hd.BanID = hdx.BanID; hd.DaThanhToan = hdx.DaThanhToan; hd.HinhThucThanhToan = hdx.HinhThucThanhToan; hd.TongTien = hdx.TongTien; hd.TenKhachHang = hdx.TenKhachHang; entities.SaveChanges(); return(Ok(hdx)); } }
private void btnThemHoaDon_Click(object sender, EventArgs e) { int idNPP = listNPP.Where(x => x.Key == cbNPP.Text).SingleOrDefault().Value; HoaDonXuat hoaDonXuat = new HoaDonXuat(txtMaHoaDonXuat.Text, DateTime.Now.ToString(), txtMaNhanVien .Text, "ghi", idNPP.ToString()); hoaDonXuat.SaveToDatabase(); foreach (ListViewItem item in lsvChiTiet.Items) { ChiTietHoaDonXuat chiTietHoaDonXuat = new ChiTietHoaDonXuat(txtMaHoaDonXuat.Text, item.SubItems[0].Text, item.SubItems[3].Text, txtMaLo.Text, item.SubItems[2].Text); chiTietHoaDonXuat.SaveToDatabase(); HangHoa.UpdateAmount(Convert.ToInt32(item.SubItems[0].Text), Convert.ToInt32(item.SubItems[2].Text) * -1); } this.Close(); mainForm.LoadToDataGridView(); }
public ActionResult XacnhanXoa(string MaHD, string MaSP) { ChiTietHoaDonXuat cthdx = db.ChiTietHoaDonXuats.SingleOrDefault(n => n.MaHD == MaHD && n.MaSP == MaSP); HoaDonXuat hd = db.HoaDonXuats.SingleOrDefault(n => n.MaHD == MaHD); SanPham sanpham = db.SanPhams.SingleOrDefault(n => n.MaSp == cthdx.MaSP); if (cthdx != null) { db.ChiTietHoaDonXuats.Remove(cthdx); //db.SaveChanges(); sanpham.SoLuongTon = sanpham.SoLuongTon + cthdx.SoLuong; db.Entry(sanpham).State = System.Data.Entity.EntityState.Modified; // db.SaveChanges(); db.HoaDonXuats.Remove(hd); db.SaveChanges(); ViewBag.Thanhcong = "Xóa Thành Công Hóa đơn"; } return(View()); }
public int Add(HoaDonXuat emp) { List <SqlParameter> paras = new List <SqlParameter>(); paras.Add(new SqlParameter("@maxuat", emp.MaXuat)); paras.Add(new SqlParameter("@manv", emp.MaNV)); paras.Add(new SqlParameter("@makh", emp.MaKH)); paras.Add(new SqlParameter("@tenxe", emp.TenXe)); paras.Add(new SqlParameter("@soluong", emp.SoLuong)); paras.Add(new SqlParameter("@dongia", emp.DonGia)); try { return(dp.ExcuteNonQuery("ThemHoaDonXuat", System.Data.CommandType.StoredProcedure, paras)); // " ten thu tuc " , loại , danh sach } catch (SqlException ex) { throw ex; } }
public void themHoaDon(String pMaHD, String maNV, String maKH, DateTime NgayXuat, int tongTien) { //HoaDonXuat hd = new HoaDonXuat(); //hd.maHD_Xuat = pMaHD; //hd.maNV = maNV; //hd.maKH = maKH; //hd.ngay_xuat = NgayXuat; //hd.tong_tien = tongTien; HoaDonXuat hd = new HoaDonXuat() { maHD_Xuat = pMaHD, maNV = maNV, maKH = maKH, ngay_xuat = NgayXuat, tong_tien = tongTien, }; data.HoaDonXuats.InsertOnSubmit(hd); data.SubmitChanges(); }
public ActionResult ThemMoi(HoaDonXuat hd) { if (ModelState.IsValid) { HoaDonXuat countHD = db.HoaDonXuats.SingleOrDefault(n => n.MaHD == hd.MaHD); if (countHD != null) { ViewBag.KiemtraMa = "Mã Hóa Đơn đã có hãy nhập lại hoặc đi đến chỉnh sửa"; } else { db.HoaDonXuats.Add(hd); db.SaveChanges(); return(RedirectToAction("ThemChiTietHD", "HoaDonXuat")); } } ViewBag.MaKho = new SelectList(db.Khoes.ToList(), "MaKho", "TenKho"); ViewBag.MaNV = new SelectList(db.NhanViens.ToList(), "MaNV", "TenNV"); ViewBag.MaKH = new SelectList(db.NhaCungCaps.ToList(), "MaKH", "TenKH"); return(View()); }
private void Frm_CTHDX_Load(object sender, EventArgs e) { lbMaHDX.Text = Frm_HDX.mahdx.ToString(); CTHDX cthdx = kn.CTHDXes.Where(s => s.MaHDX == Frm_HDX.mahdx).FirstOrDefault(); HoaDonXuat hdx = kn.HoaDonXuats.Where(s => s.MaHDX == Frm_HDX.mahdx).FirstOrDefault(); SanPham tensp = kn.SanPhams.Where(s => s.MaSP == cthdx.MaSP).FirstOrDefault(); lbTenSP.Text = tensp.TenSP; KhachHang tenkh = kn.KhachHangs.Where(s => s.MaKH == hdx.MaKH).FirstOrDefault(); lbTenKH.Text = tenkh.TenKH; lbNgayXuat.Text = hdx.NgayXuat.ToString(); NhanVien tennv = kn.NhanViens.Where(s => s.MaNV == hdx.MaNV).FirstOrDefault(); lbTenNV.Text = tennv.TenNV; txtSoLuong.Text = cthdx.Soluong.ToString(); txtGia.Text = tensp.Gia.ToString(); txtGia.Enabled = false; txtSoLuong.Enabled = false; }