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;
}
