/// <summary> /// Provides the instance related to a character index in the textbox /// </summary> /// <param name="index"></param> /// <returns></returns> protected INamable GetInstance(int index) { INamable retVal = null; if (Model != null) { InterpreterTreeNode node = Parse(EditionTextBox.Text); if (node != null) { ContextGrabber grabber = new ContextGrabber(); retVal = grabber.GetContext(index, node); } if (retVal == null) { // Perform a fuzzy search by trying to find the corresponding expression text string text = GetExpressionText(EditionTextBox.Text, index); node = Parse(text); index = text.Length - 1; if (node != null) { ContextGrabber grabber = new ContextGrabber(); retVal = grabber.GetContext(index, node); } } } return(retVal); }
public List <Customer> GetAllCustomers() { using (var context = new ContextGrabber()) { var Customers = context.Customers.ToList(); return(Customers); } }
public List <Customer> GetListCustomersByEstado(Estado estado) { using (var context = new ContextGrabber()) { var customers = context.Customers.Where(c => c.Estado == estado); return(customers.ToList()); } }
public void CreateOrder(Order order) { using (var context = new ContextGrabber()) { context.Orders.Add(order); context.SaveChanges(); } }
public void CreateProduct(Product product) { using (var context = new ContextGrabber()) { context.Products.Add(product); context.SaveChanges(); } }
public List <Product> GetAllProducts() { using (var context = new ContextGrabber()) { var Products = context.Products.ToList(); return(Products); } }
public Product GetProductById(int id) { using (var context = new ContextGrabber()) { var product = context.Products.Find(id); return(product); } }
public void CreateCustomer(Customer customer) { using (var context = new ContextGrabber()) { context.Customers.Add(customer); context.SaveChanges(); } }
public Customer GetCustomerById(int id) { using (var context = new ContextGrabber()) { var customer = context.Customers.Find(id); return(customer); } }
/*** Este metodo devolvera una lista de productos con estado ACTIVO ***/ public List <Product> GetAllProductsDisponibles() { using (var context = new ContextGrabber()) { var products = context.Products.Where(p => p.Estado == Estado.ACTIVO); return(products.ToList()); } }
public void DeleteProduct(Product product) { using (var context = new ContextGrabber()) { context.Products.Attach(product); context.Products.Remove(product); context.SaveChanges(); } }
public void EditOrder(Order order) { using (var context = new ContextGrabber()) { context.Orders.Add(order); context.Entry(order).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
public void EditProduct(Product product) { using (var context = new ContextGrabber()) { context.Products.Add(product); context.Entry(product).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
public void EditCustomer(Customer customer) { using (var context = new ContextGrabber()) { context.Customers.Add(customer); context.Entry(customer).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
public void DeleteCustomer(Customer customer) { using (var context = new ContextGrabber()) { context.Customers.Attach(customer); context.Customers.Remove(customer); context.SaveChanges(); } }
public List <Order> GetAllOrders() { using (var context = new ContextGrabber()) { var products = context.Products.ToList(); var customer = context.Customers.ToList(); var orders = context.Orders.ToList(); return(orders); } }
public void TestFunctionCall() { Dictionary test = CreateDictionary("Test"); NameSpace n1 = CreateNameSpace(test, "N1"); Structure s1 = CreateStructure(n1, "S1"); StructureElement el1 = CreateStructureElement(s1, "E1", "Boolean"); Structure s2 = CreateStructure(n1, "S2"); StructureElement el2 = CreateStructureElement(s2, "E2", "S1"); Variable v = CreateVariable(n1, "V", "S1"); v.setDefaultValue("N1.S1 { E1 => True }"); Function function = CreateFunction(n1, "f", "S1"); Compiler.Compile_Synchronous(true, true); RuleCondition rc = CreateRuleAndCondition(n1, "Rule1"); Parser parser = new Parser(); { // 0 1 // 012345678901 const string text = "V <- f().S"; VariableUpdateStatement statement = parser.Statement(rc, text, true, true) as VariableUpdateStatement; ContextGrabber grabber = new ContextGrabber(); Assert.AreEqual(v, grabber.GetContext(0, statement)); Assert.AreEqual(v, grabber.GetContext(1, statement)); Assert.IsNull(grabber.GetContext(2, statement)); Assert.IsNull(grabber.GetContext(3, statement)); Assert.IsNull(grabber.GetContext(4, statement)); Assert.AreEqual(function, grabber.GetContext(5, statement)); Assert.AreEqual(function, grabber.GetContext(6, statement)); Assert.AreEqual(function, grabber.GetContext(7, statement)); Assert.AreEqual(s1, grabber.GetContext(8, statement)); Assert.IsNull(grabber.GetContext(9, statement)); Assert.IsNull(grabber.GetContext(10, statement)); } { // 0 // 0123456789 const string text = "V <- f()."; VariableUpdateStatement statement = parser.Statement(rc, text, true, true) as VariableUpdateStatement; ContextGrabber grabber = new ContextGrabber(); Assert.AreEqual(v, grabber.GetContext(0, statement)); Assert.AreEqual(v, grabber.GetContext(1, statement)); Assert.IsNull(grabber.GetContext(2, statement)); Assert.IsNull(grabber.GetContext(3, statement)); Assert.IsNull(grabber.GetContext(4, statement)); Assert.AreEqual(function, grabber.GetContext(5, statement)); Assert.AreEqual(function, grabber.GetContext(6, statement)); Assert.AreEqual(function, grabber.GetContext(7, statement)); Assert.AreEqual(s1, grabber.GetContext(8, statement)); Assert.IsNull(grabber.GetContext(9, statement)); } }
public void TestMapExpression() { Dictionary test = CreateDictionary("Test"); NameSpace n1 = CreateNameSpace(test, "N1"); Structure s1 = CreateStructure(n1, "S1"); StructureElement el1 = CreateStructureElement(s1, "E1", "Boolean"); Structure s2 = CreateStructure(n1, "S2"); StructureElement el2 = CreateStructureElement(s2, "E2", "S1"); Function function = CreateFunction(n1, "f", "S1"); Collection collection = CreateCollection(n1, "Col", "S1", 10); Variable v = CreateVariable(n1, "V", "Col"); Compiler.Compile_Synchronous(true, true); RuleCondition rc = CreateRuleAndCondition(n1, "Rule1"); Parser parser = new Parser(); { // 0 1 2 // 012345678901234567890123456 const string text = "MAP V | X. USING X IN X.E1"; MapExpression expression = parser.Expression(rc, text, null, true, null, true, true) as MapExpression; Assert.IsNotNull(expression); ContextGrabber grabber = new ContextGrabber(); Assert.IsNull(grabber.GetContext(0, expression)); Assert.IsNull(grabber.GetContext(1, expression)); Assert.IsNull(grabber.GetContext(2, expression)); Assert.IsNull(grabber.GetContext(3, expression)); Assert.AreEqual(v, grabber.GetContext(4, expression)); Assert.AreEqual(v, grabber.GetContext(5, expression)); Assert.IsNull(grabber.GetContext(6, expression)); Assert.IsNull(grabber.GetContext(7, expression)); Assert.AreEqual(expression.IteratorVariable, grabber.GetContext(8, expression)); Assert.AreEqual(expression.IteratorVariable, grabber.GetContext(9, expression)); Assert.IsNull(grabber.GetContext(10, expression)); Assert.IsNull(grabber.GetContext(11, expression)); Assert.IsNull(grabber.GetContext(12, expression)); Assert.IsNull(grabber.GetContext(13, expression)); Assert.IsNull(grabber.GetContext(14, expression)); Assert.IsNull(grabber.GetContext(15, expression)); Assert.IsNull(grabber.GetContext(16, expression)); Assert.IsNull(grabber.GetContext(17, expression)); Assert.IsNull(grabber.GetContext(18, expression)); Assert.IsNull(grabber.GetContext(19, expression)); Assert.IsNull(grabber.GetContext(20, expression)); Assert.IsNull(grabber.GetContext(21, expression)); Assert.AreEqual(expression.IteratorVariable, grabber.GetContext(22, expression)); Assert.AreEqual(expression.IteratorVariable, grabber.GetContext(23, expression)); Assert.AreEqual(el1, grabber.GetContext(24, expression)); Assert.AreEqual(el1, grabber.GetContext(25, expression)); Assert.AreEqual(el1, grabber.GetContext(26, expression)); Assert.IsNull(grabber.GetContext(27, expression)); } }
public Order GetOrderById(int id) { using (var context = new ContextGrabber()) { var products = context.Products.ToList(); var orderDetail = context.OrderDetails.ToList(); var customer = context.Customers.ToList(); var order = context.Orders.Find(id); return(order); } }
public void TestApplyStatement() { Dictionary test = CreateDictionary("Test"); NameSpace n1 = CreateNameSpace(test, "N1"); Structure s1 = CreateStructure(n1, "S1"); StructureElement el1 = CreateStructureElement(s1, "E1", "Boolean"); Structure s2 = CreateStructure(n1, "S2"); StructureElement el2 = CreateStructureElement(s2, "E2", "S1"); Function function = CreateFunction(n1, "f", "S1"); Collection collection = CreateCollection(n1, "Col", "S1", 10); Variable v = CreateVariable(n1, "V", "Col"); Compiler.Compile_Synchronous(true, true); RuleCondition rc = CreateRuleAndCondition(n1, "Rule1"); Parser parser = new Parser(); { // 0 1 2 // 012345678901234567890123 const string text = "APPLY X <- X ON V | X."; ApplyStatement statement = parser.Statement(rc, text, true, true) as ApplyStatement; Assert.IsNotNull(statement); ContextGrabber grabber = new ContextGrabber(); Assert.IsNull(grabber.GetContext(0, statement)); Assert.IsNull(grabber.GetContext(1, statement)); Assert.IsNull(grabber.GetContext(2, statement)); Assert.IsNull(grabber.GetContext(3, statement)); Assert.IsNull(grabber.GetContext(4, statement)); Assert.IsNull(grabber.GetContext(5, statement)); Assert.AreEqual(statement.IteratorVariable, grabber.GetContext(6, statement)); Assert.AreEqual(statement.IteratorVariable, grabber.GetContext(7, statement)); Assert.IsNull(grabber.GetContext(8, statement)); Assert.IsNull(grabber.GetContext(9, statement)); Assert.IsNull(grabber.GetContext(10, statement)); Assert.AreEqual(statement.IteratorVariable, grabber.GetContext(11, statement)); Assert.AreEqual(statement.IteratorVariable, grabber.GetContext(12, statement)); Assert.IsNull(grabber.GetContext(13, statement)); Assert.IsNull(grabber.GetContext(14, statement)); Assert.IsNull(grabber.GetContext(15, statement)); Assert.AreEqual(v, grabber.GetContext(16, statement)); Assert.AreEqual(v, grabber.GetContext(17, statement)); Assert.IsNull(grabber.GetContext(18, statement)); Assert.IsNull(grabber.GetContext(19, statement)); Assert.AreEqual(statement.IteratorVariable, grabber.GetContext(20, statement)); Assert.AreEqual(statement.IteratorVariable, grabber.GetContext(21, statement)); Assert.IsNull(grabber.GetContext(22, statement)); } }
public void DeleteOrder(Order order) { using (var context = new ContextGrabber()) { var orderContext = context.Orders.Find(order.OrderID); foreach (var detail in order.Details.ToList()) { var detailContext = context.OrderDetails.Find(detail.OrderDetailID); context.OrderDetails.Attach(detailContext); context.OrderDetails.Remove(detailContext); context.SaveChanges(); } context.Orders.Attach(orderContext); context.Orders.Remove(orderContext); context.SaveChanges(); } }