private CustomerDALModel MapToCustomerDalModel(AddCustomerViewModel src) { var dalCustomer = new CustomerDALModel(); dalCustomer.ContactName = src.Name; dalCustomer.ContactTitle = src.Title; dalCustomer.City = src.City; dalCustomer.CompanyName = "Grand Circus"; dalCustomer.CustomerID = Guid.NewGuid().ToString().Substring(0, 5); return(dalCustomer); }
public bool InsertNewCustomer(CustomerDALModel dalModel) //Give parameters to sql query to stop sql injection { var sql = @"Insert INTO Customers (ContactName, City, ContactTitle, CustomerID, CompanyName) Values(@ContactName,@City,@ContactTitle, @CustomerID, @CompanyName)"; using (var connection = new SqlConnection(_config.ConnectionString)) //Idisposable { var result = connection.Execute(sql, dalModel); return(true); } }
public bool InsertNewCustomer(CustomerDALModel dalModel) { var sql = $@"Insert INTO Customers (ContactName, City, ContactTitle, CustomerID, CompanyName) Values (@{nameof(dalModel.ContactName)}, @{nameof(dalModel.City)}, @{nameof(dalModel.ContactTitle)}, @{nameof(dalModel.CustomerID)}, @{nameof(dalModel.CompanyName)})"; using (var connection = new SqlConnection(_config.ConnectionString)) { var result = connection.Execute(sql, dalModel); return(true); } }
private Customer MapCustomer(CustomerDALModel dalCustomer) { var customer = new Customer(); customer.CompanyName = dalCustomer.CompanyName; customer.Id = dalCustomer.CustomerID; customer.Address = dalCustomer.Address; customer.City = dalCustomer.City; customer.PostalCode = dalCustomer.PostalCode; customer.Phone = dalCustomer.Phone; customer.Region = dalCustomer.Region; customer.Country = dalCustomer.Country; return(customer); }
public bool InsertNewCustomer(CustomerDALModel dalModel) { throw new NotImplementedException(); }
public CustomerListItemViewModel(CustomerDALModel dalModel) { Id = dalModel.CustomerID; Name = dalModel.ContactName; }