public List <ThongKe> listThongKe(int maDeThi)
{
List <ThongKe> lst = new List <ThongKe>();
var d = from p in db.De_Hs where p.Ma_Chu_De == maDeThi group p by p.Nguoi_Lam;
foreach (var item in d)
{
ThongKe obj = new ThongKe();
obj.userName = item.First().Nguoi_Lam;
obj.lop = item.First().TaiKoan_H.lop;
obj.SUM_TIME = int.Parse(item.First().DeThi.Thoi_Gian_Lam_Bai.ToString());
obj.THOI_GIAN_LAM = DateTime.Parse(item.First().Thoi_Gian.ToString());
int s = int.Parse(item.First().DeThi.SL_De.ToString()) + int.Parse(item.First().DeThi.SL_TrungBinh.ToString()) + int.Parse(item.First().DeThi.SL_Kho.ToString());
obj.SUM_CAUHOI = s;
var d1 = db.De_Hs.Where(p => p.Ma_Chu_De == maDeThi && p.Nguoi_Lam == item.First().Nguoi_Lam).ToList();
int i = 0;
foreach (var item1 in d1)
{
if (item1.Dap_An_HS.Equals(item1.Dap_An_Dung))
{
i++;
}
}
obj.SUM_DUNG = i;
lst.Add(obj);
}
return(lst);
}
// GET: Admin/ThongKeTinNhan
public ActionResult Index()
{
ThongKe thongKe = new ThongKe();
List <CTTinNhan> cTTinNhans = thongKe.ChiTietTinNhan(Convert.ToInt32(Session["admin"]));
return(View(cTTinNhans));
}
private void button6_Click(object sender, EventArgs e)
{
ThongKe thongKe = new ThongKe();
this.Hide();
thongKe.Show();
}
public ActionResult DonHang()
{
List <DONHANG> lstDonHangs = db.LayDSDonHangTheoLoai("DL");
ThongKe thongKe = new ThongKe(lstDonHangs);
return(View(thongKe));
}
public IActionResult Index()
{
ThongKeBanHang();
ViewData["DoanhThu"] = new ThongKe()
{
tanggiam = MonthSaleSort(sumsale, sumlastsale),
phantram = decimal.Parse(MonthSale(sumsale, sumlastsale).ToString("0.00")),
solieu = sumsale,
name = "Doanh thu",
donvi = "đ",
};
ViewData["DatHang"] = new ThongKe()
{
tanggiam = MonthSaleSort(countorder, countlastorder),
phantram = decimal.Parse(MonthSale(countorder, countlastorder).ToString("0.00")),
solieu = countorder,
name = "Đặt hàng",
donvi = "lượt",
};
ViewData["Tài khoản hiện có"] = new ThongKe()
{
solieu = countkhachhang,
name = "Tài khoản hiện có",
donvi = "tài khoản",
};
return(View());
}
public IHttpActionResult PutThongKe(int id, ThongKe thongKe)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != thongKe.id)
{
return(BadRequest());
}
db.Entry(thongKe).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ThongKeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult ThongKeKH(string KH_ID, DateTime dau, DateTime cuoi)
{
ViewBag.KH = db.KHACHHANGs.ToList();
laygiatritrongthang();
ViewBag.dauthang = dau;
ViewBag.cuoithang = cuoi;
List <ThongKe> list = new List <ThongKe>();
if (string.IsNullOrEmpty(KH_ID))
{
var TKKH = from kh in db.KHACHHANGs join dn in db.DONHANGs on kh.KH_ID equals dn.KH_ID select dn;
foreach (var i in TKKH)
{
if (list.FirstOrDefault(sp => sp.KH_ID == i.KH_ID) == null)
{
var count = (from kh in db.KHACHHANGs
join dn in db.DONHANGs on kh.KH_ID equals dn.KH_ID
join ctdn in db.CHITIETDONHANGs on dn.DN_ID equals ctdn.DN_ID
where dn.DN_NGALAPDON >= dau && dn.DN_NGALAPDON <= cuoi &&
kh.KH_ID == i.KH_ID
select ctdn);
ThongKe tk = new ThongKe()
{
KH_ID = i.KH_ID,
KH_TEN = i.KHACHHANG.KH_TEN,
TongTien = Convert.ToInt32(count.Sum(a => a.CHITIETSANPHAM.SANPHAM.GIASP.GIA_GIA))
};
list.Add(tk);
}
}
}
else
{
var TKKH = from kh in db.KHACHHANGs join dn in db.DONHANGs on kh.KH_ID equals dn.KH_ID where kh.KH_ID == KH_ID select dn;
foreach (var i in TKKH)
{
if (list.FirstOrDefault(sp => sp.KH_ID == i.KH_ID) == null)
{
var count = (from kh in db.KHACHHANGs
join dn in db.DONHANGs on kh.KH_ID equals dn.KH_ID
join ctdn in db.CHITIETDONHANGs on dn.DN_ID equals ctdn.DN_ID
where dn.DN_NGALAPDON >= dau && dn.DN_NGALAPDON <= cuoi &&
dn.KH_ID == KH_ID
select ctdn);
ThongKe tk = new ThongKe()
{
KH_ID = i.KH_ID,
KH_TEN = i.KHACHHANG.KH_TEN,
TongTien = Convert.ToInt32(count.Sum(a => a.CHITIETSANPHAM.SANPHAM.GIASP.GIA_GIA))
};
list.Add(tk);
}
}
}
return(View(list.OrderByDescending(sp => sp.TongTien).ToList()));
}
public ActionResult DeleteConfirmed(int id)
{
ThongKe thongKe = db.ThongKe.Find(id);
db.ThongKe.Remove(thongKe);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void btnThongKe_Click(object sender, EventArgs e)
{
panelContainer.Controls.Clear();
ThongKe uc = new ThongKe();
uc.Dock = DockStyle.Fill;
panelContainer.Controls.Add(uc);
}
private void dgPhieuThongKe_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (dgPhieuThongKe.SelectedItem != null)
{
thongKeSelect = new ThongKe();
thongKeSelect = CThongKe.find(dgPhieuThongKe.SelectedValue.ToString());
}
}
private void btnTrangChu_Click(object sender, EventArgs e)
{
this.pnlChucNang.Controls.Clear();
ThongKe FormThongKe = new ThongKe();
FormThongKe.TopLevel = false;
this.pnlChucNang.Controls.Add(FormThongKe);
FormThongKe.Show();
}
public static bool kiemTraThongTin(ThongKe thongKe)
{
if (thongKe.ngayLap.Value.ToString("dd/MM/yyyy") != DateTime.Now.ToString("dd/MM/yyyy"))
{
MessageBox.Show("Ngày lập phiếu thống kê phải là ngày hiện tại");
return(false);
}
return(true);
}
public ActionResult Edit([Bind(Include = "id,ten,diaChi,SDT,email,soLanMuaHang")] ThongKe thongKe)
{
if (ModelState.IsValid)
{
db.Entry(thongKe).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(thongKe));
}
public frmQuanLyChiTietThongKe(ThongKe thongKe = null)
{
InitializeComponent();
thongKeSelect = thongKe;
if (thongKeSelect != null)
{
hienThiThongKe(thongKeSelect);
}
}
private void barThongKe_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
ucTK = new ThongKe();
if (!pnmain.Controls.Contains(ucTK))
{
pnmain.Controls.Add(ucTK);
}
ucTK.Dock = DockStyle.Fill;
ucTK.BringToFront();
}
public IHttpActionResult GetThongKe(string value)
{
ThongKe thongKe = db.ThongKe.Where(p => p.SDT == value).FirstOrDefault();
if (thongKe == null)
{
return(NotFound());
}
return(Ok(thongKe));
}
private void LoadChart()
{
DataTable dt = ThongKe.LoadDuLieu();
chart1.DataSource = dt;
chart1.ChartAreas["ChartArea1"].AxisX.Title = "Tên Trang";
chart1.ChartAreas["ChartArea1"].AxisY.Title = "Số bài";
chart1.Series["Trang"].XValueMember = "NameRoot";
chart1.Series["Trang"].YValueMembers = "soluong";
}
public IHttpActionResult GetThongKe(int id)
{
ThongKe thongKe = db.ThongKe.Find(id);
if (thongKe == null)
{
return(NotFound());
}
return(Ok(thongKe));
}
public ActionResult Create([Bind(Include = "id,ten,diaChi,SDT,email,soLanMuaHang")] ThongKe thongKe)
{
if (ModelState.IsValid)
{
db.ThongKe.Add(thongKe);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(thongKe));
}
// GET: Admin/Home
public ActionResult Index()
{
ThongKe thongKe = new ThongKe();
XLThongKe xLThongKe = thongKe.XuLyThongKe(Convert.ToInt32(Session["admin"]));
Session["doanhsothang"] = xLThongKe.doanhsothang;
Session["doanhsonam"] = xLThongKe.doanhsonam;
Session["kyvong"] = xLThongKe.kyvong;
Session["tongtinnhan"] = xLThongKe.tinnhan;
return(View());
}
public bool UpdateTongSldTonKho(ThongKe tk)
{
bool isCheck = false;
var result = thongKeDAL.sp_UPDATE_TONKHO(tk.Sld, tk.MaSp);
if (result > 0)
{
isCheck = true;
}
return(isCheck);
}
public DataTable TongSoLuongTonTheoMaSp(ThongKe tk)
{
var result = thongKeDAL.sp_HienThiTongSltTheoMaSp(tk.MaSp);
DataTable table = new DataTable();
table.Columns.Add("TONGSLT", typeof(Int32));
foreach (sp_HienThiTongSltTheoMaSpResult sp in result)
{
table.Rows.Add(sp.TONGSLT);
}
return(table);
}
public DataTable TonSldhTheoMaSp(ThongKe tk)
{
var result = thongKeDAL.sp_ThongKeTongSoDoDhTheoMaSp(tk.MaSp);
DataTable table = new DataTable();
table.Columns.Add("SLDH", typeof(Int32));
foreach (sp_ThongKeTongSoDoDhTheoMaSpResult tong in result)
{
table.Rows.Add(tong.SLDH);
}
return(table);
}
public DataTable TongSldhTheoNgayDh(ThongKe tk)
{
var result = thongKeDAL.sp_TinhTongSlDonDhTheoNgayDatHang(tk.DateOne, tk.DateTwo);
DataTable table = new DataTable();
table.Columns.Add("SLDH", typeof(Int32));
foreach (sp_TinhTongSlDonDhTheoNgayDatHangResult dh in result)
{
table.Rows.Add(dh.SLDH);
}
return(table);
}
public DataTable TongSldhTheoNhaSx(ThongKe tk)
{
var result = thongKeDAL.sp_TinhTongSlDonDhTheoNhaSx(tk.TenSx);
DataTable table = new DataTable();
table.Columns.Add("SLDH", typeof(Int32));
foreach (sp_TinhTongSlDonDhTheoNhaSxResult dh in result)
{
table.Rows.Add(dh.SLDH);
}
return(table);
}
public IHttpActionResult PostThongKe(ThongKe thongKe)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.ThongKe.Add(thongKe);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = thongKe.id }, thongKe));
}
public List <ThongKe> ThongKeTonKhoTheoNgayThang(ThongKe tk)
{
var result = thongKeDAL.sp_ThongKeTonKhoTheoNgayThang(tk.DateOne, tk.DateTwo);
List <ThongKe> list = new List <ThongKe>();
foreach (sp_ThongKeTonKhoTheoNgayThangResult ds in result)
{
list.Add(new ThongKe {
MaSp = ds.MASP, TenSp = ds.TENSP, Sld = ds.TONGSLD, Sln = ds.TONGSLN, Slx = ds.TONGSLX, Slcl = ds.TONGSLT
});
}
return(list);
}
public List <ThongKe> ThongKePHieuXuatTHeoNhaSx(ThongKe tk)
{
var result = thongKeDAL.sp_ThongKePhieuXuatTtheoNhaSx(tk.TenSx);
List <ThongKe> list = new List <ThongKe>();
foreach (sp_ThongKePhieuXuatTtheoNhaSxResult tks in result)
{
list.Add(new ThongKe {
MaSp = tks.MASP, TenSp = tks.TENSP, TenLoai = tks.TENLOAI, TenSx = tks.TENSX, TenKh = tks.TENKH, Slx = tks.SLX, TongTien = tks.TongTien, PhanTram = tks.PHANTRAM, ThanhTien = tks.THANHTIEN
});
}
return(list);
}
public List <ThongKe> TinhTongThanhTienTheoNgayXuat(ThongKe tk)
{
var result = thongKeDAL.sp_TinhTongThanhTienPhieuXuatTheoNgayXuat(tk.DateOne, tk.DateTwo);
List <ThongKe> list = new List <ThongKe>();
foreach (sp_TinhTongThanhTienPhieuXuatTheoNgayXuatResult pn in result)
{
list.Add(new ThongKe {
ThanhTien = pn.Column1
});
}
return(list);
}
public List <ThongKe> TinhTongThanhTienTheoNhaSanXuat(ThongKe tk)
{
var result = thongKeDAL.sp_TinhhTongThanhTienPHieuXuatTheoNhaSx(tk.TenSx);
List <ThongKe> list = new List <ThongKe>();
foreach (sp_TinhhTongThanhTienPHieuXuatTheoNhaSxResult pn in result)
{
list.Add(new ThongKe {
ThanhTien = pn.Column1
});
}
return(list);
}
