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();
                }
            }
        }
Example #4
0
        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);
        }
Example #5
0
        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...
            }
        }
Example #6
0
        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);
            }
        }
Example #8
0
        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);
        }
Example #11
0
        /// <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);
            }
        }
Example #12
0
        /// <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);
        }
Example #13
0
        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);
        }
Example #14
0
 // 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();
         }
     }
 }
Example #15
0
        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);
        }
Example #16
0
        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);
        }
Example #17
0
 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));
 }
Example #24
0
        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)
            {
            }
        }
Example #25
0
        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);
        }
Example #27
0
        /// <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);
        }
Example #31
0
 public SearchService()
 {
     unitOfWork = new UnitOfWork.UnitOfWork();
 }
Example #32
0
 public FeedBackController()
 {
     IUnitOfWork unitOfWork = new UnitOfWork.UnitOfWork();
     _exceptionResponsitory = new LogExceptionResponsitory(unitOfWork);
     _feedResponsitory = new FeedBackResponsitory(unitOfWork);
 }
Example #33
0
 public PageDefaultController()
 {
     IUnitOfWork unitOfWork = new UnitOfWork.UnitOfWork();
     _pageDefaultResponsitory = new PageDefaultResponsitory(unitOfWork);
     _logException = new LogExceptionController();
 }
Example #34
0
 public BookServices()
 {
     uow = new UnitOfWork.UnitOfWork("default");
 }
Example #35
0
 public PostController()
 {
     IUnitOfWork unitOfWork = new UnitOfWork.UnitOfWork();
     _exceptionController = new LogExceptionController();
     _postResponsitory = new PostResponsitory(unitOfWork);
 }
Example #36
0
 /// <summary>
 /// Public Constructor,initializes privately declared local variables.
 /// </summary>
 /// <param name="context"></param>
 public ProductRepository()
 {
     _unitOfWork = new UnitOfWork.UnitOfWork();
 }
Example #37
0
 public UserService()
 {
     unitOfWork = new UnitOfWork.UnitOfWork();
     imageService = new ImageService();
 }
Example #38
0
 public AbstractService(string currentUserId)
 {
     this.currentUserId = currentUserId;
     unitOfWork = new UnitOfWork.UnitOfWork();
 }
Example #39
0
 public MedalService()
 {
     unitOfWork = new UnitOfWork.UnitOfWork();
 }