public FrmKiemKho(PhongTap phong = null)
{
InitializeComponent();
phongHienTai = phong != null ? phong : Login1.GetPhongHienTai();
dataGridView1.AutoGenerateColumns = false;
loc();
}
internal static List<GoiTap> GetByPhong(PhongTap phongTap, int type)
{
using (var db = DBContext.GetContext()) {
return db.GoiTap.Include(p => p.PhongTap).
Where(p => p.PhongTap.MaPhongTap == phongTap.MaPhongTap && p.Type == type).ToList();
}
}
internal static List<KhachLe> ThongKe(DateTime start, DateTime end, PhongTap phong, Models.NhanVien nhanVienHienTai, int mode)
{
using (var db = DBContext.GetContext())
{
var ks = db.KhachLe.Include(k => k.NhanVien).Include(k=>k.NhanVien.PhongTap).Where(k => k.ThoiGian >= start
&&
k.ThoiGian <= end);
if (phong.MaPhongTap != -1) {
ks = ks.Where(p => p.NhanVien.PhongTap.MaPhongTap == phong.MaPhongTap);
}
if (nhanVienHienTai.MaNhanVien != -1)
{
ks = ks.Where(h => h.NhanVien.MaNhanVien == nhanVienHienTai.MaNhanVien);
}
switch (mode)
{
case 1:
ks = ks.Where(k => k.IsGYM);
break;
case 2:
ks = ks.Where(k => !k.IsGYM);
break;
}
ks = ks.OrderByDescending(d => d.ThoiGian);
return ks.ToList();
}
}
public FrmHangBanDuoc(NhanVien nhanVien = null, bool isNhap = false)
{
InitializeComponent();
nhanVienHienTai = nhanVien;
//pnGrid.Dock = DockStyle.Fill;
for (int i = 2010; i < 2250; i++)
{
cbbTheoThangNam.Items.Add(i);
}
IsNhap = isNhap;
cbbTheoThangNam.SelectedIndex
= cbbTheoThangThang.SelectedIndex = 0;
phongHienTai = Login1.GetPhongHienTai();
DataFiller.fillNhanVienCombo(cbbNhanVien, phongHienTai.MaPhongTap, append: true);
DataFiller.fillPhongCombo(cbbPhong, append: true);
cbbPhong.SelectedValue = phongHienTai.MaPhongTap;
cbbPhong.Enabled = cbbNhanVien.Enabled = nhanVien == null;
//loadData();
loc();
if (IsNhap)
{
lblTitle.Text = "Thống kê nhập hàng";
pnTongTien.Visible = false;
}
if (nhanVien != null)
{
cbbNhanVien.Enabled = false;
cbbNhanVien.SelectedValue = nhanVien.MaNhanVien;
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
dxErrorProvider1.ClearErrors();
if (txtTenPhong.Text == "")
{
dxErrorProvider1.SetIconAlignment(txtTenPhong, ErrorIconAlignment.MiddleRight);
dxErrorProvider1.SetError(txtTenPhong, "Tên phòng không được trống");
txtTenPhong.Focus();
return;
}
if (txtDiaChi.Text == "")
{
dxErrorProvider1.SetIconAlignment(txtDiaChi, ErrorIconAlignment.MiddleRight);
dxErrorProvider1.SetError(txtDiaChi, "Địa chỉ không được trống");
txtDiaChi.Focus();
return;
}
var tenMoi = txtTenPhong.Text.Trim();
var dcMoi = txtDiaChi.Text.Trim();
if (current == null)
{
current = new PhongTap()
{
TenPhongTap = tenMoi,
DiaChi = dcMoi
};
if (PhongTapController.Add(current) == CODE_RESULT_RETURN.ThanhCong)
{
DialogResult = DialogResult.OK;
Close();
}
else
{
MessageBox.Show("Có lỗi khi thêm");
}
}
else
{
current.TenPhongTap = tenMoi;
current.DiaChi = dcMoi;
if (PhongTapController.Update(current) == CODE_RESULT_RETURN.ThanhCong)
{
DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("Có lỗi khi cập nhật");
Close();
}
}
}
public FrmPhongTapEdit(PhongTap p = null)
{
InitializeComponent();
current = p;
if (current != null)
{
btnOK.Text = "Cập nhật";
Text = "Chỉnh sửa phòng tập";
txtDiaChi.Text = current.DiaChi;
txtTenPhong.Text = current.TenPhongTap;
}
}
void loc()
{
try
{
phongHienTai = (PhongTap)cbbPhong.SelectedItem;
}
catch
{
}
var maPhong = phongHienTai != null ? phongHienTai.MaPhongTap : -1;
try
{
DateTime start = new DateTime(), end = new DateTime();
if (rdTheoThang.Checked)
{
int month = int.Parse(cbbTheoThangThang.Text.ToString());
int year = int.Parse(cbbTheoThangNam.Text.ToString());
start = new DateTime(year, month, 1);
end = start.AddMonths(1).AddDays(-1);
}
else if (rdTheoQuy.Checked)
{
int year = int.Parse(cbbTheoQuyNam.Text);
switch (cbbTheoQuyQuy.SelectedIndex)
{
case 0:
start = new DateTime(year, 1, 1);
end = new DateTime(year, 3, 31);
break;
case 1:
start = new DateTime(year, 4, 1);
end = new DateTime(year, 6, 30);
break;
case 2:
start = new DateTime(year, 7, 1);
end = new DateTime(year, 9, 30);
break;
case 3:
start = new DateTime(year, 10, 1);
end = new DateTime(year, 12, 31);
break;
}
}
else if (rdTheoKhoangNgay.Checked)
{
start = dtpFrom.Value;
end = dtpTo.Value;
}
List<ThongKeSoLuongModel> tks = SanPhamController.ThongKeSoLuong();
dataGridView1.DataSource = tks;
}
catch { }
}
public static bool IsKhongRangBuoc(PhongTap g)
{
using (var db = DBContext.GetContext())
{
var goiTap = db.GoiTap.Include(p => p.PhongTap).FirstOrDefault(p => p.PhongTap.MaPhongTap == g.MaPhongTap);
if (goiTap != null)
return false;
var nhanVien = db.NhanVien.Include(p => p.PhongTap).FirstOrDefault(p => p.PhongTap.MaPhongTap == g.MaPhongTap);
if (nhanVien != null)
return false;
var hoiVien = db.HoiVien.Include(p => p.PhongTap).FirstOrDefault(p => p.PhongTap.MaPhongTap == g.MaPhongTap);
if (hoiVien != null)
return false;
var sp = db.SanPham.Include(p => p.PhongTap).FirstOrDefault(p => p.PhongTap.MaPhongTap == g.MaPhongTap);
if (sp != null)
return false;
return true;
}
}
internal static CODE_RESULT_RETURN Add(PhongTap nv)
{
using (var context = DBContext.GetContext())
{
try
{
var n1 = context.PhongTap.FirstOrDefault(n => n.MaPhongTap == nv.MaPhongTap);
if (n1 == null)
{
context.PhongTap.Add(nv);
context.SaveChanges();
return CODE_RESULT_RETURN.ThanhCong;
}
return CODE_RESULT_RETURN.MaTrung;
}
catch
{
return CODE_RESULT_RETURN.ThatBai;
}
}
}
public FrmLichSuPhieuThu(NhanVien nhanVienTruyenVao = null)
{
InitializeComponent();
nhanVienHienTai = nhanVienTruyenVao;
dataGridView1.AutoGenerateColumns = false;
for (int i = 2010; i < 2250; i++)
{
cbbTheoThangNam.Items.Add(i);
cbbTheoThangNam.SelectedIndex = 0;
}
cbbTheoThangThang.SelectedIndex = 0;
phongHienTai = Login1.GetPhongHienTai();
DataFiller.fillPhongCombo(cbbPhong, append:true);
if (nhanVienTruyenVao != null) {
cbbNhanVien.SelectedValue = nhanVienTruyenVao.MaNhanVien;
cbbNhanVien.Enabled = cbbPhong.Enabled = false;
}
//loadData();
loc();
// loadEnable();
}
internal static CODE_RESULT_RETURN Update(PhongTap hv)
{
using (var db = DBContext.GetContext())
{
var hvc = db.PhongTap.FirstOrDefault(h => h.MaPhongTap == hv.MaPhongTap);
if (hvc != null)
{
hvc.DiaChi = hv.DiaChi;
hvc.TenPhongTap = hv.TenPhongTap;
db.SaveChanges();
return CODE_RESULT_RETURN.ThanhCong;
}
return CODE_RESULT_RETURN.ThatBai;
}
}
void loc()
{
//var maPhong =Convert.ToInt32( cbbPhong.SelectedItem);
try
{
phongHienTai = (PhongTap)cbbPhong.SelectedItem;
}
catch { }
allPhieuThu = PhieuThuController.GetList(phongHienTai.MaPhongTap, nhanVienHienTai);
try
{
DateTime start = new DateTime(), end = new DateTime();
if (rdTheoThang.Checked)
{
int month = int.Parse(cbbTheoThangThang.Text.ToString());
int year = int.Parse(cbbTheoThangNam.Text.ToString());
start = new DateTime(year, month, 1);
end = start.AddMonths(1).AddDays(-1);
}
else if (rdTheoKhoangNgay.Checked)
{
start =DateTimeUtil.StartOfDay( dtpFrom.Value);
end = DateTimeUtil.EndOfDay( dtpTo.Value);
}
List<PhieuThu> li = new List<PhieuThu>();
li = allPhieuThu.Where(h => h.NgayLap.CompareTo(start) >= 0 && h.NgayLap.CompareTo(end) <= 0).ToList();
dataGridView1.DataSource = li;
lblTongTien.Text = li.Sum(c => c.TienSauGiam).ToString().FormatCurrency()+" đ";
}
catch { }
}
internal static List<HoiVien> GetDangKyNhanhTrongNgay(PhongTap p)
{
var dauNgay = DateTimeUtil.StartOfDay(DateTime.Now);
var cuoiNgay = DateTimeUtil.EndOfDay(DateTime.Now);
using (var db = DBContext.GetContext())
{
var hs =db.HoiVien.Include(h=>h.PhongTap).Include(h=>h.DanhSachPhieuThu).Where(h=>
//h.IsDangKyNhanh
//&&
h.PhongTap.MaPhongTap == p.MaPhongTap
&&
h.NgayGioDangKy >= dauNgay && h.NgayGioDangKy <=cuoiNgay).OrderByDescending(d=>d.NgayGioDangKy).ToList();
return hs;
}
}
//internal static List<ThongKeSanPhamModel> ThongKeMuaVaoBanRa(DateTime start, DateTime end, int maPhong = -1, NhanVien nhanVienHienTai = null) {
// List<ThongKeSanPhamModel> li = new List<ThongKeSanPhamModel>();
// using (var db = DBContext.GetContext())
// {
// var tatCaNhanVien = db.NhanVien;
// // foreach (var nv in tatCaNhanVien) {
// var kq = from nv in db.NhanVien
// group nv by nv.MaNhanVien into groupNV
// select new {
// groupNV.ToList()
// };
// // }
// foreach (var t in kq) {
// ThongKeSanPhamModel model = new ThongKeSanPhamModel() {
// NhanVien = t.
// };
// }
// }
//}
internal static List<GymFitnessOlympic.View.ActForm.FrmKiemKho.ThongKeSoLuongModel> ThongKeSoLuong(PhongTap phong)
{
List<GymFitnessOlympic.View.ActForm.FrmKiemKho.ThongKeSoLuongModel> li = new List<GymFitnessOlympic.View.ActForm.FrmKiemKho.ThongKeSoLuongModel>();
using (var db = DBContext.GetContext())
{
var hh = db.SanPham.ToList();
var allChiTiet = db.ChiTietHoaDon.Include(c => c.HoaDon).Select(c => c.SanPham);
foreach (var sp in hh)
{
GymFitnessOlympic.View.ActForm.FrmKiemKho.ThongKeSoLuongModel model = new GymFitnessOlympic.View.ActForm.FrmKiemKho.ThongKeSoLuongModel();
model.SanPham = sp;
model.SoBan = db.ChiTietHoaDon.Where(c => !c.HoaDon.IsNhap && c.SanPham.MaSanPham == sp.MaSanPham).ToList().Sum(c => c.SoLuong);
model.TienBan = db.ChiTietHoaDon.Where(c => !c.HoaDon.IsNhap && c.SanPham.MaSanPham == sp.MaSanPham).ToList().Sum(c => c.SoLuong * c.Gia);
model.SoNhap = db.ChiTietHoaDon.Where(c => c.HoaDon.IsNhap && c.SanPham.MaSanPham == sp.MaSanPham).ToList().Sum(c => c.SoLuong);
model.TienNhap = db.ChiTietHoaDon.Where(c => c.HoaDon.IsNhap && c.SanPham.MaSanPham == sp.MaSanPham).ToList().Sum(c => c.SoLuong * c.Gia);
li.Add(model);
}
return li;
}
}
void loc()
{
//var maPhong =Convert.ToInt32( cbbPhong.SelectedItem);
try
{
phongHienTai = (PhongTap)cbbPhong.SelectedItem;
}
catch
{
}
var maPhong = phongHienTai != null ? phongHienTai.MaPhongTap : -1;
//allHoaDon = HoaDonController.GetList(phongHienTai.MaPhongTap, nhanVienHienTai);
try
{
DateTime start = new DateTime(), end = new DateTime();
if (rdTheoThang.Checked)
{
int month = int.Parse(cbbTheoThangThang.Text.ToString());
int year = int.Parse(cbbTheoThangNam.Text.ToString());
start = new DateTime(year, month, 1);
end = start.AddMonths(1).AddDays(-1);
}
else if (rdTheoKhoangNgay.Checked)
{
start = DateTimeUtil.StartOfDay(dtpFrom.Value);
end = DateTimeUtil.EndOfDay(dtpTo.Value);
}
//List<HoaDon> li = new List<HoaDon>();
//li = allPhieuThu.Where(h => h.NgayLap.CompareTo(start) >= 0 && h.NgayLap.CompareTo(end) <= 0).ToList();
allThongKe = SanPhamController.ThongKeMuaVaoBanRa(start, end, maPhong, nhanVienHienTai, IsNhap);
lblTongTien.Text = allThongKe.Sum(c => c.TongTien).ToString().FormatCurrency();
pnGrid.Controls.Clear();
if (IsNhap)
{
var grid = new UcGridHangNhap();
grid.Dock = DockStyle.Fill;
pnGrid.Controls.Add(grid);
grid.dataGridView1.DataSource = allThongKe;
}
else
{
var grid = new UcGridHangBan();
grid.Dock = DockStyle.Fill;
pnGrid.Controls.Add(grid);
grid.dataGridView1.DataSource = allThongKe;
}
}
catch { }
}
