public IQueryable <Customer> SearchCustomers(CustomerOptions options) { if (options == null) { return(null); } var query = _context .Set <Customer>() .AsQueryable(); if (!string.IsNullOrWhiteSpace(options.FirstName)) { query = query.Where(c => c.FirstName == options.FirstName); } if (!string.IsNullOrWhiteSpace(options.VatNumber)) { query = query.Where(c => c.VatNumber == options.VatNumber); } if (options != null) { query = query.Where(c => c.Id == options.CustomerId); } if (options.CreateFrom != null) { query = query.Where(c => c.Created >= options.CreateFrom); } query = query.Take(500); return(query); }
public Customer CreateCustomer(CustomerOptions options) { if (options == null) { return(null); } if (string.IsNullOrWhiteSpace(options.VatNumber)) { return(null); } var customer = new Customer() { LastName = options.LastName, FirstName = options.FirstName, VatNumber = options.VatNumber }; _context.Add(customer); if (_context.SaveChanges() > 0) { return(customer); } return(null); }
private void ReloadEditor() { if (Transaction == null) { Name = "New transaction"; Description = string.Empty; TransactionType = TransactionTypeOptions.FirstOrDefault(); Customer = CustomerOptions.FirstOrDefault(); Date = DateTime.Now; Value = 0M; } else { Name = Transaction.Name; Description = Transaction.Description; TransactionType = TransactionTypeOptions.Where(tt => tt != null && tt.Id == Transaction.TransactionTypeId).FirstOrDefault(); if (TransactionType == null) { TransactionType = TransactionTypeOptions.FirstOrDefault(); } Customer = CustomerOptions.Where(c => c != null && c.Id == Transaction.CustomerId).FirstOrDefault(); if (Customer == null) { Customer = CustomerOptions.FirstOrDefault(); } Date = Transaction.Date; Value = Transaction.Value; } isTransactionTypeBoxDirty = false; }
public void UpdateCustomer(CustomerOptions options) { if (options == null) { throw new ArgumentNullException(); } var existingCustomer = SearchCustomers ( new CustomerOptions() { CustomerId = options.CustomerId } ).SingleOrDefault(); if (existingCustomer == null) { throw new ArgumentNullException(); } existingCustomer.IsActive = options.IsActive; existingCustomer.FirstName = options.FirstName; existingCustomer.LastName = options.LastName; existingCustomer.VatNumber = options.VatNumber; _context.SaveChanges(); }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { services.AddFakeCustomers(); var customerOptions = new CustomerOptions(); Configuration.GetSection("CustomersModule").Bind(customerOptions); services.AddSingleton(customerOptions); services.Configure <CustomerOptions>(Configuration.GetSection("CustomersModule")); // services.Configure<CustomerOptions>(Configuration); services.Configure <CookiePolicyOptions>(options => { // This lambda determines whether user consent for non-essential cookies is needed for a given request. options.CheckConsentNeeded = context => true; options.MinimumSameSitePolicy = SameSiteMode.None; }); //services.AddAuthentication("BasicAuthorization") // .AddScheme<> services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_1); }
public OrderOption CreateOrder(CustomerOptions customerOpt) { if (customerOpt == null) { return(null); } Customer customer = dbContext.Customers.Find(customerOpt.Id); if (customer == null) { return(null); } Order order = new Order { Customer = customer }; dbContext.Orders.Add(order); dbContext.SaveChanges(); OrderOption orderOption = new OrderOption { CustomerName = customer.FirstName + " " + customer.LastName, Id = order.Id }; return(orderOption); }
public CustomerOptions CreateCustomer(CustomerOptions customerOptions) { Customer customer = new Customer { FirstName = customerOptions.FirstName, LastName = customerOptions.LastName, Phone = customerOptions.Phone, Email = customerOptions.Email, VatNumber = customerOptions.VatNumber, Address = customerOptions.Address, Dob = customerOptions.Dob, CreatedDate = DateTime.Now, IsActive = true, TotalGross = 0m }; dbContext.Customers.Add(customer); dbContext.SaveChanges(); return(new CustomerOptions { FirstName = customer.FirstName, LastName = customer.LastName, Phone = customer.Phone, Email = customer.Email, VatNumber = customer.VatNumber, Address = customer.Address, Dob = customer.Dob, }); }
public async Task <IList <Certificate360> > QueryCustomer(CustomerOptions filter) { var statusTable = new DataTable(); statusTable.Columns.Add("Val", typeof(int)); if (filter.Status?.Any() ?? false) { foreach (var status in filter.Status) { statusTable.Rows.Add(status); } } var param = new DynamicParameters(); param.Add("@ID", filter.ID); param.Add("@Code", StringUtils.NullIfEmptyOrNull(filter.Code)); param.Add("@GroupCode", StringUtils.NullIfEmptyOrNull(filter.GroupCode)); param.Add("@Name", StringUtils.NullIfEmptyOrNull(filter.Name)); param.Add("@CertificateNo", StringUtils.NullIfEmptyOrNull(filter.CertificateNo)); param.Add("@Premise", StringUtils.NullIfEmptyOrNull(filter.Premise)); param.Add("@PremiseID", filter.PremiseID); param.Add("@Status", statusTable.AsTableValuedParameter("dbo.SmallIntType")); var mapper = new Certificate360Mapper(); return((await SqlMapper.QueryAsync( _unitOfWork.Connection, "SelectCustomer", new[] { typeof(Certificate360), typeof(Customer), typeof(Code), typeof(Code), typeof(Premise), typeof(Officer) }, obj => { var cert = obj[0] as Certificate360; var certCustomer = obj[1] as Customer; var certCustCode = obj[2] as Code; var certCustGroupCode = obj[3] as Code; var certPremise = obj[4] as Premise; var certCustOfficer = obj[5] as Officer; return mapper.Map(cert, certCustomer, certCustCode, certCustGroupCode, certCustOfficer, certPremise); }, param, splitOn: "ID, CustID, CustCodeID, CustCodeGroupID, PremID, OfficerID", commandType: CommandType.StoredProcedure, transaction: _unitOfWork.Transaction)).ToList()); }
public CustomerOptions AddCustomer(CustomerOptions customerOpt) { ICustomerService customerService = new CustomerService(); CustomerOptions customerOptions = customerService.CreateCustomer(customerOpt); return(customerOptions); }
public IActionResult UpdateCustomerWithDetails([FromRoute] int id) { CustomerOptions customerOptions = customerService.GetCustomerById(id); CustomerOptionModel model = new CustomerOptionModel { customer = customerOptions }; return(View(model)); }
private static void customerOptToCustomer(CustomerOptions customerOpt, Customer customer) { customer.FirstName = customerOpt.FirstName; customer.LastName = customerOpt.LastName; customer.Dob = customerOpt.Dob; customer.VatNumber = customerOpt.VatNumber; customer.Address = customerOpt.Address; customer.Email = customerOpt.Email; }
public Customer GetCustomerById(int opt) { var po = new CustomerOptions(); po.CustomerId = opt; var customer = SearchCustomers(po).SingleOrDefault(); return(customer); }
public Customer UpdateCustomer(CustomerOptions customerOpt, int id) { Customer customer = dbContext.Customers.Find(id); customer.Address = customerOpt.Address; customer.Email = customerOpt.Email; dbContext.SaveChanges(); return(customer); }
public IActionResult CreateCustomer(CustomerOptions options) { if (options == null) { return(BadRequest()); } var customer = _customerService.CreateCustomer(options); _dbContext.Add(customer); _dbContext.SaveChanges(); return(Json(customer)); }
static void Main(string[] args) { CustomerOptions customer = new CustomerOptions() { FirstName = "Anna", LastName = "Karenina" }; ICustomerService customerService = new CustomerService(); customerService.CreateCustomer(customer); CustomerOptions customer2 = new CustomerOptions() { FirstName = "Darya", LastName = "Alexandrova" }; customerService.CreateCustomer(customer2); }
public IActionResult SearchCustomers(CustomerOptions options) { if (options == null) { return(null); } var customerList = _customerService .SearchCustomers(options) .ToList(); if (customerList == null) { return(NotFound()); } return(Json(customerList)); }
public CustomerOptions UpdateCustomer(CustomerOptions customerOpt, int id) { Customer customer = dbContext.Customers.Find(id); customerOptToCustomer(customerOpt, customer); dbContext.SaveChanges(); return(new CustomerOptions { FirstName = customer.FirstName, LastName = customer.LastName, Phone = customer.Phone, Email = customer.Email, VatNumber = customer.VatNumber, Address = customer.Address, Dob = customer.Dob, }); }
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 IQueryable <Customer> SearchCustomers(CustomerOptions opt) // search function { //string optCustomerId = Convert.ToString(opt.CustomerId); //string optCustomerDateFrom = Convert.ToString(opt.CreatedFrom); //string optCustomerDateTo = Convert.ToString(opt.CreatedTo); if (opt.CustomerId != null) // ean exei dosei id o xrhsths sto UI tha epistrepsei to monadiko record { var queryId = db_ .Set <Customer>() .AsQueryable(); queryId = queryId.Where(c => c.CustomerId == opt.CustomerId); //Console.WriteLine($"id pelati einai {opt.CustomerId}"); return(queryId); } else { var query = db_ .Set <Customer>() .AsQueryable(); if (!String.IsNullOrWhiteSpace(opt.LastName)) { query = query.Where(c => c.LastName == opt.LastName); } if (!String.IsNullOrWhiteSpace(opt.FirstName)) { query = query.Where(c => c.FirstName == opt.FirstName); } if (!String.IsNullOrWhiteSpace(opt.VatNumber)) { query = query.Where(c => c.VatNumber == opt.VatNumber); } // if (!String.IsNullOrWhiteSpace(opt.CreatedFrom) && !String.IsNullOrWhiteSpace(optCustomerDateTo)) //{ // query = query.Where(c => c.Created >= opt.CreatedFrom && c.Created <= opt.CreatedTo); // } query.Take(500); return(query); } }
protected async override void OnLoad(object param) { AllowInput = false; try { IDatabaseService dbconn = new DatabaseService(); dbconn.ConnectionString = ConnectionStringsProvider.Get(); TransactionTypeOptions = await dbconn.TransactionTypeService.GetTransactionTypesAsync(); CustomerOptions = await dbconn.CustomerService.GetCustomersAsync(); var transactionsRaw = await dbconn.TransactionService.GetTransactionsAsync(); Transactions = new ObservableCollection <ITransaction>(transactionsRaw); ReloadEditor(); RaisePropertyChanged("TransactionTypeOptions"); RaisePropertyChanged("CustomerOptions"); TransactionType = TransactionTypeOptions.FirstOrDefault(); FilterTransactionType = TransactionTypeOptions.FirstOrDefault(); Customer = CustomerOptions.FirstOrDefault(); FilterCustomer = CustomerOptions.FirstOrDefault(); base.OnLoad(param); } catch (SqlException e) { MessageBox.Show("Unexpected SQL error occurred while accessing database. Details:/n" + e.ToString(), "Error", MessageBoxButton.OK, MessageBoxImage.Error); } catch (Exception) { MessageBox.Show("Unexpected error occurred while accessing database", "Error", MessageBoxButton.OK, MessageBoxImage.Error); } finally { AllowInput = true; } }
static void Main(string[] args) { CustomerOptions custOpt = new CustomerOptions { FirstName = "Mema", LastName = "Stamataki", Address = "Kallithea", VatNumber = "123456789", Email = "*****@*****.**", Phone = "6951915214", Dob = new DateTime(1993, 7, 6), }; CustomerCrud custCrud = new CustomerCrud(); Customer customer = custCrud.CreateCustomer(custOpt); Console.WriteLine($"Id = { customer.Id}" + $"FirstName = { customer.FirstName}"); Customer toFind = custCrud.GetCustomerById(1); Console.WriteLine($"Id = { toFind.Id}" + $"FirstName = { toFind.FirstName}"); }
protected async override void OnLoad(object param) { AllowInput = false; try { //BcDrawer = bcdFactory.CreateForTransactions(param as Grid); ReloadTimeStepOptions(); TimeStep = CurrentTimeStepOptions.FirstOrDefault(); IDatabaseService dbconn = new DatabaseService(); dbconn.ConnectionString = ConnectionStringsProvider.Get(); CustomerOptions = await dbconn.CustomerService.GetCustomersAsync(); data = await dbconn.TransactionService.GetTransactionsAsync(); RaisePropertyChanged("CustomerOptions"); FilterCustomer = CustomerOptions.FirstOrDefault(); IsIncome = false; ReloadBarChart(); ReloadPieChart(); base.OnLoad(param); } catch (SqlException e) { MessageBox.Show("Unexpected SQL error occurred while accessing database. Details:/n" + e.ToString(), "Error", MessageBoxButton.OK, MessageBoxImage.Error); } catch (Exception) { MessageBox.Show("Unexpected error occurred while accessing database", "Error", MessageBoxButton.OK, MessageBoxImage.Error); } finally { AllowInput = true; } }
public Customer CreateCustomer(CustomerOptions customerOptions) { Customer customer = new Customer { Address = customerOptions.Address, CreateDate = DateTime.Now, Dob = customerOptions.Dob, Email = customerOptions.Email, FirstName = customerOptions.FirstName, IsActive = true, LastName = customerOptions.LastName, Phone = customerOptions.Phone, TotalGross = 0M, VatNumber = customerOptions.VatNumber, }; using CrmAppDbContext dbContext = new CrmAppDbContext(); dbContext.Customers.Add(customer); dbContext.SaveChanges(); return(customer); }
static void Main(string[] args) { CustomerOptions custOpt = new CustomerOptions { FirstName = "Dimitris", LastName = "Dimitriou", Address = "Athens", VatNumber = "012345678", Email = "*****@*****.**", Phone = "210-74 000 111", Dob = new DateTime(1970, 12, 31), }; CustomerCrud custCrud = new CustomerCrud(); Customer customer = custCrud.CreateCustomer(custOpt); //Console.WriteLine("Id = " // + customer.Id // + " FirstName= " // + customer.FirstName); Console.WriteLine($"Id = {customer.Id} " + $"FirstName= {customer.FirstName}"); Customer toFind = custCrud.GetCustomerById(1); Console.WriteLine($"Id = {toFind.Id} " + $"FirstName= {toFind.FirstName}"); toFind = custCrud.GetCustomerById(100); if (toFind != null) { Console.WriteLine($"Id = {toFind.Id} " + $"FirstName= {toFind.FirstName}"); } }
public IActionResult Update([FromBody] CustomerOptions options) { var customer = _customerService.SearchCustomerById(options.CustomerId); if (customer == null) { return(BadRequest()); } //var customer = _customerService.SearchCustomerById(id); //if (customer == null) //{ // return BadRequest(); //} _customerService.UpdateCustomer(options); _dbContext.SaveChanges(); return(Json(customer)); }
public CustomerOptions AddCustomer([FromForm] CustomerWithFileModel customerOptWithFileModel) { if (customerOptWithFileModel == null) { return(null); } var formFile = customerOptWithFileModel.Picture; var filename = customerOptWithFileModel.Picture.FileName; if (formFile.Length > 0) { var filePath = Path.Combine(hostingEnvironment.WebRootPath, "uploadedimages", filename); using (var stream = System.IO.File.Create(filePath)) { formFile.CopyTo(stream); } } CustomerOptions customerOpt = new CustomerOptions { FirstName = customerOptWithFileModel.FirstName, LastName = customerOptWithFileModel.LastName, Address = customerOptWithFileModel.Address, Dob = customerOptWithFileModel.Dob, Email = customerOptWithFileModel.Email, Phone = customerOptWithFileModel.Phone, VatNumber = customerOptWithFileModel.VatNumber }; /// we save the picture path in the Phone field customerOpt.Phone = filename; CustomerOptions customerOptions = customerService.CreateCustomer(customerOpt); return(customerOptions); }
public SelectCustomerCommand(CustomerOptions filter) { _filter = filter; }
public async Task <IList <Certificate360> > QueryCustomer(CustomerOptions filter) { return(await Execute(new SelectCustomerCommand(filter))); }
public Customer UpdateCustomer(CustomerOptions customerOpt, int id) { return(customerService.UpdateCustomer(customerOpt, id)); }
public Customer AddCustomer(CustomerOptions customerOpt) { return(customerService.CreateCustomer(customerOpt)); }