public void CopyToCustomer(Customer c) { c.number = Number; c.name = Name; c.address = Address; c.mobile = Mobile; }
public OrderClothesUI(Order _order,Bag _bag,Customer _customer,Clothes _chonseClothes) { this.order = _order; this.bag = _bag; this.customer = _customer; this.chonseClothes = _chonseClothes; }
public void CopyFromCustomer(Customer c) { Number = c.number; Name = c.name; Address = c.address; Mobile = c.mobile; }
public static bool IsCustomerContentSame(Customer a, Customer b) { return a.number == b.number && a.name == b.name && a.address == b.address && a.mobile == b.mobile; }
// Hàm khởi tạo sử dụng để thêm mới đơn đặt hàng public Order(Bag _bag, Customer _customer, string _date) { this.bag = _bag; this.customer = _customer; this.date = _date; ConnectDB db = new ConnectDB(); //Lấy ID của khách hàng vừa tạo string customerID = db.GetData("Select Top 1 ID from [dbo].[Customer] order by ID desc", "ID", ""); // Sử dụng ID vừa lấy, thêm dữ liệu Order vào CSDL SqlParameter[] b = new SqlParameter[4]; b[0] = new SqlParameter("@CustomerID", customerID); b[1] = new SqlParameter("@TotalPrice", bag.totalPrice); b[2] = new SqlParameter("@Date", DateTime.Now.ToString("MM/dd/yyyy")); b[3] = new SqlParameter("@Status", "1"); db.ExecuteCommand("Order_Insert", b); // Lấy ID của Order vừa thêm vào bên trên string orderID = db.GetData("Select Top 1 ID from [dbo].[Order] order by ID desc", "ID", ""); if (orderID == null) orderID = "1"; // Sử dụng ID vừa lấy, thêm dữ liệu vào bảng OrderDetail SqlParameter[] a = new SqlParameter[3]; foreach (Clothes item in _bag.listClothes) { a[0] = new SqlParameter("@OrderID", orderID); a[1] = new SqlParameter("@ClothesID", item.ID); a[2] = new SqlParameter("@Quantity", item.Quantity); db.ExecuteCommand("OrderDetail_Insert", a); } }
public OrderControl(Order _order,Bag _bag,Customer _customer,Cloth _chonseClothes) { this.order = _order; this.bag = _bag; this.customer = _customer; this.chonseCloth = _chonseClothes; }
private void UpdateCustomer(EditableCustomer target,Customer customer) { customer.FirstName = target.FirstName; customer.LastName = target.LastName; customer.Phone = target.Phone; customer.Email = target.Email; }
public void SetCustomer(Customer customer) { _editingCustomer = customer; Customer = new EditableCustomer(); CopyCustomer(customer, Customer); if (Customer != null) Customer.ErrorsChanged -= RaiseCanExecuteChanged; Customer.ErrorsChanged += RaiseCanExecuteChanged; }
private void AddOperation() { if (!CheckCustomerRecord(false) || !IsNameValid() || !IsAddressValid() || !IsMobileValid()) return; var custRecord = new Customer(); _c.CopyToCustomer(custRecord); _dbOps.AddCustomer(custRecord); _c.Message = CustomerAdded; }
private void OnGetData( object sender, RoutedEventArgs e ) { Customer.AddProperty("count", typeof(int)); Customer.AddProperty("name", typeof(string)); Customer cust = new Customer(counter + 1); cust["count"] = counter; cust["name"] = "test"; Customers.Add(cust); }
public async Task<Customer> UpdateCustomerAsync(Customer customer) { if (!_context.Customers.Local.Any(c => c.Id == customer.Id)) { _context.Customers.Attach(customer); } _context.Entry(customer).State = EntityState.Modified; await _context.SaveChangesAsync(); return customer; }
public void CopyCustomer(Customer customer, EditableCustomer target) { target.Id = customer.Id; if (EditMode) { target.FirstName = customer.FirstName; target.LastName = customer.LastName; target.Phone = customer.Phone; target.Email = customer.Email; } }
public void CheckThatNumberUnique() { var c = CreateNewCustomer(); var duplicateCustomer = new Customer() { number = c.number, name = Name1 + "a", address = Address1, mobile = Mobile1 }; DbCtx.Customers.Add(c); DbCtx.Customers.Add(duplicateCustomer); DbCtx.SaveChanges(); }
public static void Main() { var newCustomer = new Customer() { CustomerID = "XASDa", ContactName = "Pesho", CompanyName = "Telerik" }; DataAccess.InsertCustomer(newCustomer); Console.WriteLine("Customer inserted!"); DataAccess.ChangeCustomerContactName(newCustomer.CustomerID, "Ivan"); Console.WriteLine("Customer contact Name changed!"); DataAccess.DeleteCustomer(newCustomer.CustomerID); Console.WriteLine("Customer deleted!"); Console.WriteLine(new string('-', 50)); var customers = DataAccess.FindCustomersWithOrdersInYearAndCountry(1997, "Canada"); // Only for test, do not do it N+1 problem. customers .ForEach(c => { Console.WriteLine($"Contact Name: {c.ContactName}," + $" From: {c.Country}," + $" Has order in: {c.Orders.FirstOrDefault(o => o.OrderDate.Value.Year == 1997).OrderDate.Value.Year}"); }); customers = DataAccess.FindCustomersWithOrdersInYearAndCountryWithDbCommand(1997, "Canada"); Console.WriteLine(new string('-', 50)); customers .ForEach(c => { Console.WriteLine($"Contact Name: {c.ContactName}," + $" From: {c.Country},"); }); Console.WriteLine(new string('-', 50)); var region = "RJ"; var startDate = new DateTime(1996, 6, 3); var endDate = new DateTime(1997, 6, 3); var filterdOrders = DataAccess.FindSales(region, startDate, endDate); filterdOrders.ForEach(o => Console.WriteLine($"OrderId: {o.OrderID}," + $" Region: {o.ShipRegion}," + $" Order date: {o.OrderDate}")); }
public void Compare_Equal_Customers() { var customerA = new Customer { Id = 0, FirstName = "Adelia", LastName = "Kessler", Address = new Address { Street = "16256 Reichel Plains", City = "Ryanbury", State = "VA", Zip = "58851" } }; var customerB = new Customer { Id = 0, FirstName = "Adelia", LastName = "Kessler", Address = new Address { Street = "16256 Reichel Plains", City = "Ryanbury", State = "VA", Zip = "58851" } }; var hash1 = customerA.ToMd5Hash(); var hash2 = customerB.ToMd5Hash(); Assert.AreEqual(hash1, hash2); Assert.AreEqual("21E1C0AA0002E52DE403735EC0C19E94", hash1); Assert.AreEqual("21E1C0AA0002E52DE403735EC0C19E94", hash2); }
public void Compare_UnEqual_Customers() { var customerA = new Customer { Id = 0, FirstName = "Adelia", LastName = "Kessler", Address = new Address { Street = "16256 Reichel Plains", City = "Ryanbury", State = "VA", Zip = "58851" } }; var customerB = new Customer { Id = 1, FirstName = "Melissa", LastName = "Labadie", Address = new Address { Street = "4751 Johan Landing", City = "East Bettye", State = "SD", Zip = "54538" } }; var hash1 = customerA.ToMd5Hash(); var hash2 = customerB.ToMd5Hash(); Assert.AreNotEqual(hash1, hash2); Assert.AreEqual("21E1C0AA0002E52DE403735EC0C19E94", hash1); Assert.AreEqual("377D1122C74D414DE7ECC71932E94367", hash2); }
/// <summary> /// Deprecated Method for adding a new object to the Customers EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToCustomers(Customer customer) { base.AddObject("Customers", customer); }
private void NavToAdd(Customer customer) { _addEditCustomerViewModel.EditMode = false; _addEditCustomerViewModel.SetCustomer(customer); CurrentViewModel = _addEditCustomerViewModel; }
private void NavToEdit(Customer customer) { _addEditCustomerViewModel.EditMode = true; _addEditCustomerViewModel.SetCustomer(customer); CurrentViewModel = _addEditCustomerViewModel; }
private void AddThisRecord(Customer c) { Console.WriteLine("adding {0}", c); _sut.Perform(() => _sut.Current.Customers.Add(c)); }
public void Customer_To_MD5_Hash() { var customer = new Customer { Id = 0, FirstName = "Adelia", LastName = "Kessler", Address = new Address { Street = "16256 Reichel Plains", City = "Ryanbury", State = "VA", Zip = "58851" } }; var hash1 = customer.ToMd5Hash(); customer.FirstName = "Adeliaa"; var hash2 = customer.ToMd5Hash(); Assert.AreEqual("21E1C0AA0002E52DE403735EC0C19E94", hash1); Assert.AreEqual("356264B04B09A4DCDC009746D2185A66", hash2); }
partial void DeleteCustomer(Customer instance);
public void AddCustomer(Customer c) { }
partial void InsertCustomer(Customer instance);
protected override void Seed(LocalStoreContext context) { Customer customer1 = new Customer() { CreditCardNumber = "1234567", Email = "*****@*****.**", Name = "User" }; Customer customer2 = new Customer() { CreditCardNumber = "0123456", Email = "*****@*****.**", Name = "User2" }; Customer customer3 = new Customer() { CreditCardNumber = "11111", Email = "*****@*****.**", Name = "User3" }; Customer customer4 = new Customer() { CreditCardNumber = "4444", Email = "*****@*****.**", Name = "User4" }; Customer customer5 = new Customer() { CreditCardNumber = "5555", Email = "*****@*****.**", Name = "User5" }; context.Customers.Add(customer1); context.Customers.Add(customer2); context.Customers.Add(customer3); context.Customers.Add(customer4); context.Customers.Add(customer5); Product product1 = new Product() { ProductName = "Mlqko", Price = 10.00m, Quantity = 1 }; Product product2 = new Product() { ProductName = "Qica", Price = 12.00m, Quantity = 12 }; Product product3 = new Product() { ProductName = "Sol", Price = 110.00m, Quantity = 1 }; Product product4 = new Product() { ProductName = "Qgoda", Price = 0.09m, Quantity = 11232 }; Product product5 = new Product() { ProductName = "Krusha", Price = 9.99m, Quantity = 1 }; context.Products.Add(product1); context.Products.Add(product2); context.Products.Add(product3); context.Products.Add(product4); context.Products.Add(product5); StoreLocation location1 = new StoreLocation() { Location = "Carefurr" }; StoreLocation location2 = new StoreLocation() { Location = "Kaufland" }; StoreLocation location3 = new StoreLocation() { Location = "Pazar" }; StoreLocation location4 = new StoreLocation() { Location = "Triumf" }; StoreLocation location5 = new StoreLocation() { Location= "Banq" }; context.StoreLocations.Add(location1); context.StoreLocations.Add(location2); context.StoreLocations.Add(location3); context.StoreLocations.Add(location4); context.StoreLocations.Add(location5); Sale sale1 = new Sale() { Customer = customer1, Date = new DateTime(2017, 03, 03), Product = product1, StoreLocation = location1 }; Sale sale2 = new Sale() { Customer = customer1, Date = new DateTime(2017, 03, 03), Product = product2, StoreLocation = location1 }; Sale sale3 = new Sale() { Customer = customer2, Date = new DateTime(2016, 03, 03), Product = product1, StoreLocation = location2 }; Sale sale4 = new Sale() { Customer = customer2, Date = new DateTime(2016, 03, 03), Product = product2, StoreLocation = location2 }; Sale sale5 = new Sale() { Customer = customer1, Date = new DateTime(2016, 03, 03), Product = product3, StoreLocation = location1 }; context.Sales.Add(sale1); context.Sales.Add(sale2); context.Sales.Add(sale3); context.Sales.Add(sale4); context.Sales.Add(sale5); context.SaveChanges(); base.Seed(context); }
/// <summary> /// Create a new Customer object. /// </summary> /// <param name="customerId">Initial value of the CustomerId property.</param> /// <param name="customerName">Initial value of the CustomerName property.</param> /// <param name="discountGroupId">Initial value of the DiscountGroupId property.</param> public static Customer CreateCustomer(global::System.Int32 customerId, global::System.String customerName, global::System.Int32 discountGroupId) { Customer customer = new Customer(); customer.CustomerId = customerId; customer.CustomerName = customerName; customer.DiscountGroupId = discountGroupId; return customer; }
public Customer FindCustomer(string usename, string password) { ConnectDB db = new ConnectDB(); Customer customer = new Customer(); string query = "select * from Customer where UserName like N'%" + usename + "%' and [Password] like N'%" + password + "%'"; DataTable dt = null; dt = db.ReturnDataTable_NonParameter(query); if (dt == null) return null; DataRow dr = dt.Rows[0]; customer.id = dr["ID"].ToString(); customer.name = dr["Name"].ToString(); customer.email = dr["Email"].ToString(); customer.address = dr["Address"].ToString(); customer.phoneNumber = dr["PhoneNumber"].ToString(); customer.userName = dr["UserName"].ToString(); customer.passWord = dr["Password"].ToString(); customer.rule = dr["Rule"].ToString(); return customer; }
partial void UpdateCustomer(Customer instance);
public async Task<Customer> AddCustomerAsync(Customer customer) { _context.Customers.Add(customer); await _context.SaveChangesAsync(); return customer; }
// Hàm tạo đơn hàng public void createOrder(string _name,string _email,string _address,string _phonenumber) { string date = ""; customer = new Customer(_name, _email, _address, _phonenumber); order = new Order(bag, customer, date); }
private void OnEdit(Customer customer) { EditCustomerRequested(customer); }