public async Task <bool> MoSoTietKiemAsync(SoTietKiemRequest request)
{
try
{
var soTK = new SoTk();
soTK.LoaiTietKiemId = request.LoaiTietKiemId;
soTK.KhachHang = request.KhachHang;
soTK.Cmnd = request.Cmnd;
soTK.DiaChi = request.DiaChi;
soTK.NgayMoSo = request.NgayMoSo;
soTK.SoTienGui = request.SoTienGui;
soTK.SoDu = request.SoTienGui;
context.SoTk.Add(soTK);
var phieuGuiTien = new PhieuGuiRutTien
{
Mskh = soTK.Mskh,
KhachHang = request.KhachHang,
SoTien = request.SoTienGui,
Ngay = DateTime.Now
};
context.PhieuGuiRutTien.Add(phieuGuiTien);
context.SaveChanges();
var loaiTK = context.LoaiTietKiem.Find(request.LoaiTietKiemId);
var chiTietSo = new ChiTietSoTietKiem
{
PhieuGuiRutTienId = phieuGuiTien.Id,
Mskh = soTK.Mskh,
NgayGui = request.NgayMoSo,
SoTienGui = request.SoTienGui,
LoaiTietKiemId = request.LoaiTietKiemId,
LaiSuat = loaiTK.LaiSuat,
SoDuDauKy = 0,
SoDuCuoiKy = request.SoTienGui,
SoThangLaiSuat = 0,
SoNgayLaiSuat = 0,
LaiSuatNgay = 0,
NghiepVu = "MO"
};
context.ChiTietSoTietKiem.Add(chiTietSo);
return(await context.SaveChangesAsync() > 0);
}
catch (Exception e)
{
throw e;
}
}
private PhieuGuiRutTien TaoPhieuGuiRut(ThemGuiRutTienRequest request)
{
var phieuGuiRut = new PhieuGuiRutTien
{
Mskh = request.MSKH,
KhachHang = request.KhachHang,
SoTien = Convert.ToDouble(request.SoTien.ToString()),
Ngay = request.Ngay
};
context.PhieuGuiRutTien.Add(phieuGuiRut);
if (context.SaveChanges() > 0)
{
return(phieuGuiRut);
}
else
{
return(null);
}
}
private ChiTietSoTietKiem KhoiTaoChiTiet(PhieuGuiRutTien phieuGuiTien, ChiTietSoTietKiem chitietSoTruoc, LoaiTietKiem loaitietkiem, string nghiepvu)
{
var result = new ChiTietSoTietKiem
{
PhieuGuiRutTienId = phieuGuiTien.Id,
Mskh = phieuGuiTien.Mskh,
NgayGui = phieuGuiTien.Ngay,
SoTienGui = phieuGuiTien.SoTien,
LoaiTietKiemId = loaitietkiem.Id,
LaiSuat = loaitietkiem.LaiSuat,
};
if (nghiepvu == "RUT" || nghiepvu == "DONG")
{
result.SoTienGui = 0;
result.NgayGui = null;
result.SoTienRut = phieuGuiTien.SoTien;
result.NgayRut = phieuGuiTien.Ngay;
}
result.SoDuDauKy = chitietSoTruoc.SoDuCuoiKy + phieuGuiTien.SoTien;
return(result);
}
private bool AddChiTietSo(PhieuGuiRutTien phieuGuiTien, ChiTietSoTietKiem chitietSoTruoc, LoaiTietKiem loaitietkiem, LoaiTietKiem khongkyhan, string nghiepvu, SoTk soTietKiem)
{
var addChiTietSo = this.KhoiTaoChiTiet(phieuGuiTien, chitietSoTruoc, loaitietkiem, nghiepvu);
addChiTietSo.NghiepVu = nghiepvu;
int soNam = phieuGuiTien.Ngay.Value.Year - chitietSoTruoc.NgayGui.Value.Year;
int soThang = 0;
if (soNam > 0)
{
soThang = phieuGuiTien.Ngay.Value.Month + 12 - chitietSoTruoc.NgayGui.Value.Month;
}
else
{
soThang = phieuGuiTien.Ngay.Value.Month - chitietSoTruoc.NgayGui.Value.Month;
}
var soNgay = Math.Abs(phieuGuiTien.Ngay.Value.Day - chitietSoTruoc.NgayGui.Value.Day);
if (soThang > 0 && nghiepvu != "DONG")
{
addChiTietSo.SoThangLaiSuat = soThang;
addChiTietSo.LaiSuatThang = this.LaiThang(chitietSoTruoc.SoDuCuoiKy.Value, addChiTietSo.LaiSuat.Value / 100, (double)soThang);
addChiTietSo.SoNgayLaiSuat = 0;
addChiTietSo.LaiSuatNgay = 0;
}
if (soNgay > 0 && nghiepvu != "DONG")
{
addChiTietSo.SoNgayLaiSuat = (int)soNgay;
addChiTietSo.LaiSuatNgay = this.LaiNgay(chitietSoTruoc.SoDuCuoiKy.Value, khongkyhan.LaiSuat / 100, (double)soThang, soNgay);
}
if (nghiepvu == "RUT")
{
addChiTietSo.SoThangLaiSuat = soThang;
addChiTietSo.LaiSuatThang = this.LaiThang(chitietSoTruoc.SoDuCuoiKy.Value, addChiTietSo.LaiSuat.Value / 100, (double)soThang);
addChiTietSo.SoNgayLaiSuat = 0;
addChiTietSo.LaiSuatNgay = 0;
}
if (nghiepvu == "DONG")
{
addChiTietSo.SoThangLaiSuat = 0;
addChiTietSo.LaiSuatThang = 0;
addChiTietSo.SoNgayLaiSuat = 0;
addChiTietSo.LaiSuatNgay = 0;
}
addChiTietSo.SoDuCuoiKy = addChiTietSo.SoDuDauKy + addChiTietSo.LaiSuatThang + addChiTietSo.LaiSuatNgay;
context.ChiTietSoTietKiem.Add(addChiTietSo);
soTietKiem.SoDu = addChiTietSo.SoDuCuoiKy;
if (nghiepvu == "DONG")
{
soTietKiem.NgayDongSo = DateTime.Now;
soTietKiem.SoDu = 0;
}
context.SoTk.Update(soTietKiem);
return(context.SaveChanges() > 0);
}