private void btnLapPhieuThu_Click(object sender, EventArgs e)
{
GridView gridView = grcBangKeThanhToanNgay.FocusedView as GridView;
var maPhieu = gridView.GetRowCellValue(gridView.FocusedRowHandle, "MaPhieu");// lấy được mã phiếu
var ngayLap = gridView.GetRowCellValue(gridView.FocusedRowHandle, "NgayLap");
var tenKhachHang = gridView.GetRowCellValue(gridView.FocusedRowHandle, "TenKH");
var maKhachHang = gridView.GetRowCellValue(gridView.FocusedRowHandle, "MaKH");
var soTien = gridView.GetRowCellValue(gridView.FocusedRowHandle, "TongTienNhan");
if (maPhieu == null)
{
XtraMessageBox.Show("Mời bạn chọn mã phiếu nhập hàng cần lập phiếu thu tiền");
}
else
{
PhieuThuTien phieuThu = new PhieuThuTien();
phieuThu.MaChungTu = (string)maPhieu;
phieuThu.NgayLap = (DateTime)ngayLap;
phieuThu.SoTien = (float)Convert.ToDouble(soTien);
phieuThu.TenKH = (string)tenKhachHang;
phieuThu.MaKH = (string)maKhachHang;
frmCM_LapPhieuThu fCM_LapPhieuThu = new frmCM_LapPhieuThu(phieuThu);
fCM_LapPhieuThu.ShowDialog();
grcBangKeThanhToanNgay.DataSource = inforSell.getListThanhToanCongNo(a, b, 0);
}
}
private void lậpPhiếuThuTiềnToolStripMenuItem_Click(object sender, EventArgs e)
{
PhieuThuTien f = new PhieuThuTien();
f.MdiParent = this;
f.Show();
}
private void btnLapPhieuThu_Click(object sender, EventArgs e)
{
GridView gridView = grcBangKeThanhToanNgay.FocusedView as GridView;
var maPhieu = gridView.GetRowCellValue(gridView.FocusedRowHandle, "MaPhieu");// lấy được mã phiếu
var ngayLap = gridView.GetRowCellValue(gridView.FocusedRowHandle, "NgayLap");
var tenKhachHang = gridView.GetRowCellValue(gridView.FocusedRowHandle, "TenKH");
var maKhachHang = gridView.GetRowCellValue(gridView.FocusedRowHandle, "MaKH");
var soTien = gridView.GetRowCellValue(gridView.FocusedRowHandle, "TongTienNhan");
int checkInPhieuThu = inforSellBus.checkMaChungTuInPhieuThu((string)maPhieu);
if (checkInPhieuThu == 1)
{
DialogResult dr;
dr = XtraMessageBox.Show("Đơn hàng đã được thu tiền.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (maPhieu == null)
{
XtraMessageBox.Show("Mời bạn chọn mã phiếu nhập hàng cần xóa");
}
else
{
PhieuThuTien phieuThu = new PhieuThuTien();
phieuThu.MaChungTu = (string)maPhieu;
phieuThu.NgayLap = (DateTime)ngayLap;
phieuThu.SoTien = (float)Convert.ToDouble(soTien);
phieuThu.TenKH = (string)tenKhachHang;
phieuThu.MaKH = (string)maKhachHang;
frmCM_LapPhieuThu fCM_LapPhieuThu = new frmCM_LapPhieuThu(phieuThu);
fCM_LapPhieuThu.ShowDialog();
grcBangKeThanhToanNgay.DataSource = inforSellBus.getListThanhToanNgay(a, b, 0);
}
}
public static void NhapPhieuThuTien(PhieuThuTien phieuThuTien)
{
PhieuThuTienDAL.NhapPhieuThuTien(phieuThuTien);
string hieuXe = XeDAL.GetHieuXe(phieuThuTien.BienSo);
string maBCDT = BaoCaoDoanhThuBLL.GetMaBC(phieuThuTien.NgayThu.Month, phieuThuTien.NgayThu.Year);
if (maBCDT == "")
{
maBCDT = BaoCaoDoanhThuBLL.AutoMABC();
BaoCaoDoanhThu baoCao = new BaoCaoDoanhThu();
baoCao.MaBaoCaoDoanhThu = maBCDT;
baoCao.Thang = phieuThuTien.NgayThu.Month;
baoCao.Nam = phieuThuTien.NgayThu.Year;
BaoCaoDoanhThuBLL.ThemBC(baoCao);
}
ChiTietBaoCaoDoanhThu chiTiet = new ChiTietBaoCaoDoanhThu();
chiTiet.MaBC = maBCDT;
chiTiet.MaCTBC = ChiTietBaoCaoDoanhThuBLL.GetMaCTBC(maBCDT, hieuXe);
chiTiet.HieuXe = hieuXe;
if (chiTiet.MaCTBC == "")
{
chiTiet.MaCTBC = ChiTietBaoCaoDoanhThuBLL.AutoMACTBC();
ChiTietBaoCaoDoanhThuBLL.ThemCTBC(chiTiet);
}
ChiTietBaoCaoDoanhThuBLL.CapNhatBaoCao(chiTiet, phieuThuTien.SoTienThu);
}
public frmCM_LapPhieuThu(PhieuThuTien phieuThu) : this()
{
ptTien.TenKH = phieuThuTien.TenKH = phieuThu.TenKH;
ptTien.MaKH = phieuThuTien.MaKH = phieuThu.MaKH;
ptTien.SoTien = phieuThuTien.SoTien = phieuThu.SoTien;
ptTien.MaChungTu = phieuThuTien.MaChungTu = phieuThu.MaChungTu;
ptTien.NgayLap = phieuThuTien.NgayLap = phieuThu.NgayLap;
}
public int ThemPhieuThu(PhieuThuTien pt)
{
string sql = "insert into PHIEUTHUTIEN(MaKH, MaPhieuXuat,NgayLap,SoTien,ConNo,SoTienTra,MaNV,LyDo) " +
string.Format("values ('{0}','{1}','{2}',{3},{4},{5},'{6}',N'{7}')",
pt.MaKH, pt.MaPhieuXuat, pt.NgayLap, pt.SoTien, pt.ConNo, pt.SoTienTra, pt.MaNV, pt.LyDo);
return(Execute.InsertUpdateDelete(sql));
}
public ActionResult DeleteConfirmed(int id)
{
PhieuThuTien phieuThuTien = db.PhieuThuTiens.Find(id);
db.PhieuThuTiens.Remove(phieuThuTien);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
PhieuThuTien phieuThuTien = await db.PhieuThuTiens.FindAsync(id);
db.PhieuThuTiens.Remove(phieuThuTien);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public IActionResult Put(string id, [FromBody] PhieuThuTien value)
{
if (!(_dataRepository as PhieuThuTienDM).CheckExist(id))
{
return(BadRequest());
}
_dataRepository.Update(id, value);
return(Ok());
}
public IActionResult Post([FromBody] PhieuThuTien value)
{
if ((_dataRepository as PhieuThuTienDM).CheckExist(value.MaKh))
{
return(Conflict());
}
_dataRepository.Add(value);
return(Ok());
}
private void FillDuLieu(PhieuThuTien ptt)
{
lkueKhachHang.EditValue = ptt.MaKH;
deNgayLap.EditValue = ptt.NgayLap;
txtChungTu.Text = ptt.MaPhieuXuat;
ceSoTien.EditValue = ptt.SoTien;
ceConNo.EditValue = ptt.ConNo;
ceSoTienTra.EditValue = ceConNo.EditValue;
rtbLyDo.Text = ptt.LyDo;
}
public void Insert(PhieuThuTien info)
{
string sqlQuery = "insert into PhieuThuTien values ('" +
info.MaPTT + "','" +
info.MaHD + "','" +
info.NgayThuTien.ToShortDateString() + "'," +
info.SoTienThu + ")";
ExecuteNonQuery(sqlQuery);
}
public void Update(PhieuThuTien info)
{
string sqlQuery = "update PhieuThuTien" +
" set MaPTT='" + info.MaPTT + "'," +
"MaHD='" + info.MaHD + "'" +
"NgayThuTien='" + info.NgayThuTien + "'" +
"SoTienThu=" + info.SoTienThu +
"where MaPTT='" + info.MaPTT + "'";
ExecuteNonQuery(sqlQuery);
}
public ActionResult Edit([Bind(Include = "id,NgayThu,DichVu,ThanhTien,BenhNhan_id")] PhieuThuTien phieuThuTien)
{
if (ModelState.IsValid)
{
db.Entry(phieuThuTien).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BenhNhan_id = new SelectList(db.BenhNhans, "id", "TenBN", phieuThuTien.BenhNhan_id);
return(View(phieuThuTien));
}
public async Task <ActionResult> Edit([Bind(Include = "MaPhieuThuTien,NgayThu,TienThu,MaPhieuXuat")] PhieuThuTien phieuThuTien)
{
if (ModelState.IsValid)
{
db.Entry(phieuThuTien).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(phieuThuTien));
}
public async Task <ActionResult> Create([Bind(Include = "MaPhieuThuTien,NgayThu,TienThu,MaPhieuXuat")] PhieuThuTien phieuThuTien)
{
if (ModelState.IsValid)
{
db.PhieuThuTiens.Add(phieuThuTien);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(phieuThuTien));
}
public frmLapPhieuThu(PhieuThuTien ptt, int m)
{
InitializeComponent();
Load += FrmLapPhieuThu_Load;
//button
btnBoQua.Click += BtnBoQua_Click;
btnLuu.Visible = false;
FillDuLieu(ptt);
}
public void initDataThu(PhieuThuTien ptTien)
{
pChungTuGoc.Value = ptTien.MaChungTu;
pThuQuy.Value = ptTien.TenNV;
pSoTien.Value = ptTien.SoTien;
pNgay.Value = ptTien.NgayLap;
pLyDo.Value = ptTien.GhiChu;
pNguoiNopTien.Value = ptTien.TenKH;
pNguoiLapPhieu.Value = ptTien.TenNV;
pSoTienBangChu.Value = ChuyenSoThanhChu(ChuanHoaSoTien(ptTien.SoTien.ToString()));
pMaPhieu.Value = ptTien.MaPhieu;
}
public int Sua(PhieuThuTien pPhieuThuTien, string idx)
{
var result = _context.PhieuThuTien.Find(idx);
if (result != null)
{
result = pPhieuThuTien;
_context.PhieuThuTien.Update(pPhieuThuTien);
return(_context.SaveChanges());
}
return(0);
}
private void BtnLapPhieuThu_Click(object sender, EventArgs e)
{
if (CurRowIndex >= 0)
{
PhieuThuTien pt = LayPhieuThu();
frmLapPhieuThu lpt = new frmLapPhieuThu(pt);
lpt.ThemThanhCong += Lpt_ThemThanhCong;
lpt.ThemThanhCong += FillGridView;
lpt.ShowDialog();
}
}
public void PhieuThuTien_Insert(PhieuThuTien Data)
{
using (var cmd = new SqlCommand("sp_PhieuThuTien_Insert", GetConnection()))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@MaPhieuThuTien", Data.MaPhieuThuTien));
cmd.Parameters.Add(new SqlParameter("@BienSo", Data.BienSo));
cmd.Parameters.Add(new SqlParameter("@NgayThuTien", Data.NgayThuTien));
cmd.Parameters.Add(new SqlParameter("@SoTienThu", Data.SoTienThu));
cmd.ExecuteNonQuery();
connection.Close();
}
}
public void PrintReportThu(PhieuThuTien ptTien)
{
ReportPhieuThuChi reportPhieuThuChi = new ReportPhieuThuChi();
foreach (DevExpress.XtraReports.Parameters.Parameter p in reportPhieuThuChi.Parameters)
{
p.Visible = false;
}
reportPhieuThuChi.initDataThu(ptTien);
docPrint.DocumentSource = reportPhieuThuChi;
reportPhieuThuChi.CreateDocument();
}
private PhieuThuTien LayPhieuThu()
{
PhieuThuTien pt = new PhieuThuTien();
pt.MaPhieuXuat = gvThuTien.GetRowCellValue(CurRowIndex, "MaPhieu").ToString();
pt.MaKH = gvThuTien.GetRowCellValue(CurRowIndex, "MaKH").ToString();
pt.SoTien = int.Parse(gvThuTien.GetRowCellValue(CurRowIndex, "TongTien").ToString());
pt.ConNo = int.Parse(gvThuTien.GetRowCellValue(CurRowIndex, "ConLai").ToString());
pt.NgayLap = DateTime.Now;
pt.LyDo = "Thu tiền khách hàng";
return(pt);
}
// GET: PhieuThuTiens/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PhieuThuTien phieuThuTien = db.PhieuThuTiens.Find(id);
if (phieuThuTien == null)
{
return(HttpNotFound());
}
return(View(phieuThuTien));
}
// GET: PhieuThuTien/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PhieuThuTien phieuThuTien = await db.PhieuThuTiens.FindAsync(id);
if (phieuThuTien == null)
{
return(HttpNotFound());
}
return(View(phieuThuTien));
}
// GET: PhieuThuTiens/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PhieuThuTien phieuThuTien = db.PhieuThuTiens.Find(id);
if (phieuThuTien == null)
{
return(HttpNotFound());
}
ViewBag.BenhNhan_id = new SelectList(db.BenhNhans, "id", "TenBN", phieuThuTien.BenhNhan_id);
return(View(phieuThuTien));
}
private void btnLuu_Click(object sender, RoutedEventArgs e)
{
PhieuThuTien phieuThuTien = new PhieuThuTien();
if (cbKH.SelectedItem != null && cbNhanVien.SelectedItem != null && txbSoTienThu.Text != null)
{
if ((Convert.ToInt32(txbConLai.Text) >= 0))
{
var ans = MessageBox.Show("Bạn có chắc muốn thêm phiếu thu tiền không ?", "Thông báo", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (ans == MessageBoxResult.Yes)
{
phieuThuTien.SoTienThu = Convert.ToInt32(txbSoTienThu.Text);
phieuThuTien.NgayThuTien = dpNgayLap.SelectedDate;
KhachHang khachHang = cbKH.SelectedItem as KhachHang;
NguoiDung nguoiDung = cbNhanVien.SelectedItem as NguoiDung;
KhachHang find = DataProvider.Ins.DB.KhachHangs.Find(khachHang.MaKH);
find.SoTienNo = Convert.ToInt32(txbConLai.Text);
phieuThuTien.MaKH = khachHang.MaKH;
phieuThuTien.MaND = nguoiDung.MaND;
DataProvider.Ins.DB.SaveChanges();
DataProvider.Ins.DB.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[PhieuThuTien] ON");
DataProvider.Ins.DB.PhieuThuTiens.Add(phieuThuTien);
DataProvider.Ins.DB.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[PhieuThuTien] OFF");
DataProvider.Ins.DB.SaveChanges();
dataPhieuThu.ItemsSource = getPTT();
MessageBox.Show("Bạn đã thêm phiếu thành công!", "Thông báo", MessageBoxButton.OK, MessageBoxImage.Information);
XoaTrang();
setMutabel();
btnLuu.IsEnabled = false;
btnThem.IsEnabled = true;
btnHuy.IsEnabled = false;
}
}
else
{
MessageBox.Show("Không được thu quá số tiền nợ của khách hàng!", "Thông báo", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
else
{
MessageBox.Show("Chưa nhập đủ thông tin!", "Thông báo", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
private void btnLapPhieu_Click(object sender, EventArgs e)
{
if (txtMaPhieuThu.Text == "")
{
MessageBox.Show("Chưa có mã phiếu!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtMaPhieuThu.Focus();
}
else if (txtSoTienThu.Text == "")
{
MessageBox.Show("Chưa nhập số tiền thu!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtSoTienThu.Focus();
}
else
{
try
{
PhieuThuTien pt = new PhieuThuTien()
{
BienSo = cbBienSo.Text, MaPhieuThuTien = txtMaPhieuThu.Text, /*pt.NgayThuTien = dateNgayThuTien.Value.ToShortDateString();*/ /*pt.NgayThuTien = dateNgayThuTien.Value.ToString();*/ NgayThuTien = dateNgayThuTien.Text, SoTienThu = double.Parse(txtSoTienThu.Text)
};
string[] s = txtTienNo.Text.Split(',');
if (double.Parse(txtSoTienThu.Text) > double.Parse(s[0]))
{
MessageBox.Show("Số tiền thu phải nhỏ hơn số tiền nợ");
txtSoTienThu.Text = "";
}
PhieuThuTienBUS.PhieuThuTien_Insert(pt);
MessageBox.Show("Lập phiếu thành công!!");
DataTable dtb = new DataTable();
dtb = XeBUS.Xe_GetBienSo(cbBienSo.Text);
foreach (DataRow r in dtb.Rows)
{
txtTienNo.Text = r["TienNo"].ToString();
}
btnIn.Enabled = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private async void PostPhieuThuTien(string makh, string tenkh, string diachi, string sdt, string email, DateTime ngaythu, int tienthu)
{
PhieuThuTien phieu = new PhieuThuTien();
phieu.TenKh = tenkh;
phieu.DiaChi = diachi;
phieu.DienThoai = sdt;
phieu.Email = email;
phieu.NgayThuTien = ngaythu;
phieu.TienThu = tienthu;
StringContent content = new StringContent(Newtonsoft.Json.JsonConvert.SerializeObject(phieu), Encoding.UTF8, "application/json");
using (var client = new HttpClient())
{
client.BaseAddress = new Uri("https://localhost:5001/");
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
HttpResponseMessage response = await client.PostAsync("api/phieuthutien", content);
if (response.IsSuccessStatusCode)
{
if (response.StatusCode == System.Net.HttpStatusCode.OK)
{
MessageBox.Show("Lưu phiếu thành công", "Lưu phiếu thành công", MessageBoxButtons.OK);
textBox1.Clear();
textBox2.Clear();
textBox4.Clear();
textBox5.Clear();
textBox6.Clear();
}
else
{
MessageBox.Show("Lưu phiếu thất bại", "Lưu phiếu thất bại", MessageBoxButtons.OK);
}
}
else
{
MessageBox.Show(string.Format("{0} ({1})", (int)response.StatusCode, response.ReasonPhrase));
}
}
}
private void btnTraNo_Click(object sender, EventArgs e)
{
if (decimal.Parse(txtTienTra.Text) <= 0)
{
MessageBox.Show("Nhập số tiền lớn hơn 0VND", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
tienTra = decimal.Parse(txtTienTra.Text);
tienNo = decimal.Parse(txtTienNo.Text);
if (tienTra > tienNo)
{
MessageBox.Show("Tiền khách trả không được lớn hơn tiền nợ", "Thông báo", MessageBoxButtons.OK);
txtTienTra.Clear();
txtTienNoConLai.Clear();
}
else
{
PhieuThuTien phieuThuTien = new PhieuThuTien(txtSoPhieu.Text, txtBienSo.Text, DateTime.Now, tienTra);
try
{
PhieuThuTienBLL.NhapPhieuThuTien(phieuThuTien);
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }
ThayDoiTienNo _tienNo = new ThayDoiTienNo();
_tienNo.BienSo = txtBienSo.Text;
_tienNo.TienNo = decimal.Parse(txtTienNoConLai.Text);
ThayDoiTienNoBLL.ThayDoiTienNo(_tienNo);
MessageBox.Show("Thay đổi tiền nợ thành công!", "Thông báo", MessageBoxButtons.OK);
txtTienNo.Text = txtTienNoConLai.Text;
txtTienTra.Clear();
txtTienNoConLai.Clear();
btnInPhieu.Enabled = true;
}
}
}
private void btThem_Click(object sender, RoutedEventArgs e)
{
// them thong tin khach hang
int idKhachHang = int.Parse(dsKhachHang[dsKhachHang.Count - 1].MaKH);
KhachHang kh = new KhachHang()
{ MaKH = (idKhachHang++).ToString(), DiaChiKH = tbDiaChi.Text, Email = tbEmail.Text, SoDienThoai = tbSoTienThu.Text, TenKH = tbHoTenKhachHang.Text };
busKhachHang.Insert(kh);
// them thong tin phieu thu tien
PhieuThuTien ptt = new PhieuThuTien()
{ };
}
