public int updateBaoCaoChiNhanh(BaoCaoQuanLyModel bccn)
{
var baocaochinhanh = db.BaoCaoChiNhanhs.Find(bccn.Id);
baocaochinhanh.GhiChu = bccn.GhiChu;
db.SaveChanges();
return(baocaochinhanh.MaBaoCao);
}
public int AddBaoCaoChiNhanh(BaoCaoQuanLyModel bccn, int?machinhanh)
{
var baocaochinhanh = new BaoCaoChiNhanh();
baocaochinhanh.MaChiNhanh = machinhanh;
DateTime now = DateTime.Now;
baocaochinhanh.NgayBaoCao = now;
baocaochinhanh.SoLuongBan = this.layTongSoLuong(now, machinhanh);
baocaochinhanh.DoanhThu = this.layDoanhThu(now, machinhanh);
baocaochinhanh.GhiChu = bccn.GhiChu;
db.BaoCaoChiNhanhs.Add(baocaochinhanh);
db.SaveChanges();
return(baocaochinhanh.MaBaoCao);
}
public JsonResult List(int?page)
{
var session_nhanvien = (DoAn.Common.Session.NhanVienSession)Session[DoAn.Common.Constants.NHANVIEN_SESSION];
var list = db.BaoCaoChiNhanhs.Where(x => x.MaChiNhanh == session_nhanvien.MaChiNhanh).OrderByDescending(x => x.MaBaoCao).ToList();
int pageSize = 10;
var data = new List <BaoCaoQuanLyModel>();
int i = 0;
foreach (var item in list)
{
i++;
var itemmodel = new BaoCaoQuanLyModel();
itemmodel.STT = i;
itemmodel.Id = item.MaBaoCao;
itemmodel.NgayBaoCaoShow = String.Format("{0:d/M/yyyy}", item.NgayBaoCao);
itemmodel.TongSoLuong = item.SoLuongBan;
itemmodel.DoanhThu = item.DoanhThu;
itemmodel.GhiChu = item.GhiChu;
data.Add(itemmodel);
}
if (page > 0)
{
page = page;
}
else
{
page = 1;
}
int start = (int)(page - 1) * pageSize;
ViewBag.pageCurrent = page;
int totalPage = data.Count();
float totalNumsize = (totalPage / (float)pageSize);
int numSize = (int)Math.Ceiling(totalNumsize);
ViewBag.numSize = numSize;
var datamodel = data.Skip(start).Take(pageSize);
return(Json(new { data = datamodel, pageCurrent = page, numSize = numSize }, JsonRequestBehavior.AllowGet));
}
public JsonResult Update(BaoCaoQuanLyModel baocaochinhanh)
{
return(Json(dao.updateBaoCaoChiNhanh(baocaochinhanh), JsonRequestBehavior.AllowGet));
}
public JsonResult Add(BaoCaoQuanLyModel baocaochinhanh)
{
var session = (DoAn.Common.Session.NhanVienSession)Session[DoAn.Common.Constants.NHANVIEN_SESSION];
return(Json(dao.AddBaoCaoChiNhanh(baocaochinhanh, session.MaChiNhanh), JsonRequestBehavior.AllowGet));
}
