//Khi Xóa 1 Đại lý
private void btnXoa_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Bạn có muốn xóa đại lý", "Thông báo", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
if (!txbMaSoDaiLy.Text.Equals(""))
{
// dl.MaSoDaiLy = int.Parse(txbMaSoDaiLy.Text.ToString());
if (DaiLyManager.delete(_currentDaiLy.MaSoDaiLy))
{
MessageBox.Show("Xóa đại lý thành công");
loadDaiLy();
}
else
{
MessageBox.Show("Không xóa được đại lý");
}
}
else
{
MessageBox.Show("Chọn đại lý cần xóa");
}
}
else if (dialogResult == DialogResult.No)
{
return;
}
}
public ActionResult Edit(DaiLy model, FormCollection collection)
{
try
{
// TODO: Add update logic here
if (ModelState.IsValid)
{
if (DaiLyManager.edit(model))
{
putSuccessMessage("Cập nhật thành công");
return(RedirectToAction("Details", new { id = model.MaSoDaiLy }));
}
else
{
putErrorMessage("Cập nhật thất bại");
}
}
else
{
putModelStateFailErrors(ModelState);
}
return(View(model));
}
catch (Exception ex)
{
putErrorMessage(ex.Message);
return(RedirectToAction("Edit", new { id = model.MaSoDaiLy }));
}
}
public ActionResult Details(int?id, int page = 1, int pageSize = 10, string search = null)
{
if (id == null)
{
putErrorMessage("Đường dẫn không chính xác");
return(RedirectToAction("TheoDoi"));
}
ViewBag.cultureInfo = CultureInfo;
var dl = DaiLyManager.find((int)id);
if (dl == null)
{
putErrorMessage("Không tìm thấy đại lý");
return(RedirectToAction("TheoDoi"));
}
ViewBag.currentDaiLy = dl;
var DMCongNo = dl.CongNo;
if (!String.IsNullOrEmpty(search))
{
DMCongNo = CongNoDaiLyManager.filter(search, DMCongNo);
ViewBag.SearchKey = search;
}
ViewBag.tongSoLuongNo = DMCongNo.Sum(cn => cn.SoLuong);
ViewBag.tongTienNo = DMCongNo.Sum(cn => cn.ThanhTien);
var models = DMCongNo.ToPagedList(page, pageSize);
setAlertMessage();
return(View(models));
}
private void LoadDaiLy()
{
_DSDLy = DaiLyManager.getAll();
cmbDaiLy.DataSource = _DSDLy;
cmbDaiLy.DisplayMember = "TenDaiLy";
cmbDaiLy.ValueMember = "MaSoDaiLy";
}
public ActionResult Create(DaiLy model)
{
try
{
// TODO: Add insert logic here
if (ModelState.IsValid)
{
var result = DaiLyManager.add(model);
if (result != 0)
{
putSuccessMessage("Thâm thành công");
return(RedirectToAction("Details", new { id = result }));
}
else
{
putErrorMessage("Thêm thất bại");
}
}
else
{
putModelStateFailErrors(ModelState);
}
return(View(model));
}
catch (Exception ex)
{
putErrorMessage(ex.Message);
return(RedirectToAction("Create"));
}
}
// GET: PhieuNhap/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
putErrorMessage("Đường dẫn không chính xác");
return(RedirectToAction("All"));
}
if (_currentPhieu == null || _currentPhieu != id)
{
_currentPhieu = id;
_phieu = PhieuXuatManager.find((int)id);
if (_phieu == null)
{
putErrorMessage("Không tìm thấy");
return(RedirectToAction("All"));
}
if (_phieu.TrangThai == 1)
{
//Nếu đã duyệt thì không cho sửa, chuyển sang trang chi tiết
_currentPhieu = null;
putErrorMessage("Phiếu đã duyệt");
return(RedirectToAction("Details", new { id = id }));
}
}
ViewBag.cultureInfo = CultureInfo;
ViewBag.DMSach = new SelectList(SachManager.getAllAlive()
.Where(s => s.Soluong > 0).ToList(),
nameof(SachManager.Properties.MaSoSach),
nameof(SachManager.Properties.TenSach), "");
ViewBag.DMDaiLy = new SelectList(DaiLyManager.getAllAlive(),
nameof(DaiLyManager.Properties.MaSoDaiLy),
nameof(DaiLyManager.Properties.TenDaiLy), "");
setAlertMessage();
return(View(_phieu));
}
private void txbLoc_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
gdvDMCongNo.DataSource = DaiLyManager.filter(txbLoc.Text, _DMDaiLy);
}
}
public void loadDaiLy()
{
_DMDAILY = DaiLyManager.getAll();
cmbDaiLy.DataSource = _DMDAILY;
cmbDaiLy.DisplayMember = nameof(DaiLyManager.Properties.TenDaiLy);
cmbDaiLy.ValueMember = nameof(DaiLyManager.Properties.MaSoDaiLy);
}
//Khi thêm Đại lý
private void btnThem_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Bạn có muốn thêm đại lý", "Thông báo", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
if (!txbTenDaiLy.Text.Equals("") && !txbDiaChi.Text.Equals("") && !txbSoDienThoai.Text.Equals("") && !txbSoTaiKhoan.Text.Equals(""))
{
DaiLy dl = new DaiLy();
dl.TenDaiLy = txbTenDaiLy.Text;
dl.DiaChi = txbDiaChi.Text;
dl.SoDienThoai = txbSoDienThoai.Text;
dl.SoTaiKhoan = txbSoTaiKhoan.Text;
dl.NganHang = txbNganHang.Text.ToString();
if (DaiLyManager.add(dl) != 0)
{
MessageBox.Show("Đã thêm đại lý thành công");
}
else
{
MessageBox.Show("Không thêm được, đại lý đã tồn tại ");
}
}
else
{
MessageBox.Show("Bạn chưa nhập đầy đủ thông tin");
}
}
else if (dialogResult == DialogResult.No)
{
return;
}
}
private void LoadDaiLy()
{
_DMDaiLy = DaiLyManager.getAll();
cmbDaiLy.DataSource = _DMDaiLy;
cmbDaiLy.DisplayMember = nameof(DaiLyManager.Properties.TenDaiLy);
cmbDaiLy.ValueMember = nameof(DaiLyManager.Properties.MaSoDaiLy);
}
public ActionResult Delete(int?id, FormCollection collection)
{
try
{
if (id == null)
{
putErrorMessage("Đường dẫn không chính xác");
return(RedirectToAction("Index"));
}
var model = DaiLyManager.find((int)id);
if (model == null || model.TrangThai == 0)
{
putErrorMessage("Không tìm thấy đại lý");
return(RedirectToAction("Index"));
}
// TODO: Add delete logic here
if (model.delete())
{
putSuccessMessage("Đã xóa");
return(RedirectToAction("Index"));
}
else
{
putErrorMessage("Xóa thất bại");
return(RedirectToAction("Delete", new { id }));
}
}
catch (Exception ex)
{
putErrorMessage(ex.Message);
return(RedirectToAction("Delete", new { id }));
}
}
private void cmbDaiLy_SelectionChangeCommitted(object sender, EventArgs e)
{
_currentDaiLy = DaiLyManager.find(int.Parse(cmbDaiLy.SelectedValue.ToString()));
txbMaSoDaiLy.Text = _currentDaiLy.MaSoDaiLy + "";
loadSach();
cmbDaiLy.Enabled = false;
}
public ActionResult DoanhThu(DateTime?startDate,
DateTime?endDate,
int dlpage = 1,
int dlpageSize = 10,
int nxbpage = 1,
int nxbpageSize = 10,
string searchDaiLy = null,
string searchNXB = null)
{
if (startDate != null && endDate != null)
{
ViewBag.cultureInfo = CultureInfo;
ViewBag.startDate = startDate;
ViewBag.endDate = endDate;
List <DaiLy> DMDaily = DaiLyManager.getAllAlive()
.Where(dl => dl.tinhTongTienThanhToanTheoThang(
((DateTime)startDate).Month,
((DateTime)startDate).Year,
((DateTime)endDate).Month,
((DateTime)endDate).Year) > 0).ToList();
ViewBag.tongTienThu = DMDaily.Sum(s => s.TongTienThanhToanTheoThang);
if (!String.IsNullOrEmpty(searchDaiLy))
{
DMDaily = DaiLyManager.filter(searchDaiLy, DMDaily);
ViewBag.SearchKeyDaiLy = searchDaiLy;
}
List <NhaXuatBan> DMNXB = NhaXuatBanManager.getAllAlive()
.Where(nxb => nxb.tinhTongTienThanhToanTheoThang(
((DateTime)startDate).Month,
((DateTime)startDate).Year,
((DateTime)endDate).Month,
((DateTime)endDate).Year) > 0).ToList();
ViewBag.tongTienChi = DMNXB.Sum(s => s.TongTienThanhToanTheoThang);
if (!String.IsNullOrEmpty(searchNXB))
{
DMNXB = NhaXuatBanManager.filter(searchNXB, DMNXB);
ViewBag.SearchKeyNXB = searchNXB;
}
ViewBag.tongCongDaiLy = DMDaily.Sum(dl => dl.TongTienThanhToan);
ViewBag.tongCongDaiLyTheoThang = DMDaily.Sum(dl => dl.TongTienThanhToanTheoThang);
ViewBag.tongCongNXB = DMNXB.Sum(nxb => nxb.TongTienThanhToan);
ViewBag.tongCongNXBTheoThang = DMNXB.Sum(nxb => nxb.TongTienThanhToanTheoThang);
ViewBag.DaiLymodels = DMDaily.ToPagedList(dlpage, dlpageSize);
ViewBag.NXBmodels = DMNXB.ToPagedList(nxbpage, nxbpageSize);
setAlertMessage();
return(View());
}
setAlertMessage();
return(View());
}
private void LoadDaiLy()
{
_DMDaiLy = DaiLyManager.getAllAlive()
.Where(dl => dl.tinhTongSoLuongNoTheoThang(_startMonth, _startYear, _endMonth, _endYear) > 0 &&
dl.tongTienNoThang(_startMonth, _startYear, _endMonth, _endYear) > 0 &&
dl.tongTienXuatThang(_startMonth, _startYear, _endMonth, _endYear) > 0).ToList();
gdvDMCongNo.DataSource = _DMDaiLy;
_tongTienNo = _DMDaiLy.Sum(dl => dl.TongTienNoThang);
_tongTienXuat = _DMDaiLy.Sum(dl => dl.TongTienXuatTheoThang);
lbTongConNo.Text = DataDisplayHelper.displayMoney((decimal)_tongTienNo);
lbTongTienSach.Text = DataDisplayHelper.displayMoney((decimal)_tongTienXuat);
lbTongDaThu.Text = DataDisplayHelper.displayMoney((decimal)(_tongTienXuat - _tongTienNo));
}
private void LoadTT()
{
_DSDaiLy = DaiLyManager.getAllAlive()
.Where(dl => dl.tinhTongTienThanhToanTheoThang(_startMonth, _startYear, _endMonth, _endYear) > 0).ToList();
gdvDaiLy.DataSource = _DSDaiLy;
lbTongThu.Text = _DSDaiLy.Sum(s => s.TongTienThanhToanTheoThang) + "";
int tongthu = int.Parse(lbTongThu.Text.ToString());
_DSNXB = NhaXuatBanManager.getAllAlive()
.Where(dl => dl.tinhTongTienThanhToanTheoThang(_startMonth, _startYear, _endMonth, _endYear) > 0).ToList();
gdvNXB.DataSource = _DSNXB;
lbTongChi.Text = _DSNXB.Sum(s => s.TongTienThanhToanTheoThang) + "";
int tongchi = int.Parse(lbTongChi.Text.ToString());
lbLoiNhuan.Text = tongthu - tongchi + "";
}
// GET: DaiLy/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
putErrorMessage("Đường dẫn không chính xác");
return(RedirectToAction("Index"));
}
var model = DaiLyManager.find((int)id);
if (model == null || model.TrangThai == 0)
{
putErrorMessage("Không tìm thấy đại lý");
return(RedirectToAction("Index"));
}
setAlertMessage();
return(View(model));
}
// GET: PhieuNhap/Create
public ActionResult Create()
{
ViewBag.cultureInfo = CultureInfo;
ViewBag.DMSach = new SelectList(SachManager.getAllAlive()
.Where(s => s.Soluong > 0).ToList(),
nameof(SachManager.Properties.MaSoSach),
nameof(SachManager.Properties.TenSach), "");
ViewBag.DMDaiLy = new SelectList(DaiLyManager.getAllAlive(),
nameof(DaiLyManager.Properties.MaSoDaiLy),
nameof(DaiLyManager.Properties.TenDaiLy), "");
if (_phieu == null)
{
_phieu = new PhieuXuat();
}
_phieu.NgayLap = DateTime.Now;
setAlertMessage();
return(View(_phieu));
}
// GET: DaiLy
public ActionResult Index(int page = 1, int pageSize = 10, string search = null)
{
List <DaiLy> DMDaiLy = null;
if (!String.IsNullOrEmpty(search))
{
DMDaiLy = DaiLyManager.filter(search);
ViewBag.SearchKey = search;
}
else
{
DMDaiLy = DaiLyManager.getAllAlive();
}
var models = DMDaiLy.ToPagedList(page, pageSize);
setAlertMessage();
return(View(models));
}
public ViewResult BlankEditorRow(int masodaily, int masosach = 0)
{
var dl = DaiLyManager.find((int)masodaily);
var chitiet = new ChiTietHoaDonDaiLy();
if (masosach != 0)
{
chitiet.MaSoSach = (int)masosach;
if (_hoadon.ChiTiet.Contains(chitiet))
{
return(null);
}
}
else
{
var founded = false;
foreach (Sach s in dl.getSachNo())
{
chitiet.MaSoSach = s.MaSoSach;
chitiet.Sach = s;
if (_hoadon.ChiTiet.Contains(chitiet))
{
continue;
}
founded = true;
break;
}
if (!founded)
{
return(null);
}
}
ViewBag.currentDaiLy = dl;
ViewBag.cultureInfo = CultureInfo;
ViewBag.DMSach = new SelectList(dl.getSachNo(),
nameof(SachManager.Properties.MaSoSach),
nameof(SachManager.Properties.TenSach), "");
chitiet.SoLuong = 1;
chitiet.DonGia = chitiet.Sach.GiaNhap;
_hoadon.addDetail(chitiet);
ViewData["masodaily"] = dl.MaSoDaiLy;
return(View("ChiTietEditorRow", chitiet));
}
public ActionResult TheoDoi(DateTime?startDate, DateTime?endDate, int page = 1, int pageSize = 10, string search = null)
{
if (startDate != null && endDate != null)
{
ViewBag.cultureInfo = CultureInfo;
ViewBag.startDate = startDate;
ViewBag.endDate = endDate;
List <DaiLy> DMDaiLy = DaiLyManager.getAllAlive()
.Where(dl => dl.tinhTongSoLuongNoTheoThang(
((DateTime)startDate).Month,
((DateTime)startDate).Year,
((DateTime)endDate).Month,
((DateTime)endDate).Year) > 0 &&
dl.tongTienNoThang(
((DateTime)startDate).Month,
((DateTime)startDate).Year,
((DateTime)endDate).Month,
((DateTime)endDate).Year) > 0 &&
dl.tongTienXuatThang(
((DateTime)startDate).Month,
((DateTime)startDate).Year,
((DateTime)endDate).Month,
((DateTime)endDate).Year) > 0).ToList();
if (!String.IsNullOrEmpty(search))
{
DMDaiLy = DaiLyManager.filter(search, DMDaiLy);
ViewBag.SearchKey = search;
}
ViewBag.tongTienXuat = DMDaiLy.Sum(nxb => nxb.TongTienXuatTheoThang);
ViewBag.tongSoLuongNo = DMDaiLy.Sum(nxb => nxb.TongSoLuongNoTheoThang);
ViewBag.tongTienNo = DMDaiLy.Sum(s => s.TongTienNoThang);
var models = DMDaiLy.ToPagedList(page, pageSize);
setAlertMessage();
return(View(models));
}
setAlertMessage();
return(View());
}
public FileStreamResult DoanhThu(DateTime startDate, DateTime endDate)
{
List <DaiLy> DMDaily = DaiLyManager.getAllAlive()
.Where(dl => dl.tinhTongTienThanhToanTheoThang(
((DateTime)startDate).Month,
((DateTime)startDate).Year,
((DateTime)endDate).Month,
((DateTime)endDate).Year) > 0).ToList();
List <NhaXuatBan> DMNXB = NhaXuatBanManager.getAllAlive()
.Where(nxb => nxb.tinhTongTienThanhToanTheoThang(
((DateTime)startDate).Month,
((DateTime)startDate).Year,
((DateTime)endDate).Month,
((DateTime)endDate).Year) > 0).ToList();
var printer = new PrintHelper();
printer.FileName = "report.pdf";
printer.FolderPath = "D://";
printer.Title = "Thống kê doanh thu";
var info = new MemoryStream(printer.printDoanhThu(DMDaily, DMNXB, startDate, endDate));
return(new FileStreamResult(info, "application/pdf"));
}
//Khi Cập nhật thông tin Đại lý
private void btnCapNhat_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Bạn có muốn cập nhật đại lý", "Thông báo", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
if (!txbMaSoDaiLy.Text.Equals("") && !txbTenDaiLy.Text.Equals("") && !txbSoDienThoai.Text.Equals("") && !txbSoTaiKhoan.Text.Equals("") && !txbDiaChi.Text.Equals(""))
{
//DaiLy dl = new DaiLy();
//dl.MaSoDaiLy = int.Parse(txbMaSoDaiLy.Text);
_currentDaiLy.TenDaiLy = txbTenDaiLy.Text.ToString();
_currentDaiLy.DiaChi = txbDiaChi.Text.ToString();
_currentDaiLy.SoDienThoai = txbSoDienThoai.Text.ToString();
_currentDaiLy.SoTaiKhoan = txbSoTaiKhoan.Text.ToString();
_currentDaiLy.NganHang = txbNganHang.Text.ToString();
if (DaiLyManager.edit(_currentDaiLy))
{
MessageBox.Show("Đã sửa đại lý thành công");
loadDaiLy();
}
else
{
MessageBox.Show("Không sửa được");
}
}
else
{
MessageBox.Show("Nhập đầy đủ thông tin cần sửa");
}
}
else if (dialogResult == DialogResult.No)
{
return;
}
}
// GET: PhieuNhap/ThanhToan
public ActionResult ThanhToan(int?masodaily)
{
if (masodaily != null)
{
var dl = DaiLyManager.find((int)masodaily);
if (dl == null || dl.TrangThai == 0)
{
putErrorMessage("Không tìm thấy đại lý");
return(RedirectToAction("ThanhToan"));
}
ViewBag.cultureInfo = CultureInfo;
ViewBag.currentDaiLy = dl;
ViewBag.DMSach = new SelectList(dl.getSachNo(),
nameof(SachManager.Properties.MaSoSach),
nameof(SachManager.Properties.TenSach), "");
if (_hoadon == null)
{
_hoadon = new HoaDonDaiLy();
}
_hoadon.MaSoDaiLy = dl.MaSoDaiLy;
_hoadon.DaiLy = dl;
_hoadon.NgayLap = DateTime.Now;
setAlertMessage();
return(View(_hoadon));
}
else
{
ViewBag.DMDaiLy = new SelectList(DaiLyManager.getAllAlive()
.Where(dl => dl.TongTienNo > 0).ToList(),
nameof(DaiLyManager.Properties.MaSoDaiLy),
nameof(DaiLyManager.Properties.TenDaiLy), "");
_hoadon = new HoaDonDaiLy();
setAlertMessage();
return(View());
}
}
public bool delete()
{
this.TrangThai = 0;
return(DaiLyManager.edit(this));
}
public ActionResult UpdateAgency(DaiLy model, FormCollection collection)
{
var errors = new List <string>();
if (ModelState.IsValid)
{
var currentUser = Session[Core.Constants.SESSION.USERNAME] as NguoiDung;
model.MaSoNguoiDung = currentUser.MaSoNguoiDung;
if (currentUser.DaiLy == null)
{
var result = DaiLyManager.add(model);
if (result != 0)
{
model.MaSoDaiLy = result;
currentUser.DaiLy = model;
currentUser.MaSoDaiLy = result;
Session[Core.Constants.SESSION.USERNAME] = currentUser;
TempData[Core.Constants.TEMPDATA.SUCCESS] = new List <string> {
"Đăng ký đại lý thành công"
};
}
else
{
errors.Add("Đăng ký không thành công");
TempData[Core.Constants.TEMPDATA.ERRORS] = errors;
}
}
else
{
if (DaiLyManager.edit(model))
{
currentUser.DaiLy = model;
Session[Core.Constants.SESSION.USERNAME] = currentUser;
TempData[Core.Constants.TEMPDATA.SUCCESS] = new List <string> {
"Cập nhật thành công"
};
}
else
{
errors.Add("Cập nhật không thành công");
TempData[Core.Constants.TEMPDATA.ERRORS] = errors;
}
}
if (errors.Count > 0)
{
TempData[Core.Constants.TEMPDATA.ERRORS] = errors;
}
return(RedirectToAction("Agency"));
}
else
{
foreach (var value in ModelState.Values)
{
if (value.Errors.Count > 0)
{
foreach (var error in value.Errors)
{
errors.Add(error.ErrorMessage);
}
}
}
TempData[Core.Constants.TEMPDATA.ERRORS] = errors;
return(RedirectToAction("Agency"));
}
}
//Khi chọn lọc
private void btnLoc_Click(object sender, EventArgs e)
{
gdvDMCongNo.DataSource = DaiLyManager.filter(txbLoc.Text, _DMDaiLy);
}
public void loadDaiLy()
{
_DMDaiLy = DaiLyManager.getAllAlive();
gdvDMDaiLy.DataSource = _DMDaiLy;
}
