public List <GiaBanViewModel> GetAllGiaBanToDataGridView()
{
var watch = System.Diagnostics.Stopwatch.StartNew();
var listGiaBan =
Queryable()
.Join(_unitOfWork.Repository <SanPham>().Queryable(), gb => gb.SanPhamId, sp => sp.Id,
(gb, sp) => new
{
gb.Id,
sp.TenSanPham,
gb.KhachHangId,
gb.Gia,
gb.NgayThayDoi
})
.Join(_unitOfWork.Repository <KhachHang>().Queryable(), gb => gb.KhachHangId, kh => kh.Id,
(gb, kh) => new GiaBanViewModel
{
Stt = gb.Id,
SanPham = gb.TenSanPham,
KhachHang = kh.HoTen,
Gia = gb.Gia,
NgayThayDoi = gb.NgayThayDoi
})
.ToList();
watch.Stop();
var elapsedMs = watch.ElapsedMilliseconds;
return(listGiaBan);
}
// GET: Products/Create
public ActionResult Create()
{
var categoryRepository = _unitOfWork.Repository <Category>();
ViewBag.CategoryId = new SelectList(categoryRepository.Queryable(), "Id", "Name");
return(View());
}
public ActionResult GetMessages()
{
var messageRepository = _unitOfWork.Repository <Message>();
var data = messageRepository.Queryable().ToList();
var rows = data.Select(n => new { Id = n.Id, From = n.From });
return(Json(rows, JsonRequestBehavior.AllowGet));
}
public ActionResult GetMenuItems()
{
var menuitemRepository = _unitOfWork.Repository <MenuItem>();
var data = menuitemRepository.Queryable().ToList();
var rows = data.Select(n => new { Id = n.Id, Title = n.Title });
return(Json(rows, JsonRequestBehavior.AllowGet));
}
// GET: Orders/Create
public ActionResult Create()
{
var productRepository = _unitOfWork.Repository <Product>();
ViewBag.ProductId = new SelectList(productRepository.Queryable(), "Id", "Name");
return(View());
}
public ActionResult GetCustomers()
{
var customerRepository = _unitOfWork.Repository <Customer>();
var data = customerRepository.Queryable().ToList();
var rows = data.Select(n => new { Id = n.Id, AccountNumber = n.AccountNumber });
return(Json(rows, JsonRequestBehavior.AllowGet));
}
public ActionResult GetOrders()
{
var orderRepository = _unitOfWork.Repository <Order>();
var data = orderRepository.Queryable().ToList();
var rows = data.Select(n => new { Id = n.Id, OrderKey = n.OrderKey });
return(Json(rows, JsonRequestBehavior.AllowGet));
}
public ActionResult GetProductionProcesses()
{
var productionprocessRepository = _unitOfWork.Repository <ProductionProcess>();
var data = productionprocessRepository.Queryable().ToList();
var rows = data.Select(n => new { Id = n.Id, Name = n.Name });
return(Json(rows, JsonRequestBehavior.AllowGet));
}
public ActionResult GetBaseCodes()
{
var basecodeRepository = _unitOfWork.Repository <BaseCode>();
var data = basecodeRepository.Queryable().ToList();
var rows = data.Select(n => new { Id = n.Id, CodeType = n.CodeType });
return(Json(rows, JsonRequestBehavior.AllowGet));
}
public ActionResult GetDepartments()
{
var departmentRepository = _unitOfWork.Repository <Department>();
var data = departmentRepository.Queryable().ToList();
var rows = data.Select(n => new { Id = n.Id, Name = n.Name });
return(Json(rows, JsonRequestBehavior.AllowGet));
}
//获取查询页面数据
public string GetData()
{
PageResponseModel model = new PageResponseModel();
var data = _unitOfWork.Repository <MemuInfor>().Query().Select().ToList();
model.count = data.Count();
model.data = data;
return(JsonConvert.SerializeObject(model));
}
// GET: RoleMenus/Create
public ActionResult Create()
{
RoleMenu roleMenu = new RoleMenu();
//set default value
var menuitemRepository = _unitOfWork.Repository <MenuItem>();
ViewBag.MenuId = new SelectList(menuitemRepository.Queryable(), "Id", "Title");
return(View(roleMenu));
}
// GET: Departments/Create
public ActionResult Create()
{
Department department = new Department();
//set default value
var companyRepository = _unitOfWork.Repository <Company>();
ViewBag.CompanyId = new SelectList(companyRepository.Queryable(), "Id", "Name");
return(View(department));
}
public PostController(IUnitOfWorkAsync unitOfWork,
IOptions <PagingOption> pagingOption,
IHubContext <PostMessageHub> postMessageHubContext)
{
_postRepo = unitOfWork.Repository <Models.Post>() as IEfRepositoryAsync <Models.Post>;
_postCommentRepo = unitOfWork.Repository <Models.PostComment>() as IEfRepositoryAsync <Models.PostComment>;
_clapRepo = unitOfWork.Repository <Models.Clap>() as IEfRepositoryAsync <Models.Clap>;
_pagingOption = pagingOption;
_postMessageHubContext = postMessageHubContext;
}
public void InsertTestClan()
{
var ninjaClanRepository = _unitOfWorkAsync.Repository <NinjaClan>();
var ninjaClan = ninjaClanRepository.Query().Select().ToList();
Assert.AreEqual(2, ninjaClan.Count);
Assert.AreEqual(1, ninjaClan.First().Ninjas.Count);
Assert.AreEqual(3, ninjaClan.First().Ninjas.First().EquipmentOwned.Count);
}
public List <ApplicationUser> UsersActiveGetAll()
{
return
(_unitOfWorkAsync.Repository <ApplicationUser>()
.Queryable()
.Where(u => u.Active)
.OrderBy(u => u.LastName)
.ThenBy(u => u.FirstName)
.ToList());
}
public async Task <CreateProjectResponse> Handle(CreateProjectRequest request,
CancellationToken cancellationToken)
{
var projectRepository = _uow.Repository <Domain.Project>();
var result = await projectRepository.AddAsync(Domain.Project.Load(request.Name));
return(new CreateProjectResponse {
Result = result.ToDto()
});
}
public TaskController(
IUnitOfWorkAsync unitOfWork,
IEfQueryRepository <Domain.Task> taskQuery,
IGetTasksService getTasksService,
IOptions <PaginationOption> paginationOption)
{
_taskRepository = unitOfWork.Repository <Domain.Task>() as IEfRepositoryAsync <Domain.Task>;
_taskQuery = taskQuery;
_getTasksService = getTasksService;
_paginationOption = paginationOption;
}
public ActionResult EditOrderDetail(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var orderdetailRepository = _unitOfWork.Repository <OrderDetail>();
var orderdetail = orderdetailRepository.Find(id);
var orderRepository = _unitOfWork.Repository <Order>();
var productRepository = _unitOfWork.Repository <Product>();
if (orderdetail == null)
{
ViewBag.OrderId = new SelectList(orderRepository.Queryable(), "Id", "Customer");
ViewBag.ProductId = new SelectList(productRepository.Queryable(), "Id", "Name");
//return HttpNotFound();
return(PartialView("_OrderDetailEditForm", new OrderDetail()));
}
else
{
ViewBag.OrderId = new SelectList(orderRepository.Queryable(), "Id", "Customer", orderdetail.OrderId);
ViewBag.ProductId = new SelectList(productRepository.Queryable(), "Id", "Name", orderdetail.ProductId);
}
return(PartialView("_OrderDetailEditForm", orderdetail));
}
// GET: MenuItems/Create
public ActionResult Create()
{
MenuItem menuItem = new MenuItem();
menuItem.IsEnabled = true;
//set default value
var menuitemRepository = _unitOfWork.Repository <MenuItem>();
ViewBag.ParentId = new SelectList(menuitemRepository.Queryable(), "Id", "Title");
return(View(menuItem));
}
protected void Page_Load(object sender, EventArgs e)
{
uow = new UnitOfWork(context);
repoUsers = uow.Repository<Users>();
IQueryable<Users> lst = from r in repoUsers.AsNoTracking()
where r.UserName == "sai"
select r;
foreach (Users user in lst)
{
}
}
public ActionResult EditProduct(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var productRepository = _unitOfWork.Repository <Product>();
var product = productRepository.Find(id);
var categoryRepository = _unitOfWork.Repository <Category>();
if (product == null)
{
ViewBag.CategoryId = new SelectList(categoryRepository.Queryable(), "Id", "Name");
//return HttpNotFound();
return(PartialView("_ProductEditForm", new Product()));
}
else
{
ViewBag.CategoryId = new SelectList(categoryRepository.Queryable(), "Id", "Name", product.CategoryId);
}
return(PartialView("_ProductEditForm", product));
}
public ActionResult EditCodeItem(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var codeitemRepository = _unitOfWork.Repository <CodeItem>();
var codeitem = codeitemRepository.Find(id);
var basecodeRepository = _unitOfWork.Repository <BaseCode>();
if (codeitem == null)
{
ViewBag.BaseCodeId = new SelectList(basecodeRepository.Queryable(), "Id", "CodeType");
//return HttpNotFound();
return(PartialView("_CodeItemEditForm", new CodeItem()));
}
else
{
ViewBag.BaseCodeId = new SelectList(basecodeRepository.Queryable(), "Id", "CodeType", codeitem.BaseCodeId);
}
return(PartialView("_CodeItemEditForm", codeitem));
}
public List <HoaDonViewModel> GetAllHoaDonToDataGridView()
{
var listHoaDon =
Queryable()
.Join(_unitOfWork.Repository <KhachHang>().Queryable(), hd => hd.KhachHangId, kh => kh.Id,
(hd, kh) => new HoaDonViewModel
{
Id = hd.Id,
KhachHang = kh.HoTen,
TongTien = hd.TongTien,
NgayLap = hd.NgayLap
})
.ToList();
return(listHoaDon);
}
public void update(dto_User user)
{
this.BeginTransaction(System.Data.IsolationLevel.ReadCommitted);
var _userRepo = _uow.Repository <tbl_User>();
var _user = _userRepo.Select(c => c.ID == user.ID, c => c.OrderByDescending(x => x.ID), null, 1, 1).FirstOrDefault();
var dbuser = Mapper.Map(user, _user);
_userRepo.Update(dbuser, new List <System.Linq.Expressions.Expression <Func <tbl_User, object> > >()
{
x => x.Password
});
_uow.SaveChanges();
this.Commit();
}
public ActionResult EditDepartment(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var departmentRepository = _unitOfWork.Repository <Department>();
var department = departmentRepository.Find(id);
var companyRepository = _unitOfWork.Repository <Company>();
if (department == null)
{
ViewBag.CompanyId = new SelectList(companyRepository.Queryable(), "Id", "Name");
//return HttpNotFound();
return(PartialView("_DepartmentEditForm", new Department()));
}
else
{
ViewBag.CompanyId = new SelectList(companyRepository.Queryable(), "Id", "Name", department.CompanyId);
}
return(PartialView("_DepartmentEditForm", department));
}
public IRepository <T> GetRepository <T>() where T : class, IObjectState
{
return(_unitOfWork.Repository <T>());
}
public virtual IRepository <T> GetRepository <T>() where T : class, IAggregateRoot, IObjectState => UnitOfWorkAsync.Repository <T>();
public IRepository <T> GetRepository <T>() where T : class, ITrackable
{
return(_unitOfWork.Repository <T>());
}
public IRepository <T> GetRepository <T>() where T : class, IObservableEntity, new()
{
return(_unitOfWork.Repository <T>());
}
public virtual IRepository <T> GetRepository <T>() where T : class, IAggregateRoot, IObjectState
{
return(_unitOfWork.Repository <T>());
}
