private void btn_Luu_Click(object sender, EventArgs e) { if (checkUpdateInformation()) { //XtraMessageBox.Show("Các thông tin đã hợp lệ"); PhieuChi tempPhieuChi = new PhieuChi(tempMaPC, Convert.ToDateTime(tempNgayLap), tempMaNV, tempMaNCC, tempSoTienNo, tempSoTienChi); bool updated = false; updated = UserControl_ListPhieuChi.objPhieuChiBUS.updatePhieuChi(tempPhieuChi); if (updated) { //XtraMessageBox.Show("Cập nhật thành công!"); UserControl_ListPhieuChi.Instance.loadDanhSachPhieuChi(); UserControl_ListPhieuChi.Instance.BringToFront(); UserControl_ListPhieuChi.Instance.label_notification.Text = "Cập nhật thành công!"; } else { XtraMessageBox.Show("Cập nhật không thành công!"); } //Enable các btn: UserControl_ListButton_PhieuChi.Instance.btn_Edit.Enabled = true; UserControl_ListButton_PhieuChi.Instance.btn_Xoa.Enabled = true; UserControl_ListButton_PhieuChi.Instance.btn_themMoi.Enabled = true; } else { } }
public bool updatePhieuChi(PhieuChi _phieuChi) { try { SqlCommand cmd = new SqlCommand("PHIEUCHI_Update", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MaPC", SqlDbType.VarChar, 10)).Value = _phieuChi.maPhieuChi; cmd.Parameters.Add(new SqlParameter("@NgayLap", SqlDbType.Date)).Value = _phieuChi.ngayLap; cmd.Parameters.Add(new SqlParameter("@MaNV", SqlDbType.VarChar, 10)).Value = _phieuChi.maNV; cmd.Parameters.Add(new SqlParameter("@MaNCC", SqlDbType.VarChar, 10)).Value = _phieuChi.maNCC; cmd.Parameters.Add(new SqlParameter("@SoTienNo", SqlDbType.Int)).Value = _phieuChi.soTienNo; cmd.Parameters.Add(new SqlParameter("@SoTienChi", SqlDbType.Int)).Value = _phieuChi.soTienChi; if (conn.State != ConnectionState.Open) { conn.Open(); } cmd.ExecuteNonQuery(); conn.Close(); return(true); } catch (Exception e) { conn.Close(); Console.WriteLine("Lỗi: " + e.Message); return(false); } }
public PhieuChi getPhieuChi(string _maPhieuChi) { try { SqlCommand cmd = new SqlCommand("PHIEUCHI_getPhieuChi", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MaPhieuChi", SqlDbType.VarChar, 10)).Value = _maPhieuChi; if (conn.State != ConnectionState.Open) { conn.Open(); } SqlDataReader dr = cmd.ExecuteReader(); PhieuChi phieuChi = null; if (dr.Read()) { phieuChi = new PhieuChi(); phieuChi.maPhieuChi = dr["MaPC"].ToString(); phieuChi.ngayLap = (DateTime)dr["NgayLap"]; phieuChi.maNV = dr["MaNV"].ToString(); phieuChi.maNCC = dr["MaNCC"].ToString(); phieuChi.soTienNo = (int)dr["SoTienNo"]; phieuChi.soTienChi = (int)dr["SoTienChi"]; } conn.Close(); return(phieuChi); } catch (Exception e) { conn.Close(); Console.WriteLine("Lỗi: " + e.Message); return(null); } }
public IActionResult Create(PhieuChiViewModel model) { if (ModelState.IsValid) { PhieuChi phieu = new PhieuChi(); phieu.NgayLap = DateTime.Now; phieu.NhanVienId = _bookStoreData.findUserId(User.Identity.Name); phieu.TongTien = model.TongTien; phieu.LoaiPhieuId = model.LoaiPhieuId; if (model.KhachHangId != null) { phieu.KhachHangId = model.KhachHangId; _bookStoreData.TaoPhieuChi(phieu); return(RedirectToAction("Index")); } if (model.KhachHangId == null && model.NCCId == null) { phieu.KhachHangId = 1; _bookStoreData.TaoPhieuChi(phieu); return(RedirectToAction("Index")); } if (model.NCCId != null) { phieu.NhaCungCapId = model.NCCId; _bookStoreData.TaoPhieuChi(phieu); return(RedirectToAction("Index")); } } return(View()); }
public async Task <int> UpdatePhieuChiNhapHang(PhieuChi phieuChi) { _context.Entry(phieuChi).State = EntityState.Modified; _context.Entry(phieuChi).Property("NgayLap").IsModified = false; return(await _context.SaveChangesAsync()); }
public async Task <int> AddPhieuNhapHang(PhieuNhapHang phieuNhapHang, ICollection <ChiTietPhieuNhapHang> properties) { phieuNhapHang.TrangThaiId = (await GetTrangThai("Waiting", "PhieuNhapHang") .FirstOrDefaultAsync()).Id; await _context.PhieuNhapHang.AddAsync(phieuNhapHang); foreach (var property in properties) { property.PhieuNhapHangId = phieuNhapHang.Id; phieuNhapHang.TongTien += property.SoLuong * property.GiaNhap; } await _context.ChiTietPhieuNhapHang.AddRangeAsync(properties); PhieuChi phieuChi = new PhieuChi() { NhanVienId = phieuNhapHang.NhanVienId, NgayLap = phieuNhapHang.NgayLap, PhieuNhapHangId = phieuNhapHang.Id, TongTien = phieuNhapHang.TongTien, }; return(await AddPhieuChiNhapHang(phieuChi)); }
// GET: Admin/PhieuChis/Create public ActionResult Create() { PhieuChi a = new PhieuChi(); a.MaPhieuChi = getMaDL(); return(View(a)); }
private void btnLuu_Click(object sender, EventArgs e) { float CNo = 0; if (KiemTra() == 1) { MessageBox.Show("Phiếu đã lập !"); } else { CNo = (float.Parse(txtSoTien.Text)) - (float.Parse(txtSoTienTra.Text)); PhieuChi pc = new PhieuChi() { TenKH = txtKhachHang.Text, MaCT = txtTheoChungTu.Text, Ngay = DateTime.Parse(dateHT.Text), SoTien = float.Parse(txtSoTien.Text), ConNo = CNo, DaTra = float.Parse(txtSoTienTra.Text), NhanVien = txtMaNV.Text, GhiChu = mmGhiChu.Text, Phieu = txtPhieu.Text }; if (pc_bus.ThemPC(pc) > 0) { MessageBox.Show("Lập phiếu thành công.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); a.Add('"' + txtTheoChungTu.Text + '"'); Xoa(); this.Close(); } } }
public async Task <ActionResult> Deletes(int id) { PhieuChi huyPhieuChi = (PhieuChi)await _phieuChiBus.Find(id); if (huyPhieuChi == null) { SetAlert("Đã xảy ra lỗi! Bạn hãy hủy lại", "error"); return(RedirectToAction("Edit")); } else { try { await _phieuChiBus.HuyPhieuChi(huyPhieuChi); SetAlert("Đã hủy phiếu chi thành công!!!", "success"); } catch { SetAlert("Đã xảy ra lỗi! Bạn hãy hủy lại", "error"); return(RedirectToAction("Edit")); } } return(RedirectToAction("Index")); }
public void insert_PhieuChi(PhieuChi a) { QLVESODataContext db = new QLVESODataContext(); db.PhieuChis.InsertOnSubmit(a); db.SubmitChanges(); }
public IHttpActionResult PutPhieuChi(int id, PhieuChi phieuChi) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != phieuChi.IDPhieuChi) { return(BadRequest()); } db.Entry(phieuChi).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!PhieuChiExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
private void simpleButton1_Click(object sender, EventArgs e) { // save to database PhieuChi newPhieuChi = new PhieuChi(); newPhieuChi.MaKH = comboBox1.SelectedIndex - 1; newPhieuChi.NgayPS = dtCreateDate.Value; newPhieuChi.SoPC = db.PhieuChis.Count() + 1; newPhieuChi.SoTien = Convert.ToDecimal(txtMoney.Text); db.PhieuChis.Add(newPhieuChi); //db.SaveChanges(); // open report form FormToView frm = new FormToView(); frm.Address = txtDiaChi.Text; frm.SoTT = txtMoney.Text; frm.HoaDonID = newPhieuChi.SoPC; frm.CustomerName = txtName.Text; rp_PhieuChi newRP = new rp_PhieuChi(frm, rtDescription.Text); ReportPrintTool tool = new ReportPrintTool(newRP); tool.ShowPreviewDialog(); tool.Report.CreateDocument(); }
public ActionResult DeleteConfirmed(int id) { PhieuChi phieuChi = db.PhieuChis.Find(id); db.PhieuChis.Remove(phieuChi); db.SaveChanges(); return(RedirectToAction("Index")); }
public async Task HuyPhieuChi(object editModel) // chỉnh sửa trạng thái và ngày chỉnh sửa { PhieuChi editPhieuChi = (PhieuChi)editModel; editPhieuChi.TrangThai = false; editPhieuChi.NgayChinhSua = DateTime.Now; await _phieuChiRepo.EditAsync(editPhieuChi); }
public int ThemDSPC(PhieuChi pc) { string sql = string.Format(" insert into [DanhSachPhieuChi] Values('{0}','{1}','{2}','{3}',{4},{5},{6},'{7}','{8}')" , pc.Phieu, pc.MaCT, pc.Ngay, pc.TenKH, pc.SoTien, pc.ConNo, pc.DaTra, pc.NhanVien, pc.GhiChu); var rs = db.ExecuteSQL(sql); return(rs); }
public ActionResult Create() { PhieuChi dk = new PhieuChi(); var dao = new PhieuChiDao(); dk.Ngay = DateTime.Now; dk.MaPhieuChi = dao.AutoGetMa(); return(View(dk)); }
public async Task <int> AddPhieuChiNhapHang(PhieuChi phieuChi) { phieuChi.LoaiPhieuId = (await _context.LoaiPhieu .Where(m => m.Loai == "PCNH").SingleOrDefaultAsync()).Id; await _context.PhieuChi.AddAsync(phieuChi); return(await _context.SaveChangesAsync()); }
public void delete_PhieuChi(string ma) { QLVESODataContext db = new QLVESODataContext(); PhieuChi b = new PhieuChi(); b = db.PhieuChis.Where(ax => ax.MaPhieuChi == ma).Single(); db.PhieuChis.DeleteOnSubmit(b); db.SubmitChanges(); }
public ActionResult DeleteConfirmed(string id) { PhieuChi phieuChi = db.PhieuChi.Find(id); phieuChi.Flag = false; db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult DeleteConfirmed(string id) { PhieuChi pc = db.PhieuChis.Find(id); db.PhieuChis.Remove(pc); TempData["notice"] = "Successfully delete"; TempData["tensanpham"] = pc.MaPhieuChi; db.SaveChanges(); return(RedirectToAction("Index")); }
public async Task <IActionResult> Create(decimal TienThu, int ID, List <ChiTietTraHang> returnDetails) { try { var phieutra = new PhieuTraHang(); phieutra.DonHangId = ID; phieutra.NgayLap = DateTime.Now; var user = await _usermanager.FindByNameAsync(User.Identity.Name); phieutra.NhanVienId = user.Id; phieutra.TongTien = TienThu; var kh = _bookStoreData.findCustomerByDonhang((int)phieutra.DonHangId); phieutra.KhachHangId = kh.Id; _bookStoreData.TaoPhieuTraHang(phieutra); var phieuchi = new PhieuChi(); var pt = _bookStoreData.findNewPhieuTraHang(); phieuchi.KhachHangId = kh.Id; phieuchi.NhanVienId = user.Id; phieuchi.PhieuTraHangId = pt.Id; phieuchi.TongTien = phieutra.TongTien; phieuchi.LoaiPhieuId = 10; phieuchi.NgayLap = DateTime.Now; _bookStoreData.TaoPhieuChi(phieuchi); //List<ChiTietPhieuTraHang> chitietphieu = new List<ChiTietPhieuTraHang>(); for (int i = 0; i < returnDetails.Count; i++) { var chitiet = new ChiTietPhieuTraHang(); chitiet.PhieuTraHangId = pt.Id; chitiet.ChiTietDonHangId = returnDetails[i].ChiTietDonHangId; chitiet.SoLuong = returnDetails[i].Soluong; chitiet.GiaTra = returnDetails[i].GiaTra; _bookStoreData.TaoCTPhieuTraHang(chitiet); } var noti = new Notification { Title = "Thành Công", Content = "Tạo phiếu trả hàng thành công", Icon = "checkmark", MessageType = "positive", }; return(PartialView("_Notify", noti)); } catch (Exception e) { var noti = new Notification { Title = "Thất bại", Content = "Có lỗi xảy ra" + e.Message, Icon = "remove", MessageType = "negative", }; return(PartialView("_Notify", noti)); } }
public IHttpActionResult GetPhieuChi(int id) { PhieuChi phieuChi = db.PhieuChis.Find(id); if (phieuChi == null) { return(NotFound()); } return(Ok(phieuChi)); }
public IHttpActionResult PostPhieuChi(PhieuChi phieuChi) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.PhieuChis.Add(phieuChi); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = phieuChi.IDPhieuChi }, phieuChi)); }
public void xoa1phieuchi(string mapt) { using (QLBanHangDataContext data = new QLBanHangDataContext()) { PhieuChi pt = data.PhieuChis.Where(m => m.MaPhieuChi == mapt).FirstOrDefault(); if (pt != null) { data.PhieuChis.DeleteOnSubmit(pt); data.SubmitChanges(); } } }
public ActionResult Edit([Bind(Include = "MaPhieuChi,NgayChi,NoiDung,SoTien,Flag")] PhieuChi phieuChi) { if (ModelState.IsValid) { phieuChi.Flag = true; db.Entry(phieuChi).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(phieuChi)); }
public void update_PhieuChi(PhieuChi a) { QLVESODataContext db = new QLVESODataContext(); PhieuChi b = new PhieuChi(); b = db.PhieuChis.Where(ax => ax.MaPhieuChi == a.MaPhieuChi).Single(); b.MaPhatHanh = a.MaPhatHanh; b.Ngay = a.Ngay; b.NoiDung = a.NoiDung; b.SoTien = a.SoTien; db.SubmitChanges(); }
public ActionResult Edit([Bind(Include = "SoPhieuChi,NgayChi,MaNguoiDung,SoPhieuNhapKho,TongTienChi,GhiChu,NgayChinhSua,IsDeleted")] PhieuChi phieuChi) { if (ModelState.IsValid) { db.Entry(phieuChi).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MaNguoiDung = new SelectList(db.NguoiDungs, "MaNguoiDung", "TenNguoiDung", phieuChi.MaNguoiDung); ViewBag.SoPhieuNhapKho = new SelectList(db.PhieuNhapKhoes, "SoPhieuNhapKho", "GhiChu", phieuChi.SoPhieuNhapKho); return(View(phieuChi)); }
public ActionResult Edit([Bind(Include = "maPC,diengiai,tongtien,ngaytao,maMucChi,maNV")] PhieuChi phieuChi) { if (ModelState.IsValid) { db.Entry(phieuChi).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.maMucChi = new SelectList(db.MucChis, "maMucChi", "mucchi1", phieuChi.maMucChi); ViewBag.maNV = new SelectList(db.NhanViens, "maNV", "tenNV", phieuChi.maNV); return(View(phieuChi)); }
public IActionResult ThemPC(string ten, DateTime ngay, string tien, string noidung) { PhieuChi pc = new PhieuChi(); pc.TenPhieuChi = ten; pc.Ngay = ngay; pc.SoTien = double.Parse(tien); pc.NoiDung = noidung; vsc.Add(pc); vsc.SaveChanges(); return(RedirectToAction("Index")); }
// GET: TTNhom_QLKS/PhieuChis/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PhieuChi phieuChi = db.PhieuChis.Find(id); if (phieuChi == null) { return(HttpNotFound()); } return(View(phieuChi)); }