public String DesactivatePurchase(Purchase purchase) { _gestionDb = new GcdbEntities(); purchase.Status = 1; MajPurchase(purchase); return "Achat désactiver avec succes"; }
public String AddPurchase(Purchase pur) { _gestionDb = new GcdbEntities(); if (IsPurchaseExist(pur)) return "Achat existe déjà"; _gestionDb.Purchases.Add(pur); _gestionDb.SaveChanges(); return "Achat ajouter avec succes"; }
public String DelPurchase(Purchase pur) { _gestionDb = new GcdbEntities(); if (!IsPurchaseExist(pur)) return "Achat n'existante pas"; Purchase purchase = _gestionDb.Purchases.Single(p => p.PurchaseID == pur.PurchaseID); _gestionDb.Purchases.Remove(pur); _gestionDb.SaveChanges(); return "Achat supprimer avec succes"; }
private void CustomersDataTable_OnMouseDoubleClick(object sender, MouseButtonEventArgs e) { if (PurchaseGridControl.VisibleRowCount == 0) return; int rowHandle = PurchaseGridControl.View.FocusedRowHandle; if (rowHandle < 0) return; _purchaseClient = new PurchaseClient(); int purchaseId = Convert.ToInt32(PurchaseGridControl.GetCellValue(rowHandle, "PurchaseID").ToString()); _getPurchase = _purchaseClient.GetPurchaseById(purchaseId); if (_getPurchase == null) return; LoadPurchaseStoreGridControl(_getPurchase); // OrderDateDateEdit.Text = order.OrderDate.ToString(); }
private void LoadGridProducts(Purchase purchase) { Dispatcher.BeginInvoke(new Action(() => { _purchaseStoresList = _purchaseDetailsManager.GetPurchaseDetails(); if (_purchaseStoresList != null) SelectedProductsDataGrid.ItemsSource = (from t in _purchaseStoresList where t.PurchaseID == purchase.PurchaseID select new { ProductName = t.Product.ProductName, CategoryName = t.Product.SubCategory.Category.CategoryName, UnitsInStock = t.Product.UnitsInStock, PurchasePrice = t.Product.PurchasePrice, SalePrice = t.Product.SalePrice, // Mesure = t.Products.Measures.MesureName, } ).ToList(); })); }
private void LoadPurchaseStoreGridControl(Purchase thePurchase) { var getPurchaseStores = new BackgroundWorker(); getPurchaseStores.DoWork += GetPurchaseStoresFromPurchaseOnDoWork; getPurchaseStores.RunWorkerCompleted += GetPurchaseStoresFromPurchaseOnRunWorkerCompleted; getPurchaseStores.RunWorkerAsync(thePurchase); }
private String MajPurchase(Purchase pur) { _gestionDb = new GcdbEntities(); Purchase purchase = _gestionDb.Purchases.Single(p => p.PurchaseID == pur.PurchaseID); try { purchase = pur; // si sa marche pas alors attache detache sinon affactation champ par champ } catch (Exception ) { return "erreur"; } return "Achat modifier avec succes"; }
private static bool IsPurchaseExist(Purchase pur) { try { GcdbEntities gestionDb = new GcdbEntities(); var query = from t in gestionDb.Purchases where t.PurchaseID.Equals(pur.PurchaseID) select t; return query.Any(); } catch (Exception) { return false; } return false; }
public Double GetTotalPurchase(Purchase p) { try { _gestionDb = new GcdbEntities(); var list = from purchase in _gestionDb.PurchaseStores where (purchase.PurchaseID == p.PurchaseID) select purchase; Double somme = 0; // foreach (PurchaseStore pd in list) somme += (Double)pd.UnitPrice * pd.Quantity; return somme; } catch (Exception) { return 0; } }
public List<PurchaseStore> GetPurchaseStoresList(Purchase getPurchase) { try { _gestionDb = new GcdbEntities(); var query = from t in _gestionDb.PurchaseStores where t.PurchaseID == getPurchase.PurchaseID select t; return !query.Any() ? new List<PurchaseStore>() : query.ToList(); } catch (Exception) { return new List<PurchaseStore>(); } }
private void CreatePurchase(float getDicount, string etatPayement, string modePayement, string modeAchat, string commandNum, string factureNum, float facturePriceHt, string remarque, Provider provider, DateTime commandeDtae, float tvaValue) { try { var gestionDb = new GcdbEntities(); Provider getProvider = gestionDb.Providers.FirstOrDefault(c => c.SupplierID == provider.SupplierID); if(getProvider==null)return; var newPurchase = new Purchase { TvaValue = tvaValue, FacturePrice = facturePriceHt, PurchaseMontant = _total, EtatPaiement = etatPayement, ModePaiement = modePayement, ModeAchat = modeAchat, CommandeNum = commandNum, FactureNum = factureNum, PurchaseDate = AchatDateDte.DateTime.Date, CommandeDate = commandeDtae, Status = 0, Provider = getProvider, SupplierID = provider.SupplierID, Description = remarque, Discount = (float?) getDicount, Timbre = (double?) _timbre }; foreach (var entitys in _productsSelSelected) { var getId = Getid(entitys, tvaValue); Product getProduct = gestionDb.Products.FirstOrDefault(c => c.ProductID == entitys.ProductId); if(getProduct==null)continue; var nwStore = new PurchaseStore { Product = getProduct, ProductID = entitys.ProductId, PurchasePrice = entitys.PurchasePrice, TotalPriceAchat = entitys.TotalPriceAchat, UnitsOnOrder = (double?) entitys.UnitsOnOrder, VentePriceGros = entitys.VentePriceGros, VentePriceDetail = entitys.VentePriceDetail, VentePriceComptoire = entitys.VentePriceComptoire, Discount = entitys.Discount, TvaValue = tvaValue, StockStoreID = getId }; newPurchase.PurchaseStores.Add(nwStore); } gestionDb.Purchases.Add(newPurchase); gestionDb.SaveChanges(); } catch (Exception e) { MessageBox.Show(e.ToString()); } }