public void Execute(object parameter) { ScannedProduct s = (ScannedProduct)parameter; EditProduct ep = new EditProduct(ref s); VM.LoadEditProductView(ep); }
public void update_ScannedProduct(ScannedProduct sp) { if (sp != null) { rep.update_ScannedProduct(sp); } }
public EditProduct(ref ScannedProduct sp) { _sp = sp; InitializeComponent(); VM = new EditProductVM(this, ref _sp); this.DataContext = VM; }
public EditProductVM(EditProduct view, ref ScannedProduct s) { this.View = view; this.sp = s; this.p = new BLimp().getProductByScannedProduct(sp); NumberList = new ObservableCollection <int>(Enumerable.Range(0, 1000)); }
public void add_ScannedProduct(ScannedProduct scan, string name) { using (var context = new ProductDB()) { var arr = (from p in context.products where p.num == scan.productNo select p).ToList <Product>(); if (arr.Count == 0) { add_Product(new Product(scan.productNo, name, "", null)); } //var temp = context.scans.FirstOrDefault(value => value.productNo == scan.productNo && value.store.Equals(scan.store) && (DbFunctions.TruncateTime(scan.dateScan) == (DbFunctions.TruncateTime(value.dateScan)))); //if (temp != null) //{ // temp.amount++; // context.SaveChanges(); // // update_ScannedProduct(temp); //} //if (temp == null) //{ // context.scans.Add(scan); // context.SaveChanges(); //} context.scans.Add(scan); context.SaveChanges(); } }
private void SaveStream(System.IO.MemoryStream stream, string saveTo) { using (System.IO.FileStream file = new System.IO.FileStream(saveTo, System.IO.FileMode.Create, System.IO.FileAccess.Write)) { stream.WriteTo(file); } DAL.Barcode_reader reader = new Barcode_reader(); string text = reader.Decode(saveTo); string time = saveTo.Substring(saveTo.Length - 1 - 9 - 3, 6); string hour = time.Substring(0, 2); string minnutes = time.Substring(2, 2); string dayNight = time.Substring(4, 2); if (dayNight == "PM") { hour = (Int32.Parse(hour) + 12).ToString(); } int y = saveTo.IndexOf("at") - saveTo.IndexOf("Barcodes") - 10; string x = saveTo.Substring(saveTo.IndexOf("Barcodes") + 9, y); DateTime dateTime = DateTime.Parse(x + " " + hour + ":" + minnutes + ":" + "00" + " " + dayNight); string[] str = text.Split('-'); ScannedProduct s = new ScannedProduct(Int32.Parse(str[4]), str[3], dateTime, float.Parse(str[2]), Int32.Parse(str[1])); rep.saveProductFromDrive(s, str[0]); }
public void Execute(object parameter) { ScannedProduct s = (ScannedProduct)parameter; BLimp bl = new BLimp(); bl.delete_ScannedProduct(s); VM.worker.RunWorkerAsync(); }
public Product getProductByScannedProduct(ScannedProduct sp) { Product result; using (var context = new ProductDB()) { result = context.products.FirstOrDefault(value => value.num == sp.productNo); } return(result); }
public void delete_ScannedProduct(ScannedProduct scan) { using (var context = new ProductDB()) { var old = context.scans.Find(scan.Id); context.scans.Remove(old); context.SaveChanges(); } }
public bool isInScannedProductInDay(int value, string dt) { using (var context = new ProductDB()) { ScannedProduct p = context.scans.Find(value); if (p == null) { return(false); } return(p.dateScan.DayOfWeek.ToString() == dt); } }
public ScannedProduct connectSqlServer() { ScannedProduct res = new ScannedProduct(); using (var db = new ProductDB()) { if (db.scans != null) { res = db.scans.FirstOrDefault(value => value.Id >= 0); } } return(res); }
public void update_ScannedProduct(ScannedProduct scan) { using (var context = new ProductDB()) { var old = context.scans.Find(scan.Id); old.amount = scan.amount; old.cost = scan.cost; old.dateScan = scan.dateScan; old.rating = scan.rating; old.store = scan.store; context.SaveChanges(); } }
private static void SelectShopAndFilter(string path, List <ScannedProduct> SProducts) { string[] Shops = new string[] { "MAXIMA", "LIDL", "PALINK", "RIMI", "NORFA" }; string ShopResult = Shops.FirstOrDefault <string>(s => tempStr[0].ToUpper().Contains(s)); switch (ShopResult) { case "MAXIMA": tempStr[0] = "xxx"; Scan(path, SProducts); break; case "LIDL": tempStr[0] = "xxx"; ScanLidl(path, SProducts); break; case "PALINK": tempStr[0] = "xxx"; ScanIki(path, SProducts); break; case "RIMI": tempStr[0] = "xxx"; Scan(path, SProducts); break; case "NORFA": tempStr[0] = "xxx"; Scan(path, SProducts); break; default: ScannedProduct Spr = new ScannedProduct() { Name = "Could not detect Shop!" }; SProducts.Add(Spr); break; } }
public void AddProduct(Product Pr) { IEnumerable <IEnumerable <Product> > products = DataProcessor.LoadJson <IEnumerable <Product> >(Tools.Utils.ProductsPath); IEnumerable <Product> filteredProducts = new List <Product>(); filteredProducts = products.SelectMany(iepr => iepr.Where(Prod => Prod.Name == Pr.Name && Prod.PriceUnit == Pr.PriceUnit && Prod.Category == Pr.Category && Prod.Shop == Pr.Shop)); ScannedProduct pr = new ScannedProduct() { Shop = Pr.Shop, Name = Pr.Name, PriceUnit = Pr.PriceUnit, Price = Convert.ToDouble(Pr.Price), Id = (from fil in filteredProducts select fil.Id).First() }; ProductEditor.AddProducts(pr); }
public static void PickProducts(this string[] tempStr, Shops shop, string path, List <ScannedProduct> SProducts) { foreach (string line in tempStr) { string query = line.ToLower().Trim(); IEnumerable <Product> filtered = SearchAndFind.SearchForProduct(query, path); foreach (Product pr in filtered) { if (pr.Shop == shop) { ScannedProduct Spr = new ScannedProduct() { Shop = pr.Shop, Name = pr.Name, PriceUnit = pr.PriceUnit, Price = Convert.ToDouble(pr.Price), Id = pr.Id }; SProducts.Add(Spr); } } } }
public static void AddProducts(ScannedProduct pr) { ScannedProducts.Add(pr); }
public void saveProductFromDrive(ScannedProduct s, string name) { add_ScannedProduct(s, name); }
public void add_ScannedProduct(ScannedProduct scan, string name) { rep.add_ScannedProduct(scan, name); }
public void delete_ScannedProduct(ScannedProduct s) { rep.delete_ScannedProduct(s); }
public void connectSqlServer() { rep.resetLastDate(); new DAL.GoogleDriveApi().Connect(DateTime.Parse(rep.getLastDate().lastDate)); ScannedProduct s = rep.connectSqlServer(); }