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