public ActionResult Create([Bind(Include = "Id,Nome,Id_Estado")] CidadeViewModel cidadeViewModel) { if (ModelState.IsValid) { using (UnitOfWork.UnitOfWork uow = new UnitOfWork.UnitOfWork()) { try { Cidade cidade = new Cidade(); cidade = Mapper.Map <Cidade>(cidadeViewModel); cidade.Id = Guid.NewGuid(); cidade.TimesTamp = DateTime.Now; uow.CidadeRepositorio.Adcionar(cidade); uow.Commit(); TempData["mensagem"] = string.Format("Registro Cadastrado com Sucesso!"); return(RedirectToAction("Index")); } catch (Exception ex) { TempData["mensagem"] = string.Format("Não Foi Possivel Gravar o Registro!\n {0}", ex.Message); return(View()); } finally { uow.Dispose(); } } } return(View(cidadeViewModel)); }
public ActionResult Edit([Bind(Include = "Id,Nome,Id_Estado")] CidadeViewModel cidadeViewModel) { if (ModelState.IsValid) { using (UnitOfWork.UnitOfWork uow = new UnitOfWork.UnitOfWork()) { try { Cidade cidade = new Cidade(); cidade = Mapper.Map <Cidade>(cidadeViewModel); cidade.TimesTamp = DateTime.Now; uow.CidadeRepositorio.Atualizar(cidade); uow.Commit(); TempData["mensagem"] = string.Format("Registro Alterado Com Sucesso!"); return(RedirectToAction("Index")); } catch (Exception ex) { TempData["mensagem"] = string.Format("Ocorreu ao Alterar o Registro!\n {0}", ex.Message); return(RedirectToAction("Index")); } finally { uow.Dispose(); } } } return(View(cidadeViewModel)); }
// GET: CidadeViewModels/Edit/5 public ActionResult Edit(Guid?id) { CidadeViewModel cidadeViewModel = null; if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } using (UnitOfWork.UnitOfWork uow = new UnitOfWork.UnitOfWork()) { try { cidadeViewModel = Mapper.Map <CidadeViewModel>(uow.CidadeRepositorio.Get(x => x.Id == id)); List <EstadoViewModel> lista = Mapper.Map <List <EstadoViewModel> >(uow.EstadoRepositorio.GetTudo().ToList()); ViewBag.EstadoLista = lista; return(View(cidadeViewModel)); } catch (Exception ex) { TempData["mensagem"] = string.Format("Ocorreu um erro!\n {0}", ex.Message); if (cidadeViewModel == null) { return(HttpNotFound()); } return(View(cidadeViewModel)); } finally { uow.Dispose(); } } }
public Van DeMap(VanDTO dto) { Van entity = repo.GetByID(dto.Id); UoW = new UnitOfWork.UnitOfWork(); if (entity == null) { return new Van() { TrainId = dto.TrainId, Number = dto.Number, ClassPropereties = UoW.ClassPropereties.GetByID(dto.ClassProperetiesId), ClassProperetiesId = dto.ClassProperetiesId, Id = dto.Id, } } ; entity.TrainId = dto.TrainId; entity.Number = dto.Number; entity.ClassPropereties = UoW.ClassPropereties.GetByID(dto.ClassProperetiesId); entity.ClassProperetiesId = dto.ClassProperetiesId; entity.Id = dto.Id; return(entity); }
public void AddNewPayroll(int employeeId, decimal philhealth, decimal sss, decimal pagibig, decimal grosspay) { decimal netPayComputation = grosspay - (philhealth + sss + pagibig); try { using (var uow = new UnitOfWork.UnitOfWork()) { var viewmodel = new PayrollViewModel() { EmployeeId = employeeId, GrossPay = grosspay, PagIbig = pagibig, SSS = sss, PhilHealth = philhealth, NetPay = netPayComputation }; uow.Payroll.AddNewPayroll(viewmodel); uow.SaveChanges(); } } catch (FieldAccessException ex) { } catch (EncoderFallbackException ex) { //todo: add logger here... } catch (Exception ex) { //todo: add logger here... } }
public List <DocumentAnalyticEntity> GetDocAnalytics() { List <DocumentAnalyticEntity> lstDocumentsEL = new List <DocumentAnalyticEntity>(); try { using (uow = new UnitOfWork.UnitOfWork()) { lstDocumentsEL = uow.DocumentAnalyticRepository.Get().Select(p => new DocumentAnalyticEntity { AnalyticsID = p.AnalyticsID, Browser = p.Browser, Date = p.Date, DocumentName = p.DocumentName, IPAddress = p.IPAddress, OS = p.OS, Platform = p.Platform, Username = p.Username }).OrderByDescending(x => x.AnalyticsID).ToList(); } } catch (Exception ex) { } return(lstDocumentsEL); }
/// <summary> /// Metodo responsavel por gerar o contas a receber do funcionario /// </summary> /// <remarks> /// Autor: Luiz Fernando /// Data: 29/04/2019 /// </remarks> /// <param name="pedido">Recebe o pedido e gera o financeiro do mesmo</param> /// <returns>true se deu certo e false caso tenha dado algum erro</returns> /// public bool GerarContasReceber(Pedido pedido) { bool retorno = false; try { using (UnitOfWork.UnitOfWork uow = new UnitOfWork.UnitOfWork()) { //recupero o id do fornecedor Guid idFornecedor = uow.CardapiorRepositorio.Get(x => x.Id == pedido.Id_Cardapio).Id_Fornecedor; ContasReceber contasReceber = new ContasReceber { Id = Guid.NewGuid(), Emissao = DateTime.Now, Id_Pedido = pedido.Id, Id_Fornecedor = idFornecedor, Id_Usuario = pedido.Id_Usuario, Quitado = false, ValorPago = 0, Valor = pedido.Total }; uow.ContasReceberRepositorio.Adcionar(contasReceber); uow.Commit(); retorno = true; return(retorno); } } catch (Exception ex) { retorno = false; return(retorno); } }
public void AppClassMark(ClassMarkViewModel model) { using (UnitOfWork.UnitOfWork uow = new UnitOfWork.UnitOfWork()) { var mark = new ClassMark { Student_No = model.Student_No, Student_name = model.Student_name, ClassGroupe_id = model.ClassGroupe_id, Subject1 = model.Subject1, Subject2 = model.Subject2, mark = model.mark, mark12 = model.mark12, mark21 = model.mark21, mark23 = model.mark32, mark32 = model.mark32, Subject3 = model.Subject3, Subject4 = model.Subject4, Subject5 = model.Subject5, }; uow.Repository <ClassMark>().Insert(mark); uow.Save(); } }
public List <UserEL> GetQuotedStoresForCustomer(int userID) { List <UserEL> lstReciepts = new List <UserEL>(); try { using (uow = new UnitOfWork.UnitOfWork()) { lstReciepts = uow.RecieptRepository.Get().Join(uow.RecieptOrderRepository.Get(), rec => rec.RecieptID, use => use.RecieptID, (rec, use) => new { rec, use }) .Join(uow.StoreUserRepository.Get(), str => str.use.ReceiverStoreID, sre => sre.StoreUserID, (str, sre) => new { str, sre }) .Where(sp => sp.str.use.SenderStoreID == userID && sp.str.rec.Status == ((int)ReceiptStatus.Quoted).ToString() && sp.str.use.Subtotal != null).OrderByDescending(y => y.str.use.OrderTime) .Select(lst => new UserEL { StoreName = lst.sre.StoreName, DeviceID = lst.sre.DeviceID, DeviceType = lst.sre.DeviceType, Email = lst.sre.Email, Active = lst.sre.Active, StoreUserID = lst.sre.StoreUserID, Address = lst.sre.Address, Username = lst.sre.Username }).ToList(); return(lstReciepts); } } catch { } return(lstReciepts); }
public List <RecieptEL> GetQuotedRecieptsForCustomer(int userID) { List <RecieptEL> lstReciepts = new List <RecieptEL>(); try { using (uow = new UnitOfWork.UnitOfWork()) { lstReciepts = uow.RecieptRepository.Get() .Where(sp => sp.Status == ((int)ReceiptStatus.Quoted).ToString() && sp.StoreID == userID).OrderByDescending(y => y.CreatedOn) .Select(lst => new RecieptEL { Name = lst.Name, CreatedOn = lst.CreatedOn, RecieptID = lst.RecieptID, StoreID = lst.StoreID, Status = lst.Status, Price = lst.Price }).ToList(); return(lstReciepts); } } catch { } return(lstReciepts); }
/// <summary> /// Отключение от базы данных. /// </summary> /// <param name="message">Сообщение с ошибкой.</param> /// <returns>Произошло лиуспешное отключение.</returns> public bool Disconnect(out string message) { lock (Locker) { message = string.Empty; if (!IsConnected) { message = "Подключение к базе данных отсутствует."; return(true); } try { _unitOfWork = null; } catch (Exception ex) { IsConnected = true; message = $"Ошибка во время отлючения от базы данных. {Methods.CalcMessageException(ex)}"; return(false); } IsConnected = false; return(true); } }
/// <summary> /// Sorgu nesnesini ilişkileriyle, filtrelenmiş ve sıralanmış olarak oluşturur. /// </summary> /// <param name="uow">Açılmış olan veritabanı bağlantısı</param> /// <param name="additionalExpression">Ek filtre sorgusu yazılması gerekiyorsa yazılmalıdır.</param> /// <returns></returns> public IQueryable <T> GetQueryObject(UnitOfWork.UnitOfWork <D> uow, List <string> includePaths, Expression <Func <T, bool> > additionalExpression = null) { IQueryable <T> queryObject = uow.GetRepository <T>().GetAll(GetExpression()).Include(includePaths); if (additionalExpression != null) { queryObject = queryObject.Where(additionalExpression); } if (Sort != null) { IOrderedQueryable <T> orderedQueryable = (IOrderedQueryable <T>)queryObject; for (int i = 0; i < Sort.Count; i++) { orderedQueryable = i == 0 ? GetOrderQueryable(queryObject, Sort[i]) : GetOrderQueryable(orderedQueryable, Sort[i]); } queryObject = orderedQueryable; } if (TakeCount > 0) { queryObject = queryObject.Take(SkipCount + TakeCount); } if (SkipCount > 0) { queryObject = queryObject.Skip(SkipCount); } return(queryObject); }
public bool UpdateProductAvailabilityPrice(ProductEL productEL) { bool isProductAvailabilityUpdated = false; try { Product product = new Product(); using (uow = new UnitOfWork.UnitOfWork()) { product = uow.ProductRepository.GetById(productEL.ProductID); product.IsAvailable = productEL.IsAvailable; product.Price = productEL.Price; uow.ProductRepository.Update(product); uow.Save(); isProductAvailabilityUpdated = true; } } catch { isProductAvailabilityUpdated = false; } return(isProductAvailabilityUpdated); }
// GET: PedidoViewModels/Create public ActionResult Create() { using (UnitOfWork.UnitOfWork uow = new UnitOfWork.UnitOfWork()) { try { IEnumerable <CardapioViewModel> lista = Mapper.Map <IEnumerable <CardapioViewModel> >(uow.CardapiorRepositorio.GetTudo()); List <CardapioViewModel> valorFormatado = new List <CardapioViewModel>(); foreach (var item in lista) { var descricaoItens = uow.ItensCardapioRepositorio.GetTudo(x => x.Id_Cardapio == item.Id); string aux = ""; foreach (var nome in descricaoItens) { aux += nome.Produto.Descricao + " | "; } var valor = uow.ItensCardapioRepositorio.GetTudo(x => x.Id_Cardapio == item.Id).Sum(x => x.Produto.Preco); item.Descricao = item.Descricao.Trim() + " | " + aux + "R$ " + valor; valorFormatado.Add(item); } ViewBag.CardapioLista = valorFormatado; return(View()); } catch (Exception ex) { ModelState.AddModelError("", string.Format("Ocorreu um Erro na Busca dos Cardapios:\n {0}", ex.Message)); return(View()); } finally { uow.Dispose(); } } }
public UsersEL GetCustomerByID(string id) { UsersEL userEl = new UsersEL(); try { using (uow = new UnitOfWork.UnitOfWork()) { User user = uow.UserRepository.Get().Where(x => x.UserID == Convert.ToInt32(id)).FirstOrDefault(); userEl.Active = user.Active; userEl.Address = user.Address; userEl.City = user.City; userEl.Country = user.Country; userEl.CreatedDate = user.CreatedDate; userEl.Email = user.Email; userEl.Name = user.Name; userEl.PhoneNo = user.PhoneNo; userEl.State = user.State; userEl.Zipcode = user.Zipcode; userEl.Username = user.Username; userEl.UserID = user.UserID; userEl.Password = user.Password; userEl.DeviceType = user.DeviceType; userEl.PushToken = user.PushToken; } } catch (Exception ex) { } return(userEl); }
public List <UsersEL> GetAllCustomers() { List <UsersEL> lstUsersEL = new List <UsersEL>(); try { using (uow = new UnitOfWork.UnitOfWork()) { List <User> lstUsers = uow.UserRepository.Get().Where(x => x.UserRoleID == 2).ToList(); foreach (User user in lstUsers) { UsersEL userEl = new UsersEL(); userEl.Active = user.Active; userEl.Address = user.Address; userEl.City = user.City; userEl.Country = user.Country; userEl.CreatedDate = user.CreatedDate; userEl.Email = user.Email; userEl.Name = user.Name; userEl.PhoneNo = user.PhoneNo; userEl.State = user.State; userEl.Zipcode = user.Zipcode; userEl.Username = user.Username; userEl.UserID = user.UserID; userEl.UsDot = user.USDot; lstUsersEL.Add(userEl); } } } catch (Exception ex) { } return(lstUsersEL); }
public List <StaffViewModel> GetAllStaff() { using (var uow = new UnitOfWork.UnitOfWork()) { return (uow.Repository <Staff>().GetAll() .Select( x => new StaffViewModel() { Stuff_Number = x.Stuff_Number, FirstName = x.FirstName, LastName = x.LastName, Registration_Date = x.Registration_Date, Gender = x.Gender, ContactNumber = x.ContactNumber, Email = x.Email, Password = x.Password, AddPhoto = x.AddPhoto, IdentityNumber = x.IdentityNumber, Role = x.Role, }) .ToList()); } }
public List <DocumentEL> GetUserDocuments(string id) { List <DocumentEL> lstDocumentEL = new List <DocumentEL>(); try { using (uow = new UnitOfWork.UnitOfWork()) { lstDocumentEL = uow.UserDocumentRepository.Get().Join(uow.DocumentMasterRepository.Get(), ud => ud.DocID, dm => dm.DocumentID, (ud, dm) => new { ud, dm }).Where(x => x.ud.UserID == Convert.ToInt32(id)) .Select(po => new DocumentEL { DocumentID = (int)po.ud.DocID, DocumentName = po.dm.DocumentName, DocumentPath = po.ud.UploadPath, UserID = (int)po.ud.UserID, DocumentTypeID = po.ud.UserDocID, }).ToList(); //foreach (UserDocument doc in lstDocs) //{ // DocumentEL docEl = new DocumentEL(); // docEl.DocumentID = Convert.ToInt32(doc.DocID); // docEl.DocumentPath = doc.UploadPath; // lstDocumentEL.Add(docEl); //} } } catch (Exception ex) { } return(lstDocumentEL); }
public ActionResult Delete(Guid?id) { UsuarioViewModel usuarioViewModel = null; if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } using (UnitOfWork.UnitOfWork uow = new UnitOfWork.UnitOfWork()) { try { usuarioViewModel = Mapper.Map <UsuarioViewModel>(uow.UsuarioRepositorio.Get(x => x.Id == id)); return(View(usuarioViewModel)); } catch (Exception ex) { TempData["mensagem"] = string.Format("Ocorreu um erro!\n {0}", ex.Message); if (usuarioViewModel == null) { return(HttpNotFound()); } return(View(usuarioViewModel)); } finally { uow.Dispose(); } } }
public DocumentMaster AddDocumentType(DocumentEL document) { DocumentMaster newDoc = new DocumentMaster(); using (TransactionScope transactionScope = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions { IsolationLevel = IsolationLevel.ReadCommitted })) { try { if (document != null) { using (uow = new UnitOfWork.UnitOfWork()) { #region Add New Document newDoc.Description = document.Description; newDoc.DocumentName = document.DocumentTypeName; uow.DocumentMasterRepository.Insert(newDoc); uow.Save(); #endregion transactionScope.Complete(); } } } catch (Exception ex) { transactionScope.Dispose(); } return(newDoc); } }
public ActionResult Register(UsuarioViewModel usuarioViewModel) { if (ModelState.IsValid) { try { using (UnitOfWork.UnitOfWork uow = new UnitOfWork.UnitOfWork()) { Usuario usuario = new Usuario(); usuarioViewModel.Id = Guid.NewGuid(); usuario = Mapper.Map <Usuario>(usuarioViewModel); usuario.Senha = Criptografia.Encrypt(usuario.Senha); uow.UsuarioRepositorio.Adcionar(usuario); uow.Commit(); TempData["mensagem"] = string.Format("Registro Cadastrado com Sucesso!"); return(RedirectToAction("Index", "Home", null)); } } catch (Exception ex) { ModelState.AddModelError("", string.Format("Registro Falhou\n {0}", ex.Message)); } } return(View(usuarioViewModel)); }
// GET: PaisViewModels/Edit/5 public ActionResult Edit(Guid?id) { UsuarioViewModel usuarioViewModel = null; if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } using (UnitOfWork.UnitOfWork uow = new UnitOfWork.UnitOfWork()) { try { usuarioViewModel = Mapper.Map <UsuarioViewModel>(uow.UsuarioRepositorio.Get(x => x.Id == id)); return(View(usuarioViewModel)); } catch (Exception ex) { if (usuarioViewModel == null) { return(HttpNotFound()); } ModelState.AddModelError("", string.Format("Ocorreu um Erro {0}", ex.Message)); return(View()); } } }
public ActionResult Edit([Bind(Include = "Id,Nome,Login,Email,Senha,Adm,")] UsuarioViewModel usuarioViewModel) { if (ModelState.IsValid) { using (UnitOfWork.UnitOfWork uow = new UnitOfWork.UnitOfWork()) { try { Usuario usuario = new Usuario(); usuario = Mapper.Map <Usuario>(usuarioViewModel); usuario.Senha = Criptografia.Encrypt(usuario.Senha); uow.UsuarioRepositorio.Atualizar(usuario); uow.Commit(); TempData["mensagem"] = string.Format("Registro Alterado Com Sucesso!"); return(RedirectToAction("Index")); } catch (Exception ex) { TempData["mensagem"] = string.Format("Ocorreu ao Alterar o Registro!\n {0}", ex.Message); return(RedirectToAction("Index")); } finally { uow.Dispose(); } } } return(View(usuarioViewModel)); }
public void Logout(string userID) { try { if (userID != null) { using (uow = new UnitOfWork.UnitOfWork()) { // If token exists then delete existing token AuthenticationToken existingToken = uow.AuthenticationTokenRepository.Get(). Where(auth => auth.FkUserID.Equals(userID)) .FirstOrDefault(); if (existingToken != null) { // Delete token uow.AuthenticationTokenRepository.Delete(existingToken); uow.Save(); } } } } catch (Exception ex) { } }
public List <ProductEL> GetProductsByReciept(int recieptID) { List <ProductEL> lstProducts = new List <ProductEL>(); try { using (uow = new UnitOfWork.UnitOfWork()) { lstProducts = uow.ProductRepository.Get().Join(uow.RecieptRepository.Get(), pro => pro.RecieptID, rec => rec.RecieptID, (pro, rec) => new { pro, rec }) .Where(sp => sp.pro.RecieptID == recieptID).Select(lst => new ProductEL { Name = lst.pro.Name, AddedOn = lst.pro.AddedOn, RecieptID = lst.pro.RecieptID, ProductID = lst.pro.ProductID, Quantity = lst.pro.Quantity, UpdatedOn = lst.pro.UpdatedOn }).ToList(); return(lstProducts); } } catch { } return(lstProducts); }
public List <DocumentEL> GetAllDocumentType() { List <DocumentEL> lstDocumentEL = new List <DocumentEL>(); try { using (uow = new UnitOfWork.UnitOfWork()) { List <DocumentMaster> lstDocs = uow.DocumentMasterRepository.Get().OrderBy(x => x.DocumentID).ToList(); foreach (DocumentMaster doc in lstDocs) { DocumentEL docEl = new DocumentEL(); docEl.DocumentTypeName = doc.DocumentName; docEl.Description = doc.Description; docEl.DocumentTypeID = doc.DocumentID; docEl.DocumentID = doc.DocumentID; lstDocumentEL.Add(docEl); } } } catch (Exception ex) { } return(lstDocumentEL); }
/// <summary> /// Подключение к базе данных. /// </summary> /// <param name="message">Сообщение с ошибкой.</param> /// <returns>Произошло ли успешное подключение.</returns> public bool Connect(out string message) { lock (Locker) { message = string.Empty; if (IsConnected) { message = "Уже существует подключение к базе данных."; return(true); } try { _unitOfWork = new UnitOfWork.UnitOfWork(); } catch (Exception ex) { IsConnected = false; message = $"Ошибка во время подключения к базе данных. {Methods.CalcMessageException(ex)}"; return(false); } IsConnected = true; return(true); } }
public List <RecieptEL> GetRecieptsByUserID(int userID) { List <RecieptEL> lstReciepts = new List <RecieptEL>(); try { using (uow = new UnitOfWork.UnitOfWork()) { lstReciepts = uow.RecieptRepository.Get().Join(uow.StoreUserRepository.Get(), rec => rec.StoreID, use => use.StoreUserID, (rec, use) => new { rec, use }) .Where(sp => sp.rec.StoreID == userID).Select(lst => new RecieptEL { Name = lst.rec.Name, CreatedOn = lst.rec.CreatedOn, RecieptID = lst.rec.RecieptID, StoreID = lst.rec.StoreID }).ToList(); return(lstReciepts); } } catch { } return(lstReciepts); }
public bool AddDocument(DocumentEL document) { bool isInserted = false; UserDocument newDoc = new UserDocument(); using (TransactionScope transactionScope = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions { IsolationLevel = IsolationLevel.ReadCommitted })) { try { if (document != null) { using (uow = new UnitOfWork.UnitOfWork()) { #region Add New Document newDoc.DocID = document.DocumentID; newDoc.UserID = document.UserID; newDoc.UploadPath = document.DocumentPath; uow.UserDocumentRepository.Insert(newDoc); uow.Save(); #endregion transactionScope.Complete(); isInserted = true; } } } catch (Exception ex) { transactionScope.Dispose(); } return(isInserted); } }
public Ticket DeMap(TicketDTO dto) { Ticket entity = repo.GetByID(dto.Id); UoW = new UnitOfWork.UnitOfWork(); if (entity == null) { return new Ticket() { Id = dto.Id, Price = dto.Price, PassangerId = dto.PassangerId, VanId = dto.VanId, TrainId = dto.TrainId, SeatId = dto.SeatId } } ; entity.Id = dto.Id; entity.Price = dto.Price; entity.PassangerId = dto.PassangerId; entity.VanId = dto.VanId; entity.TrainId = dto.TrainId; entity.SeatId = dto.SeatId; return(entity); }
public SearchService() { unitOfWork = new UnitOfWork.UnitOfWork(); }
public FeedBackController() { IUnitOfWork unitOfWork = new UnitOfWork.UnitOfWork(); _exceptionResponsitory = new LogExceptionResponsitory(unitOfWork); _feedResponsitory = new FeedBackResponsitory(unitOfWork); }
public PageDefaultController() { IUnitOfWork unitOfWork = new UnitOfWork.UnitOfWork(); _pageDefaultResponsitory = new PageDefaultResponsitory(unitOfWork); _logException = new LogExceptionController(); }
public BookServices() { uow = new UnitOfWork.UnitOfWork("default"); }
public PostController() { IUnitOfWork unitOfWork = new UnitOfWork.UnitOfWork(); _exceptionController = new LogExceptionController(); _postResponsitory = new PostResponsitory(unitOfWork); }
/// <summary> /// Public Constructor,initializes privately declared local variables. /// </summary> /// <param name="context"></param> public ProductRepository() { _unitOfWork = new UnitOfWork.UnitOfWork(); }
public UserService() { unitOfWork = new UnitOfWork.UnitOfWork(); imageService = new ImageService(); }
public AbstractService(string currentUserId) { this.currentUserId = currentUserId; unitOfWork = new UnitOfWork.UnitOfWork(); }
public MedalService() { unitOfWork = new UnitOfWork.UnitOfWork(); }