internal static List <Stock> ListStock()
 {
     using (ErpEntities dbContext = new ErpEntities())
     {
         return(dbContext.Stock.ToList());
     }
 }
 internal static Stock GetStock(int productID)
 {
     using (ErpEntities dbContext = new ErpEntities())
     {
         return(dbContext.Stock.FirstOrDefault(f => f.ProductID == productID));
     }
 }
 internal static List <Client> ListClients()
 {
     using (ErpEntities dbContext = new ErpEntities())
     {
         return(dbContext.Client.ToList());
     }
 }
 internal static Client GetClient(int userID)
 {
     using (ErpEntities dbContext = new ErpEntities())
     {
         return(dbContext.Client.FirstOrDefault(f => f.ClientID == userID));
     }
 }
 internal static Product GetProduct(int productID)
 {
     using (ErpEntities dbContext = new ErpEntities())
     {
         return(dbContext.Product.FirstOrDefault(f => f.ProductID == productID));
     }
 }
 internal static List <Product> ListProducts()
 {
     using (ErpEntities dbContext = new ErpEntities())
     {
         return(dbContext.Product.ToList());
     }
 }
Ejemplo n.º 7
0
 public List <Customer> Get(Func <Customer, bool> predicate)
 {
     using (var context = new ErpEntities())
     {
         return(context.Customers.Where(predicate).ToList());
     }
 }
 internal static void AddProduct(Product product)
 {
     using (ErpEntities dbContext = new ErpEntities())
     {
         dbContext.Product.Add(product);
         dbContext.SaveChanges();
     }
 }
 internal static void AddClient(Client client)
 {
     using (ErpEntities dbContext = new ErpEntities())
     {
         dbContext.Client.Add(client);
         dbContext.SaveChanges();
     }
 }
 internal static string GetName(int productID)
 {
     using (ErpEntities dbContext = new ErpEntities())
     {
         var product = dbContext.Product.SingleOrDefault(f => f.ProductID == productID);
         return(product.ProductName);
     }
 }
 internal static void ChangeStock(int productID, int new_quantity)
 {
     using (ErpEntities dbContext = new ErpEntities())
     {
         Stock stock = dbContext.Stock.FirstOrDefault(f => f.ProductID == productID);
         stock.ProductQuantity = new_quantity;
         dbContext.SaveChanges();
     }
 }
 internal static void ModifyClient(int userID, string clientName, string clientEmail)
 {
     using (ErpEntities dbContext = new ErpEntities())
     {
         var client = dbContext.Client.SingleOrDefault(f => f.ClientID == userID);
         client.ClientName  = clientName;
         client.ClientEmail = clientEmail;
         dbContext.SaveChanges();
     }
 }
 internal static void ModifyProduct(int productID, string productName, decimal productPrice)
 {
     using (ErpEntities dbContext = new ErpEntities())
     {
         var product = dbContext.Product.SingleOrDefault(f => f.ProductID == productID);
         product.ProductName  = productName;
         product.ProductPrice = productPrice;
         dbContext.SaveChanges();
     }
 }
        internal static void AddStock(Product product, int productQuantity)
        {
            using (ErpEntities dbContext = new ErpEntities())
            {
                Stock stock = new Stock
                {
                    ProductID       = product.ProductID,
                    ProductQuantity = productQuantity
                };

                dbContext.Stock.Add(stock);
                dbContext.SaveChanges();
            }
        }
 internal static bool RemoveProduct(int productID)
 {
     using (ErpEntities dbContext = new ErpEntities())
     {
         Product product = dbContext.Product.FirstOrDefault(f => f.ProductID == productID);
         if (product != null)
         {
             dbContext.Product.Remove(product);
             dbContext.SaveChanges();
             return(true);
         }
         else
         {
             Display.NoEntry();
             return(false);
         }
     }
 }
 internal static bool RemoveClient(int userID)
 {
     using (ErpEntities dbContext = new ErpEntities())
     {
         Client client = dbContext.Client.FirstOrDefault(f => f.ClientID == userID);
         if (client != null)
         {
             dbContext.Client.Remove(client);
             dbContext.SaveChanges();
             return(true);
         }
         else
         {
             Display.NoEntry();
             return(false);
         }
     }
 }
Ejemplo n.º 17
0
 public UserDao()
 {
     db = new ErpEntities();
 }