public Clothes Add(Clothes employee)
{
//var sqlQuery = "INSERT INTO Clothes (Name, Quantity) VALUES(@Name, @Quantity); " + "SELECT CAST(SCOPE_IDENTITY() as int)";
var employeeId = this._db.Query<Guid>(INSERT_CLOTHES_QUERY, employee).FirstOrDefault();
employee.Id = employeeId;
return employee;
}
public Clothes Update(Clothes employee)
{
var sqlQuery =
"UPDATE Clothes " +
"SET Name = @Name, " +
"Quantity = @Quantity " +
"WHERE Id = @Id";
this._db.Execute(sqlQuery, employee);
return employee;
}
