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