public static CuaHangUpdateModel LayCuaHangUpdateTheoIDCuaHang(int maCuaHang)
{
CuaHangUpdateModel result = null;
using (var context = new TIT_Entities())
{
result = (from ch in context.CuaHangs
where ch.MaCuaHang == maCuaHang
select new CuaHangUpdateModel()
{
MaCuaHang = ch.MaCuaHang,
TenCuaHang = ch.TenCuaHang,
DiaChi = ch.DiaChi,
DienThoai = "Không có",
NgayTao = ch.NgayTao,
NguoiTao = ch.NguoiTao,
QuyTienMat = ch.QuyTienMat.HasValue ? ch.QuyTienMat.Value : 0,
VonDauTu = ch.VonDauTu.HasValue ? ch.VonDauTu.Value : 0,
Latitude = ch.Latitude.HasValue ? ch.Latitude.Value : 0,
Longitude = ch.Longitude.HasValue ? ch.Longitude.Value : 0,
TinhTrang = ch.TinhTrang == 1 ? true : false,
TKQuanLy = ch.QuanLyCuaHang
}).FirstOrDefault();
}
return(result);
}
public static BaoCaoCuaHangTempViewModel LayBaoCaoCuaHang(int cuaHang_Id)
{
BaoCaoCuaHangTempViewModel result;
using (var context = new TIT_Entities())
{
var date = DateTime.Now.Date;
result = (from nv in context.BaoCaoHangNgays
where nv.Id_CuaHang == cuaHang_Id && nv.Ngay == date
select new BaoCaoCuaHangTempViewModel()
{
TongChi = nv.TongChi,
TongChiBatHo = nv.TongChiHopDongBatHo,
TongChiCamDo = nv.TongChiHopDongCamDo,
TongChiChoVay = nv.TongChiHopDongChoVay,
TongChiDNGD = nv.TongChiHopDongChoVayDNGD,
TongChiKhac = nv.TongChiKhac,
TongSoTienConLai = nv.SoTienVonConLai,
TongSoTienDauNgay = nv.SoTienVonDauNgay,
TongThu = nv.TongThu,
TongThuBatHo = nv.TongThuHopDongBatHo,
TongThuCamDo = nv.TongThuHopDongCamDo,
TongThuChoVay = nv.TongThuHopDongChoVay,
TongThuDNGD = nv.TongThuHopDongChoVayDNGD,
TongThuKhac = nv.TongThuKhac
}).FirstOrDefault();
if (result == null)
{
return(new BaoCaoCuaHangTempViewModel());
}
}
return(result);
}
public static int Insert(CuaHangAddNewModel model)
{
var dbModel = new CuaHang
{
TenCuaHang = model.TenCuaHang,
DiaChi = model.DiaChi,
Latitude = model.Latitude,
Longitude = model.Longitude,
NgayTao = model.NgayTao,
NguoiTao = model.NguoiTao,
QuyTienMat = model.QuyTienMat,
VonDauTu = model.VonDauTu,
TinhTrang = model.TinhTrang ? 1 : 0,
QuanLyCuaHang = model.TKQuanLy
};
using (var context = new TIT_Entities())
{
context.CuaHangs.Add(dbModel);
try
{
return(context.SaveChanges());
}
catch (Exception ex)
{
ex.ToString();
//_logger.Error(ex.ToString());
return(-1);
}
}
}
public static List <AspNetRole> LayDanhSachPhanQuyen()
{
using (var context = new TIT_Entities())
{
return(context.AspNetRoles.ToList());
}
}
public static IEnumerable <BatHo_ThongTinChiTietDongTienLaiModel> LayDanhSachDongTienLai(string maHopDong)
{
IEnumerable <BatHo_ThongTinChiTietDongTienLaiModel> result;
using (var context = new TIT_Entities())
{
result = (from hd in context.ThongTinDongLais
join nv in context.AspNetUsers on hd.NhanVienThuTien equals nv.Id into gj
from subpet in gj.DefaultIfEmpty()
where hd.HopDong_Id == maHopDong
select new BatHo_ThongTinChiTietDongTienLaiModel()
{
NgayHo = hd.NgayBatDau,
NgayKetThuc = hd.NgayKetThuc,
DaDong = hd.DaDong,
TienHo = hd.TienLai,
MaNhanVien = hd.NhanVienThuTien,
TenNhanVien = subpet.UserName ?? String.Empty,
ID = hd.Id,
NgayGiaoDich = hd.NgayDongLai.HasValue? hd.NgayDongLai.Value: hd.NgayBatDau
}).ToArray();
}
return(result);
}
public static int CapNhatThongTinGhiChu(string id_HopDong, string ghiChu)
{
using (var context = new TIT_Entities())
{
var hd_update = context.HD_VayDuNoGiamDan.SingleOrDefault(x => x.HD_Id == id_HopDong);
hd_update.GhiChu = ghiChu;
try
{
if (context.SaveChanges() > 0)
{
return(1);
}
else
{
return(0);
}
}
catch (Exception ex)
{
ex.ToString();
//_logger.Error(ex.ToString());
return(0);
}
}
}
public static int HenGio(string id_HopDong, DateTime ngayHen, string ghiChu)
{
using (var context = new TIT_Entities())
{
var HD = context.HD_VayDuNoGiamDan.Where(x => x.HD_Id == id_HopDong).FirstOrDefault();
if (HD != null)
{
HD.TrangThaiHenGio = 1;
HD.NgayHenGio = ngayHen;
HD.GhiChuHenGio = ghiChu;
try
{
if (context.SaveChanges() > 0)
{
return(1);
}
else
{
return(0);
}
}
catch (Exception ex)
{
ex.ToString();
//_logger.Error(ex.ToString());
}
}
}
return(0);
}
public static IEnumerable <HopDongVayDNGDGridViewModel> LayHopDongTheoIdQuanLy(string IdQuanLy)
{
IEnumerable <HopDongVayDNGDGridViewModel> result;
using (var context = new TIT_Entities())
{
result = (from hd in context.HD_VayDuNoGiamDan
join kh in context.KhachHangs on hd.KhachHang_CMND equals kh.CMND
join ch in context.CuaHangs on hd.CuaHang_Id equals ch.MaCuaHang
where ch.QuanLyCuaHang == IdQuanLy && hd.TinhTrang != "Hủy hợp đồng"
select new HopDongVayDNGDGridViewModel
{
KhachHang = new KhachHangModel()
{
TenKhachHang = kh.TenKhachHang,
SoDienThoai = kh.SoDienThoai1
},
HoaHong = hd.HoaHong,
LaiSuat = hd.LaiSuat,
NgayDongTienCuoiCung = hd.NgayCuoiCungDongTien.HasValue ? hd.NgayCuoiCungDongTien.Value : hd.NgayVay,
NgayVay = hd.NgayVay,
SoTien = hd.SoTienVay,
ThoiHanVay = hd.ThoiHanVay,
Id_HopDong = hd.HD_Id,
TinhTrang = hd.TinhTrang,
NgayHen = hd.NgayHenGio.HasValue ? hd.NgayHenGio.Value : DateTime.MinValue,
NoiDungHen = hd.GhiChuHenGio,
IsHenGio = hd.TrangThaiHenGio == 1 ? true : false,
DaDong = hd.TienLaiDaDong,
NgayBatDauThanhToan = hd.NgayBatDauDongLai,
CuaHang = ch.TenCuaHang
}).ToArray();
}
return(result);
}
public override IEnumerable <CamDoGridDataModel> GetGridViewCamDoModel()
{
IEnumerable <CamDoGridDataModel> result;
using (var context = new TIT_Entities())
{
result = (from hd in context.HD_CamDo
join kh in context.KhachHangs on hd.KhachHang_CMND equals kh.CMND
join user in context.AspNetUsers on hd.CuaHang_Id equals user.CuaHang_Id
where user.Id == _userId
select new CamDoGridDataModel
{
HopDong_Id = hd.HD_CamDo_Id,
TenKhachHang = kh.TenKhachHang,
SoDienThoai = kh.SoDienThoai1,
NgayPhaiDongLai = hd.NgayCuoiCungDongTienLai.HasValue ? hd.NgayCuoiCungDongTienLai.Value : hd.NgayCam,
TinhTrang = hd.TinhTrang.ToString(),
NoCu = "",
SoTien = hd.SoTienCam,
TaiSan = hd.TaiSan,
NgayTaoHopDong = hd.NgayCam
}).ToArray();
}
return(result);
}
public static IEnumerable <ThuChiGridViewModel> LayDanhSachThu(IEnumerable <CuaHangDataModel> models)
{
IEnumerable <ThuChiGridViewModel> result;
var DanhSachIDCuaHang = models.Select(x => x.MaCuaHang);
using (var context = new TIT_Entities())
{
DateTime today = DateTime.Now.Date;
DateTime tmr = DateTime.Now.Date.AddDays(1);
result = (from tc in context.ThongTinThuChis
join ch in context.CuaHangs on tc.Id_CuaHang equals ch.MaCuaHang
join nv in context.AspNetUsers on tc.Id_NhanVien equals nv.Id
where DanhSachIDCuaHang.Contains(tc.Id_CuaHang) && tc.NgayTao >= today && tc.NgayTao < tmr && tc.PhieuThu == PHIEU_THU
select new ThuChiGridViewModel()
{
KhachHang = tc.KhachHang,
GhiChu = tc.GhiChu,
LoaiPhieu = tc.LoaiPhieu,
SoTien = tc.SoTien,
Ngay = tc.NgayTao,
CuaHang = new CuaHangDataModel()
{
MaCuaHang = ch.MaCuaHang,
TenCuaHang = ch.TenCuaHang
},
NhanVien = nv.UserName
}).ToArray();
}
return(result);
}
public static IEnumerable <HopDongBatHoGridViewModel> LayHopDongTheoIdQuanLy(string IdQuanLy)
{
IEnumerable <HopDongBatHoGridViewModel> result;
using (var context = new TIT_Entities())
{
result = (from hd in context.HD_BatHo
join kh in context.KhachHangs on hd.KhachHang_CMND equals kh.CMND
join ch in context.CuaHangs on hd.CuaHang_Id equals ch.MaCuaHang
where ch.QuanLyCuaHang == IdQuanLy
select new HopDongBatHoGridViewModel
{
KhachHang = new KhachHangModel()
{
TenKhachHang = kh.TenKhachHang,
SoDienThoai = kh.SoDienThoai1
},
Id_HopDong = hd.HD_BatHo_Id,
NgayBoc = hd.NgayBoc,
NgayDongTienCuoiCung = hd.NgayCuoiCungDongTien.HasValue ? hd.NgayCuoiCungDongTien.Value : hd.NgayBoc,
NoCu = 0,
TienGiaoKhach = hd.TienDuaChoKhach,
BatHo = hd.BatHo,
BocTrongVong = hd.BocTrongVong,
SoNgayDongTien = hd.SoNgayDongTien,
TinhTrang = hd.TinhTrang
}).ToArray();
}
return(result);
}
public static ChoVayDNGD_CapNhatThongTinDongTienViewModel LayThongTinDongTienHopDong(string maHopDong)
{
ChoVayDNGD_CapNhatThongTinDongTienViewModel result = new ChoVayDNGD_CapNhatThongTinDongTienViewModel();
using (var context = new TIT_Entities())
{
result.HopDongChoVay = (from hd in context.HD_VayDuNoGiamDan
join kh in context.KhachHangs on hd.KhachHang_CMND equals kh.CMND
where hd.HD_Id == maHopDong
select new HopDongChoVayDNGDDataModel()
{
Id_HopDong = hd.HD_Id,
GhiChu = hd.GhiChu,
KhachHang = new KhachHangModel()
{
TenKhachHang = kh.TenKhachHang,
CMND = kh.CMND,
DiaChi = kh.DiaChi != null ? kh.DiaChi : "",
HinhDaiDien = kh.HinhDaiDien != null ? kh.HinhDaiDien : "",
SoDienThoai = kh.SoDienThoai1
},
Lai = hd.LaiSuat,
NgayVay = hd.NgayVay,
SoTienVay = hd.SoTienVay,
TinhTrang = hd.TinhTrang,
CuaHang_Id = hd.CuaHang_Id,
HoaHong = hd.HoaHong,
NhanVien_Id = hd.NhanVien_Id,
ThoiHanVay = hd.ThoiHanVay,
NgayBatDauThanhToan = hd.NgayBatDauDongLai,
NgayDongLaiCuoiCung = hd.NgayCuoiCungDongTien.HasValue ? hd.NgayCuoiCungDongTien.Value : hd.NgayVay,
ThongTinHenGio = new ChoVayDNGD_HenGio()
{
NgayHen = hd.NgayHenGio.HasValue? hd.NgayHenGio.Value: DateTime.Now,
GhiChu = hd.GhiChuHenGio,
IsNhacHen = hd.TrangThaiHenGio == 1? true: false
},
UrlHinh1 = hd.UrlHinh1,
UrlHinh2 = hd.UrlHinh2,
UrlHinh3 = hd.UrlHinh3,
TongSoTienLaiDaDong = hd.TienLaiDaDong
}).FirstOrDefault();
result.ThongTinDongLai = new ChoVayDNGD_ThongTinDongLaiModel();
result.ThongTinDongLai.DanhSachChiTietDongTienLai = (from dl in context.ThongTinDongLais
where dl.HopDong_Id == maHopDong
select new ChoVayDNGD_ThongTinChiTietDongTienLaiModel()
{
ID = dl.Id,
NgayBatDau = dl.NgayBatDau,
NgayKetThuc = dl.NgayKetThuc,
DaDong = dl.DaDong,
TienKhac = dl.TienKhac.HasValue ? dl.TienKhac.Value : 0,
TienLai = dl.TienLai,
SoNgay = dl.SoNgay,
SoTienDaDong = dl.SoTienDaDong
}).ToList();
}
return(result);
}
public static string Insert(HopDongChoVayDNGDDataModel model)
{
using (var context = new TIT_Entities())
{
var result = context.ThemHopDongDNGD(model.KhachHang.CMND, model.SoTienVay, model.HoaHong, model.Lai, model.ThoiHanVay,
model.NgayVay, model.GhiChu, model.CuaHang_Id, model.NhanVien_Id, DateTime.Now, model.NgayDongLaiCuoiCung, model.TinhTrang,
model.NgayBatDauThanhToan, DateTime.MinValue, "", 0, "", "", "", model.TongSoTienLaiDaDong, model.LaiThangDau, model.LaiGocMotThang);
return(result.ToString());
}
}
internal static int LayIdCuaHangTheoIdNhanVien(string idNhanVien)
{
int?result;
using (var context = new TIT_Entities())
{
result = (from user in context.AspNetUsers
where user.Id == idNhanVien
select user.CuaHang_Id).SingleOrDefault();
}
return(result.HasValue? result.Value : -1);
}
public static string LayIdNguoiQuanLyTheoIdNhanVien(string idNhanVien)
{
string result;
using (var context = new TIT_Entities())
{
result = (from user in context.AspNetUsers
where user.Id == idNhanVien
select user.ManagerId).SingleOrDefault();
}
return(result);
}
public static int LayCuaHangIdTheoIdNhanVien(string id_NhanVien)
{
int result = -1;
using (var context = new TIT_Entities())
{
result = (from nv in context.AspNetUsers
where nv.Id == id_NhanVien
select nv.CuaHang_Id).FirstOrDefault().Value;
}
return(result);
}
public static IEnumerable <NhanVienModel> LayDanhSachNhanVienTheoIDQuanLy(string idQuanLy)
{
IEnumerable <NhanVienModel> result;
using (var context = new TIT_Entities())
{
result = (from nv in context.AspNetUsers
where nv.ManagerId == idQuanLy
select new NhanVienModel()
{
MaNhanVien = nv.Id,
TenNhanVien = nv.FullName
}).ToArray();
}
return(result);
}
public static IEnumerable <NhanVienModel> LayDanhSachNhanVienTheoIdCuaHang(int idCuaHang)
{
IEnumerable <NhanVienModel> result;
using (var context = new TIT_Entities())
{
result = (from nv in context.AspNetUsers
where nv.CuaHang_Id == idCuaHang
select new NhanVienModel()
{
MaNhanVien = nv.Id,
TenNhanVien = nv.FullName
}).ToArray();
}
return(result);
}
public static BatHo_CapNhatThongTinDongTienViewModel LayThongTinDongTienHopDong(string maHopDong)
{
BatHo_CapNhatThongTinDongTienViewModel result = new BatHo_CapNhatThongTinDongTienViewModel();
using (var context = new TIT_Entities())
{
result.HopDongBatHo = (from hd in context.HD_BatHo
join kh in context.KhachHangs on hd.KhachHang_CMND equals kh.CMND
where hd.HD_BatHo_Id == maHopDong
select new HopDongBatHoDataModel()
{
HD_BatHo_Id = hd.HD_BatHo_Id,
GhiChu = hd.GhiChu,
KhachHang = new KhachHangModel()
{
TenKhachHang = kh.TenKhachHang,
CMND = kh.CMND,
DiaChi = kh.DiaChi != null ? kh.DiaChi : "",
HinhDaiDien = kh.HinhDaiDien != null ? kh.HinhDaiDien : "",
SoDienThoai = kh.SoDienThoai1
},
BatHo = hd.BatHo,
BocTrongVong = hd.BocTrongVong,
NgayBoc = hd.NgayBoc,
NgayDongTienCuoiCung = hd.NgayCuoiCungDongTien.HasValue? hd.NgayCuoiCungDongTien.Value: hd.NgayBoc,
NgayTao = hd.NgayTao,
NhanVien_Id = hd.NhanVien_Id,
SoNgayDongTien = hd.SoNgayDongTien,
ThuHoTruoc = hd.ThuHoTruoc,
CuaHang_Id = hd.CuaHang_Id,
TienDuaChoKhach = hd.TienDuaChoKhach,
TinhTrang = hd.TinhTrang
}).FirstOrDefault();
result.ThongTinDongLai = new BatHo_ThongTinDongLaiModel();
result.ThongTinDongLai.DanhSachChiTietDongTienLai = (from dl in context.ThongTinDongLais
where dl.HopDong_Id == maHopDong
select new BatHo_ThongTinChiTietDongTienLaiModel()
{
NgayHo = dl.NgayBatDau,
TienHo = dl.TienLai,
ID = dl.Id,
DaDong = dl.DaDong
}).ToList();
}
return(result);
}
public static void CapNhatBaoCao_Thu(TIT_Entities context, int MaCuaHang, decimal SoTien)
{
var BaoCaoTongKet = context.BaoCaoTongKets.Where(x => x.Id_CuaHang == MaCuaHang).OrderByDescending(p => p.Ngay).FirstOrDefault();
if (BaoCaoTongKet != null)
{
if (BaoCaoTongKet.Ngay == DateTime.Now.ToString("yyyy-MM-dd"))
{
BaoCaoTongKet.CamDo_Thu += SoTien;
}
else
{
var baoCao = new BaoCaoTongKetGiaoDichModel()
{
SoTienDauNgay = BaoCaoTongKet.SoTienDauNgay,
CamDo_Thu = BaoCaoTongKet.CamDo_Thu,
CamDo_Chi = BaoCaoTongKet.CamDo_Chi,
VayLai_Thu = BaoCaoTongKet.VayLai_Thu,
VayLai_Chi = BaoCaoTongKet.VayLai_Chi,
BatHo_Thu = BaoCaoTongKet.BatHo_Thu,
BatHo_Chi = BaoCaoTongKet.BatHo_Chi,
HoatDong_Thu = BaoCaoTongKet.HoatDong_Thu,
HoatDong_Chi = BaoCaoTongKet.HoatDong_Chi,
Ngay_ToString = BaoCaoTongKet.Ngay
};
var baoCaoHomNay = new BaoCaoTongKet()
{
Ngay = DateTime.Now.ToString("yyyy-MM-dd"),
SoTienDauNgay = baoCao.SoTienCuoiNgay,
CamDo_Thu = SoTien,
Id_CuaHang = MaCuaHang,
};
context.BaoCaoTongKets.Add(baoCaoHomNay);
}
}
else
{
var baoCaoHomNay = new BaoCaoTongKet()
{
Ngay = DateTime.Now.ToString("yyyy-MM-dd"),
CamDo_Thu = SoTien,
Id_CuaHang = MaCuaHang,
};
context.BaoCaoTongKets.Add(baoCaoHomNay);
}
}
public static IEnumerable <CuaHangDataModel> GetListViewCuaHangTheoAdmin()
{
IEnumerable <CuaHangDataModel> result;
using (var context = new TIT_Entities())
{
result = (from ch in context.CuaHangs
select new CuaHangDataModel()
{
MaCuaHang = ch.MaCuaHang,
TenCuaHang = ch.TenCuaHang,
QuyTienMat = ch.QuyTienMat.HasValue? ch.QuyTienMat.Value : 0,
VonDauTu = ch.VonDauTu.HasValue? ch.VonDauTu.Value: 0,
DiaChi = ch.DiaChi
}).ToArray();
}
return(result);
}
public static IEnumerable <AccountViewModel> GetList()
{
IEnumerable <AccountViewModel> result;
using (var context = new TIT_Entities())
{
result = (from user in context.AspNetUsers
join ur in context.AspNetUserRoles on user.Id equals ur.UserId
select new AccountViewModel()
{
Id = user.Id,
UserName = user.UserName,
FullName = user.FullName,
Email = user.Email,
UserRole = ur.AspNetRole.Name
}).ToArray();
}
return(result);
}
public static IEnumerable <UserWithRole> LayDanhSachBranchManager()
{
List <UserWithRole> result;
using (var context = new TIT_Entities())
{
result = (from user in context.AspNetUsers
join ur in context.AspNetUserRoles on user.Id equals ur.UserId
join role in context.AspNetRoles on ur.RoleId equals role.Id
where role.Name == "BranchManager"
select new UserWithRole()
{
UserId = user.Id,
RoleName = role.Name,
UserName = user.UserName
}).ToList();
}
return(result);
}
public static IEnumerable <CuaHangDataModel> GetListViewCuaHangTheoIdNhanVien(string maNhanVien)
{
IEnumerable <CuaHangDataModel> result;
using (var context = new TIT_Entities())
{
result = (from nv in context.AspNetUsers
join ch in context.CuaHangs on nv.CuaHang_Id equals ch.MaCuaHang
where nv.Id == maNhanVien
select new CuaHangDataModel()
{
MaCuaHang = ch.MaCuaHang,
TenCuaHang = ch.TenCuaHang,
QuyTienMat = ch.QuyTienMat.HasValue ? ch.QuyTienMat.Value : 0,
VonDauTu = ch.VonDauTu.HasValue ? ch.VonDauTu.Value : 0,
DiaChi = ch.DiaChi
}).ToArray();
}
return(result);
}
public static IEnumerable <CuaHangDataModel> GetListViewCuaHangTheoIdKeToan(string IdKeToan)
{
IEnumerable <CuaHangDataModel> result;
using (var context = new TIT_Entities())
{
result = (from ch in context.CuaHangs
join user in context.AspNetUsers on IdKeToan equals user.Id
where ch.QuanLyCuaHang == user.ManagerId
select new CuaHangDataModel()
{
MaCuaHang = ch.MaCuaHang,
TenCuaHang = ch.TenCuaHang,
QuyTienMat = ch.QuyTienMat.HasValue ? ch.QuyTienMat.Value : 0,
VonDauTu = ch.VonDauTu.HasValue ? ch.VonDauTu.Value : 0,
DiaChi = ch.DiaChi
}).ToArray();
}
return(result);
}
public static IEnumerable <NhanVienViewModel> GetListByManagerId(string managerId)
{
IEnumerable <NhanVienViewModel> result;
using (var context = new TIT_Entities())
{
result = (from user in context.AspNetUsers
join ch in context.CuaHangs on user.CuaHang_Id equals ch.MaCuaHang
where ch.QuanLyCuaHang == managerId
select new NhanVienViewModel()
{
Id = user.Id,
UserName = user.UserName,
FullName = user.FullName,
Email = user.Email,
TenCuaHang = ch.TenCuaHang
}).ToArray();
}
return(result);
}
internal IEnumerable <CamDoHistoryDataModel> GetHistoryViewModel(string id_HopDong)
{
IEnumerable <CamDoHistoryDataModel> result;
using (var context = new TIT_Entities())
{
result = (from hd in context.LichSuThaoTacs
join user in context.AspNetUsers on hd.Id_NhanVienThaoTac equals user.Id
where hd.Id_HopDong == id_HopDong
select new CamDoHistoryDataModel
{
Ngay = hd.NgayThaoTac,
GiaoDichVien = user.UserName,
SoTienGhiCo = hd.ThuTien == 1 ? hd.SoTien : 0,
SoTienGhiNo = hd.ThuTien == 0 ? hd.SoTien : 0,
NoiDung = hd.NoiDung
}).ToArray();
}
return(result);
}
public static int CapNhatCuaHangTheoAdmin(CuaHangUpdateModel model)
{
using (var context = new TIT_Entities())
{
//update
var item_update = context.CuaHangs.SingleOrDefault(x => x.MaCuaHang == model.MaCuaHang);
if (item_update != null)
{
item_update.DiaChi = model.DiaChi;
item_update.Latitude = model.Latitude;
item_update.Longitude = model.Longitude;
item_update.QuyTienMat = model.QuyTienMat;
item_update.TenCuaHang = model.TenCuaHang;
item_update.TinhTrang = model.TinhTrang ? 1 : 0;
item_update.VonDauTu = model.VonDauTu;
item_update.QuanLyCuaHang = model.QuanLyCuaHang;
try
{
if (context.SaveChanges() > 0)
{
return(1);
}
else
{
return(0);
}
}
catch (Exception ex)
{
ex.ToString();
//_logger.Error(ex.ToString());
return(0);
}
}
}
return(0);
}
public static IEnumerable <CuaHangGridViewModel> GetGridViewCuaHangTheoIdNhanVien(string MaNhanVien)
{
IEnumerable <CuaHangGridViewModel> result;
using (var context = new TIT_Entities())
{
result = (from nv in context.AspNetUsers
join ch in context.CuaHangs on nv.CuaHang_Id equals ch.MaCuaHang
where nv.Id == MaNhanVien
select new CuaHangGridViewModel()
{
MaCuaHang = ch.MaCuaHang,
TenCuaHang = ch.TenCuaHang,
DiaChi = ch.DiaChi,
DienThoai = "Không có",
NgayTao = ch.NgayTao,
NguoiTao = ch.NguoiTao,
QuyTienMat = ch.QuyTienMat.HasValue? ch.QuyTienMat.Value: 0,
VonDauTu = ch.VonDauTu.HasValue? ch.VonDauTu.Value: 0,
TinhTrang = ch.TinhTrang
}).ToArray();
}
return(result);
}
public static int CapNhatUrl(string idHopDong, string newPath, int STT)
{
using (var context = new TIT_Entities())
{
var hopdong = context.HD_VayDuNoGiamDan.Where(x => x.HD_Id == idHopDong).FirstOrDefault();
if (STT == 1)
{
hopdong.UrlHinh1 = newPath;
}
else if (STT == 2)
{
hopdong.UrlHinh2 = newPath;
}
else
{
hopdong.UrlHinh3 = newPath;
}
try
{
if (context.SaveChanges() > 0)
{
return(1);
}
else
{
return(0);
}
}
catch (Exception ex)
{
ex.ToString();
//_logger.Error(ex.ToString());
return(0);
}
}
}
