static void Main(string[] args) { //using (var context = new TinyCrmDbContext()) //{ // ICustomerService customerService = new CustomerService( // context); // var results = customerService.CreateCustomer( // new CreateCustomerOptions() // { // FirstName = "Dimitris", // LastName = "grevenos", // Email = "*****@*****.**", // Phone = "6988776655", // VatNumber = "123456789", // IsActive = true, // }); //} using (var context = new TinyCrmDbContext()) { IProductService productService = new ProductService( context); var results = productService.CreateProduct( new CreateProductOptions() { ProductId = "AB", Name = "p1", Description = "The Product 1 is this product", ProductCategory = ProductCategory.Laptops }); } }
static void Main(string[] args) { using (var context = new TinyCrmDbContext()) { var customerService = new CustomerService(context); //var results = customerService.SearchCustomers( // new SearchCustomerOptions() // { // CustomerId = 3 // }).SingleOrDefault(); //Console.WriteLine(results.Firstname); var result = customerService.CreateCustomer(new CreateCustomerOptions { Firstname = "Thanos", Lastname = "batzelios", VatNumber = "123456789" }); Console.WriteLine(result.Firstname); //var up = customerService.UpdateCustomer(new UpdateCustomerOptions //{ // Email = "*****@*****.**" //},2); } }
public OrderService( TinyCrmDbContext contextByProgram, ICustomerService custService, IProductService prodService) { context = contextByProgram; customerService = custService; productService = prodService; }
static void Main(string[] args) { using (var context = new TinyCrmDbContext()) { ICustomerService customerService = new CustomerService( context); var customer = customerService.CreateCustomer( new CreateCustomerOptions() { Firstname = "Dimitris", Lastname = "Pnevmatikos", Vatnumber = "123456789" }); } }
static void Main(string[] args) { using (var context = new TinyCrmDbContext()) { IProductService productService = new ProductService(context); ICustomerService customerService = new CustomerService(context); IOrderService orderService = new OrderService(context, customerService, productService); var customer = customerService.CreateCustomer(new CreateCustomerOptions() { FirstName = "Dimitris", LastName = "Pnevmatikos", VatNumber = "123456789" }); } }
static void Main(string[] args) { using (var context = new TinyCrmDbContext()) { ICustomerService customerService = new CustomerService( context); var results = customerService.SearchCustomers( new SearchCustomerOptions() { CustomerId = 3 }).SingleOrDefault(); } var orderOptions = new CreateOrderOptions(); orderOptions.CustomerId = 5; orderOptions.ProductIds.Add("1312"); orderOptions.ProductIds.Add("13112312312"); }
static void Main(string[] args) { using (var context = new TinyCrmDbContext()) { ICustomerService customerService = new CustomerService(context); var customer = customerService.CreateCustomer( new CreateCustomerOptions() { Firstname = "Dimitris", LastName = "Pneumatikos", Vatnumber = "123456789" }); //IOrderService orderService = new OrderService(context, customerService); //var results = customerService.SearchCustomers(new SearchCustomerOptions() //{ // CustomerId = 3 //}).SingleOrDefault(); } }
public ProductService(TinyCrmDbContext contextByProgram) { context = contextByProgram; }
static void Main(string[] args) { using (var context = new TinyCrmDbContext()) { } }
public static IQueryable <Customer> SearchCustomers(CustomerOptions customerOptions, TinyCrmDbContext dbContext) { if (customerOptions.CreatedFrom != null && customerOptions.CreatedTo != null && customerOptions.CreatedFrom > customerOptions.CreatedTo) { return(null); } var query = dbContext.Set <Customer>().AsQueryable(); if (customerOptions.CustomerId != null) { query = query.Where(c => c.CustomerId == customerOptions.CustomerId); } if (customerOptions.VatNumber != null) { query = query.Where(c => c.VatNumber == customerOptions.VatNumber); } if (customerOptions.CreatedFrom != null) { query = query.Where(c => c.Created >= customerOptions.CreatedFrom); } if (customerOptions.CreatedTo != null) { query = query.Where(c => c.Created <= customerOptions.CreatedTo); } if (!String.IsNullOrWhiteSpace(customerOptions.FirstName)) { query = query.Where(c => c.FirstName.Contains(customerOptions.FirstName)); } if (!String.IsNullOrWhiteSpace(customerOptions.LastName)) { query = query.Where(c => c.LastName.Contains(customerOptions.LastName)); } query = query.Take(500); return(query); }
public static IQueryable <Product> SearchProducts(ProductOptions productOptions, TinyCrmDbContext dbContext) { if (productOptions.PriceFrom != null && productOptions.PriceTo != null && productOptions.PriceFrom > productOptions.PriceTo) { return(null); } var query = dbContext.Set <Product>().AsQueryable(); if (productOptions.ProductId != null) { query = query.Where(p => p.ProductId == productOptions.ProductId); } if (productOptions.Categories != null && productOptions.Categories.Any()) { query = query.Where(p => productOptions.Categories.Contains(p.Category)); } if (productOptions.PriceFrom != null) { query = query.Where(p => p.Price >= productOptions.PriceFrom); } if (productOptions.PriceTo != null) { query = query.Where(p => p.Price <= productOptions.PriceTo); } query = query.Take(500); return(query); }
static void Main(string[] args) { var dbContext = new TinyCrmDbContext(); /*var productsSeed = GetProductsFromCsv("C:\\data.csv"); * foreach (Product p in productsSeed) * { * dbContext.Add(p); * } * dbContext.SaveChanges();*/ var customerOpts = new CustomerOptions { CreatedFrom = new DateTime(2020, 5, 1), CreatedTo = new DateTime(2020, 5, 3) }; // var customer = SearchCustomers(customerOpts, dbContext).SingleOrDefault(); var customers = SearchCustomers(customerOpts, dbContext).ToList(); if (customers.Any()) { Console.WriteLine("===Customers==="); foreach (Customer c in customers) { Console.WriteLine($"| {c.CustomerId} | {c.VatNumber} | {c.FirstName} | {c.LastName} | {c.Created} |"); } } else { Console.WriteLine("Nothing Found!"); } /*var productOpts = new ProductOptions * { * Categories = new List<ProductCategory>() * { * ProductCategory.Headphones * } * }; * * var products = SearchProducts(productOpts, dbContext).ToList(); * * var order = new Order() * { * DeliveryAddress = "Unknown 123, 00000" * }; * * if (products.Any()) * { * foreach (Product p in products) * { * order.OrderProducts.Add( * new OrderProduct() * { * Product = p * }); * } * } * else * { * Console.WriteLine("Nothing Found!"); * } * * if (customer != null) * { * customer.Orders.Add(order); * dbContext.SaveChanges(); * }*/ dbContext.Dispose(); }
public CustomerService(TinyCrmDbContext context) { context_ = context; }
static void Main(string[] args) { using (var context = new TinyCrmDbContext()) { ICustomerService customerService = new CustomerService( context); // IProductService productService = new ProductService( // context); // IOrderService orderService = new OrderService( // context, customerService, productService); // CREATE CUSTOMER var customer = customerService.CreateCustomer( new CreateCustomerOptions() { //Firstname = "Sakis", //Lastname = "Batsilas", //Email = "*****@*****.**", VatNumber = "098765432" }); /* * // SEARCH CUSTOMERS * var customers = customerService.SearchCustomers( * new SearchCustomerOptions { * Firstname = "Sakis" * }).ToList(); * * // UPDATE CUSTOMERS * var customer = customerService.UpdateCustomer( * new UpdateCustomerOptions { * CustomerId = 9, * Firstname = "Kevin" * }); * * // GET CUSTOMERS BY ID * var customer = customerService.GetCustomerById( * new GetCustomerByIdOptions() { * CustomerId = 2 * }); * * // CREATE PRODUCTS * var product = productService.CreateProduct( * new CreateProductOptions() * { * ProductId = "PRCT100", * Name = "xiaomi", * Price = 60.0m, * Category = ProductCategory.Headphones, * Description = "product 100" * }); * * // SEARCH PRODUCTS * var products = productService.SearchProducts( * new SearchProductOptions * { * ProductId = "PRCT100" * }).ToList(); * * //UPDATE PRODUCTS * var customer = productService.UpdateProduct( * new UpdateProductOptions { * ProductId = "PRCT100", * Name = "lenovo", * Price = 35.0m, * Category = ProductCategory.Printers * }); * * // GET PRODUCTS BY ID * var product = productService.GetProductById( * new GetProductByIdOptions() * { * ProductId = "PDCT3" * }); * * // CREATE ORDER * var order = orderService.CreateOrder( * new CreateOrderOptions() * { * CustomerId = 2, * DeliveryAddress = "Los Angeles", * ProductIds = { "PDCT5","PDCT6","PRCT9"} * }); * * // SEARCH ORDERS * var orders = orderService.SearchOrders( * new SearchOrderOptions * { * OrderId = 5 * }).ToList(); * * //UPDATE ORDERS * var orders = orderService.UpdateOrder( * new UpdateOrderOptions * { * OrderId = 2, * DeliveryAddress = "Krania" * }); */ } }
public CustomerService(TinyCrmDbContext contextByProgram) { context = contextByProgram; }