public static void AddLog(string userName, int type, string smg) { LichSuThaoTac log = new LichSuThaoTac(); log.UserId = db.TaiKhoans.FirstOrDefault(s => s.UserName == userName).Id; log.Function = type; log.Smg = smg; log.LogTime = DateTime.Now; log.MaCN = db.TaiKhoans.FirstOrDefault(s => s.UserName == userName).MaCN; db.LichSuThaoTacs.Add(log); db.SaveChanges(); }
public static int DongTienLai(string hD_BatHo_Id, BatHo_ThongTinChiTietDongTienLaiModel update, string Id_NhanVien) { using (var context = new TIT_Entities()) { //update var item_update = context.ThongTinDongLais.SingleOrDefault(x => x.Id == update.ID); item_update.DaDong = update.DaDong; item_update.NgayDongLai = DateTime.Now; var hd_update = context.HD_BatHo.SingleOrDefault(x => x.HD_BatHo_Id == hD_BatHo_Id); hd_update.NgayCuoiCungDongTien = item_update.NgayKetThuc; var baocao = context.BaoCaoHangNgays.OrderByDescending(x => x.Ngay).FirstOrDefault(x => x.Id_CuaHang == hd_update.CuaHang_Id); if (baocao != null) { if (baocao.Ngay == DateTime.Now.Date) { baocao.SoTienVonConLai += update.TienHo; baocao.TongThu += update.TienHo; baocao.TongThuHopDongBatHo += update.TienHo; } else { var bcModel = new BaoCaoHangNgay { Id_CuaHang = hd_update.CuaHang_Id, Ngay = DateTime.Now.Date, SoTienVonDauNgay = baocao.SoTienVonConLai, SoTienVonConLai = baocao.SoTienVonConLai, }; bcModel.SoTienVonConLai += update.TienHo; bcModel.TongThu += update.TienHo; bcModel.TongThuHopDongBatHo += update.TienHo; context.BaoCaoHangNgays.Add(bcModel); } } else { var bcModel = new BaoCaoHangNgay { Id_CuaHang = hd_update.CuaHang_Id, Ngay = DateTime.Now.Date }; bcModel.SoTienVonConLai += update.TienHo; bcModel.TongThu += update.TienHo; bcModel.TongThuHopDongBatHo += update.TienHo; context.BaoCaoHangNgays.Add(bcModel); } decimal QuyTienMat = 0; var lastestLichSuThaoTac = context.LichSuThaoTacs.Where(x => x.Id_CuaHang == hd_update.CuaHang_Id).OrderByDescending(p => p.Id).FirstOrDefault(); if (lastestLichSuThaoTac != null) { QuyTienMat = lastestLichSuThaoTac.TongCongTon; } var lichsu = new LichSuThaoTac() { Id_CuaHang = hd_update.CuaHang_Id, Id_HopDong = hd_update.HD_BatHo_Id, Id_NhanVienThaoTac = Id_NhanVien, NgayThaoTac = DateTime.Now, NoiDung = "Đóng họ", SoTien = item_update.TienLai, ThuTien = 1, TongCongTon = QuyTienMat + item_update.TienLai, TenKhachHang = "" }; context.LichSuThaoTacs.Add(lichsu); try { if (context.SaveChanges() > 0) { return(1); } else { return(0); } } catch (Exception ex) { ex.ToString(); //_logger.Error(ex.ToString()); return(0); } } }
public static int ThanhToanHopDong(string Id_HopDong, int Id_CuaHang, string Id_NhanVien, decimal SoTien) { using (var context = new TIT_Entities()) { var item_update2 = context.ThongTinDongLais.Where(x => x.HopDong_Id == Id_HopDong).ToList(); for (int i = 0; i < item_update2.Count; i++) { item_update2[i].DaDong = 1; } //update var item_update = context.HD_BatHo.SingleOrDefault(x => x.HD_BatHo_Id == Id_HopDong); item_update.TinhTrang = "Thanh Lý"; item_update.NgayCuoiCungDongTien = item_update2[item_update2.Count - 1].NgayKetThuc; var baocao = context.BaoCaoHangNgays.OrderByDescending(x => x.Ngay).FirstOrDefault(x => x.Id_CuaHang == Id_CuaHang); if (baocao != null) { if (baocao.Ngay == DateTime.Now.Date) { baocao.SoTienVonConLai += SoTien; baocao.TongThu += SoTien; baocao.TongThuHopDongBatHo += SoTien; } else { var bcModel = new BaoCaoHangNgay { Id_CuaHang = Id_CuaHang, Ngay = DateTime.Now.Date, SoTienVonDauNgay = baocao.SoTienVonConLai, SoTienVonConLai = baocao.SoTienVonConLai, }; bcModel.SoTienVonConLai += SoTien; bcModel.TongThu += SoTien; bcModel.TongThuHopDongBatHo += SoTien; context.BaoCaoHangNgays.Add(bcModel); } } else { var bcModel = new BaoCaoHangNgay { Id_CuaHang = Id_CuaHang, Ngay = DateTime.Now.Date }; bcModel.SoTienVonConLai += SoTien; bcModel.TongThu += SoTien; bcModel.TongThuHopDongBatHo += SoTien; context.BaoCaoHangNgays.Add(bcModel); } decimal QuyTienMat = 0; var lastestLichSuThaoTac = context.LichSuThaoTacs.Where(x => x.Id_CuaHang == Id_CuaHang).OrderByDescending(p => p.Id).FirstOrDefault(); if (lastestLichSuThaoTac != null) { QuyTienMat = lastestLichSuThaoTac.TongCongTon; } var model = new LichSuThaoTac() { Id_CuaHang = Id_CuaHang, Id_HopDong = Id_HopDong, Id_NhanVienThaoTac = Id_NhanVien, NgayThaoTac = DateTime.Now, NoiDung = "Thanh lý hợp đồng", SoTien = SoTien, ThuTien = 1, TongCongTon = QuyTienMat + SoTien, TenKhachHang = "" }; context.LichSuThaoTacs.Add(model); try { if (context.SaveChanges() > 0) { return(1); } else { return(0); } } catch (Exception ex) { ex.ToString(); //_logger.Error(ex.ToString()); return(0); } } }
public static string Insert(HopDongBatHoDataModel model) { var dbModel = new HD_BatHo { CuaHang_Id = model.CuaHang_Id, GhiChu = model.GhiChu, BatHo = model.BatHo, BocTrongVong = model.BocTrongVong, KhachHang_CMND = model.KhachHang.CMND, NgayBoc = model.NgayBoc, NgayCuoiCungDongTien = model.NgayBoc, NgayTao = DateTime.Now, NhanVien_Id = model.NhanVien_Id, SoNgayDongTien = model.SoNgayDongTien, SoTienKhachDaDong = 0, ThuHoTruoc = false, TienDuaChoKhach = model.TienDuaChoKhach, TinhTrang = "Đang vay" }; using (var context = new TIT_Entities()) { context.HD_BatHo.Add(dbModel); try { if (context.SaveChanges() > 0) { var baocao = context.BaoCaoHangNgays.OrderByDescending(x => x.Ngay).FirstOrDefault(x => x.Id_CuaHang == model.CuaHang_Id); if (baocao != null) { if (baocao.Ngay == DateTime.Now.Date) { baocao.SoTienVonConLai -= model.TienDuaChoKhach; baocao.TongChi += model.TienDuaChoKhach; baocao.TongChiHopDongBatHo += model.TienDuaChoKhach; } else { var bcModel = new BaoCaoHangNgay { Id_CuaHang = model.CuaHang_Id, Ngay = DateTime.Now.Date, SoTienVonDauNgay = baocao.SoTienVonConLai, SoTienVonConLai = baocao.SoTienVonConLai, }; bcModel.SoTienVonConLai -= model.TienDuaChoKhach; bcModel.TongChi += model.TienDuaChoKhach; bcModel.TongChiHopDongBatHo += model.TienDuaChoKhach; context.BaoCaoHangNgays.Add(bcModel); } } else { var bcModel = new BaoCaoHangNgay { Id_CuaHang = model.CuaHang_Id, Ngay = DateTime.Now.Date }; bcModel.SoTienVonConLai -= model.TienDuaChoKhach; bcModel.TongChi += model.TienDuaChoKhach; bcModel.TongChiHopDongBatHo += model.TienDuaChoKhach; context.BaoCaoHangNgays.Add(bcModel); } decimal QuyTienMat = 0; var lastestLichSuThaoTac = context.LichSuThaoTacs.Where(x => x.Id_CuaHang == model.CuaHang_Id).OrderByDescending(p => p.Id).FirstOrDefault(); if (lastestLichSuThaoTac != null) { QuyTienMat = lastestLichSuThaoTac.TongCongTon; } var dbModel2 = new LichSuThaoTac() { Id_CuaHang = model.CuaHang_Id, Id_HopDong = dbModel.HD_BatHo_Id, Id_NhanVienThaoTac = model.NhanVien_Id, NgayThaoTac = DateTime.Now, NoiDung = "Tạo hợp đồng", SoTien = model.TienDuaChoKhach, ThuTien = 0, TenKhachHang = model.KhachHang.TenKhachHang, TongCongTon = QuyTienMat - model.TienDuaChoKhach }; context.LichSuThaoTacs.Add(dbModel2); List <ThongTinDongLai> listModels = new List <ThongTinDongLai>(); int SoNgay = model.BocTrongVong / model.SoNgayDongTien; DateTime ngayBatDau = model.NgayBoc; for (int i = 0; i < SoNgay; i++) { ThongTinDongLai item = new ThongTinDongLai() { DaDong = 0, HopDong_Id = dbModel.HD_BatHo_Id, NgayBatDau = ngayBatDau, NgayDongLai = DateTime.Now, NgayKetThuc = ngayBatDau.AddDays(model.SoNgayDongTien - 1), SoNgay = model.SoNgayDongTien, TienLai = model.TienMotNgay * model.SoNgayDongTien }; context.ThongTinDongLais.Add(item); ngayBatDau = ngayBatDau.AddDays(model.SoNgayDongTien); } if (context.SaveChanges() > 0) { return(dbModel.HD_BatHo_Id); } else { return(null); } } else { return(null); } } catch (Exception ex) { ex.ToString(); //_logger.Error(ex.ToString()); return(null); } } }
public static int Insert(ThuChiDataModel model, int PhieuThuHayChi) { var dbModel = new ThongTinThuChi() { Id_CuaHang = model.MaCuaHang, Id_NhanVien = model.MaNhanVien, KhachHang = model.KhachHang, LoaiPhieu = model.LoaiPhieu, NgayTao = DateTime.Now, PhieuThu = PhieuThuHayChi, GhiChu = model.GhiChu, SoTien = model.SoTien }; using (var context = new TIT_Entities()) { decimal QuyTienMat = 0; var lastestLichSuThaoTac = context.LichSuThaoTacs.Where(x => x.Id_CuaHang == model.MaCuaHang).OrderByDescending(p => p.Id).FirstOrDefault(); if (lastestLichSuThaoTac != null) { QuyTienMat = lastestLichSuThaoTac.TongCongTon; } var dbLichsu = new LichSuThaoTac() { Id_CuaHang = model.MaCuaHang, Id_HopDong = "", Id_NhanVienThaoTac = model.MaNhanVien, NgayThaoTac = DateTime.Now, NoiDung = model.LoaiPhieu + ":" + model.GhiChu, SoTien = model.SoTien, ThuTien = PhieuThuHayChi == PHIEU_THU ? 1 : 0, TongCongTon = QuyTienMat + model.SoTien * (PhieuThuHayChi == PHIEU_THU ? 1 : -1), TenKhachHang = model.KhachHang }; context.LichSuThaoTacs.Add(dbLichsu); var baocao = context.BaoCaoHangNgays.OrderByDescending(x => x.Ngay).FirstOrDefault(x => x.Id_CuaHang == model.MaCuaHang); if (baocao != null) { if (baocao.Ngay == DateTime.Now.Date) { if (PhieuThuHayChi == PHIEU_THU) { baocao.SoTienVonConLai += model.SoTien; baocao.TongThu += model.SoTien; baocao.TongThuKhac += model.SoTien; } else { baocao.SoTienVonConLai -= model.SoTien; baocao.TongChi += model.SoTien; baocao.TongChiKhac += model.SoTien; } } else { var bcModel = new BaoCaoHangNgay { Id_CuaHang = model.MaCuaHang, Ngay = DateTime.Now.Date, SoTienVonDauNgay = baocao.SoTienVonConLai, SoTienVonConLai = baocao.SoTienVonConLai }; if (PhieuThuHayChi == PHIEU_THU) { bcModel.SoTienVonConLai += model.SoTien; bcModel.TongThu += model.SoTien; bcModel.TongThuKhac += model.SoTien; } else { bcModel.SoTienVonConLai -= model.SoTien; bcModel.TongChi += model.SoTien; bcModel.TongChiKhac += model.SoTien; } context.BaoCaoHangNgays.Add(bcModel); } } else { var bcModel = new BaoCaoHangNgay { Id_CuaHang = model.MaCuaHang, Ngay = DateTime.Now.Date }; if (PhieuThuHayChi == PHIEU_THU) { bcModel.SoTienVonConLai = model.SoTien; bcModel.TongThu = model.SoTien; bcModel.TongThuKhac = model.SoTien; } else { bcModel.SoTienVonConLai = -model.SoTien; bcModel.TongChi = model.SoTien; bcModel.TongChiKhac = model.SoTien; } context.BaoCaoHangNgays.Add(bcModel); } context.ThongTinThuChis.Add(dbModel); try { if (context.SaveChanges() > 0) { return(dbModel.Id); } else { return(0); } } catch (Exception ex) { ex.ToString(); //_logger.Error(ex.ToString()); return(0); } } }
public static int ThanhToanHopDong(string Id_HopDong, int Id_CuaHang, string Id_NhanVien, decimal SoTien, decimal TienPhat, string NoiDung, DateTime NgayBatDau, DateTime NgayKetThuc, string TenKhachHang) { using (var context = new TIT_Entities()) { //update var item_update = context.HD_VayDuNoGiamDan.SingleOrDefault(x => x.HD_Id == Id_HopDong); item_update.TinhTrang = "Thanh Lý"; item_update.TienLaiDaDong += SoTien; var item_delete = context.ThongTinDongLais.Where(x => x.DaDong == 0 && x.HopDong_Id == Id_HopDong).ToArray(); var start = item_delete.First(); foreach (var item in item_delete) { context.ThongTinDongLais.Remove(item); } var item_donglai = new ThongTinDongLai() { HopDong_Id = Id_HopDong, GhiChu = "Thanh lý", DaDong = 1, NgayBatDau = start.NgayBatDau, NgayKetThuc = NgayKetThuc, NgayDongLai = DateTime.Now, NhanVienThuTien = Id_NhanVien, TienLai = SoTien, SoTienDaDong = SoTien, TienKhac = TienPhat, SoNgay = 0 }; context.ThongTinDongLais.Add(item_donglai); decimal QuyTienMat = 0; var lastestLichSuThaoTac = context.LichSuThaoTacs.Where(x => x.Id_CuaHang == Id_CuaHang).OrderByDescending(p => p.Id).FirstOrDefault(); if (lastestLichSuThaoTac != null) { QuyTienMat = lastestLichSuThaoTac.TongCongTon; } QuyTienMat += SoTien; var model = new LichSuThaoTac() { Id_CuaHang = Id_CuaHang, Id_HopDong = Id_HopDong, Id_NhanVienThaoTac = Id_NhanVien, NgayThaoTac = DateTime.Now, NoiDung = "Thanh lý hợp đồng", SoTien = SoTien, ThuTien = 1, TongCongTon = QuyTienMat, TenKhachHang = TenKhachHang }; context.LichSuThaoTacs.Add(model); if (TienPhat > 0) { QuyTienMat += TienPhat; var model2 = new LichSuThaoTac() { Id_CuaHang = Id_CuaHang, Id_HopDong = Id_HopDong, Id_NhanVienThaoTac = Id_NhanVien, NgayThaoTac = DateTime.Now, NoiDung = NoiDung, SoTien = TienPhat, ThuTien = 1, TongCongTon = QuyTienMat, TenKhachHang = TenKhachHang }; context.LichSuThaoTacs.Add(model2); } var baocao = context.BaoCaoHangNgays.OrderByDescending(x => x.Ngay).FirstOrDefault(x => x.Id_CuaHang == Id_CuaHang); if (baocao != null) { if (baocao.Ngay == DateTime.Now.Date) { baocao.SoTienVonConLai += SoTien + TienPhat; baocao.TongThu += SoTien + TienPhat; baocao.TongThuHopDongChoVayDNGD += SoTien + TienPhat; } else { var bcModel = new BaoCaoHangNgay { Id_CuaHang = Id_CuaHang, Ngay = DateTime.Now.Date, SoTienVonDauNgay = baocao.SoTienVonConLai, SoTienVonConLai = baocao.SoTienVonConLai, }; bcModel.SoTienVonConLai += SoTien + TienPhat; bcModel.TongThu += SoTien + TienPhat; bcModel.TongThuHopDongChoVayDNGD += SoTien + TienPhat; context.BaoCaoHangNgays.Add(bcModel); } } else { var bcModel = new BaoCaoHangNgay { Id_CuaHang = Id_CuaHang, Ngay = DateTime.Now.Date }; bcModel.SoTienVonConLai += SoTien + TienPhat; bcModel.TongThu += SoTien + TienPhat; bcModel.TongThuHopDongChoVayDNGD += SoTien + TienPhat; context.BaoCaoHangNgays.Add(bcModel); } try { if (context.SaveChanges() > 0) { return(1); } else { return(0); } } catch (Exception ex) { ex.ToString(); //_logger.Error(ex.ToString()); return(0); } } }
public static int DongTienLai(string hD_Id, List <ChoVayDNGD_ThongTinChiTietDongTienLaiModel> update, string Id_NhanVien, decimal SoTien, decimal TienPhat, string Ghichu, string GhiChuTong, string TenKhachHang) { using (var context = new TIT_Entities()) { decimal TienDongHangThang = update[0].TienLai; decimal SoTienDong = SoTien; int IDX = 0; DateTime NgayCuoiCung = DateTime.MinValue; DateTime NgayDongLaiCuoiCung = DateTime.MinValue; int SoKyDongLaiBoSung = 0; bool IsTienPhat = true; while (SoTienDong > 0 && IDX < update.Count) { if (SoTienDong + update[IDX].SoTienDaDong < TienDongHangThang) { int ID = update[IDX].ID; var item_update = context.ThongTinDongLais.SingleOrDefault(x => x.Id == ID); item_update.SoTienDaDong = SoTienDong + update[IDX].SoTienDaDong; NgayCuoiCung = item_update.NgayKetThuc; SoTienDong = SoTienDong + update[IDX].SoTienDaDong - TienDongHangThang; if (IsTienPhat) { item_update.TienKhac += TienPhat; item_update.GhiChu = Ghichu; IsTienPhat = false; } } else { int ID = update[IDX].ID; SoTienDong = SoTienDong + update[IDX].SoTienDaDong - TienDongHangThang; var item_update = context.ThongTinDongLais.SingleOrDefault(x => x.Id == ID); item_update.SoTienDaDong = TienDongHangThang; NgayDongLaiCuoiCung = item_update.NgayKetThuc; item_update.DaDong = 1; SoKyDongLaiBoSung++; if (IsTienPhat) { item_update.TienKhac += TienPhat; item_update.GhiChu = Ghichu; IsTienPhat = false; } } IDX++; } if (IsTienPhat) { int ID = update[IDX].ID; var item_update = context.ThongTinDongLais.SingleOrDefault(x => x.Id == ID); item_update.TienKhac = TienPhat; item_update.GhiChu = Ghichu; IsTienPhat = false; } ////update //var item_update = context.ThongTinDongLais.SingleOrDefault(x => x.Id == update.ID); //item_update.DaDong = update.DaDong; //item_update.TienKhac = update.TienKhac; //item_update.NgayDongLai = DateTime.Now; var hd_update = context.HD_VayDuNoGiamDan.SingleOrDefault(x => x.HD_Id == hD_Id); if (NgayDongLaiCuoiCung != DateTime.MinValue) { hd_update.NgayCuoiCungDongTien = NgayDongLaiCuoiCung; } hd_update.TienLaiDaDong += SoTien; hd_update.GhiChu = GhiChuTong; //int desMonth = hd_update.NgayCuoiCungDongTien.Value.Month; //int srcMonth = hd_update.NgayVay.Month; //int totalMonth = desMonth > srcMonth ? desMonth - srcMonth : desMonth + 13 - srcMonth; //if (totalMonth - 1 >= hd_update.ThoiHanVay) // hd_update.TinhTrang = "Thanh Lý"; if (SoKyDongLaiBoSung == update.Count) { hd_update.TinhTrang = "Thanh Lý"; } decimal QuyTienMat = 0; var lastestLichSuThaoTac = context.LichSuThaoTacs.Where(x => x.Id_CuaHang == hd_update.CuaHang_Id).OrderByDescending(p => p.Id).FirstOrDefault(); if (lastestLichSuThaoTac != null) { QuyTienMat = lastestLichSuThaoTac.TongCongTon; } QuyTienMat = QuyTienMat + SoTien; var lichsu = new LichSuThaoTac() { Id_CuaHang = hd_update.CuaHang_Id, Id_HopDong = hd_update.HD_Id, Id_NhanVienThaoTac = Id_NhanVien, NgayThaoTac = DateTime.Now, NoiDung = "Đóng lãi", SoTien = SoTien, ThuTien = 1, TongCongTon = QuyTienMat, TenKhachHang = TenKhachHang }; context.LichSuThaoTacs.Add(lichsu); if (TienPhat > 0) { QuyTienMat = QuyTienMat + TienPhat; var lichsu2 = new LichSuThaoTac() { Id_CuaHang = hd_update.CuaHang_Id, Id_HopDong = hd_update.HD_Id, Id_NhanVienThaoTac = Id_NhanVien, NgayThaoTac = DateTime.Now, NoiDung = "Tiền khác", SoTien = TienPhat, ThuTien = 1, TongCongTon = QuyTienMat, TenKhachHang = TenKhachHang }; context.LichSuThaoTacs.Add(lichsu2); } var baocao = context.BaoCaoHangNgays.OrderByDescending(x => x.Ngay).FirstOrDefault(x => x.Id_CuaHang == hd_update.CuaHang_Id); if (baocao != null) { if (baocao.Ngay == DateTime.Now.Date) { baocao.SoTienVonConLai += SoTien; baocao.TongThu += SoTien; baocao.TongThuHopDongChoVayDNGD += SoTien; } else { var bcModel = new BaoCaoHangNgay { Id_CuaHang = hd_update.CuaHang_Id, Ngay = DateTime.Now.Date, SoTienVonDauNgay = baocao.SoTienVonConLai, SoTienVonConLai = baocao.SoTienVonConLai, }; bcModel.SoTienVonConLai += SoTien; bcModel.TongThu += SoTien; bcModel.TongThuHopDongChoVayDNGD += SoTien; context.BaoCaoHangNgays.Add(bcModel); } } else { var bcModel = new BaoCaoHangNgay { Id_CuaHang = hd_update.CuaHang_Id, Ngay = DateTime.Now.Date }; bcModel.SoTienVonConLai += SoTien; bcModel.TongThu += SoTien; bcModel.TongThuHopDongChoVayDNGD += SoTien; context.BaoCaoHangNgays.Add(bcModel); } try { if (context.SaveChanges() > 0) { return(1); } else { return(0); } } catch (Exception ex) { ex.ToString(); //_logger.Error(ex.ToString()); return(0); } } }
public static int HuyHopDong(string id_HopDong, string ghiChu, decimal soTienThuLai, string Id_NhanVien, string TenKhachHang) { using (var context = new TIT_Entities()) { //update var item_update = context.HD_VayDuNoGiamDan.SingleOrDefault(x => x.HD_Id == id_HopDong); item_update.TinhTrang = "Hủy hợp đồng"; var item_delete = context.ThongTinDongLais.Where(x => x.HopDong_Id == id_HopDong).ToArray(); foreach (var item in item_delete) { context.ThongTinDongLais.Remove(item); } decimal QuyTienMat = 0; var lastestLichSuThaoTac = context.LichSuThaoTacs.Where(x => x.Id_CuaHang == item_update.CuaHang_Id).OrderByDescending(p => p.Id).FirstOrDefault(); if (lastestLichSuThaoTac != null) { QuyTienMat = lastestLichSuThaoTac.TongCongTon; } QuyTienMat += soTienThuLai; var model = new LichSuThaoTac() { Id_CuaHang = item_update.CuaHang_Id, Id_HopDong = id_HopDong, Id_NhanVienThaoTac = Id_NhanVien, NgayThaoTac = DateTime.Now, NoiDung = "Hủy hợp đồng: " + ghiChu, SoTien = soTienThuLai, ThuTien = 1, TongCongTon = QuyTienMat, TenKhachHang = TenKhachHang }; context.LichSuThaoTacs.Add(model); var baocao = context.BaoCaoHangNgays.OrderByDescending(x => x.Ngay).FirstOrDefault(x => x.Id_CuaHang == item_update.CuaHang_Id); if (baocao != null) { if (baocao.Ngay == DateTime.Now.Date) { baocao.SoTienVonConLai += soTienThuLai; baocao.TongThu += soTienThuLai; baocao.TongThuHopDongChoVayDNGD += soTienThuLai; } else { var bcModel = new BaoCaoHangNgay { Id_CuaHang = item_update.CuaHang_Id, Ngay = DateTime.Now.Date, SoTienVonDauNgay = baocao.SoTienVonConLai, SoTienVonConLai = baocao.SoTienVonConLai, }; bcModel.SoTienVonConLai += soTienThuLai; bcModel.TongThu += soTienThuLai; bcModel.TongThuHopDongChoVayDNGD += soTienThuLai; context.BaoCaoHangNgays.Add(bcModel); } } else { var bcModel = new BaoCaoHangNgay { Id_CuaHang = item_update.CuaHang_Id, Ngay = DateTime.Now.Date }; bcModel.SoTienVonConLai += soTienThuLai; bcModel.TongThu += soTienThuLai; bcModel.TongThuHopDongChoVayDNGD += soTienThuLai; context.BaoCaoHangNgays.Add(bcModel); } try { if (context.SaveChanges() > 0) { return(1); } else { return(0); } } catch (Exception ex) { ex.ToString(); //_logger.Error(ex.ToString()); return(0); } } }
internal CamDoGridDataModel InsertCamDo(CamDoInsertNewDataModel model) { var dbModel = new HD_CamDo { CuaHang_Id = model.Id_CuaHang, MaTaiSan = model.LoaiTaiSan, TaiSan = model.TenTaiSan, NgayCuoiCungDongTienLai = model.NgayVay, HinhThucLai = model.HinhThucLai, GhiChu = model.GhiChu, KyLai = model.KyLai, Lai = model.LaiPhi, SoTienCam = model.SoTien, NgayCam = model.NgayVay, NgayThanhLyHopDong = null, NhanVien_Id = _userId, TinhTrang = "Đang cầm", KhachHang_CMND = model.CMND, KhachHang_HoTen = model.TenKhachHang, NgayTao = DateTime.Now, }; using (var context = new TIT_Entities()) { context.HD_CamDo.Add(dbModel); try { if (context.SaveChanges() > 0) { var dbDongLai = new ThongTinDongLai() { HopDong_Id = dbModel.HD_CamDo_Id, TienLai = HinhThucLaiHelper.TinhLaiMotNgay(model.HinhThucLai, model.SoTien, model.LaiPhi) * model.KyLai, TienKhac = 0, DaDong = 0, NgayBatDau = model.NgayVay.Date, NgayKetThuc = model.NgayVay.Date.Add(new TimeSpan(model.KyLai - 1, 0, 0, 0)), NgayDongLai = DateTime.Now }; CapNhatBaoCao_Chi(context, model.Id_CuaHang, model.SoTien); decimal QuyTienMat = 0; var lastestLichSuThaoTac = context.LichSuThaoTacs.Where(x => x.Id_CuaHang == model.Id_CuaHang).OrderByDescending(p => p.Id).FirstOrDefault(); if (lastestLichSuThaoTac != null) { QuyTienMat = lastestLichSuThaoTac.TongCongTon; } var dbModel2 = new LichSuThaoTac() { Id_CuaHang = model.Id_CuaHang, Id_HopDong = dbModel.HD_CamDo_Id, Id_NhanVienThaoTac = _userId, NgayThaoTac = DateTime.Now, NoiDung = "Tạo hợp đồng", SoTien = model.SoTien, ThuTien = 0, TongCongTon = QuyTienMat - model.SoTien, TenKhachHang = model.TenKhachHang }; context.ThongTinDongLais.Add(dbDongLai); context.LichSuThaoTacs.Add(dbModel2); if (context.SaveChanges() > 0) { return(new CamDoGridDataModel() { HopDong_Id = dbModel.HD_CamDo_Id, SoTien = dbModel.SoTienCam, LaiDaDong = "0", LaiPhiDenHomNay = "0", NgayPhaiDongLai = dbModel.NgayCuoiCungDongTienLai.Value.AddDays(1), NgayTaoHopDong = dbModel.NgayCam, NoCu = "0", TaiSan = dbModel.TaiSan, TinhTrang = dbModel.TinhTrang }); } else { return(null); } } else { return(null); } } catch (Exception ex) { ex.ToString(); //_logger.Error(ex.ToString()); return(null); } } }