/// <summary> /// Xóa doanh số /// </summary> /// <param name="id"></param> /// <returns></returns> public JsonResult XoaDoanhSo(int?id) { DoanhSoService services = new DoanhSoService(); var data = services.Delete(id); return(Json(new { data }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// Lưu doanh số /// </summary> /// <param name="doanhso"></param> /// <returns></returns> public JsonResult LuuThongTin(tbl_Doanh_so doanhso) { DoanhSoService services = new DoanhSoService(); var data = services.InsertOrUpdate(doanhso); return(Json(new { data = data != null }, JsonRequestBehavior.AllowGet)); }
public JsonResult GetDataChartByCus(string ngay, string ten) { DoanhSoService services = new DoanhSoService(); string[] dsngay = ngay.Replace(" ", "").Split('-'); var list = (dsngay != null && dsngay.Length == 2) ? services.DanhSachDoanhSoTongHop(ToDate(dsngay[0]), ToDate(dsngay[1]), ten) : services.DanhSachDoanhSoTongHop(null, null, ten); return(Json(new { doanhso = list.ToList() }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// View Thông tin doanh số /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult _ThongTinDoanhSo(int?id) { tbl_Doanh_so _ds = new tbl_Doanh_so(); DoanhSoService _service = new DoanhSoService(); if (id != null) { _ds = _service.ThongTinDoanhSo((int)id); } return(PartialView(_ds)); }
/// <summary> /// Lấy dữ liệu chart theo ngày /// </summary> /// <param name="ngay"></param> /// <param name="ten"></param> /// <returns></returns> public JsonResult GetDataChartByTime(string ngay, string ten) { DoanhSoService services = new DoanhSoService(); string[] dsngay = ngay.Replace(" ", "").Split('-'); List <tbl_Doanh_so> dsDoanhSo = new List <tbl_Doanh_so>(); for (DateTime dt = ToDate(dsngay[0]).Date; dt.Date <= ToDate(dsngay[1]).Date; dt = dt.AddDays(1)) { var list = services.DanhSachDoanhSoTheoNgay(dt, ten).ToList(); tbl_Doanh_so dSo = new tbl_Doanh_so(); dSo.doanh_so = (list != null && list.Count > 0) ? list.Sum(x => x.doanh_so == null ? 0 : (decimal)x.doanh_so) : 0; dSo.ngay_ct = dt; dsDoanhSo.Add(dSo); } return(Json(new { doanhso = dsDoanhSo }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// Danh sách dữ liệu doanh số /// </summary> /// <param name="request"></param> /// <param name="ngay"></param> /// <param name="ten"></param> /// <returns></returns> public JsonResult _DanhSachDoanhSo(IDataTablesRequest request, string ngay, string ten) { var xeploai = request.Start / request.Length + 1; DoanhSoService service = new DoanhSoService(); string[] dsngay = ngay.Replace(" ", "").Split('-'); var list = (dsngay != null && dsngay.Length == 2) ? service.GetDataDoanhSo(request, ToDate(dsngay[0]), ToDate(dsngay[1]), ten) : service.GetDataDoanhSo(request, null, null, ten); var ds = list.ToPagedList(xeploai, request.Length); return(Json(new { draw = request.Draw, data = ds.Select(a => new { a.id, a.ngay_ct, a.ten_kh, a.doanh_so }).ToList(), recordsTotal = ds.TotalItemCount, recordsFiltered = ds.TotalItemCount }, JsonRequestBehavior.AllowGet)); }