/// <summary> /// Saves the customer. /// </summary> /// <param name="customer">The customer.</param> public void SaveCustomer(Customer customer) { var filter = Builders <CustomerDO> .Filter.Eq(r => r.ExternalId, customer.Id); CustomerDO customerDO = this.Customers.Find(filter).FirstOrDefault(); if (customerDO == null) { this.Customers.InsertOne(new CustomerDO() { ExternalId = customer.Id, IdCard = customer.IdCard, Name = customer.Name, Surname = customer.Surname, Balance = 0, }); } else { customerDO.IdCard = customer.IdCard; customerDO.Name = customer.Name; customerDO.Surname = customer.Surname; this.Customers.ReplaceOne(filter, customerDO); } }
public Customer GetCustomerByCustomerID(int customerID) { CustomerDO customerDAL = new CustomerDO(); Customer customer = customerDAL.GetCustomerByCustomerID(customerID); return(customer); }
public List <Customer> SearchCustomersByFirstNameOrLastName(string FirstName, string LastName) { CustomerDO customerDAL = new CustomerDO(); List <Customer> customers = customerDAL.SearchCustomersByFirstNameOrLastName(FirstName, LastName); return(customers); }
public void UpdateCustomer(Customer customer) { CustomerDO customerDO = new CustomerDO(); customerDO.UpdateCustomer(customer); return; }
public List <Customer> GetCustomersByLastName(string LastName) { CustomerDO customerDAL = new CustomerDO(); List <Customer> customers = customerDAL.GetCustomersByLastName(LastName); return(customers); }
public List <Customer> GetCustomersByFirstNameAndLastName(string FirstName, string LastName) { CustomerDO customerDAL = new CustomerDO(); List <Customer> customers = customerDAL.GetCustomersByFirstNameAndLastName(FirstName, LastName); return(customers); }
public int AddCustomer(CustomerDO customer) { // Check if customer of same name exists if (db.Customers.ToList().Exists(c => c.Name.ToLower() == customer.Name.ToLower())) { return(0); } db.Customers.Add(customer); db.SaveChanges(); return(customer.CustomerId); }
public List <Customer> GetCustomers() { CustomerDO customerDAL = new CustomerDO(); List <Customer> customers = new List <Customer>(); try { customers = customerDAL.GetCustomers(); if (customers == null) { customers = new List <Customer>(); customers.Add(new Customer { customerID = 1, firstName = "Fred", lastName = "Flinstone", middleInitial = "", name = "Fred Flinstone", address1 = "", address2 = "", city = "Bedrock", state = "A place right out of History", zip = "", address = "Bedrock, A place right out of History" }); customers.Add(new Customer { customerID = 2, firstName = "Wilma", lastName = "Flinstone", middleInitial = "", name = "Wilma Flinstone", address1 = "", address2 = "", city = "Bedrock", state = "A place right out of History", zip = "", address = "Bedrock, A place right out of History" }); } else { FormatCustomers(ref customers); } } catch (Exception ex) { throw; } return(customers); }
public decimal GetAvailableFunds(int customerId) { var filter = Builders <CustomerDO> .Filter.Eq(r => r.ExternalId, customerId); CustomerDO customer = this.Customers.Find(filter).FirstOrDefault(); if (customer == null) { throw new AccountNotFound(); } return(customer.Balance); }
public async Task <ActionResult> Register(RegisterViewModel model) { if (ModelState.IsValid) { var user = new ApplicationUser { UserName = model.Email, Email = model.Email }; var result = await UserManager.CreateAsync(user, model.Password); try { if (result.Succeeded) { CustomerDO dataModel = new CustomerDO(); dataModel.FirstName = model.FirstName; dataModel.LastName = model.LastName; dataModel.Contact = model.Contact; dataModel.City_ID = model.City_ID; dataModel.User_ID = user.Id; //dataModel.UpdatedDate = model.UpdatedDate; CustomerManagement customerManagement = new CustomerManagement(); customerManagement.CreateUser(dataModel); RegisterViewModel modelData = new RegisterViewModel(); modelData.Cities = getCityDropDownData(); UserManager.AddToRole(user.Id, "Customer"); await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false); // For more information on how to enable account confirmation and password reset please visit https://go.microsoft.com/fwlink/?LinkID=320771 // Send an email with this link // string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id); // var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme); // await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>"); return(RedirectToAction("Index", "Home")); } } catch (Exception e) { Console.WriteLine(e); } AddErrors(result); } // If we got this far, something failed, redisplay form return(View(model)); }
public void WithdrawFunds(int customerId, decimal funds) { var filter = Builders <CustomerDO> .Filter.Eq(r => r.ExternalId, customerId); CustomerDO customerDO = this.Customers.Find(filter).FirstOrDefault(); if (customerDO == null) { throw new AccountNotFound(); } var update = Builders <CustomerDO> .Update.Set(x => x.Balance, customerDO.Balance - funds); var result = this.Customers.UpdateOneAsync(filter, update).Result; }
public void CreateUser(CustomerDO dataModel) { SqlCommand cmd = new SqlCommand("insert into Customer values(@FirstName, @LastName, @Contact, @City_ID, @User_ID)", conn); cmd.Parameters.AddWithValue("@FirstName", dataModel.FirstName); cmd.Parameters.AddWithValue("@LastName", dataModel.LastName); cmd.Parameters.AddWithValue("@Contact", dataModel.Contact); cmd.Parameters.AddWithValue("@City_ID", dataModel.City_ID); cmd.Parameters.AddWithValue("@User_ID", dataModel.User_ID); //cmd.Parameters.AddWithValue("@UpdatedDate", dataModel.UpdatedDate); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }
public List <Customer> GetCustomers() { CustomerDO customerDAL = new CustomerDO(); List <Customer> customers = new List <Customer>(); try { customers = customerDAL.GetCustomers(); if (customers == null) { customers = new List <Customer>(); customers.Add(new Customer { CustomerID = 1, FirstName = "Fred", LastName = "Flinstone", MiddleInitial = "", Address1 = "", Address2 = "", City = "Bedrock", State = "A place right out of History", Zip = "" }); customers.Add(new Customer { CustomerID = 2, FirstName = "Wilma", LastName = "Flinstone", MiddleInitial = "", Address1 = "", Address2 = "", City = "Bedrock", State = "A place right out of History", Zip = "" }); } } catch (Exception ex) { throw; } return(customers); }
public void GetCustomersAccess(object sender, System.EventArgs e) { CustomerDO customerDO = new CustomerDO(); List <CustomerRow> customerRows = customerDO.GetCustomers(); if (customerRows != null) { if (customerRows.Count > 0) { foreach (CustomerRow customerRow in customerRows) { bindingSource1.Add(customerRow); } } } // BuildCustomerGrid(); }
/// <summary> /// Gets the customer. /// </summary> /// <param name="id">The identifier.</param> /// <returns></returns> public Customer GetCustomer(int id) { var filter = Builders <CustomerDO> .Filter.Eq(r => r.ExternalId, id); CustomerDO customer = this.Customers.Find(filter).FirstOrDefault(); if (customer == null) { throw new AccountNotFound(); } return(new Customer() { Id = customer.ExternalId, IdCard = customer.IdCard, Name = customer.Name, Surname = customer.Surname, }); }
public void UpdatePhotos() { CustomerDO customerDO = new CustomerDO(); //customerDO.saveImage(@"C:\Dev\React\ReactTraining\Full Stack - AG-Grid\API\Images", "face2.jpg", 1699); //customerDO.saveImage(@"C:\Dev\React\ReactTraining\Full Stack - AG-Grid\API\Images", "face1.jpg", 1700); //customerDO.saveImage(@"C:\Dev\React\ReactTraining\Full Stack - AG-Grid\API\Images", "face7.jpg", 1701); //customerDO.saveImage(@"C:\Dev\React\ReactTraining\Full Stack - AG-Grid\API\Images", "face9.jpg", 1701); //customerDO.saveImage(@"C:\Dev\React\ReactTraining\Full Stack - AG-Grid\API\Images", "face4.jpg", 1703); //customerDO.saveImage(@"C:\Dev\React\ReactTraining\Full Stack - AG-Grid\API\Images", "face5.jpg", 1704); //customerDO.saveImage(@"C:\Dev\React\ReactTraining\Full Stack - AG-Grid\API\Images", "face6.jpg", 1705); //customerDO.saveImage(@"C:\Dev\React\ReactTraining\Full Stack - AG-Grid\API\Images", "face8.jpg", 1706); //customerDO.saveImage(@"C:\Dev\React\ReactTraining\Full Stack - AG-Grid\API\Images", "face3.jpg", 1707); //customerDO.saveImage(@"C:\Dev\Web Services\WebAPI\SampleWebApi\SampleDemoWebApi\Images", "FemaleSillouette.jpg", 1708); // customerDO.saveImage(@"C:\Dev\Web Services\WebAPI\SampleWebApi\SampleDemoWebApi\Images", "generic.png", -1); //customerDO.saveImage(@"C:\Dev\Web Services\WebAPI\SampleWebApi\SampleDemoWebApi\Images", "Female2.jpg", -2); customerDO.saveImage(@"C:\Dev\Web Services\WebAPI\SampleWebApi\SampleDemoWebApi\Images", "MaleSillouette.png", -3); }
public void RetrievePhotos() { CustomerDO customerDO = new CustomerDO(); Image mike = customerDO.getImage(); }