/// <summary>
/// Lưu thông tin giá đặc biệt
/// </summary>
/// <param name="KhachHangID"></param>
/// <param name="isPhanTram"></param>
/// <param name="SH"></param>
/// <param name="KD"></param>
/// <param name="HC"></param>
/// <param name="CC"></param>
/// <param name="SX"></param>
/// <param name="month"></param>
/// <param name="year"></param>
public void saveGiaDacBiet(int KhachHangID, double SH, double KD, double HC, double CC, double SX, double SH1, double SH2, double SH3, double SH4, int month, int year)
{
HoaDonHaDongEntities db = new HoaDonHaDongEntities();
//xóa record ứng với áp giá tổng hợp của khách hàng đó
db.Apgiatonghops.RemoveRange(db.Apgiatonghops.Where(p => p.KhachhangID == KhachHangID && p.ThangTongHop == month && p.NamTongHop == year));
if (KD != -1)
{
Apgiatonghop apTongHopKD = new Apgiatonghop();
apTongHopKD.KhachhangID = KhachHangID;
apTongHopKD.IsDelete = false;
apTongHopKD.IDLoaiApGia = KhachHang.KINHDOANHDICHVU; //KD
apTongHopKD.SanLuong = KD;
apTongHopKD.NamTongHop = year;
apTongHopKD.ThangTongHop = month;
db.Apgiatonghops.Add(apTongHopKD);
}
if (HC != -1)
{
Apgiatonghop apTongHopHC = new Apgiatonghop();
apTongHopHC.KhachhangID = KhachHangID;
apTongHopHC.IsDelete = false;
apTongHopHC.IDLoaiApGia = KhachHang.COQUANHANHCHINH; //HC
apTongHopHC.SanLuong = HC;
apTongHopHC.NamTongHop = year;
apTongHopHC.ThangTongHop = month;
db.Apgiatonghops.Add(apTongHopHC);
}
if (CC != -1)
{
Apgiatonghop apTongHopCC = new Apgiatonghop();
apTongHopCC.KhachhangID = KhachHangID;
apTongHopCC.IsDelete = false;
apTongHopCC.IDLoaiApGia = KhachHang.DONVISUNGHIEP; //CC
apTongHopCC.SanLuong = CC;
apTongHopCC.NamTongHop = year;
apTongHopCC.ThangTongHop = month;
db.Apgiatonghops.Add(apTongHopCC);
}
if (SX != -1)
{
Apgiatonghop apTongHopSX = new Apgiatonghop();
apTongHopSX.KhachhangID = KhachHangID;
apTongHopSX.IsDelete = false;
apTongHopSX.IDLoaiApGia = KhachHang.SANXUAT; //SX
apTongHopSX.SanLuong = SX;
apTongHopSX.NamTongHop = year;
apTongHopSX.ThangTongHop = month;
db.Apgiatonghops.Add(apTongHopSX);
}
if (SH != -1)
{
Apgiatonghop apTongHop = new Apgiatonghop();
apTongHop.KhachhangID = KhachHangID;
apTongHop.IsDelete = false;
apTongHop.IDLoaiApGia = KhachHang.SINHHOAT; //SH
apTongHop.SanLuong = SH;
apTongHop.NamTongHop = year;
apTongHop.ThangTongHop = month;
db.Apgiatonghops.Add(apTongHop);
}
if (SH1 != -1)
{
Apgiatonghop apTongHop = new Apgiatonghop();
apTongHop.KhachhangID = KhachHangID;
apTongHop.IsDelete = false;
apTongHop.IDLoaiApGia = KhachHang.SH1; //SH
apTongHop.SanLuong = SH1;
apTongHop.NamTongHop = year;
apTongHop.ThangTongHop = month;
db.Apgiatonghops.Add(apTongHop);
}
if (SH2 != -1)
{
Apgiatonghop apTongHop = new Apgiatonghop();
apTongHop.KhachhangID = KhachHangID;
apTongHop.IsDelete = false;
apTongHop.IDLoaiApGia = KhachHang.SH2; //SH
apTongHop.SanLuong = SH2;
apTongHop.NamTongHop = year;
apTongHop.ThangTongHop = month;
db.Apgiatonghops.Add(apTongHop);
}
if (SH3 != -1)
{
Apgiatonghop apTongHop = new Apgiatonghop();
apTongHop.KhachhangID = KhachHangID;
apTongHop.IsDelete = false;
apTongHop.IDLoaiApGia = KhachHang.SH3; //SH
apTongHop.SanLuong = SH3;
apTongHop.NamTongHop = year;
apTongHop.ThangTongHop = month;
db.Apgiatonghops.Add(apTongHop);
}
if (SH4 != -1)
{
Apgiatonghop apTongHop = new Apgiatonghop();
apTongHop.KhachhangID = KhachHangID;
apTongHop.IsDelete = false;
apTongHop.IDLoaiApGia = KhachHang.SH4; //SH
apTongHop.SanLuong = SH4;
apTongHop.NamTongHop = year;
apTongHop.ThangTongHop = month;
db.Apgiatonghops.Add(apTongHop);
}
db.SaveChanges();
}
/// <summary>
/// Lưu chỉ số tổng hợp cho khách hàng
/// </summary>
/// <param name="KhachHangID"></param>
/// <param name="isPhanTram"></param>
/// <param name="SH"></param>
/// <param name="KD"></param>
/// <param name="SX"></param>
public void saveGiaTongHop(int KhachHangID, byte isPhanTram, double SH, double KD, double HC, double CC, double SX, int month, short year)
{
HoaDonHaDongEntities _db = new HoaDonHaDongEntities();
_db.Apgiatonghops.RemoveRange(_db.Apgiatonghops.Where(p => p.KhachhangID == KhachHangID).ToList());
if (KD != -1)
{
Apgiatonghop apTongHopKD = new Apgiatonghop();
apTongHopKD.KhachhangID = KhachHangID;
apTongHopKD.IsDelete = false;
apTongHopKD.CachTinh = isPhanTram;
apTongHopKD.IDLoaiApGia = KhachHang.KINHDOANHDICHVU; //KD
apTongHopKD.SanLuong = KD;
apTongHopKD.NamTongHop = year;
apTongHopKD.ThangTongHop = month;
_db.Apgiatonghops.Add(apTongHopKD);
_db.SaveChanges();
}
if (HC != -1)
{
Apgiatonghop apTongHopHC = new Apgiatonghop();
apTongHopHC.KhachhangID = KhachHangID;
apTongHopHC.IsDelete = false;
apTongHopHC.CachTinh = isPhanTram;
apTongHopHC.IDLoaiApGia = KhachHang.COQUANHANHCHINH; //HC
apTongHopHC.SanLuong = HC;
apTongHopHC.NamTongHop = year;
apTongHopHC.ThangTongHop = month;
_db.Apgiatonghops.Add(apTongHopHC);
_db.SaveChanges();
}
if (CC != -1)
{
Apgiatonghop apTongHopCC = new Apgiatonghop();
apTongHopCC.KhachhangID = KhachHangID;
apTongHopCC.IsDelete = false;
apTongHopCC.CachTinh = isPhanTram;
apTongHopCC.IDLoaiApGia = KhachHang.DONVISUNGHIEP; //CC
apTongHopCC.SanLuong = CC;
apTongHopCC.NamTongHop = year;
apTongHopCC.ThangTongHop = month;
_db.Apgiatonghops.Add(apTongHopCC);
_db.SaveChanges();
}
if (SX != -1)
{
Apgiatonghop apTongHopSX = new Apgiatonghop();
apTongHopSX.KhachhangID = KhachHangID;
apTongHopSX.IsDelete = false;
apTongHopSX.CachTinh = isPhanTram;
apTongHopSX.IDLoaiApGia = KhachHang.SANXUAT; //SX
apTongHopSX.SanLuong = SX;
apTongHopSX.NamTongHop = year;
apTongHopSX.ThangTongHop = month;
_db.Apgiatonghops.Add(apTongHopSX);
_db.SaveChanges();
}
if (SH != -1)
{
Apgiatonghop apTongHop = new Apgiatonghop();
apTongHop.KhachhangID = KhachHangID;
apTongHop.IsDelete = false;
apTongHop.CachTinh = isPhanTram;
apTongHop.IDLoaiApGia = KhachHang.SINHHOAT; //SH
apTongHop.SanLuong = SH;
apTongHop.NamTongHop = year;
apTongHop.ThangTongHop = month;
_db.Apgiatonghops.Add(apTongHop);
_db.SaveChanges();
}
}
