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"));
}
