public customersModel InsertCustomer(customersModel Customers)
{
var sql =
"INSERT INTO coreDapperApi.Customers (Vat,Email,FirstName,LastName,Phone) VALUES(@Vat, @Email, @FirstName, @LastName,@Phone); " +
"SELECT CAST(SCOPE_IDENTITY() as int)";
var id = con.Query <int>(sql, Customers).Single();
Customers.Id = id;
return(Customers);
}
public customersModel InsertCustomer(customersModel Customers)
{
var sql =
"INSERT INTO apox.Customers (Vat,Email,FirstName,LastName,Phone,Address,StatusId,RatingId) VALUES(@Vat, @Email, @FirstName, @LastName,@Phone,@Address,@StatusId,@RatingId); " +
"SELECT CAST(SCOPE_IDENTITY() as int)";
var id = con.Query <int>(sql, Customers).Single();
Customers.Id = id;
return(Customers);
}
public IHttpActionResult UpdateCustomer([FromBody] customersModel customer)
{
try
{
_repository.UpdateCustomer(customer);
}
catch (Exception ex)
{
return(BadRequest());
}
return(Ok(customer));
}
public IActionResult CreateCustomer([FromBody] customersModel customer)
{
try
{
_repository.InsertCustomer(customer);
}
catch (Exception ex)
{
return(BadRequest(ex));
}
return(Ok(customer));
}
public customersModel UpdateCustomer(customersModel Customers)
{
var sql =
"UPDATE coreDapperApi.Customers " +
"SET Vat = @Vat, " +
" Email = @Email, " +
" FirstName = @FirstName, " +
" LastName = @LastName, " +
" Phone = @Phone " +
"WHERE Id = @Id";
con.Execute(sql, Customers);
return(Customers);
}
public customersModel UpdateCustomer(customersModel Customers)
{
var sql =
"UPDATE apox.Customers " +
"SET Vat = @Vat, " +
" Email = @Email, " +
" FirstName = @FirstName, " +
" LastName = @LastName, " +
" Phone = @Phone, " +
" Address = @Address, " +
" StatusId = @StatusId, " +
" RatingId = @RatingId " +
"WHERE Id = @Id";
con.Execute(sql, Customers);
return(Customers);
}
public void Insert()
{
// arrange
IcustomersRepository repository = CreateRepository();
var CustomersModel = new customersModel
{
Vat = "213456777",
Email = "*****@*****.**",
FirstName = "TestFirstName",
LastName = "TestLastName"
};
// act
repository.InsertCustomer(CustomersModel);
// assert
CustomersModel.Id.Should().NotBe(0, "because Identity should have been assigned by database.");
Console.WriteLine("New ID: " + CustomersModel.Id);
id = CustomersModel.Id;
}
