public ActionResult Edit(int id, VeThang st) { var e = db.VeThangs.SingleOrDefault(x => x.MaVeThang == id); e.TenVeThang = st.TenVeThang; e.DonGia = st.DonGia; e.GhiChu = st.GhiChu; db.SaveChanges(); return(RedirectToAction("Index")); }
public HttpResponseMessage GetAll(HttpRequestMessage request, int page, int pageSize, string batDau, string ketThuc) { return(CreateHttpResponse(request, () => { try { HttpContext.Current.Session[CommonConstants.SessionSumThongKeGiaHan] = new SumThongKeGiaHan(); HttpContext.Current.Session[CommonConstants.SessionThongKeGiaHan] = new List <ThongKeGiaHanViewModel>(); List <long> lstLoaiGiaVe = new List <long>(); DateTime _batdau = Convert.ToDateTime(batDau); DateTime _ketthuc = Convert.ToDateTime(ketThuc); var resultGiaHan = _thongKeGiaHanService.GetAll(batDau, ketThuc); if (!resultGiaHan.IsSuccessStatusCode) { return request.CreateErrorResponse(resultGiaHan.StatusCode, resultGiaHan.Content.ReadAsStringAsync().Result); } var resultVeThang = _veThangService.GetAll(); if (!resultVeThang.IsSuccessStatusCode) { return request.CreateErrorResponse(resultVeThang.StatusCode, resultVeThang.Content.ReadAsStringAsync().Result); } var resultNhanVien = _appUser.GetAll(); if (!resultNhanVien.IsSuccessStatusCode) { return request.CreateErrorResponse(resultNhanVien.StatusCode, resultNhanVien.Content.ReadAsStringAsync().Result); } var lst_nhanvien = resultNhanVien.Content.ReadAsAsync <IEnumerable <ApplicationUserViewModel> >().Result.ToList(); List <VeThang> lst_vethang = resultVeThang.Content.ReadAsAsync <IEnumerable <VeThang> >().Result.ToList(); List <GiaHan> lst_giahan = resultGiaHan.Content.ReadAsAsync <IEnumerable <GiaHan> >().Result.ToList(); List <ThongKeGiaHanViewModel> listData = new List <ThongKeGiaHanViewModel>(); int i = 0; long _tongtien = 0; foreach (GiaHan _giahan in lst_giahan) { if (lst_vethang.Select(_vt => _vt.Id).Contains(_giahan.VeThangId.Value)) { VeThang _vethang = lst_vethang.Single(_vt => _vt.Id == _giahan.VeThangId); i++; var tkGiaHan = new ThongKeGiaHanViewModel(); tkGiaHan.STT = i; tkGiaHan.MaThe = _giahan.MaThe; tkGiaHan.BienSo = _giahan.BienSo; tkGiaHan.NgayGiaHan = _giahan.NgayGiaHan.Value.ToString("HH:mm dd/MM/yyyy"); tkGiaHan.GiaHanHoTen = _giahan.HoTen; tkGiaHan.VeThangHoTen = _vethang.HoTen; tkGiaHan.GiaVe = _giahan.GiaVe.Value.ToString("#,##"); _tongtien = _tongtien + _giahan.GiaVe.Value; if (!lstLoaiGiaVe.Contains(_giahan.GiaVe.Value)) { lstLoaiGiaVe.Add(_giahan.GiaVe.Value); } tkGiaHan.NgayHetHan = _vethang.NgayHetHan.Value.ToString("HH:mm dd/MM/yyyy"); tkGiaHan.NhanVien = string.IsNullOrEmpty(_giahan.NhanVienId) ? "Không đăng nhập" : lst_nhanvien.Where(_nv => _nv.Id == _giahan.NhanVienId).SingleOrDefault().FullName; listData.Add(tkGiaHan); } } long soLuotXe, tonTien; List <ListLoaiGiaVe> listLoaiGiaVe = new List <ListLoaiGiaVe>(); soLuotXe = i; foreach (long item in lstLoaiGiaVe) { var loaiGiaVe = new ListLoaiGiaVe(); loaiGiaVe.Name = " + " + lst_giahan.Where(_gh => _gh.GiaVe == item).Count() + " x " + item.ToString("#,## VNĐ"); loaiGiaVe.TongTien = (lst_giahan.Where(_gh => _gh.GiaVe == item).Count() * item).ToString("#,## VNĐ"); listLoaiGiaVe.Add(loaiGiaVe); } tonTien = _tongtien; int totalRow = listData.Count(); var query = listData.OrderBy(x => x.STT).Skip(page * pageSize).Take(pageSize); var sumTk = new SumThongKeGiaHan { SoLuotXe = soLuotXe.ToString("#,##"), ListLoaiGiaVe = listLoaiGiaVe, TongIien = tonTien.ToString("#,## VNĐ") }; PaginationSet <ThongKeGiaHanViewModel> pagedSet = new PaginationSet <ThongKeGiaHanViewModel>() { Page = page, TotalCount = totalRow, TotalPages = (int)Math.Ceiling((decimal)totalRow / pageSize), Items = query, SumThongKeGiaHan = sumTk }; HttpContext.Current.Session[CommonConstants.SessionSumThongKeGiaHan] = sumTk; HttpContext.Current.Session[CommonConstants.SessionThongKeGiaHan] = listData; var response = request.CreateResponse(HttpStatusCode.OK, pagedSet); return response; } catch (Exception ex) { return null; } })); }
public ActionResult Create(VeThang e) { db.VeThangs.Add(e); db.SaveChanges(); return(RedirectToAction("Index")); }