Beispiel #1
0
        public static List <CarPart> CreateCarParts(CarPart car, List <Tuple <string, string, int, decimal, CurrencyTypeEnum> > parts)
        {
            var list = new List <CarPart>();

            foreach (var part in parts)
            {
                var partialVin  = car.Vin.Substring(car.Vin.Length - 5);
                var description = partialVin + " " + car.Model + " " + part.Item1;
                var category    = part.Item2;
                var quantity    = part.Item3;
                var price       = part.Item4;
                var currency    = part.Item5;
                var index       = parts.IndexOf(part) + 1;

                var newPart = new CarPart()
                {
                    Code              = partialVin + index,
                    AlternativeCode   = "NA",
                    ProviderProductId = "NA",
                    Description       = description,
                    Vin                    = car.Vin,
                    Make                   = car.Make,
                    Model                  = car.Model,
                    Year                   = car.Year,
                    Transmission           = car.Transmission,
                    Motor                  = car.Motor,
                    Color                  = car.Color,
                    Provider               = car.Provider,
                    Category               = category,
                    LastPurchaseDate       = car.LastPurchaseDate,
                    Cost                   = 0M,
                    CostCurrency           = CurrencyTypeEnum.USD,
                    ImportCost             = 0M,
                    ImportCostCurrency     = CurrencyTypeEnum.USD,
                    Price                  = price,
                    PriceCurrency          = currency,
                    Location               = car.Location,
                    SpecificLocation       = car.SpecificLocation,
                    InternalQuantity       = 0,
                    QuantitySold           = 0,
                    AmountSold             = 0,
                    LocalQuantityAvailable = quantity,
                    TotalQuantityAvailable = quantity,
                    MinimumStockQuantity   = 0,
                    LastSaleDate           = car.LastPurchaseDate,
                    ImageName              = car.ImageName,
                    Valid                  = true
                };

                list.Add(newPart);
            }
            return(list);
        }
Beispiel #2
0
        public CarRegistrationViewModel()
        {
            Thread.CurrentThread.CurrentCulture = new CultureInfo("es-MX");

            _carPartsSearchedEntries = new ObservableCollection <CarPart>();
            //_carPartsSearchedEntries.Add(new CarPart()
            //{
            //    Id = 1,
            //    Category = "interior",
            //    Code = "123x",
            //    Description = "Puerta",
            //    Model = "Honda 1998",
            //    Vin = "FDG43BDBSG1435",
            //    Price = 100M,
            //    PriceCurrency = CurrencyTypeEnum.USD,
            //    Enabled = true,
            //    TotalQuantityAvailable = 4
            //});
            //_carPartsSearchedEntries.Add(new CarPart()
            //{
            //    Id = 1,
            //    Category = "interior",
            //    Code = "12343x",
            //    Description = "Cofre",
            //    Model = "Honda 1998",
            //    Vin = "FDG43BDBSG1435",
            //    Price = 150M,
            //    PriceCurrency = CurrencyTypeEnum.USD,
            //    Enabled = true,
            //    TotalQuantityAvailable = 1
            //});
            var carList      = FileIO.GetListFromFile(Constants.DataFolderPath + Constants.CarBrandListFileName);
            var transList    = FileIO.GetListFromFile(Constants.DataFolderPath + Constants.TransmissiondListFileName);
            var locationList = FileIO.GetListFromFile(Constants.DataFolderPath + Constants.LocationListFileName);

            CarBrandsList     = new ObservableCollection <string>(carList);
            TransmissionsList = new ObservableCollection <string>(transList);
            LocationsList     = new ObservableCollection <string>(locationList);

            //Set default states
            Car = new CarPart()
            {
                CostCurrency       = CurrencyTypeEnum.USD,
                ImportCostCurrency = CurrencyTypeEnum.USD,
                LastPurchaseDate   = DateTime.Now,
                Make         = carList[0],
                Transmission = transList[1],
                Location     = locationList[0],
            };

            CurrentPage = Constants.CarRegistrationMainPage; //"\\View\\CarRegistrationInfoPage.xaml";
        }
        internal void Execute_ImportExportCarCommand(object parameter)
        {
            if ((string)parameter == "import")
            {
                var openFileDialog = new OpenFileDialog()
                {
                    Filter           = ".csv files (*.csv)|*.csv",
                    Title            = "Selecciona archivo de partes de carros",
                    InitialDirectory = @"C:\Projects\"
                };

                if (openFileDialog.ShowDialog() == true)
                {
                    var fileName = openFileDialog.FileName;
                    var parts    = CarPart.ReadPartsFile(fileName);
                    //var car = new CarPart()
                    //{
                    //    Vin = "10000",
                    //    Make = "Honda",
                    //    Model = "Civic",
                    //    Year = 2010,
                    //    Color = "Azul",
                    //    Transmission = "Std",
                    //    Motor = "1.8T"
                    //};
                    CarPartsSearchedEntries = new ObservableCollection <CarPart>(CarPart.CreateCarParts(Car, parts));
                    CarParts = new ObservableCollection <CarPart>(CarPart.CreateCarParts(Car, parts));
                }
            }
            else if ((string)parameter == "export")
            {
                var saveFileDialog = new SaveFileDialog()
                {
                    Filter           = ".csv files (*.csv)|*.csv",
                    Title            = "Guarda archivo de partes de carro",
                    InitialDirectory = @"C:\Projects\"
                };

                if (saveFileDialog.ShowDialog() == true)
                {
                    var carParts = new List <Tuple <string, string, int, decimal, CurrencyTypeEnum> >();
                    foreach (var carPart in CarParts)
                    {
                        carParts.Add(new Tuple <string, string, int, decimal, CurrencyTypeEnum>(carPart.Description, carPart.Category,
                                                                                                carPart.TotalQuantityAvailable, carPart.Price, carPart.PriceCurrency));
                    }
                    CarPart.WritePartsFile(saveFileDialog.FileName, carParts);
                }
            }
        }
        internal void Execute_StartCarRegistrationCommand(object parameter)
        {
            var parts = CarPart.ReadPartsFile(Constants.DataFolderPath + Constants.DefaultPartsListFileName);

            //var car = new CarPart()
            //{
            //    Vin = "10000",
            //    Make = "Honda",
            //    Model = "Civic",
            //    Year = 2010,
            //    Color = "Azul",
            //    Transmission = "Std",
            //    Motor = "1.8T"
            //};
            CarParts = new ObservableCollection <CarPart>(CarPart.CreateCarParts(Car, parts));
            CarPartsSearchedEntries = CarParts;
            MainWindowViewModel.GetInstance(null, null).CurrentPage = "\\View\\CarRegistrationListPage.xaml";
        }
Beispiel #5
0
        public List <IProduct> Search(string input)
        {
            var products = new List <IProduct>();

            //Return empty list if invalid inputs are entered for the search
            if (string.IsNullOrWhiteSpace(input) || input == "x")
            {
                return(products);
            }

            if (input == "*")
            {
                var allProducts = DictOfData.AsEnumerable();
                foreach (var row in allProducts)
                {
                    var product = new CarPart()
                    {
                        Id                     = Int32.Parse(row["NumeroProducto"].ToString()),
                        Code                   = row["Codigo"].ToString(),
                        AlternativeCode        = row["CodigoAlterno"].ToString(),
                        ProviderProductId      = row["ProveedorProductoId"].ToString(),
                        Description            = row["Descripcion"].ToString(),
                        Provider               = row["Proveedor"].ToString(),
                        Category               = row["Categoria"].ToString(),
                        LastPurchaseDate       = Convert.ToDateTime(row["UltimoPedidoFecha"].ToString()),
                        Cost                   = Decimal.Parse(row["Costo"].ToString()),
                        Price                  = decimal.Parse(row["Precio"].ToString()),
                        InternalQuantity       = Int32.Parse(row["CantidadInternoHistorial"].ToString()),
                        QuantitySold           = Int32.Parse(row["CantidadVendidoHistorial"].ToString()),
                        AmountSold             = decimal.Parse(row["VendidoHistorial"].ToString()),
                        LocalQuantityAvailable = Int32.Parse(row["CantidadLocal"].ToString()),
                        TotalQuantityAvailable = Int32.Parse(row["CantidadDisponibleTotal"].ToString()),
                        MinimumStockQuantity   = Int32.Parse(row["CantidadMinima"].ToString()),
                        LastSaleDate           = Convert.ToDateTime(row["UltimaTransaccionFecha"].ToString()),
                        ImageName              = row["Imagen"].ToString(),
                        Vin                    = row["VIN"].ToString(),
                        Make                   = row["Marca"].ToString(),
                        Model                  = row["Modelo"].ToString(),
                        Year                   = Int32.Parse(row["Anho"].ToString()),
                        Transmission           = row["Transmision"].ToString(),
                        Motor                  = row["Motor"].ToString(),
                        Color                  = row["Color"].ToString(),
                        ImportCost             = decimal.Parse(row["CostoImportacion"].ToString()),
                        Location               = row["Ubicacion"].ToString(),
                        SpecificLocation       = row["Pasillo"].ToString()
                    };

                    product.CostCurrency       = row["CostoMoneda"].ToString().ToUpper() == "USD" ? CurrencyTypeEnum.USD : CurrencyTypeEnum.MXN;
                    product.PriceCurrency      = row["PrecioMoneda"].ToString().ToUpper() == "USD" ? CurrencyTypeEnum.USD : CurrencyTypeEnum.MXN;
                    product.ImportCostCurrency = row["CostoImportacionMoneda"].ToString().ToUpper() == "USD" ? CurrencyTypeEnum.USD : CurrencyTypeEnum.MXN;
                    products.Add(product);
                }

                return(products);
            }

            var descriptionFilter = DictOfData.AsEnumerable().Where(r => r.Field <string>("Descripcion").ToLower().Contains(input));
            var codeFilter        = DictOfData.AsEnumerable().Where(r => r.Field <string>("Codigo").ToLower().Contains(input));

            foreach (var row in codeFilter)
            {
                var product = new CarPart()
                {
                    Id                     = Int32.Parse(row["NumeroProducto"].ToString()),
                    Code                   = row["Codigo"].ToString(),
                    AlternativeCode        = row["CodigoAlterno"].ToString(),
                    ProviderProductId      = row["ProveedorProductoId"].ToString(),
                    Description            = row["Descripcion"].ToString(),
                    Provider               = row["Proveedor"].ToString(),
                    Category               = row["Categoria"].ToString(),
                    LastPurchaseDate       = Convert.ToDateTime(row["UltimoPedidoFecha"].ToString()),
                    Cost                   = Decimal.Parse(row["Costo"].ToString()),
                    Price                  = decimal.Parse(row["Precio"].ToString()),
                    InternalQuantity       = Int32.Parse(row["CantidadInternoHistorial"].ToString()),
                    QuantitySold           = Int32.Parse(row["CantidadVendidoHistorial"].ToString()),
                    AmountSold             = decimal.Parse(row["VendidoHistorial"].ToString()),
                    LocalQuantityAvailable = Int32.Parse(row["CantidadLocal"].ToString()),
                    TotalQuantityAvailable = Int32.Parse(row["CantidadDisponibleTotal"].ToString()),
                    MinimumStockQuantity   = Int32.Parse(row["CantidadMinima"].ToString()),
                    LastSaleDate           = Convert.ToDateTime(row["UltimaTransaccionFecha"].ToString()),
                    ImageName              = row["Imagen"].ToString(),
                    Vin                    = row["VIN"].ToString(),
                    Make                   = row["Marca"].ToString(),
                    Model                  = row["Modelo"].ToString(),
                    Year                   = Int32.Parse(row["Anho"].ToString()),
                    Transmission           = row["Transmision"].ToString(),
                    Motor                  = row["Motor"].ToString(),
                    Color                  = row["Color"].ToString(),
                    ImportCost             = decimal.Parse(row["CostoImportacion"].ToString()),
                    Location               = row["Ubicacion"].ToString(),
                    SpecificLocation       = row["Pasillo"].ToString()
                };

                product.CostCurrency       = row["CostoMoneda"].ToString().ToUpper() == "USD" ? CurrencyTypeEnum.USD : CurrencyTypeEnum.MXN;
                product.PriceCurrency      = row["PrecioMoneda"].ToString().ToUpper() == "USD" ? CurrencyTypeEnum.USD : CurrencyTypeEnum.MXN;
                product.ImportCostCurrency = row["CostoImportacionMoneda"].ToString().ToUpper() == "USD" ? CurrencyTypeEnum.USD : CurrencyTypeEnum.MXN;

                products.Add(product);
            }

            foreach (var row in descriptionFilter)
            {
                var product = new CarPart()
                {
                    Id                     = Int32.Parse(row["NumeroProducto"].ToString()),
                    Code                   = row["Codigo"].ToString(),
                    AlternativeCode        = row["CodigoAlterno"].ToString(),
                    ProviderProductId      = row["ProveedorProductoId"].ToString(),
                    Description            = row["Descripcion"].ToString(),
                    Provider               = row["Proveedor"].ToString(),
                    Category               = row["Categoria"].ToString(),
                    LastPurchaseDate       = Convert.ToDateTime(row["UltimoPedidoFecha"].ToString()),
                    Cost                   = Decimal.Parse(row["Costo"].ToString()),
                    Price                  = decimal.Parse(row["Precio"].ToString()),
                    InternalQuantity       = Int32.Parse(row["CantidadInternoHistorial"].ToString()),
                    QuantitySold           = Int32.Parse(row["CantidadVendidoHistorial"].ToString()),
                    AmountSold             = decimal.Parse(row["VendidoHistorial"].ToString()),
                    LocalQuantityAvailable = Int32.Parse(row["CantidadLocal"].ToString()),
                    TotalQuantityAvailable = Int32.Parse(row["CantidadDisponibleTotal"].ToString()),
                    MinimumStockQuantity   = Int32.Parse(row["CantidadMinima"].ToString()),
                    LastSaleDate           = Convert.ToDateTime(row["UltimaTransaccionFecha"].ToString()),
                    ImageName              = row["Imagen"].ToString(),
                    Vin                    = row["VIN"].ToString(),
                    Make                   = row["Marca"].ToString(),
                    Model                  = row["Modelo"].ToString(),
                    Year                   = Int32.Parse(row["Anho"].ToString()),
                    Transmission           = row["Transmision"].ToString(),
                    Motor                  = row["Motor"].ToString(),
                    Color                  = row["Color"].ToString(),
                    ImportCost             = decimal.Parse(row["CostoImportacion"].ToString()),
                    Location               = row["Ubicacion"].ToString(),
                    SpecificLocation       = row["Pasillo"].ToString()
                };

                product.CostCurrency       = row["CostoMoneda"].ToString().ToUpper() == "USD" ? CurrencyTypeEnum.USD : CurrencyTypeEnum.MXN;
                product.PriceCurrency      = row["PrecioMoneda"].ToString().ToUpper() == "USD" ? CurrencyTypeEnum.USD : CurrencyTypeEnum.MXN;
                product.ImportCostCurrency = row["CostoImportacionMoneda"].ToString().ToUpper() == "USD" ? CurrencyTypeEnum.USD : CurrencyTypeEnum.MXN;

                //Add if it does not exist already
                if (!products.Exists(x => x.Code == product.Code))
                {
                    products.Add(product);
                }
            }

            return(products);
        }
Beispiel #6
0
        internal void Execute_ImportExportCarCommand(object parameter)
        {
            if ((string)parameter == "import")
            {
                var openFileDialog = new OpenFileDialog()
                {
                    Filter           = ".csv files (*.csv)|*.csv",
                    Title            = "Selecciona archivo de partes de carros",
                    InitialDirectory = @"C:\"
                };

                if (openFileDialog.ShowDialog() == true)
                {
                    var fileName = openFileDialog.FileName;
                    var parts    = CarPart.ReadPartsFile(fileName);
                    //var car = new CarPart()
                    //{
                    //    Vin = "10000",
                    //    Make = "Honda",
                    //    Model = "Civic",
                    //    Year = 2010,
                    //    Color = "Azul",
                    //    Transmission = "Std",
                    //    Motor = "1.8T"
                    //};
                    CarPartsSearchedEntries = new ObservableCollection <CarPart>(CarPart.CreateCarParts(Car, parts));
                    CarParts = new ObservableCollection <CarPart>(CarPart.CreateCarParts(Car, parts));
                }
            }
            else if ((string)parameter == "export")
            {
                var saveFileDialog = new SaveFileDialog()
                {
                    Filter           = ".csv files (*.csv)|*.csv",
                    Title            = "Guarda archivo de partes de carro",
                    InitialDirectory = @"C:\"
                };

                if (saveFileDialog.ShowDialog() == true)
                {
                    var carParts = new List <Tuple <string, string, int, decimal, CurrencyTypeEnum, bool> >();
                    foreach (var carPart in CarParts)
                    {
                        //remove detailed information to create default list
                        //remove model
                        var desc = carPart.Description.Replace(Car.Model, "");
                        //remove year
                        desc = desc.Replace(Car.Year.ToString(), "");
                        //remove vin
                        var firstSpaceIndex = desc.IndexOf(" ", StringComparison.Ordinal);
                        desc = desc.Remove(0, firstSpaceIndex + 1);
                        //remove spaces
                        desc = desc.TrimStart(' ');

                        carParts.Add(new Tuple <string, string, int, decimal, CurrencyTypeEnum, bool>(desc, carPart.Category,
                                                                                                      carPart.TotalQuantityAvailable, carPart.Price, carPart.PriceCurrency, carPart.Valid));
                    }
                    CarPart.WritePartsFile(saveFileDialog.FileName, carParts);
                }
            }
        }