Exemplo n.º 1
0
 public IList <Operatie> GetAllOperations()
 {
     try
     {
         _operatieRead = new ReadOperatieRepository(context);
         return(_operatieRead.GetAll().ToList());
     }
     catch (Exception e)
     {
         var message = DbEntityCustomException.BuildMessageExceptions(e);
         throw new DbEntityCustomException(message);
     }
 }
Exemplo n.º 2
0
 /// <inheritdoc />
 /// <summary>
 /// Gets the client autos.
 /// </summary>
 /// <param name="clientId">The client identifier.</param>
 /// <returns>IList&lt;Auto&gt;.</returns>
 /// <exception cref="NotImplementedException"></exception>
 public IList <Auto> GetClientAutos(int clientId)
 {
     try
     {
         _autoRead = new ReadAutoRepository(_context);
         return(_autoRead.GetAutoByClient(clientId));
     }
     catch (Exception e)
     {
         var message = DbEntityCustomException.BuildMessageExceptions(e);
         throw new DbEntityCustomException(message);
     }
 }
Exemplo n.º 3
0
 public IList <Comanda> GetAllDoneOrders()
 {
     try
     {
         _comandaRead = new ReadComandaRepository(context);
         return(_comandaRead.GetAll().Where(comanda => comanda.StareComanda == StareComanda.Executata).ToList());
     }
     catch (Exception e)
     {
         var message = DbEntityCustomException.BuildMessageExceptions(e);
         throw new DbEntityCustomException(message);
     }
 }
Exemplo n.º 4
0
 /// <inheritdoc />
 /// <summary>
 /// Gets all detaliu comenzii.
 /// </summary>
 /// <returns>IList&lt;DetaliuComanda&gt;.</returns>
 /// <exception cref="DbEntityCustomException"></exception>
 public IList <DetaliuComanda> GetAllDetaliuComandas()
 {
     try
     {
         _detaliuComandaRead = new ReadDetaliuComandaRepository(context);
         return(_detaliuComandaRead.GetAll().ToList());
     }
     catch (Exception e)
     {
         var message = DbEntityCustomException.BuildMessageExceptions(e);
         throw new DbEntityCustomException(message);
     }
 }
Exemplo n.º 5
0
 /// <inheritdoc />
 /// <summary>
 /// Gets all mecanics.
 /// </summary>
 /// <returns>IList&lt;Mecanic&gt;.</returns>
 /// <exception cref="DbEntityCustomException"></exception>
 public IList <Mecanic> GetAllMecanics()
 {
     try
     {
         _mecanicRead = new ReadMecanicRepository(context);
         return(_mecanicRead.GetAll().ToList());
     }
     catch (Exception e)
     {
         var message = DbEntityCustomException.BuildMessageExceptions(e);
         throw new DbEntityCustomException(message);
     }
 }
Exemplo n.º 6
0
 public IList <Material> GetAvailabelMaterials()
 {
     try
     {
         _materialRead = new ReadMaterialRepository(context);
         return(_materialRead.GetAvailables());
     }
     catch (Exception e)
     {
         var message = DbEntityCustomException.BuildMessageExceptions(e);
         throw new DbEntityCustomException(message);
     }
 }
Exemplo n.º 7
0
 public int GetOperationsTotalTime()
 {
     try
     {
         _operatieRead = new ReadOperatieRepository(context);
         var response = _operatieRead.GetAll().Where(operatie => operatie.TimpExecutie.HasValue).ToList();
         return(Decimal.ToInt32((decimal)response.Sum(operatie => operatie.TimpExecutie)));
     }
     catch (Exception e)
     {
         var message = DbEntityCustomException.BuildMessageExceptions(e);
         throw new DbEntityCustomException(message);
     }
 }
Exemplo n.º 8
0
        /// <inheritdoc />
        /// <summary>
        /// Creates the material.
        /// </summary>
        /// <param name="material">The material.</param>
        /// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns>
        public bool CreateMaterial(Material material)
        {
            try
            {
                _materialWrite = new WriteMaterialRepository(_context);

                _materialWrite.Create(material);
                _context.SaveChanges();
                return(true);
            }
            catch (Exception e)
            {
                var message = DbEntityCustomException.BuildMessageExceptions(e);
                throw new DbEntityCustomException(message);
            }
        }
Exemplo n.º 9
0
        /// <inheritdoc />
        /// <summary>
        /// Creates the automatic.
        /// </summary>
        /// <param name="auto">The automatic.</param>
        /// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns>
        public bool CreateAuto(Auto auto)
        {
            try
            {
                _autoWrite = new WriteAutoRepository(_context);

                _autoWrite.Create(auto);
                _context.SaveChanges();
                return(true);
            }
            catch (Exception e)
            {
                var message = DbEntityCustomException.BuildMessageExceptions(e);
                throw new DbEntityCustomException(message);
            }
        }
Exemplo n.º 10
0
        /// <inheritdoc />
        /// <summary>
        /// Creates the client.
        /// </summary>
        /// <param name="client">The client.</param>
        /// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns>
        public bool CreateClient(Client client)
        {
            try
            {
                _clientWrite = new WriteClientRepository(_context);

                _clientWrite.Create(client);
                _context.SaveChanges();
                return(true);
            }
            catch (Exception e)
            {
                var message = DbEntityCustomException.BuildMessageExceptions(e);
                throw new DbEntityCustomException(message);
            }
        }
Exemplo n.º 11
0
        /// <inheritdoc />
        /// <summary>
        /// Creates the mecanic.
        /// </summary>
        /// <param name="mecanic">The mecanic.</param>
        /// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns>
        public bool CreateMecanic(Mecanic mecanic)
        {
            try
            {
                _mecanicWrite = new WriteMecanicRepository(_context);

                _mecanicWrite.Create(mecanic);
                _context.SaveChanges();
                return(true);
            }
            catch (Exception e)
            {
                var message = DbEntityCustomException.BuildMessageExceptions(e);
                throw new DbEntityCustomException(message);
            }
        }
Exemplo n.º 12
0
        /// <inheritdoc />
        /// <summary>
        /// Creates the operatie.
        /// </summary>
        /// <param name="operatie">The operatie.</param>
        /// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns>
        public bool CreateOperatie(Operatie operatie)
        {
            try
            {
                _operatieWrite = new WriteOperatieRepository(_context);

                _operatieWrite.Create(operatie);
                _context.SaveChanges();
                return(true);
            }
            catch (Exception e)
            {
                var message = DbEntityCustomException.BuildMessageExceptions(e);
                throw new DbEntityCustomException(message);
            }
        }
Exemplo n.º 13
0
        /// <inheritdoc />
        /// <summary>
        /// Creates the imagine.
        /// </summary>
        /// <param name="imagine">The imagine.</param>
        /// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns>
        public bool CreateImagine(Imagine imagine)
        {
            try
            {
                _imagineWrite = new WriteImagineRepository(_context);

                _imagineWrite.Create(imagine);
                _context.SaveChanges();
                return(true);
            }
            catch (Exception e)
            {
                var message = DbEntityCustomException.BuildMessageExceptions(e);
                throw new DbEntityCustomException(message);
            }
        }
Exemplo n.º 14
0
        /// <inheritdoc />
        /// <summary>
        /// Creates the detaliu comanda.
        /// </summary>
        /// <param name="detaliuComanda">The detaliu comanda.</param>
        /// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns>
        public bool CreateDetaliuComanda(DetaliuComanda detaliuComanda)
        {
            try
            {
                _detaliuComandaWrite = new WriteDetaliuComandaRepository(_context);

                _detaliuComandaWrite.Create(detaliuComanda);
                _context.SaveChanges();
                return(true);
            }
            catch (Exception e)
            {
                var message = DbEntityCustomException.BuildMessageExceptions(e);
                throw new DbEntityCustomException(message);
            }
        }
Exemplo n.º 15
0
        public void DeleteAllEntitiesOnTable(string tableName)
        {
            string databaseName = context.Database.Connection.Database;
            var    count        = context.Database.SqlQuery <int>($"SELECT COUNT(*) FROM [{databaseName}].[dbo].[{tableName}]");

            if (count.Any() && count.First() > 0)
            {
                try
                {
                    var setResponse = $"Deleted {count.First()} items from {tableName}";
                    context.Database.ExecuteSqlCommand($"DELETE FROM {tableName}");
                    Logger.Log.Handle(LogLevel.Info, setResponse);
                }
                catch (Exception e)
                {
                    var message = DbEntityCustomException.BuildMessageExceptions(e);
                    throw new DbEntityCustomException(message);
                }
            }
        }
Exemplo n.º 16
0
        /// <inheritdoc />
        /// <summary>
        /// Adds the mecanics.
        /// </summary>
        /// <param name="selectedMecanics">The selected mecanics.</param>
        /// <param name="detaliuComanda">The detaliu comanda.</param>
        /// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns>
        /// <exception cref="DbEntityCustomException"></exception>
        public bool AddMecanics(List <Mecanic> selectedMecanics, DetaliuComanda detaliuComanda)
        {
            try
            {
                _detaliuComandaWrite = new WriteDetaliuComandaRepository(context);
                foreach (var selectedMecanic in selectedMecanics)
                {
                    detaliuComanda.Mecanici.Add(selectedMecanic);
                }
                _detaliuComandaWrite.Update(detaliuComanda);

                context.SaveChanges();
                return(true);
            }
            catch (Exception e)
            {
                var message = DbEntityCustomException.BuildMessageExceptions(e);
                throw new DbEntityCustomException(message);
            }
        }
Exemplo n.º 17
0
        /// <inheritdoc />
        /// <summary>
        /// Adds the operatie.
        /// </summary>
        /// <param name="operatie">The operatie.</param>
        /// <param name="detaliuComanda">The detaliu comanda.</param>
        /// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns>
        /// <exception cref="DbEntityCustomException"></exception>
        public bool AddOperatie(Operatie operatie, DetaliuComanda detaliuComanda)
        {
            try
            {
                _operatieWrite       = new WriteOperatieRepository(context);
                _detaliuComandaWrite = new WriteDetaliuComandaRepository(context);

                _operatieWrite.Create(operatie);
                if (detaliuComanda.Operaties == null)
                {
                    detaliuComanda.Operaties = new List <Operatie>();
                }
                detaliuComanda.Operaties.Add(operatie);
                _detaliuComandaWrite.Update(detaliuComanda);

                context.SaveChanges();
                return(true);
            }
            catch (Exception e)
            {
                var message = DbEntityCustomException.BuildMessageExceptions(e);
                throw new DbEntityCustomException(message);
            }
        }
Exemplo n.º 18
0
        /// <inheritdoc />
        /// <summary>
        /// Searches the client.
        /// </summary>
        /// <param name="searchClientString">Search by SerieSasiu, Telefon, Email</param>
        /// <returns>System.Int32.</returns>
        /// <exception cref="NotImplementedException"></exception>
        public Client GetClient(string searchClientString)
        {
            try
            {
                _clientRead = new ReadClientRepository(_context);

                if (searchClientString.Contains("@"))
                {
                    return(_clientRead.GetByEmail(searchClientString));
                }

                if (searchClientString.Contains("+") || IsDigitsOnly(searchClientString))
                {
                    return(_clientRead.GetByTelefon(searchClientString));
                }

                return(_clientRead.GetBySerieSasiu(searchClientString));
            }
            catch (Exception e)
            {
                var message = DbEntityCustomException.BuildMessageExceptions(e);
                throw new DbEntityCustomException(message);
            }
        }