public void CustomerCountTest() { ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString()); var context = cRUDTestDBContextProvider.GetContext(); var customer = new Customer { CustomerId = 1, SupportRepId = 1, FirstName = "TestFirst", LastName = "TestLast", Email = "Test" }; var customer2 = new Customer { CustomerId = 2, FirstName = "Test2First", LastName = "Test2Last", Email = "2Test" }; var employee = new Employee { EmployeeId = 1, FirstName = "TesteFirst", LastName = "TesteLast", Email = "eTest" }; context.Add(customer); context.Add(customer2); context.Add(employee); context.SaveChanges(); EmployeeBE employeeBE = new EmployeeBE(cRUDTestDBContextProvider); employeeBE.Load(1); Assert.IsTrue(employeeBE.CustomerCount == 1); CustomerBE customerBE = new CustomerBE(cRUDTestDBContextProvider); customerBE.Load(2); employeeBE.AddToCustomer(customerBE); customerBE.Save(); EmployeeBE employeeBE2 = new EmployeeBE(cRUDTestDBContextProvider); employeeBE2.Load(1); Assert.IsTrue(employeeBE2.CustomerCount == 2); }
public void InvoiceCountTest() { ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString()); var context = cRUDTestDBContextProvider.GetContext(); var invoiceInvoiceCountTest = new Invoice { InvoiceId = 1, CustomerId = 1 }; var customerInvoiceCountTest = new Customer { CustomerId = 1 }; context.Add(invoiceInvoiceCountTest); context.Add(customerInvoiceCountTest); context.SaveChanges(); CustomerBE customerBE = new CustomerBE(cRUDTestDBContextProvider); customerBE.Load(1); Assert.IsTrue(customerBE.InvoiceCount == 1); InvoiceBE invoiceBE = new InvoiceBE(cRUDTestDBContextProvider); invoiceBE.New(); customerBE.AddToInvoice(invoiceBE); invoiceBE.Save(); CustomerBE customerBE2 = new CustomerBE(cRUDTestDBContextProvider); customerBE2.Load(1); Assert.IsTrue(customerBE2.InvoiceCount == 2); }
public void AddToCustomersTest() { ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString()); var context = cRUDTestDBContextProvider.GetContext(); var customer = new Customer { CustomerId = 1, FirstName = "TestFirst", LastName = "TestLast", Email = "Test" }; var employee = new Employee { EmployeeId = 1, FirstName = "TesteFirst", LastName = "TesteLast", Email = "eTest" }; context.Add(customer); context.Add(employee); context.SaveChanges(); CustomerBE customerBE = new CustomerBE(cRUDTestDBContextProvider); EmployeeBE employeeBE = new EmployeeBE(cRUDTestDBContextProvider); employeeBE.Load(1); customerBE.Load(1); employeeBE.AddToCustomer(customerBE); customerBE.Save(); employeeBE.Load(1); var customerBECollection = employeeBE.GetCustomers(); Assert.IsTrue(customerBECollection.First().Id == 1); Assert.IsTrue(customerBECollection.First().SupportRepId == 1); }
public List <CustomerBE> GetAllCustomers() { List <CustomerBE> list = new List <CustomerBE>(); _mDataAcess.Open(); try { string sql = "select * from Customer"; IDataReader reader = _mDataAcess.GetReader(sql); while (reader.Read()) { CustomerBE customer = new CustomerBE(); customer.CustomerId = reader.GetInt32(0); customer.CustomerName = reader.GetString(1); customer.CustomerGender = reader.GetBoolean(2); int addressId = reader.GetInt32(3); AddressBE address = (new AddressDA()).GetById(addressId); customer.Address = address; list.Add(customer); } } catch (Exception e) { ILog log = log4net.LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType); log.Error("error", e); } finally { _mDataAcess.Close(); } return(list); }
public void AddToInvoiceTest() { ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString()); var context = cRUDTestDBContextProvider.GetContext(); var customerAddToInvoiceTest = new Customer { CustomerId = 1 }; var invoiceAddToInvoiceTest = new Invoice { InvoiceId = 1, Total = 20 }; context.Add(customerAddToInvoiceTest); context.Add(invoiceAddToInvoiceTest); context.SaveChanges(); CustomerBE customerBE = new CustomerBE(cRUDTestDBContextProvider); InvoiceBE invoiceBE = new InvoiceBE(cRUDTestDBContextProvider); invoiceBE.Load(1); customerBE.Load(1); customerBE.AddToInvoice(invoiceBE); invoiceBE.Save(); customerBE.Load(1); var InvoiceBECollection = customerBE.GetInvoices().Where(p => p.Id == 1); Assert.IsTrue(InvoiceBECollection.First().Id == 1); Assert.IsTrue(InvoiceBECollection.First().CustomerID == 1); }
public void GetAllTripsTest() { CustomerBE cbe = new CustomerBE(); List <Contract.dto.Trip> l = cbe.GetAllTrips(); Assert.AreNotEqual(0, l.Count); }
public void GetInvoicesTest() { ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString()); var context = cRUDTestDBContextProvider.GetContext(); var invoiceGetInvoicesTest = new Invoice { InvoiceId = 1, CustomerId = 1, Total = 10 }; var customerGetInvoicesTest = new Customer { CustomerId = 1 }; var customer2GetInvoicesTest = new Customer { CustomerId = 2 }; context.Add(invoiceGetInvoicesTest); context.Add(customerGetInvoicesTest); context.Add(customer2GetInvoicesTest); context.SaveChanges(); CustomerBE customerBE = new CustomerBE(cRUDTestDBContextProvider); CustomerBE customerBE2 = new CustomerBE(cRUDTestDBContextProvider); customerBE.Load(1); customerBE2.Load(2); var invoiceBECollection = customerBE.GetInvoices(); Assert.IsTrue(invoiceBECollection.First().GetType() == typeof(InvoiceBE)); Assert.IsTrue(invoiceBECollection.First().Total == 10); Assert.IsTrue(invoiceBECollection.First().Id == 1); Assert.IsTrue(customerBE2.GetInvoices().IsNullOrEmpty()); }
public List <CustomerBE> GetAllCustomerType() { List <CustomerBE> customersType = new List <CustomerBE>(); using (_connection = new SqlConnection(_connectionString)) { var query = "SELECT * FROM CustomerType"; SqlCommand command = new SqlCommand(query, _connection); try { _connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { CustomerBE customerType = new CustomerBE(); customerType.CustomerTypeID = Convert.ToInt32(reader["CustomerTypeID"]); customerType.CustomerTypeName = Convert.ToString(reader["CustomerTypeName"]); //Adding object to the list customersType.Add(customerType); } reader.Close(); return(customersType); } catch (Exception) { throw; } } }
/// <summary> /// Translate customerDE to customerBE /// </summary> /// <param name="customerDE"></param> /// <returns></returns> public CustomerBE Translate(Customer customerDE) { if (customerDE != null) { CustomerBE customerBE = new CustomerBE() { CustomerId = customerDE.CustomerId, CustomerName = customerDE.CustomerName, CustomerGender = customerDE.CustomerGender, Address = new AddressBE() { AddressId = customerDE.Address.AddressId, Country = customerDE.Address.Country, Province = customerDE.Address.Province, City = customerDE.Address.City, DetailAddress = customerDE.Address.Address1, }, }; return(customerBE); } else { return(null); } }
protected void Button1_Click(object sender, EventArgs e) { Proxy service = new Proxy(); string id = this.labId.Text; string name = this.txCustomerName.Text.ToString().Trim(); int genderInt = Convert.ToInt32(this.rblGender.SelectedValue); bool gender = genderInt == 1 ? true : false; int addressId = Convert.ToInt32(this.dropListAddresses.SelectedValue); CustomerBE customer = new CustomerBE(); customer.CustomerName = name; customer.CustomerGender = gender; AddressBE address = new AddressBE(); address.AddressId = addressId; address.City = "City"; address.Country = "Country"; address.DetailAddress = "Detail"; address.Province = "Province"; customer.Address = address; if (id != "") { customer.CustomerId = Convert.ToInt32(id); service.UpdateCustomer(customer); } else { service.InsertCustomer(customer); } Response.Redirect("CustomerList.aspx"); }
protected void Page_Load(object sender, EventArgs e) { Proxy service = new Proxy(); if (!IsPostBack) { this.dropListAddresses.DataSource = service.GetAllAddresses();// Post back this.dropListAddresses.DataTextField = "Country"; this.dropListAddresses.DataValueField = "AddressId"; this.dropListAddresses.DataBind(); } string id = Request.QueryString["id"]; if (id != null && this.labMethod.Text == "") { CustomerBE customer = service.GetCustomerById(Convert.ToInt32(id)); this.txCustomerName.Text = customer.CustomerName; if (customer.CustomerGender) { this.rblGender.SelectedValue = "1"; } else { this.rblGender.SelectedValue = "0"; } this.dropListAddresses.SelectedValue = customer.Address.AddressId.ToString(); this.btnCreateNewCustomer.Text = "Update"; this.labId.Text = id; this.labMethod.Text = "Update"; } }
public CustomerBE GetById(int id) { CustomerBE customer = new CustomerBE(); _mDataAcess.Open(); try { string sql = "select * from Customer where CustomerId=@CustomerId"; QueryParameter p = new QueryParameter(Id, id, DbType.Int32); IDataReader reader = _mDataAcess.GetReader(sql, p); while (reader.Read()) { customer.CustomerId = id; customer.CustomerName = reader.GetString(1); customer.CustomerGender = reader.GetBoolean(2); int addressId = reader.GetInt32(3); AddressBE address = _mAddressDA.GetById(addressId); customer.Address = address; } } catch (Exception e) { ILog log = log4net.LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType); log.Error("error", e); } finally { _mDataAcess.Close(); } return(customer); }
public bool Update(CustomerBE customer) { bool result = true; _mDataAcess.Open(); try { string sql = "update Customer set CustomerName=@CustomerName, CustomerGender=@CustomerGender, AddressId=@AddressId where CustomerId=@CustomerId"; QueryParameter[] list = new QueryParameter[4]; list[0] = new QueryParameter(Name, customer.CustomerName, DbType.String); list[1] = new QueryParameter(Gender, customer.CustomerGender, DbType.Boolean); list[2] = new QueryParameter(AddressId, customer.Address.AddressId, DbType.Int32); list[3] = new QueryParameter(Id, customer.CustomerId, DbType.Int32); int i = _mDataAcess.ExecuteNonQuery(sql, list); if (i == 0) { result = false; } else { result = true; } } catch (Exception e) { ILog log = log4net.LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType); log.Error("error", e); } finally { _mDataAcess.Close(); } return(result); }
public void GetAllVehiclesTest() { CustomerBE cbe = new CustomerBE(); List <Contract.dto.Vehicle> l = cbe.GetAllVehicles(); Assert.IsTrue(l.Count >= 1); }
/// <summary> /// Inserts the customer. --Robin /// </summary> /// <param name="customerBE">The customer BE.</param> /// <returns></returns> public bool InsertCustomer(CustomerBE customerBE) { InsertCustomerRequest request = new InsertCustomerRequest(); request.MyCustomer = customerBE; InsertCustomerResponse response = MyChannelFactory.CreateChannel().InsertCustomer(request); return(!response.IsFailed); }
public void CreateCustomerTest() { CustomerBE cbe = new CustomerBE(); Contract.dto.Customer c = UnitTest.TestHelpers.randomCustomer(); c.CustomerId = 0; Assert.IsTrue(cbe.CreateCustomer(c)); }
/// <summary> /// Translate customerBE to customerDE /// </summary> /// <param name="customerBE"></param> /// <returns></returns> public Customer Translate(CustomerBE customerBE) { Customer customerDE = new Customer(); customerDE.CustomerId = customerBE.CustomerId; customerDE.CustomerName = customerBE.CustomerName; customerDE.CustomerGender = customerBE.CustomerGender; customerDE.AddressId = customerBE.Address.AddressId; return(customerDE); }
public void CreateCustomerReservationTest() { CustomerBE cbe = new CustomerBE(); Contract.dto.Reservation r = cbe.CreateCustomerReservation( UnitTest.TestHelpers.randomTrip(), UnitTest.TestHelpers.randomCustomer(), 24.3, UnitTest.TestHelpers.GenerateRandomId(1, 10), UnitTest.TestHelpers.randomVehicle() ); Assert.AreNotEqual(0, r.ReservationId); }
public void SaveWithoutIdTest() { ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString()); CustomerBE customerBE = new CustomerBE(cRUDTestDBContextProvider); customerBE.New(); customerBE.FirstName = "TestFirstName"; customerBE.LastName = "TestLastName"; customerBE.Email = "*****@*****.**"; customerBE.Save(); Assert.IsTrue(customerBE.Id != default); }
public ActionResult Registration(CustomerBE s) { int res = ob.Registration(s); if (res > 0) { ViewData["status"] = " Registered successfully "; } else { ViewData["status"] = "CustID already Exists"; } return(View()); }
/// <summary> /// Insert a customer /// </summary> /// <param name="dbEntity"> Database Entity Container</param> /// <param name="customerBE">Customer DataEntity</param> public bool Insert(TTAEntityContainer dbEntity, CustomerBE customerBE) { dbEntity.AddToCustomers((new CustomerTranslator()).Translate(customerBE)); int result = dbEntity.SaveChanges(); if (result == 1) { return(true); } else { return(false); } }
public Customer(CustomerBE c) { Id = c.Id; Name = c.Name; Address = c.Address; ZipCode = c.ZipCode; City = c.City; Email = c.Email; Phone = c.Phone; Accounts = new List <BankAccount>(); foreach (BankAccountBE acc in c.Accounts) { Accounts.Add(new BankAccount(acc)); } }
public async Task <CustomerBE> RecuperarPorDni(string nroDocumento) { CustomerBE customerBE = null; var res = await(from x in _clienteContext.Cliente where x.NroDocumento == nroDocumento select x).FirstOrDefaultAsync(); if (res != null) { customerBE = new CustomerBE(res); } return(customerBE); }
public async Task <CustomerBE> RecuperarTitularIdCuenta(int idCuenta) { CustomerBE customerBE = null; var res = await(from x in _clienteContext.Cuenta.Include("Cliente") where x.IdCuenta == idCuenta select x.Cliente).FirstOrDefaultAsync(); if (res != null) { customerBE = new CustomerBE(res); } return(customerBE); }
public void GetCustomerByLoginTest() { CustomerBE cbe = new CustomerBE(); Contract.dto.Customer c = UnitTest.TestHelpers.randomCustomer(); c.CustomerId = 1; c.Mail = UnitTest.TestHelpers.RandomWords(UnitTest.TestHelpers.GenerateRandomId(5, 15)); c.Password = UnitTest.TestHelpers.RandomWords(UnitTest.TestHelpers.GenerateRandomId(5, 15)); cbe.CreateCustomer(c); Contract.dto.Customer c2 = cbe.GetCustomerByLogin(c.Mail, c.Password); /// This might work, but because we use random mail and password, it only works sometimes (Most of the time) Assert.AreEqual(c.CustomerId, c2.CustomerId); }
public async Task <CustomerBE> RecuperarPorId(int id) { // CustomerBE customerBE = null; var res = await(from x in _clienteContext.Cliente where x.IdCliente == id select x).FirstOrDefaultAsync(); if (res != null) { customerBE = new CustomerBE(res); } return(customerBE); }
public void CreateDefaultBankAcccount(CustomerBE cbe) { BankAccount acc = new BankAccount() { AccountNumber = nextAccNumber++, Balance = 0.0, InterestRate = BankAccount.DEFAULT_INTERESTRATE, Customers = new List <Customer>() { new Customer(cbe) } }; AccountsRepo.Add(acc); }
/// <summary> /// Updates the customer. --Robin /// </summary> /// <param name="customerBE">The customer BE.</param> /// <returns></returns> public bool UpdateCustomer(CustomerBE customerBE) { UpdateCustomerRequest request = new UpdateCustomerRequest(); request.MyCustomer = customerBE; UpdateCustomerResponse response = MyChannelFactory.CreateChannel().UpdateCustomer(request); if (response.IsFailed) { ILog log = log4net.LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType); log.Error("error", new Exception(response.Message)); log.Fatal("fatal", new Exception(response.Message)); throw new Exception("We have a error!"); } return(true); }
/// <summary> /// Inserts the customer. /// </summary> /// <param name="name">The name.</param> /// <param name="gender">if set to <c>true</c> [gender].</param> /// <param name="addressId">The address id.</param> public void InsertCustomer() { CustomerBE customer = new CustomerBE(); customer.CustomerName = View.CustomerName; customer.CustomerGender = View.CustomerGender; AddressBE address = new AddressBE(); address.AddressId = View.CustomerAddressId; address.City = "City"; address.Country = "Country"; address.DetailAddress = "Detail"; address.Province = "Province"; customer.Address = address; _controller.InsertCustomer(customer); }
public void LoadValidIdTest() { ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString()); var context = cRUDTestDBContextProvider.GetContext(); var customer = new Customer { CustomerId = 1, FirstName = "TestFirstName", LastName = "TestLastName", Email = "*****@*****.**", Company = "TestCompany", Address = "123 Test Address", City = "TestCity", State = "TestState", Country = "TestCountry", PostalCode = "TestPC", Phone = "TestPhone", Fax = "TestFax", SupportRepId = 1 }; var employeeLoadValidIdTest = new Employee { EmployeeId = 1, FirstName = "TestEmployeeFirst", LastName = "TestEmployeeLast" }; context.Add(customer); context.Add(employeeLoadValidIdTest); context.SaveChanges(); CustomerBE customerBE = new CustomerBE(cRUDTestDBContextProvider); customerBE.Load(1); Assert.IsTrue(customerBE.Id == 1); Assert.IsTrue(customerBE.FirstName == "TestFirstName"); Assert.IsTrue(customerBE.LastName == "TestLastName"); Assert.IsTrue(customerBE.Company == "TestCompany"); Assert.IsTrue(customerBE.Address == "123 Test Address"); Assert.IsTrue(customerBE.City == "TestCity"); Assert.IsTrue(customerBE.State == "TestState"); Assert.IsTrue(customerBE.Country == "TestCountry"); Assert.IsTrue(customerBE.PostalCode == "TestPC"); Assert.IsTrue(customerBE.Phone == "TestPhone"); Assert.IsTrue(customerBE.Fax == "TestFax"); Assert.IsTrue(customerBE.Email == "*****@*****.**"); Assert.IsTrue(customerBE.SupportRepId == 1); }